The sql above will fix the items schema to be in concordance with the latest binary. I realize it may not work for everyone, so the sql needs to be sourced in line by line. You really need to download heidiSQL and perform these changes. If these don't work, I will upload an items table for you.
GeorgeS
Quote:
Originally Posted by AudioGarden21
As you can see they're pretty much identical.
I recognize that there are unknown fields in the database but I can't seem to remove them or get them updated.
I've done a fresh database with the latest SVN build (Rev1549) and it just doesn't seem to make any difference. I've been at it for hours.
My current server build is Rev1535 as well. I had a server about a year ago or so that was running just fine but I decided to get rid of it because there were a few issues with damage dealing and intake (it wasn't very accurate to live servers).
I've been scouring the forums looking for an answer and the one posted by GeorgeS up above seems like the most logical step. However the only issue is I can't seem to get the SQL (1542_items_table_cleanup to be exact, which contains those lines he posted) to source for the life of me. I'm also unsure of what he means by "post these changes to make it work".
Anyone able to clarify how to do this?
|