Post by toothless3010 » Tue Nov 14, 2017 12:34 pm

This error shows up whenever I delete the upload(trident) folder in xampp/htdocs/trident and paste a new upload folder with the same name "trident". I understand that the table already exist but i tried finding for the solution in the internet and i cant seem to find it. Can anybody tell me what to do so i can move on successfully installing opencart again. I have come across this error few times and i choose to ignore it by installing xampp server and it solves the problem. Im sure there is other way to solve this in a easier way. Im seeking the opencart community help.

Fatal error: Uncaught exception 'ErrorException' with message 'Error: Table 'oc_product_profile' already exists<br />Error No: 1050<br /> 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; ' in

Newbie

Posts

Joined
Tue Sep 05, 2017 5:02 pm

Post by webmedialdh » Tue Nov 14, 2017 2:39 pm

Use create table condition :

Code: Select all

CREATE TABLE IF NOT EXISTS `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; 
Regards

Webx IT Solutions
Tel: +91 99154 09292, Skype: webmedialdh, Email: support@webxitsolutions.com
Image


User avatar
New member

Posts

Joined
Fri Apr 22, 2016 5:52 pm
Location - Ludhiana, Punjab

Post by toothless3010 » Tue Nov 14, 2017 3:22 pm

Im sorry, but where do I do this??
Use create table condition :
Code: Select all

CREATE TABLE IF NOT EXISTS `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;

Newbie

Posts

Joined
Tue Sep 05, 2017 5:02 pm
Who is online

Users browsing this forum: No registered users and 29 guests