BugMeNot Posted December 4, 2013 Group: Members Topic Count: 5 Topics Per Day: 0.00 Content Count: 15 Reputation: 0 Joined: 10/06/12 Last Seen: May 17, 2014 Share Posted December 4, 2013 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 Quote Link to comment Share on other sites More sharing options...
Patskie Posted December 5, 2013 Group: Members Topic Count: 50 Topics Per Day: 0.01 Content Count: 1702 Reputation: 238 Joined: 09/05/12 Last Seen: April 21 Share Posted December 5, 2013 Try to execute this on your database : ALTER TABLE `char` ADD COLUMN `unban_time` INT(11) unsigned NOT NULL default '0', Quote Link to comment Share on other sites More sharing options...
0 bdgro Posted May 27, 2017 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 37 Reputation: 0 Joined: 05/05/17 Last Seen: August 2, 2018 Share Posted May 27, 2017 i got same problem, anyone can help me? Quote Link to comment Share on other sites More sharing options...
0 Cyro Posted May 27, 2017 Group: Members Topic Count: 8 Topics Per Day: 0.00 Content Count: 1137 Reputation: 290 Joined: 04/29/13 Last Seen: January 9, 2023 Share Posted May 27, 2017 19 minutes ago, bdgro said: i got same problem, anyone can help me? If u got same problem, the answer already mentioned in here Quote Link to comment Share on other sites More sharing options...
0 bdgro Posted May 27, 2017 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 37 Reputation: 0 Joined: 05/05/17 Last Seen: August 2, 2018 Share Posted May 27, 2017 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.. Quote Link to comment Share on other sites More sharing options...
0 Cyro Posted May 27, 2017 Group: Members Topic Count: 8 Topics Per Day: 0.00 Content Count: 1137 Reputation: 290 Joined: 04/29/13 Last Seen: January 9, 2023 Share Posted May 27, 2017 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 Quote Link to comment Share on other sites More sharing options...
0 bdgro Posted May 27, 2017 Group: Members Topic Count: 9 Topics Per Day: 0.00 Content Count: 37 Reputation: 0 Joined: 05/05/17 Last Seen: August 2, 2018 Share Posted May 27, 2017 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 Quote Link to comment Share on other sites More sharing options...
Aksl Posted December 4, 2013 Group: Members Topic Count: 3 Topics Per Day: 0.00 Content Count: 35 Reputation: 2 Joined: 05/23/12 Last Seen: September 27, 2014 Share Posted December 4, 2013 Do you have column 'unban_time' in `char` table ? Quote Link to comment Share on other sites More sharing options...
BugMeNot Posted December 5, 2013 Group: Members Topic Count: 5 Topics Per Day: 0.00 Content Count: 15 Reputation: 0 Joined: 10/06/12 Last Seen: May 17, 2014 Author Share Posted December 5, 2013 finally it's working again..maybe i accidently deleted the column during cleanup before this thank you for helping me Quote Link to comment Share on other sites More sharing options...
bomdekd Posted December 6, 2013 Group: Members Topic Count: 0 Topics Per Day: 0 Content Count: 1 Reputation: 0 Joined: 12/05/13 Last Seen: August 30, 2014 Share Posted December 6, 2013 up download pm Quote Link to comment Share on other sites More sharing options...
Question
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
Link to comment
Share on other sites
9 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.