Post by mRC » Tue Dec 16, 2014 7:37 am

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
Last edited by mRC on Tue Mar 17, 2015 4:19 pm, edited 2 times in total.

mRC
Active Member

Posts

Joined
Wed Nov 12, 2014 12:43 am

Post by imdevlper18 » Tue Dec 16, 2014 1:58 pm

Just go to phpmyadmin through cpanel.

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


User avatar
Active Member

Posts

Joined
Sun May 11, 2014 2:04 pm

Post by mRC » Tue Dec 16, 2014 3:31 pm

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
Last edited by mRC on Tue Mar 17, 2015 4:19 pm, edited 1 time in total.

mRC
Active Member

Posts

Joined
Wed Nov 12, 2014 12:43 am

Post by imdevlper18 » Tue Dec 16, 2014 3:36 pm

There is an column issue, Currently your oc_paypal_order table does not contain column called paypal_order_id
You need to add it.

Opencart Extensions | Professional opencart support | Support Ticket | support@cartbinder.com


User avatar
Active Member

Posts

Joined
Sun May 11, 2014 2:04 pm

Post by mRC » Tue Dec 16, 2014 9:03 pm

thanks for the info I did manage to get the site back with a very old sql backup thanks again for your help

mRC
Active Member

Posts

Joined
Wed Nov 12, 2014 12:43 am
Who is online

Users browsing this forum: No registered users and 7 guests