Character missing and SQL error

[BugMeNot]

Hi all,

Need help on database

it seems all character is missing from selection menu and i cannot create any new character..either using my account or my friends account

already try to restore from earlier backup but the problem still persist..i don't want to lose any of my progress

 

screenshot of charserv:

 

char in sql:

 

 

thanks

[Patskie]

Try to execute this on your database :

ALTER TABLE `char` ADD COLUMN `unban_time` INT(11) unsigned NOT NULL default '0',

[bdgro]

i got same problem, anyone can help me?

[Cyro]

19 minutes ago, bdgro said:

i got same problem, anyone can help me?

If u got same problem, the answer already mentioned in here

[bdgro]

1 hour ago, Cyro said:

If u got same problem, the answer already mentioned in here

yes but my unban_time already done.. and still error..

 

 

[Cyro]

3 hours ago, bdgro said:

yes but my unban_time already done.. and still error..

 

 

as i asked already, paste errors here from your console if any

[bdgro]

30 minutes ago, Cyro said:

as i asked already, paste errors here from your console if any

nothing error from console.. everything is fine.. but i cannot create new character 

[Aksl]

Do you have column 'unban_time' in `char` table ?

[BugMeNot]

finally it's working again..maybe i accidently deleted the column during cleanup before this

 

thank you for helping me 

[bomdekd]

up download  pm