MySQL errors - Printable Version

MySQL errors - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL errors (/showthread.php?tid=642996)

MySQL errors - leon44 - 11.10.2017

Hi mates, I've recently installed the lastest updates from MySQL to an older MySQL from 2012, but when I updated them I've got 21 errors while that wasn't happening when I had the old MySQL there yet. these are the following errors:

Код:

D:\Escritorio\server\gamemodes\DM.pwn(460) : error 017: undefined symbol "mysql_ping"
D:\Escritorio\server\gamemodes\DM.pwn(478) : error 035: argument type mismatch (argument 1)
D:\Escritorio\server\gamemodes\DM.pwn(479) : error 017: undefined symbol "mysql_store_result"
D:\Escritorio\server\gamemodes\DM.pwn(480) : error 017: undefined symbol "mysql_num_rows"
D:\Escritorio\server\gamemodes\DM.pwn(482) : error 017: undefined symbol "mysql_fetch_row"
D:\Escritorio\server\gamemodes\DM.pwn(486) : error 017: undefined symbol "mysql_free_result"
D:\Escritorio\server\gamemodes\DM.pwn(518) : error 035: argument type mismatch (argument 1)
D:\Escritorio\server\gamemodes\DM.pwn(519) : error 017: undefined symbol "mysql_store_result"
D:\Escritorio\server\gamemodes\DM.pwn(520) : error 017: undefined symbol "mysql_num_rows"
D:\Escritorio\server\gamemodes\DM.pwn(522) : error 017: undefined symbol "mysql_free_result"
D:\Escritorio\server\gamemodes\DM.pwn(883) : error 017: undefined symbol "mysql_ping"
D:\Escritorio\server\gamemodes\DM.pwn(885) : error 017: undefined symbol "mysql_debug"
D:\Escritorio\server\gamemodes\DM.pwn(3430) : error 035: argument type mismatch (argument 1)
D:\Escritorio\server\gamemodes\DM.pwn(3450) : error 035: argument type mismatch (argument 1)
D:\Escritorio\server\gamemodes\DM.pwn(3451) : error 017: undefined symbol "mysql_store_result"
D:\Escritorio\server\gamemodes\DM.pwn(3452) : error 017: undefined symbol "mysql_fetch_row"
D:\Escritorio\server\gamemodes\DM.pwn(3463) : error 017: undefined symbol "mysql_free_result"
D:\Escritorio\server\gamemodes\DM.pwn(3516) : error 035: argument type mismatch (argument 1)
D:\Escritorio\server\gamemodes\DM.pwn(3517) : error 017: undefined symbol "mysql_free_result"
D:\Escritorio\server\gamemodes\DM.pwn(3902) : error 017: undefined symbol "mysql_fetch_field_row"
D:\Escritorio\server\gamemodes\DM.pwn(3908) : error 017: undefined symbol "mysql_fetch_field_row"
Pawn compiler 3.2.3664	 	 	Copyright © 1997-2006, ITB CompuPhase


21 Errors.

Lines:

PHP код:



if(mysql_ping() == 1)//460

PHP код:



mysql_query(query); //478

                mysql_store_result(); //479

                if(mysql_num_rows() > 0) //480

                {

                    mysql_fetch_row(query); //482

                } else {

                    query = "Unknown";

                }

                mysql_free_result(); //486

            }

        }

PHP код:



mysql_query(query); //518

        mysql_store_result(); //519

        if(mysql_num_rows() == 0) //520

        {

            mysql_free_result();//522

PHP код:



if(mysql_ping() == 1)//883

    {

        mysql_debug(1);//885

PHP код:



mysql_query(query); //3430

PHP код:



mysql_query(query); //3450

    mysql_store_result(); //3451

    if(mysql_fetch_row(query) == 1)//3452

PHP код:



mysql_free_result();//3463

PHP код:



mysql_query(qwery);//3516

        mysql_free_result();//3517

PHP код:



mysql_fetch_field_row(fetch,fields); //3902 and 3908 the same line

How can I fix them?

Re: MySQL errors - Pizzy - 11.10.2017

Use the old MySQL plugin you were using. The mysql functions would have changed, so you'd need to change them all over again.

Re: MySQL errors - leon44 - 11.10.2017

Quote:

Originally Posted by Pizzy

Use the old MySQL plugin you were using. The mysql functions would have changed, so you'd need to change them all over again.

Yes but when I ran samp-server.exe I got this error in MySQL (serverlog):

Код:

SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team

[20:28:26] filterscripts = ""  (string)
[20:28:26] weburl = "www.sa-mp.com"  (string)
[20:28:26] 
[20:28:26] Server Plugins
[20:28:26] --------------
[20:28:26]  Loading plugin: filemanager
[20:28:26] ******************
[20:28:26] ** FILE MANAGER **
[20:28:26] **    Loaded    **
[20:28:26] ** Version 1.1 **
[20:28:26] ******************
[20:28:26]   Loaded.
[20:28:26]  Loading plugin: xml
[20:28:26]   Loaded.
[20:28:26]  Loading plugin: streamer
[20:28:26]   Loaded.
[20:28:26]  Loading plugin: sscanf
[20:28:26] 

[20:28:26]  ===============================

[20:28:26]       sscanf plugin loaded.     

[20:28:26]    © 2009 Alex "******" Cole

[20:28:26]  ===============================

[20:28:26]   Loaded.
[20:28:26]  Loading plugin: mysql
[20:28:26] 

  > MySQL plugin R6-2 successfully loaded.

[20:28:26]   Loaded.
[20:28:26]  Loaded 5 plugins.

[20:28:26] 
[20:28:26] Filterscripts
[20:28:26] ---------------
[20:28:26]   Loaded 0 filterscripts.

[20:28:27] [MYSQL]: [error]: connection with `samp` hasn't been established
[20:28:27] 
--------------------------------------------------
[20:28:27] DM © 2012
[20:28:27] Number of vehicle models: 0

Re: MySQL errors - Kyle - 11.10.2017

Quote:

Originally Posted by leon44

Yes but when I ran samp-server.exe I got this error in MySQL (serverlog):

Код:

SA-MP Dedicated Server
----------------------
v0.3.7-R2, ©2005-2015 SA-MP Team

[20:28:26] filterscripts = ""  (string)
[20:28:26] weburl = "www.sa-mp.com"  (string)
[20:28:26] 
[20:28:26] Server Plugins
[20:28:26] --------------
[20:28:26]  Loading plugin: filemanager
[20:28:26] ******************
[20:28:26] ** FILE MANAGER **
[20:28:26] **    Loaded    **
[20:28:26] ** Version 1.1 **
[20:28:26] ******************
[20:28:26]   Loaded.
[20:28:26]  Loading plugin: xml
[20:28:26]   Loaded.
[20:28:26]  Loading plugin: streamer
[20:28:26]   Loaded.
[20:28:26]  Loading plugin: sscanf
[20:28:26] 

[20:28:26]  ===============================

[20:28:26]       sscanf plugin loaded.     

[20:28:26]    © 2009 Alex "******" Cole

[20:28:26]  ===============================

[20:28:26]   Loaded.
[20:28:26]  Loading plugin: mysql
[20:28:26] 

  > MySQL plugin R6-2 successfully loaded.

[20:28:26]   Loaded.
[20:28:26]  Loaded 5 plugins.

[20:28:26] 
[20:28:26] Filterscripts
[20:28:26] ---------------
[20:28:26]   Loaded 0 filterscripts.

[20:28:27] [MYSQL]: [error]: connection with `samp` hasn't been established
[20:28:27] 
--------------------------------------------------
[20:28:27] DM © 2012
[20:28:27] Number of vehicle models: 0

Have you setup MySQL on your hosts computer? You need to create a database, import the database and update your hosts credentials such as IP, Port, Database Name, User and Password.

Once you have this data update your script.

The reason why this error has popped up is because the server is not connected to a MySQL Database.