MySQL Error, not sure what though
#6

Sending this error but no idea if it's anything to do with it:


pawn Код:
[20:26:42] [ERROR] "cache_get_field_content_int" - invalid connection handle (ID = 0)
[20:26:42] [ERROR] "cache_get_field_content_int" - invalid connection handle (ID = 0)
[20:26:42] [ERROR] "cache_get_field_content_int" - invalid connection handle (ID = 0)
[20:26:42] [ERROR] "cache_get_field_content_int" - invalid connection handle (ID = 0)
[20:26:42] [ERROR] "cache_get_field_content_int" - invalid connection handle (ID = 0)
[20:26:42] [ERROR] "cache_get_field_content_int" - invalid connection handle (ID = 0)
[20:27:12] [ERROR] CMySQLQuery::Execute[()] - (error #1064) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '.0.1, `health` = 0.000000, `armour` = 0.000000,`gender` = 0, `pDisX` = 50.000000' at line 1


Here's where the code is put

pawn Код:
case DIALOG_LOGIN:
            {
                new hash[129];
                WP_Hash(hash, sizeof(hash), inputtext);
               
                if(!strcmp(hash, Account[playerid][Password]))
                {
                    SCM(playerid, COLOR_GREEN, "You have successfully logged into "GAMEMODE_SHORTNAME". You will be spawned in a minute.");
                    SCM(playerid, COLOR_GREEN, "Remember, if you need help use "EMBED_WHITE"/assistance");
                    SCM(playerid, COLOR_GREEN, "And if you find a player is breaking the rules use "EMBED_WHITE"/report");

                    mysql_format(sqlHandle, gVar3000, sizeof(gVar3000), "SELECT * FROM `samp_users` WHERE 'Username' = '%s' AND Password = '%s'", Name[playerid], Account[playerid][Password]);
                    mysql_tquery(sqlHandle, gVar3000, "OnAccountLoad", "d", playerid);
                }
                else
                {
                    SCM(playerid, COLOR_DEATHRED, "[ERR] You appear to have entered an incorrect password.");
                    KickDelay(playerid);
                }
            }
the query is sending but always returning 0 rows
Reply


Messages In This Thread
MySQL Error, not sure what though - by sammp - 23.10.2014, 19:18
Re: MySQL Error, not sure what though - by dusk - 23.10.2014, 19:22
Re: MySQL Error, not sure what though - by sammp - 23.10.2014, 19:24
Re: MySQL Error, not sure what though - by dusk - 23.10.2014, 19:28
Re: MySQL Error, not sure what though - by sammp - 23.10.2014, 19:30
Re: MySQL Error, not sure what though - by sammp - 23.10.2014, 19:33
Re: MySQL Error, not sure what though - by sammp - 23.10.2014, 21:58
Re: MySQL Error, not sure what though - by TakeiT - 23.10.2014, 22:11
Re: MySQL Error, not sure what though - by sammp - 23.10.2014, 22:25
Re: MySQL Error, not sure what though - by sammp - 23.10.2014, 22:29

Forum Jump:


Users browsing this thread: 1 Guest(s)