hi all I tried to update to the latest version but had loads of issues so I tried to go back to Version 1.5.6.1, I did a back up via ftp and also via the admin but when I restore I get the following message any help please. If I cant get a fix I have lost the lot.
Notice: Error: Table '.oc_openbay_faq' doesn't exist
Error No: 1146
TRUNCATE TABLE `oc_openbay_faq` in /home/linweb31/g/.co.uk/user/htdocs/system/database/mysql.php on line 50
Notice: Error: Table '.oc_openbay_faq' doesn't exist
Error No: 1146
TRUNCATE TABLE `oc_openbay_faq` in /home/linweb31/g/.co.uk/user/htdocs/system/database/mysql.php on line 50
Last edited by mRC on Tue Mar 17, 2015 4:19 pm, edited 2 times in total.
Just go to phpmyadmin through cpanel.
Then go to your database table and then click sql button. Paste the code below and click go.
Your issue should be fixed with this.
For assistance email: imdevlper18@gmail.com
Then go to your database table and then click sql button. Paste the code below and click go.
Code: Select all
CREATE TABLE IF NOT EXISTS `oc_openbay_faq` (`id` int(11) NOT NULL AUTO_INCREMENT,`route` text NOT NULL, PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8;
Your issue should be fixed with this.
For assistance email: imdevlper18@gmail.com
Opencart Extensions | Professional opencart support | Support Ticket | support@cartbinder.com
thanks very much it did work but now stuck on this line now
Notice: Error: Unknown column 'paypal_order_id' in 'field list'
Error No: 1054
INSERT INTO `oc_paypal_order` (`paypal_order_id`, `order_id`, `created`, `modified`, `capture_status`, `currency_code`, `authorization_id`, `total`) VALUES ('1', '43', '2014-10-21 10:49:10', '2014-10-21 10:49:10', 'Complete', 'GBP', '7L65676096639692P', '33.99') in /home/linweb31/g/.co.uk/user/htdocs/system/database/mysql.php on line 50
any idea please and much appreciated
Notice: Error: Unknown column 'paypal_order_id' in 'field list'
Error No: 1054
INSERT INTO `oc_paypal_order` (`paypal_order_id`, `order_id`, `created`, `modified`, `capture_status`, `currency_code`, `authorization_id`, `total`) VALUES ('1', '43', '2014-10-21 10:49:10', '2014-10-21 10:49:10', 'Complete', 'GBP', '7L65676096639692P', '33.99') in /home/linweb31/g/.co.uk/user/htdocs/system/database/mysql.php on line 50
any idea please and much appreciated
Last edited by mRC on Tue Mar 17, 2015 4:19 pm, edited 1 time in total.
There is an column issue, Currently your oc_paypal_order table does not contain column called paypal_order_id
You need to add it.
You need to add it.
Opencart Extensions | Professional opencart support | Support Ticket | support@cartbinder.com
Who is online
Users browsing this forum: No registered users and 7 guests