Gesior Acc Problems again :-(

[Zer0xe]

Hello, again OTLand Support.

My Gesior Acc is really annoying I got a question first though,

Is it possible to transfer old accounts from one database (MYSQL) to another MYSQL database?

And when It comes to my error, when you try to create a account, i'm getting the error

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42000]: Syntax error or access violation: 1064 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 'WHERE `player_id` = 155 AND `skillid` = 0' at line 1' in C:\xampp\htdocs\eng\qe\pot\OTS_Player.php:184 Stack trace: #0 C:\xampp\htdocs\eng\qe\pot\OTS_Player.php(184): PDO->query('UPDATE `player_...') #1 C:\xampp\htdocs\eng\qe\accountmanagement.php(710): OTS_Player->save() #2 C:\xampp\htdocs\eng\qe\index.php(130): include('C:\xampp\htdocs...') #3 {main} thrown in C:\xampp\htdocs\eng\qe\pot\OTS_Player.php on line 184

I have no Idea of what the problem is about, I have been trying but it doesn't looks like it gets nowhere...

Thanks,
Zer0xe.

 

[Nikkster]

Hello, yes it's just to export the database you'd like to have, and then just import the database again and if needed, delete all triggers.

Maybe you're using a wrong AAC, could you try re-installing it, also be sure the AAC Version supports the TFS you are using.

 

[Zer0xe]

Okay, thanks. I'll try that.
But I use the TFS 0.2.x Mystic Spirit, THEBEST031a_for_TFS_02

But I would like to use a 8.41 Database too 8.42 - So I guess that's not possible, is it?

Zer0xe.

 

[Zer0xe]

Now I'm getting some sort of weird error when try to import the accounts/player things.

 DELIMITER ; -- -- Data i tabell `accounts` -- INSERT INTO `accounts` (`id`, `name`, `password`, `premdays`, `lastday`, `email`, `key`, `blocked`, `warnings`, `group_id`, `page_lastday`, `email_new`, `email_new_time`, `created`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `premium_points`, `vote`, `passed`, `blocked_short`, `blocked_normal`, `blocked_long`) VALUES (1, '1', 'patrik112', 65535, 1241775576, '', '0', 0, 0, 1, 1240333885, '', 0, 0, '', '', 3, '0', 0, 0, 0, 0, 0, 0, 0), (164794, '891130', 'jaken1337', 0, 1241775576, '[email protected]', '0', 0, 0, 1, 1241029634, '', 0, 1240569723, '', '', 0, '0', 0, 0, 0, 0, 0, 0, 0), (235900, 'XGIRL', 'xgirl', 0, 1241775576, '[email protected]', '0', 0, 0, 1, 1240848214, '', 0, 1240848206, '', '', 0, '0', 0, 0, 0, 0, 0, 0, 0), (242004, '9934576', 'killer560', 0, 1241775576, '[email protected]', '0', 0, 0, 1, 1240686527, '', 0, 1240686516, '', '', 0, '0', 0, 0, 0, 0, 0, 0, 0), (275878, 'Z', 'z', 0, 1241713880, 'z[...]

MySQL sa: Dokumentation
#1054 - Unknown column 'name' in 'field list'

Zer0xe.