TFS 1.X+ DATABASE erro

[jel]

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

 

[Snavy]

try:

UPDATE guilds SET `balance` = 0, `level` = 1, `experience` = 0 WHERE id = 1

 

[jel]

try:

UPDATE guilds SET `balance` = 0, `level` = 1, `experience` = 0 WHERE id = 1

the error continues

 

[Addams]

Try inserting this query

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;