OpenCart Community

I did a new install for 1.30 and that worked fine until I tried to restore my backup. I get an error and I am clueless to this stuff.

Error: Unknown column 'keyword' in 'field list'
Error No: 1054
INSERT INTO `category` (`category_id`, `keyword`, `image`, `parent_id`, `sort_order`, `date_added`, `date_modified`) VALUES ('46', '', 'lostS3_pw11.JPG', '38', '3', '2009-06-07 01:16:43', '2009-06-26 15:16:26')

I think your new database have another prefix and when you restore old database they cant find column check it.

I did not use a prefix on either data bases when I did the installs. So I don't really understand how there could be a different prefix unless one was designated when I installed 1.29.

download 1.3.0 and try again.

I did a fresh install which works but when I tried the restore again my backup gets the error still

Error: Unknown column 'keyword' in 'field list'
Error No: 1054
INSERT INTO `category` (`category_id`, `keyword`, `image`, `parent_id`, `sort_order`, `date_added`, `date_modified`) VALUES ('46', '', 'lostS3_pw11.JPG', '38', '3', '2009-06-07 01:16:43', '2009-06-26 15:16:26')

I think I figured it out...the problem is some of this stuff intimidates me with altering the database and such. I will see if it works

I have it working now but can get the theme to work

I Have the same error from when restoring

Error: Unknown column 'keyword' in 'field list'
Error No: 1054
INSERT INTO `category` (`category_id`, `keyword`, `image`, `parent_id`, `sort_order`, `date_added`, `date_modified`) VALUES ('44', 'dynamic', 'dynamic.jpg', '43', '0', '2009-07-07 10:32:00', '2009-07-10 11:28:47')

I upgraded from 1.2.9 and followed the instructions carefully (i hope). everything goes okay cept when i try to restore the database through the admin.

Would it be possible just to delete the phpmyadmin database and create a new one then restore the database through the admin or would that not work?

Also what was the solution to your problem comiclair?

do a fresh install.

bfore restoting your db remove all create and trunicate parts of code.

remove all create and trunicate parts of code.

Hi Daniel im not quite sure what this means? Could you explain it a bit further for me?

I fixed my database by actually following the upgrade instructions (that where included in the download) on my backup :
ALTER TABLE `oc_category` DROP `keyword`;
ALTER TABLE `oc_product` DROP `keyword`;
ALTER TABLE `oc_manufacturer` DROP `keyword`;
ALTER TABLE `oc_information` DROP `keyword`;
DROP TABLE `oc_url_alias`;

Thanks, i wont be editing tables after ive backed up my database next time Problem fixed.