MySQL is being really helpful here, simply remove the line
Code:
ALTER TABLE `orders` DROP `total_weight`;
and then rerun the install sql. That is not a necessary line and in most ZC installs it will simply show an error as a bar at the top of the screen after it has been run. What version of MySQL is balking at you?
Bookmarks