MySQL error - Printable Version

MySQL error - 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 error (/showthread.php?tid=375499)

MySQL error - Sniper Kitty - 07.09.2012

pawn Код:

mysql_query("CREATE TABLE IF NOT EXISTS `serverdata`(Name VARCHAR(100) DEFAULT 'Unknown Gamemode');");
        mysql_query("ALTER TABLE `serverdata` ADD Mode VARCHAR(100) DEFAULT 'Unknown';");
        mysql_query("ALTER TABLE `serverdata` ADD Map VARCHAR(100) DEFAULT 'San Andreas';");
        mysql_query("ALTER TABLE `serverdata` ADD Website VARCHAR(100) DEFAULT 'www.sa-mp.com';");
        mysql_query("ALTER TABLE `serverdata` ADD Password VARCHAR(100) DEFAULT '0';");
        
        mysql_query("CREATE TABLE IF NOT EXISTS `playerdata`(Name VARCHAR(100) DEFAULT 'Unknown');");
        mysql_query("ALTER TABLE `playerdata` ADD IP VARCHAR(100) DEFAULT '*.*.*.*';");
        mysql_query("ALTER TABLE `playerdata` ADD Country VARCHAR(100) DEFAULT 'Unknown';");
        mysql_query("ALTER TABLE `playerdata` ADD Ping INT(10) DEFAULT -1;");
        mysql_query("ALTER TABLE `playerdata` ADD Connected INT(10) DEFAULT 0;");
        mysql_query("ALTER TABLE `playerdata` ADD PosWorld INT(10) DEFAULT 0;");
        mysql_query("ALTER TABLE `playerdata` ADD PosInterior INT(10) DEFAULT 0;");
        mysql_query("ALTER TABLE `playerdata` ADD PosX FLOAT(4,6) DEFAULT 0000.000000;");
        mysql_query("ALTER TABLE `playerdata` ADD PosY FLOAT(4,6) DEFAULT 0000.000000;");
        mysql_query("ALTER TABLE `playerdata` ADD PosZ FLOAT(4,6) DEFAULT 0000.000000;");
        mysql_query("ALTER TABLE `playerdata` ADD PosO FLOAT(4,6) DEFAULT 0000.000000;");
        mysql_query("ALTER TABLE `playerdata` ADD Frozen INT(10) DEFAULT 0;");
        mysql_query("ALTER TABLE `playerdata` ADD Registered INT(10) DEFAULT 0;");
        mysql_query("ALTER TABLE `playerdata` ADD LoggedIn INT(10) DEFAULT 0;");
        mysql_query("ALTER TABLE `playerdata` ADD Password VARCHAR(100) DEFAULT 'Unknown';");

Why do I receive these errors,

Код:

Server.pwn(49) : error 017: undefined symbol "mysql_query"
Server.pwn(50) : error 017: undefined symbol "mysql_query"
Server.pwn(51) : error 017: undefined symbol "mysql_query"
Server.pwn(52) : error 017: undefined symbol "mysql_query"
Server.pwn(53) : error 017: undefined symbol "mysql_query"
Server.pwn(55) : error 017: undefined symbol "mysql_query"
Server.pwn(56) : error 017: undefined symbol "mysql_query"
Server.pwn(57) : error 017: undefined symbol "mysql_query"
Server.pwn(58) : error 017: undefined symbol "mysql_query"
Server.pwn(59) : error 017: undefined symbol "mysql_query"
Server.pwn(60) : error 017: undefined symbol "mysql_query"
Server.pwn(61) : error 017: undefined symbol "mysql_query"
Server.pwn(62) : error 017: undefined symbol "mysql_query"
Server.pwn(63) : error 017: undefined symbol "mysql_query"
Server.pwn(64) : error 017: undefined symbol "mysql_query"
Server.pwn(65) : error 017: undefined symbol "mysql_query"
Server.pwn(66) : error 017: undefined symbol "mysql_query"
Server.pwn(67) : error 017: undefined symbol "mysql_query"
Server.pwn(68) : error 017: undefined symbol "mysql_query"
Server.pwn(69) : error 017: undefined symbol "mysql_query"

Iam using BlueG's MySQL plugin (R6)

Re: MySQL error - doreto - 07.09.2012

1.Are you sure if R6 not R7 becose in r7 mysql_query is removed
2.did you define mysql include on top ?

Re: MySQL error - Sniper Kitty - 07.09.2012

1. Yeah it's R6.

Quote:

2. It is included at the top.

Re: MySQL error - TheArcher - 07.09.2012

Try to re-download the whole MySQL package and replace them, open pawno.exe firtsly and browse your gamemode then re-compile it.

Re: MySQL error - Sniper Kitty - 07.09.2012

Fixed, BlueG has the R7 download link labeled as the R6 download link.

For those who recently downloaded and have the same problem as me, the actual download link is,
http://files.g-stylezzz.com/mysql/rel/R6/a_mysql.inc