MySQL error
#1

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

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

1. Yeah it's R6.
Quote:

/*
SA-MP MySQL plugin R5
Copyright © 2008-2010, G-sTyLeZzZ
*/

2. It is included at the top.
Reply
#4

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

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
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)