Hey,
When people add someone to VIP list and logout this console error occurs:
It's very strange... I've tested to import billions of other account_viplist tables without any success. The player doesn't get saved at all after added a friend to viplist and logout. The player added to VIP disappear too. I've also tried to import table from databasemanager.cpp but nothing work. I've started to think that there is nothing wrong with the table.
Here's the table from databasemanager.cpp:
What can it be? I've run out of ideas! Could it be too old imported database?
I'm asking here cuz the premium board is dead...
When people add someone to VIP list and logout this console error occurs:
Code:
[2/1/2013 20:58:39] Ub Kenobi has logged out.
[2/1/2013 20:58:39] mysql_real_query(): INSERT INTO `account_viplist` (`account_id`, `world_id`, `player_id`) VALUES (DELETE FROM `account_viplist` WHERE `account_id` = 4 AND `world_id` = 04,0,26) - MYSQL ERROR: 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 'DELETE FROM `account_viplist` WHERE `account_id` = 4 AND `world_id` = 04,0,26)' at line 1 (1064)
[2/1/2013 20:58:39] mysql_real_query(): INSERT INTO `account_viplist` (`account_id`, `world_id`, `player_id`) VALUES (DELETE FROM `account_viplist` WHERE `account_id` = 4 AND `world_id` = 04,0,26) - MYSQL ERROR: 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 'DELETE FROM `account_viplist` WHERE `account_id` = 4 AND `world_id` = 04,0,26)' at line 1 (1064)
[2/1/2013 20:58:39] mysql_real_query(): INSERT INTO `account_viplist` (`account_id`, `world_id`, `player_id`) VALUES (DELETE FROM `account_viplist` WHERE `account_id` = 4 AND `world_id` = 04,0,26) - MYSQL ERROR: 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 'DELETE FROM `account_viplist` WHERE `account_id` = 4 AND `world_id` = 04,0,26)' at line 1 (1064)
[2/1/2013 20:58:39] Error while saving player: Ub Kenobi.It's very strange... I've tested to import billions of other account_viplist tables without any success. The player doesn't get saved at all after added a friend to viplist and logout. The player added to VIP disappear too. I've also tried to import table from databasemanager.cpp but nothing work. I've started to think that there is nothing wrong with the table.
Here's the table from databasemanager.cpp:
Code:
CREATE TABLE `account_viplist`
(
`account_id` INT NOT NULL,
`world_id` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0,
`player_id` INT NOT NULL,
KEY (`account_id`), KEY (`player_id`), KEY (`world_id`), UNIQUE (`account_id`, `player_id`),
FOREIGN KEY (`account_id`) REFERENCES `accounts`(`id`) ON DELETE CASCADE,
FOREIGN KEY (`player_id`)
REFERENCES `players`(`id`) ON DELETE CASCADE
) ENGINE = InnoDB;What can it be? I've run out of ideas! Could it be too old imported database?
I'm asking here cuz the premium board is dead...
