Small MYSQL updating not working?
#1

Fixed.
Reply
#2

Updated.
Reply
#3

Please do not bump within 24 hours.

As for your code - debug it with print(f) to see what is getting called, and check your mysql_log.
Reply
#4

Quote:
Originally Posted by MP2
Посмотреть сообщение
Please do not bump within 24 hours.

As for your code - debug it with print(f) to see what is getting called, and check your mysql_log.
Sorry about the bump. Didn't mean it like that. I don't have a mysql_log, and what do you want me to put with the print(f)?
Reply
#5

Enable debug for MySQL, for BlueG's plugin its mysql_debug(true);
Reply
#6

Add mysql_debug(1); under OnGameModeInit, this will automatically log everything especially on queries and save it into a text file(Debug.txt) and you'll see what's wrong with your code.
Reply
#7

Here is the error it states.

pawn Код:
Query(UPDATE accounts SET group = 1 WHERE name = 'Billy_Bob') - An error has occured. (Error ID: 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 'group = 1 WHERE name = 'Billy_Bob'' at line 1)
Reply
#8

pawn Код:
format(query, sizeof(query), "UPDATE `accounts` SET group = '%d' WHERE name = '%s'", value, GetName(playerid));
That's it (:
Reply


Forum Jump:


Users browsing this thread: 2 Guest(s)