1.30 - 1.31. Database Restore Problems

Upgrading from 1.30 ti 1.31. When restoring backed up database i get this error.
Note: I did run the SQL Query then backed up the database. Also Fostex was a disabled products if that is any help.

Error: Unknown column 'discount' in 'field list'
Error No: 1054
INSERT INTO `order_product` (`order_product_id`, `order_id`, `product_id`, `name`, `model`, `price`, `discount`, `total`, `tax`, `quantity`) VALUES ('1', '1', '52', 'Fostex PC-1EX Volume Controller', 'PC-1EX', '50.0000', '0.0000', '50.0000', '0.0000', '1')

Also weirdly its put the catergories only back on the new clean install when restore the database but all the products ect are missing. Any ideas?

This isn't your fault.

The reason you have categories, is because thats how far the backup script got until it error'd.

This part of the script is trying to restore your previous orders, so it;s trying to add this product to an order.
Orders used to have a discount field, but not anymore, so it's trying to put data into the discounts table but it doesn;t exist, hence it error'd.

Have to wait to see if Daniel has a fix.

I have the same problem.

Little confused....I just did clean install which worked fine but when I went to restore back up from 1.3 nothing is restores. I am not getting any error message so am I missing that I have to change something in tables.

thanks

No, you only get errors if you restore through phpmyadmin.
If you restore through the admin panel, it will say it's sucessful when really it's not.

so we are waiting for a fix then?

I'm not sure that Daniel will release a fix as he seems to have ignored the problem.

There are two ways around this; dropping the tables from the original database, then creating a backup and using that. But i don't like this method, because if something goes wrong, you have modified your old database which isn't good.

The method that i prefer, that i will be doing myself in a bit is creating these tables again, restoring the backup, then dropping the tables after.

After i have done it, and if it's sucessful, i'll post instructions here in a bit.