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

SQL Error help pls

mesosot

Member
Joined
Aug 16, 2007
Messages
356
Reaction score
5
hello there

i got this error what i shall do ?


HTML:
[10/09/2010 02:14:11] mysql_real_query(): SELECT `TRIGGER_NAME` FROM `information_schema`.`triggers` WHERE `TRIGGER_SCHEMA` = 'otserver' AND `TRIGGER_NAME` = 'ondelete_players'; - MYSQL ERROR: Error on delete of '\Server\xampp\xampp\tmp\#sql584_cf90_84.MYI' (Errcode: 13) (6)
[10/09/2010 02:14:11] > Trigger: ondelete_players does not exist, creating it...
[10/09/2010 02:14:11] mysql_real_query(): CREATE TRIGGER `ondelete_players` BEFORE DELETE ON `players` FOR EACH ROW BEGIN DELETE FROM `bans` WHERE `type` = 2 AND `value` = OLD.`id`; UPDATE `houses` SET `owner` = 0 WHERE `owner` = OLD.`id`; END; - MYSQL ERROR: This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table' (1235)
[10/09/2010 02:14:11] > Optimizing table: account_viplist... [success]
 
Same to me, can some1 help?


mysql_real_query(): SELECT `name`, `password`, `salt`, `premdays`, `lastday`, `key`, `warnings` FROM `Accounts` WHERE `id` = 1 LIMIT = 1 - MYSQL ERROR: Unknow Column ´salt´ in ´field list´ (1054)
mysql_real_query(): SELECT `name`, `password`, `salt`, `premdays`, `lastday`, `key`, `warnings` FROM `Accounts` WHERE `id` = 6159667 LIMIT = 1 - MYSQL ERROR: Unknow Column ´salt´ in ´field list´ (1054)
 
Back
Top