Post by shepscrook » Fri Aug 16, 2013 1:58 am

This is the error I get when I try to edit a product.

Notice: Error: Table 'xxxxxx_ocart.oc_profile' doesn't exist
Error No: 1146
SELECT `p`.`profile_id`, `p`.`sort_order`, `pd`.`name` FROM `oc_profile` AS `p` JOIN `oc_profile_description` AS `pd` ON `pd`.`profile_id` = `p`.`profile_id` AND `pd`.`language_id` = 1 ORDER BY p.sort_order ASC in /home/xxxxxx/public_html/xxxxxx.com/system/database/mysql.php on line 50

Any ideas on what could fix this?

Newbie

Posts

Joined
Wed Aug 07, 2013 11:38 pm

Post by Antoni4 » Fri Aug 16, 2013 9:26 am

Go to the database and check if table oc_profile is present in your 1.5.6 installation.

User avatar
New member

Posts

Joined
Sat Sep 29, 2012 7:03 am

Post by butte » Fri Aug 16, 2013 12:46 pm

Ditto, simply "profile" -- just in case there are two sets of tables, with oc prefix, and with no prefix. You can check that via phpMyAdmin.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by badavis5 » Fri Sep 13, 2013 9:42 pm

ok, so the oc_profile table is not there... now what?
I assume I have to just create one but I don't know the names, values or attributes to use. any help would be great

Newbie

Posts

Joined
Fri Sep 13, 2013 9:38 pm

Post by butte » Sat Sep 14, 2013 5:53 am

Back in a minute with links, Google Updater is about to die a horrible death, it is set to shut up and does not shut up. [Dead.]

One thread offers a practical solution:
http://forum.opencart.com/viewtopic.php?f=19&t=106677
see also http://forum.opencart.com/viewtopic.php ... 44#p431649

to this problem:
Notice: Error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AFTER `price`' at line 1
Error No: 1064
ALTER TABLE `oc_profile` CHANGE `frequency` `frequency` ENUM AFTER `price` in

Plural threads and isolated posts accordingly bear cross-linkage, at least for the sake of noting its prevalence:
http://forum.opencart.com/viewtopic.php ... 21#p424887 (with a user's editorial comment below it)
http://forum.opencart.com/viewtopic.php?f=20&t=106706 (with perspectives)
http://forum.opencart.com/viewtopic.php?f=20&t=106973

Instances are beginning to proliferate a little bit, perhaps according to whether people search carefully first (or don't search). The problem is known, it will undoubtedly be remedied in 1.5.6.1 in due course.

Guru Member

Posts

Joined
Wed Mar 20, 2013 6:58 am

Post by swiftws » Sat Dec 28, 2013 8:25 pm

if i be honest with you . No idea what this guy @butte tries to say here. i mean just give 4 to 5 links and saying go and find the help.

If you have upgraded to 1.5.6 and getting the error above . THis means oc_profile is mission from your data base . all you need to do is type yourwebsite.com/install . if the install folder is not there just reinstall it and type that once you done this . Click on continue and you are good to go.

Worked for me . and defiantly will work for you .

Newbie

Posts

Joined
Mon Dec 23, 2013 11:00 pm

Post by Antoni4 » Fri Jul 04, 2014 9:09 pm

To create oc_profile table you can run this:

CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

But you might also need to create oc_profile_description table.

CREATE TABLE IF NOT EXISTS `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 DEFAULT CHARSET=utf8;

User avatar
New member

Posts

Joined
Sat Sep 29, 2012 7:03 am
Who is online

Users browsing this forum: No registered users and 18 guests