• 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!

TFS 1.X+ DATABASE erro

jel

Member
Joined
Mar 22, 2014
Messages
207
Reaction score
8
hello, I have this error any solution?

[Error - mysql_real_query] Query: UPDATE guilds SET balance = 0`level` = 1`experience` = 0 WHERE id = 1
Message: 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 'level = 1`experience` = 0 WHERE id = 1' at line 1
[Error - mysql_real_query] Query: UPDATE guilds SET balance = 0`level` = 1`experience` = 0 WHERE id = 1
Message: 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 'level = 1`experience` = 0 WHERE id = 1' at line 1
 

M0ustafa

1337
Senator
Joined
Mar 4, 2017
Messages
2,560
Solutions
315
Reaction score
1,132
Location
Egypt
Try inserting this query
SQL:
CREATE TABLE `guilds` (
  `id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  `ownerid` int(11) NOT NULL,
  `creationdata` int(11) NOT NULL,
  `motd` varchar(255) NOT NULL DEFAULT '',
  `residence` int(11) NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `balance` bigint(20) UNSIGNED NOT NULL DEFAULT '0',
  `logo_name` varchar(255) NOT NULL DEFAULT 'default.gif'
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
Top