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
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.
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
Who is online
Users browsing this forum: No registered users and 20 guests
