MySQL errors
#1

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?
Reply
#2

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

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
Reply
#4

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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)