Can't login to the game

[Frozt]

15/11/2008 15:14:26] > MySQL ERROR mysql_real_query: SELECT `id`, `password`, `type`, `premdays`, `lastday`, `key`, `warnings` FROM `accounts` WHERE `id` = 1 Unknown column 'type' in 'field list'

I used my old accounts changed the pos x,y and z to line with the new map but i can't log into the game.

 

[Chris]

Most likely there's no "type" field in your accounts database. Add it manually in phpMyAdmin.

 

[Frozt]

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'loss_items' in 'field list'' in C:\xampp\htdocs\pot\OTS_Player.php:113 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Player.php(113): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\pot\OTS_Row_DAO.php(53): OTS_Player->load(1) #2 C:\xampp\htdocs\pot\OTS_Base_List.php(224): OTS_Row_DAO->__construct(1) #3 C:\xampp\htdocs\accountmanagement.php(62): OTS_Base_List->current() #4 C:\xampp\htdocs\index.php(133): include('C:\xampp\htdocs...') #5 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 113

 

[Frozt]

any clué to my new problem there i'm not all to well put into that part

 

[Blue Charizard]

Its basically saying that your database lacks the column `loss_items`, it usually happens when you use an AAC for TFS 0.3, and your server is either TFS 0.2 or some other type whos database lacks that field.

 

[Frozt]

Thanks blue =)

 

[Nikkster]

It should work if you just made a new database or something, or whether you fix the columns, that's frequently up to you.

 

[Frozt]

I must say i rly do suck at doing these things creating a database from 0 i can't is the anyother database out there i could steal it from or use? for tfs alpha4 i belive it is