Проблема Не сохраняет аккаунт в БД

[#meow 64]

Доброго времени суток, у меня в моде не сохраняет аккаунты.

Ошибок никаких при компиляции - нет, никогда с таким не сталкивался.
 
[spoiler=mysql_log]

[20:20:05] >> mysql_connect(localhost, root, vlsrp, ******) on port 3306
[20:20:05] CMySQLHandler::CMySQLHandler() - constructor called.
[20:20:05] CMySQLHandler::CMySQLHandler() - Connecting to "localhost" | DB: "vlsrp" | Username: "root"
[20:20:05] CMySQLHandler::Connect() - Connection was successful.
[20:20:05] CMySQLHandler::Connect() - Auto-Reconnect has been enabled.
[20:20:05] >> mysql_ping( Connection handle: 1 )
[20:20:05] CMySQLHandler::Ping() - Connection is still alive.
[20:20:05]
[20:20:05] ** MySQL Debugging enabled (01/23/19)
[20:20:05]
[20:20:43] >> mysql_query_callback( Connection handle: 1 )
[20:20:43] Passing query SELECT `id` FROM `accounts` WHERE `login` = 'Cl_Cl' | ii
[20:20:43] ProcessQueryThread(player_check) - Query was successful. (SELECT `id` FROM `accounts` WHERE `login` = 'Cl_Cl')
[20:20:43] ProcessQueryThread(player_check) - Data caching enabled.
[20:20:43] CMySQLHandler::StoreResult() - Result was stored.
[20:20:43] CMySQLHandler::FreeResult() - Result was successfully free'd.
[20:20:43] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[20:20:43] player_check(ii) - Threaded function called.
[20:20:43] >> cache_get_data( Connection handle: 1 )
[20:20:43] ProcessTick() - The cache has been cleared.
[20:20:50] >> mysql_real_escape_string( Connection handle: 1 )
[20:20:50] CMySQLHandler::EscapeString(123456); - Escaped 6 characters to 123456.
[20:20:50] >> mysql_query_callback( Connection handle: 1 )
[20:20:50] >> mysql_query_callback( Connection handle: 1 )
[20:20:50] Passing query INSERT INTO `accounts` (`login`,`password`) VLUES ('Cl_Cl','123456') |
[20:20:50] CMySQLHandler::ProcessQueryThread() - Error will be triggered to OnQueryError()
[20:20:50] OnQueryError() - Called.
[20:20:50] Passing query SELECT * FROM `accounts` WHERE `login` = 'Cl_Cl' AND `password` = '123456' LIMIT 1 | i
[20:20:50] ProcessQueryThread(player_login) - Query was successful. (SELECT * FROM `accounts` WHERE `login` = 'Cl_Cl' AND `password` = '123456' LIMIT 1)
[20:20:50] ProcessQueryThread(player_login) - Data caching enabled.
[20:20:50] CMySQLHandler::StoreResult() - Result was stored.
[20:20:50] CMySQLHandler::FreeResult() - Result was successfully free'd.
[20:20:50] CMySQLHandler::ProcessQueryThread() - Data is getting passed to ->ProcessTick()
[20:20:50] player_login(i) - Threaded function called.
[20:20:50] >> cache_get_data( Connection handle: 1 )
[20:20:50] ProcessTick() - The cache has been cleared.

 

 

Изменено 23 января, 2019 пользователем #moon

[16Shadows 101]

У Вас в запросе слово VLUES, а должно быть VALUES

[16Shadows 101]

Добавьте в OnQueryError()

printf(error);

И скиньте ошибку из логов сервера

[#meow 64]

OnQueryError()

 

[spoiler=server log]

[08:58:14] [MySQL]:База Данных - подключена!
[08:58:14] Number of vehicle models: 0
[08:58:46] Incoming connection: 127.0.0.1:63430
[08:58:47] [join] Ck_Ck has joined the server (0:127.0.0.1)
[08:58:50] 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 'VLUES ('Ck_Ck','123123')' at line 1

 

 

Изменено 24 января, 2019 пользователем #moon