MySQL Query Errors.
#12

Quote:
Originally Posted by DRIFT_HUNTER
Посмотреть сообщение
Increase query length. Your query is getting cut off half way.

EDIT: Second problem. Set default values in mysql table and try to insert like these:
[sql]INSERT INTO `Users` SET `UserName`='%s', `Password`='%s'[/sql]

Dont forget to escape strings for safety.
Got an error.

pawn Код:
[01:32:44] CMySQLHandler::Query(INSERT INTO `accounts` SET Name`='Keith_Lawrence', `Password`='123456') - An error has occured. (Error ID: 1064, You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '`='Keith_Lawrence', `Password`='123456'' at line 1)
PM'ed you for more details.
Reply


Messages In This Thread
MySQL Query Errors. - by Shady - 13.07.2016, 16:45
Re: MySQL Query Errors. - by Konstantinos - 13.07.2016, 16:53
Re: MySQL Query Errors. - by Shady - 13.07.2016, 16:59
Re: MySQL Query Errors. - by Konstantinos - 13.07.2016, 17:02
Re: MySQL Query Errors. - by Shady - 13.07.2016, 17:11
Re: MySQL Query Errors. - by PrO.GameR - 13.07.2016, 19:49
Re: MySQL Query Errors. - by SickAttack - 13.07.2016, 20:22
Re: MySQL Query Errors. - by Shady - 13.07.2016, 22:52
Re: MySQL Query Errors. - by Ghazal - 13.07.2016, 23:06
Re: MySQL Query Errors. - by Shady - 13.07.2016, 23:14
Re: MySQL Query Errors. - by DRIFT_HUNTER - 13.07.2016, 23:25
Re: MySQL Query Errors. - by ItzShady - 13.07.2016, 23:36
Re: MySQL Query Errors. - by SyS - 14.07.2016, 01:16
Re: MySQL Query Errors. - by SickAttack - 14.07.2016, 01:41
Re: MySQL Query Errors. - by WhiteGhost - 14.07.2016, 01:43
Re: MySQL Query Errors. - by SyS - 14.07.2016, 02:24
Re: MySQL Query Errors. - by SickAttack - 14.07.2016, 02:39
Re: MySQL Query Errors. - by DRIFT_HUNTER - 14.07.2016, 02:52
Re: MySQL Query Errors. - by ItzShady - 14.07.2016, 02:53
Re: MySQL Query Errors. - by SyS - 14.07.2016, 08:23

Forum Jump:


Users browsing this thread: 1 Guest(s)