Post by carmedia » Tue Sep 09, 2014 3:16 am

Hej, I have upgraded from 1.5.5 to 1.5.6.4 and when i click on product this mesg comes up. How can i fix this problem.

Notice: Error: Table 'carmedia_se.oc_product_profile' doesn't exist
Error No: 1146

SELECT `pd`.* FROM `oc_product_profile` `pp` JOIN `oc_profile_description` `pd` ON `pd`.`language_id` = 2 AND `pd`.`profile_id` = `pp`.`profile_id` JOIN `oc_profile` `p` ON `p`.`profile_id` = `pd`.`profile_id` WHERE `product_id` = 81 AND `status` = 1 AND `customer_group_id` = 1 ORDER BY `sort_order` ASC in /customers/8/e/3/carmedia.se/httpd.www/system/database/mysql.php on line 50

Car Multimedia System, Sales, Support & Installation


User avatar
Newbie

Posts

Joined
Sun Sep 08, 2013 7:54 pm
Location - Sweden

Post by imdevlper18 » Tue Sep 09, 2014 3:15 pm

Version 1.5.6.4 adds new table in database. You need to add them as well.

Go to cpanel - phpmyadmin - database - sql and then copy code below and click go.

Code: Select all

CREATE TABLE `oc_product_profile` (
  `product_id` int(11) NOT NULL,
  `profile_id` int(11) NOT NULL,
  `customer_group_id` int(11) NOT NULL,
  PRIMARY KEY (`product_id`,`profile_id`,`customer_group_id`)
) ENGINE=MyISAM COLLATE=utf8_general_ci;



CREATE TABLE `oc_profile` (
  `profile_id` int(11) NOT NULL AUTO_INCREMENT,
  `sort_order` int(11) NOT NULL,
  `status` tinyint(4) NOT NULL,
  `price` decimal(10,4) NOT NULL,
  `frequency` enum('day','week','semi_month','month','year') NOT NULL,
  `duration` int(10) unsigned NOT NULL,
  `cycle` int(10) unsigned NOT NULL,
  `trial_status` tinyint(4) NOT NULL,
  `trial_price` decimal(10,4) NOT NULL,
  `trial_frequency` enum('day','week','semi_month','month','year') NOT NULL,
  `trial_duration` int(10) unsigned NOT NULL,
  `trial_cycle` int(10) unsigned NOT NULL,
  PRIMARY KEY (`profile_id`)
) ENGINE=MyISAM COLLATE=utf8_general_ci;


CREATE TABLE `oc_profile_description` (
  `profile_id` int(11) NOT NULL,
  `language_id` int(11) NOT NULL,
  `name` varchar(255) NOT NULL,
  PRIMARY KEY (`profile_id`,`language_id`)
) ENGINE=MyISAM COLLATE=utf8_general_ci;

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


User avatar
Active Member

Posts

Joined
Sun May 11, 2014 2:04 pm
Who is online

Users browsing this forum: No registered users and 20 guests