Hi James,
The problem is caused by the additional SQL queries inserted into the database.
They do not have the prefix that has been used when your original site was configured.
Neither the new tables, or the modified tables will be correct.
Please see the following SQL query, and substitute YOUR PREFIX with whatever you have set as a prefix.
Run the query either through zen admin, or phpmyadmin.
Be sure to back up your database first.
CREATE TABLE YOUR PREFIX_free_gifts (
gift_id tinyint(4) NOT NULL auto_increment,
threshold mediumint(9) NOT NULL default '0',
products_id mediumint(9) NOT NULL default '0',
PRIMARY KEY (gift_id)
) TYPE=MyISAM;
insert into YOUR PREFIX_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values (1200, 'Gifts Image Width', 'GIFTS_IMAGE_WIDTH', '90', 'The pixel width of heading images', '4', '25', now(), now(), NULL, NULL);
insert into YOUR PREFIX_configuration (configuration_id, configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, last_modified, date_added, use_function, set_function) values (1201, 'Gifts Image Height', 'GIFTS_IMAGE_HEIGHT', '100', 'The pixel height of heading images', '4', '26', now(), now(), NULL, NULL);
UPDATE YOUR PREFIX_configuration_group SET sort_order=last_insert_id() WHERE configuration_group_id=last_insert_id();
ALTER TABLE YOUR PREFIX_products ADD products_carrot tinyint(1) default '0' AFTER products_status ;
That should solve all your problems.
Regards
Steve
