I have three backups, MySQL database dump, the backup.sql that Opencart creates, and I have a full backup of the store taken from my old server before I moved to a new host. I ended up doing a fresh install because I could not get the previous install to take in the new server, to many weird errors and to much time. The fresh install worked great even better than last time I did one. I installed my MySQL database backup, uploaded all my photos, and then installed though Opencart the backup.sql generated by Opencart when it finished I get this error on a blank page
Notice: Error: Unknown column 'tax_class_id' in 'field list'
Error No: 1054
INSERT INTO `tax_rate` (`tax_rate_id`, `geo_zone_id`, `tax_class_id`, `priority`, `rate`, `description`, `date_modified`, `date_added`) VALUES ('86', '3', '9', '1', '17.5000', 'VAT 17.5%', '0000-00-00 00:00:00', '2011-03-09 21:17:10') in /home/myname/public_html/store/system/database/mysql.php on line 49
Then I went to the store's home page and I see this error at the very top of the page
plus I saw that my Banner with the slideshow was not there and Featured was not thereWarning: Invalid argument supplied for foreach() in /home/myname/public_html/store/catalog/controller/common/column_left.php on line 49Warning: Invalid argument supplied for foreach() in /home/myname/public_html/store/catalog/controller/common/column_right.php on line 49Warning: Invalid argument supplied for foreach() in /home/myname/public_html/store/catalog/controller/common/content_top.php on line 49Warning: Invalid argument supplied for foreach() in /home/myname/public_html/store/catalog/controller/common/content_bottom.php on line 49
but it is a easy fix, just uninstall and then re-install the Modules and the error went away and then re-did the Banner and Featured and now everything works.
What sucks really bad is that I just spent days inputting SEO Keywords for Pretty URLs and was just going to go live with my store after the move to the new server but the backup did not restore the SEO Keywords, all the boxes are empty.
I do have the the full backup of the last install is there a file in there that I can copy over into this install of Opencart to restore the SEO Keywords? Not looking forward to having to input all that data again. I really appreciate any help on this one.