I had the same issue with the new "update" that came out after we released kunark.
I had to do the following to get it working properly.
Follow the directions, but after you run doors_update.sql you'll notice a error in freport. but the last 2 go through fine.
Now run this.
mysqldump -u user -p databasename doors>doors.sql
that dumps the contents of your doors table.
Now do this.
DELETE FROM doors;
Now run the doors_update.sql AGAIN on the empty doors table.
It should update your first one, and error on the second 2, because they were already done previously. Now your structure should be proper.
now
source doors.sql
and itll put the info back into your table. Proceed with doorsdata.sql and you are done.
|