JeffShadow90 Posted November 26, 2011 Group: Members Topic Count: 10 Topics Per Day: 0.00 Content Count: 15 Reputation: 0 Joined: 11/26/11 Last Seen: December 16, 2011 Share Posted November 26, 2011 (edited) Hi. We encountered a big big problem with SQL We had a trunk version in the Hosting.. with SQL.. everything was fine but we decided to change the emulator to a Stable version. We thought that the emulator was compatible but after we uploaded it, the MySQL changed everything like money, levels ecc.. We gave back every object after a rollback back to the players.. and than the chars dissapeared °_° Does anybody knows why? or a solution? Thanks Uploaded with ImageShack.us Edited November 26, 2011 by JeffShadow90 Quote Link to comment Share on other sites More sharing options...
0 Brian Posted November 26, 2011 Group: Members Topic Count: 75 Topics Per Day: 0.02 Content Count: 2223 Reputation: 593 Joined: 10/26/11 Last Seen: June 2, 2018 Share Posted November 26, 2011 If you have a SQL backup, restore it. Check if the `char`.`base_level` column is there. If it is there in the backup, it means you or someone with SQL access deleted the column accidentally or on purpose. 1 Quote Link to comment Share on other sites More sharing options...
0 Judas Posted November 26, 2011 Group: Members Topic Count: 26 Topics Per Day: 0.01 Content Count: 2244 Reputation: 182 Joined: 11/19/11 Last Seen: April 14 Share Posted November 26, 2011 Doesnt look good. What i see it u need to insert a new column in sql for base_level or ur missing a whole row of char variables. Quote Link to comment Share on other sites More sharing options...
0 simplynice Posted November 26, 2011 Group: Members Topic Count: 25 Topics Per Day: 0.01 Content Count: 128 Reputation: 4 Joined: 11/14/11 Last Seen: April 13, 2016 Share Posted November 26, 2011 stable or trunk has the same database/sql format i guess. if it is so then it will never happen not unless you accidentally deleted one of the table/fields. Quote Link to comment Share on other sites More sharing options...
Question
JeffShadow90
Hi.
We encountered a big big problem with SQL
We had a trunk version in the Hosting.. with SQL.. everything was fine but we decided to change the emulator to a Stable version.
We thought that the emulator was compatible but after we uploaded it, the MySQL changed everything like money, levels ecc..
We gave back every object after a rollback back to the players.. and than the chars dissapeared °_°
Does anybody knows why? or a solution?
Thanks
Uploaded with ImageShack.us
Edited by JeffShadow90Link to comment
Share on other sites
3 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.