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 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')
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 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?
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?
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`;
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`;
Problem fixed.
Who is online
Users browsing this forum: No registered users and 22 guests
