Неа, не сохраняет!Сообщение от Bublik_Public
PHP код: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 '' at line 1
Неа, не сохраняет!
PHP код: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 '' at line 1
Показывай логи с DEBUGom
Bady (10.01.2015)
PHP код:[00:28:04] [DEBUG] mysql_connect - host: "127.0.0.1", user: "root", database: "new", password: "****", port: 3306, autoreconnect: true, pool_size: 2
[00:28:04] [DEBUG] CMySQLHandle::Create - creating new connection..
[00:28:04] [DEBUG] CMySQLHandle::CMySQLHandle - constructor called
[00:28:04] [DEBUG] CMySQLHandle::Create - connection created (id: 1)
[00:28:04] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[00:28:04] [DEBUG] CMySQLConnection::Connect - connection was successful
[00:28:04] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[00:28:04] [DEBUG] cache_get_data - connection: 1
[00:28:04] [WARNING] cache_get_data - no active cache
[00:28:04] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[00:28:04] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[00:28:04] [DEBUG] CMySQLConnection::Connect - establishing connection to database...
[00:28:04] [DEBUG] CMySQLConnection::Connect - connection was successful
[00:28:04] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[00:28:04] [DEBUG] CMySQLConnection::Connect - connection was successful
[00:28:04] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[00:28:04] [DEBUG] CMySQLConnection::Connect - connection was successful
[00:28:04] [DEBUG] CMySQLConnection::Connect - auto-reconnect has been enabled
[00:28:26] [DEBUG] mysql_tquery - connection: 1, query: "SELECT `Name` FROM `accounts` WHERE `Name` = 'Alberto_Johnson'", callback: "OnPlayerRegCheck", format: "d"
[00:28:26] [DEBUG] CMySQLQuery::Execute[OnPlayerRegCheck] - starting query execution
[00:28:26] [DEBUG] CMySQLQuery::Execute[OnPlayerRegCheck] - query was successfully executed within 2.315 milliseconds
[00:28:26] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[00:28:26] [DEBUG] Calling callback "OnPlayerRegCheck"..
[00:28:26] [DEBUG] cache_get_data - connection: 1
[00:28:26] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[00:28:27] [DEBUG] mysql_format - connection: 1, len: 144, format: "SELECT * FROM `accounts` WHERE `Name` = '%s' AND `pKey` = '%e'"
[00:28:27] [DEBUG] mysql_tquery - connection: 1, query: "SELECT * FROM `accounts` WHERE `Name` = 'Alberto_Johnson' AND `p", callback: "LoginCallback", format: "ds"
[00:28:27] [DEBUG] CMySQLQuery::Execute[LoginCallback] - starting query execution
[00:28:27] [DEBUG] CMySQLQuery::Execute[LoginCallback] - query was successfully executed within 1.423 milliseconds
[00:28:27] [DEBUG] CMySQLResult::CMySQLResult() - constructor called
[00:28:27] [DEBUG] Calling callback "LoginCallback"..
[00:28:27] [DEBUG] cache_get_data - connection: 1
[00:28:27] [DEBUG] cache_get_field_content - row: 0, field_name: "ID", connection: 1, max_len: 68
[00:28:27] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "ID", data: "0"
[00:28:27] [DEBUG] cache_get_field_content - row: 0, field_name: "pLevel", connection: 1, max_len: 68
[00:28:27] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "pLevel", data: "1"
[00:28:27] [DEBUG] cache_get_field_content - row: 0, field_name: "pReg", connection: 1, max_len: 68
[00:28:27] [DEBUG] CMySQLResult::GetRowDataByName - row: '0', field: "pReg", data: "1"
[00:28:27] [DEBUG] CMySQLResult::~CMySQLResult() - deconstructor called
[00:28:31] [DEBUG] mysql_format - connection: 1, len: 600, format: "UPDATE `house` SET "
[00:28:31] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `house` SET `hAddress`='',`hOwner`='',`hX`='0.000000',`hY", callback: "(null)", format: "(null)"
[00:28:31] [DEBUG] mysql_format - connection: 1, len: 600, format: "UPDATE `house` SET "
[00:28:31] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `house` SET `hAddress`='1',`hOwner`='None',`hX`='1756.192", callback: "(null)", format: "(null)"
[00:28:31] [DEBUG] mysql_format - connection: 1, len: 132, format: "%s VALUES ('%d', '%f', '%f', '%f', '%d', '%d', '%d', '%s','%s')"
[00:28:31] [DEBUG] mysql_format - connection: 1, len: 132, format: "INSERT INTO `house` (`hID`, `hX`,`hY`, `hZ`,`hPrice`,`hInterior`,`hVirtWorld`,`hAddress`,`hOwner`)"
[00:28:31] [DEBUG] mysql_tquery - connection: 1, query: "INSERT INTO `house` (`hID`, `hX`,`hY`, `hZ`,`hPrice`,`hInterior`", callback: "(null)", format: "(null)"
[00:28:31] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:28:31] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 1.863 milliseconds
[00:28:31] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[00:28:31] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:28:31] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.365 milliseconds
[00:28:31] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
[00:28:31] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:28:31] [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 '' at line 1
[00:28:31] [DEBUG] CMySQLQuery::Execute[] - error will be triggered in OnQueryError
[00:28:31] [DEBUG] Calling callback "OnQueryError"..
[00:28:33] [DEBUG] mysql_format - connection: 1, len: 2350, format: "UPDATE `accounts` SET `pLevel` = '%d',`pReg` = '%d' WHERE `Name` = '%s'"
[00:28:33] [DEBUG] mysql_tquery - connection: 1, query: "UPDATE `accounts` SET `pLevel` = '1',`pReg` = '1' WHERE `Name` =", callback: "(null)", format: "(null)"
[00:28:33] [DEBUG] CMySQLQuery::Execute[] - starting query execution
[00:28:33] [DEBUG] CMySQLQuery::Execute[] - query was successfully executed within 0.606 milliseconds
[00:28:33] [DEBUG] CMySQLQuery::Execute[] - no callback specified, skipping result saving
132 string, увеличь для теста 500, просто я не вижу больше синтаксическую ошибку в запросе..
И ещё вот так попробуй:
PHP код:new string[128];
mysql_format(mysql_variable, mysql_querys, sizeof(mysql_querys), "INSERT INTO `house` (`hID`, `hX`, `hY`, `hZ`, `hPrice`, `hInterior`, `hVirtWorld`, `hAddress`, `hOwner`)",
mysql_format(mysql_variable, mysql_querys, sizeof(mysql_querys), "%s VALUES ('%d', '%f', '%f', '%f', '%d', '%d', '%d', '%s','%s')",
format(string sizeof(string), "mysql_querys: %s", mysql_querys);
printf(string);
Последний раз редактировалось $continue$; 10.01.2015 в 02:48.
Bady (10.01.2015)
PHP код:[00:54:58] mysql_querys: INSERT INTO `house` (`hID`, `hX`, `hY`, `hZ`, `hPrice`, `hInterior`, `hVirtWorld`, `hAddress`, `hOwner`)
[00:54:58] 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 '' at line 1
Ты мне кинь что в лог вывело, обычный от сервера..
Bady (10.01.2015)
Я это и кинул ...
Исправил, переписал запрос:
PHP код:mysql_format(mysql_variable, mysql_querys, sizeof(mysql_querys), "INSERT INTO `house` (`hID`,`hAddress`, `hOwner`,`hX`,`hY`, `hZ`,`hInterior`,`hVirtWorld`,`hPrice`) VALUES ('%d','%s','%s', '%f', '%f', '%f', '%d', '%d', '%d')",
HouseInfo[TotalHouse][hID],HouseInfo[TotalHouse][hAddress],HouseInfo[TotalHouse][hOwner],HouseInfo[TotalHouse][hX],HouseInfo[TotalHouse][hY],HouseInfo[TotalHouse][hZ],HouseInfo[TotalHouse][hInterior],HouseInfo[TotalHouse][hPrice]);
Эту тему просматривают: 1 (пользователей: 0 , гостей: 1)
Ваши права
Ответить с цитированием