• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

Error MySQL

Mokk

New Member
Joined
Jun 2, 2023
Messages
12
Reaction score
4
Hello guys, I'm having a little problem running the /save command

[12:29:08.352] > Salvando servidor...
[12:29:09.298] mysql_real_query(): INSERT INTO global_storage (key, world_id, value) VALUES (, 0, '19876'),(172100, 0, '0'),(172101, 0, '0'),(172102, 0, '0'),(172354, 0, '0'),(172355, 0, '0'),(19871, 0, '0'),(19875, 0, '36'),(19876, 0, 'Teste'),(19877, 0, '36'),(19878, 0, 'Teste') - MYSQL ERROR: 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 ' 0, '19876'),(172100, 0, '0'),(172101, 0, '0'),(172102, 0, '0'),(172354, 0, '...' at line 1 (1064)
[12:29:09.388] > SAVE: Completo em 1.03 segundos usando binary casa storage.

Could someone help me fix it?
Post automatically merged:

Bug fix:

ALTER TABLE global_storage ADD key INT(11) NOT NULL DEFAULT 0;
ALTER TABLE global_storage ADD world_id INT(11) NOT NULL DEFAULT 0;
ALTER TABLE global_storage ADD value INT(11) NOT NULL DEFAULT 0;
 
Last edited:
Back
Top