SQL Problem

[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 November 26, 2011 by JeffShadow90

[Brian]

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.

[Judas]

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.

[simplynice]

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.