Page 1 of 1

Upgrade from 1.5.5.1 to 1.5.6 error when editing products.

Posted: Fri Aug 16, 2013 1:58 am
by shepscrook
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?

Re: Upgrade from 1.5.5.1 to 1.5.6 error when editing product

Posted: Fri Aug 16, 2013 9:26 am
by Antoni4
Go to the database and check if table oc_profile is present in your 1.5.6 installation.

Re: Upgrade from 1.5.5.1 to 1.5.6 error when editing product

Posted: Fri Aug 16, 2013 12:46 pm
by butte
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.

Re: Upgrade from 1.5.5.1 to 1.5.6 error when editing product

Posted: Fri Sep 13, 2013 9:42 pm
by badavis5
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

Re: Upgrade from 1.5.5.1 to 1.5.6 error when editing product

Posted: Sat Sep 14, 2013 5:53 am
by butte
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.

Re: Upgrade from 1.5.5.1 to 1.5.6 error when editing product

Posted: Sat Dec 28, 2013 8:25 pm
by swiftws
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 .

Re: Upgrade from 1.5.5.1 to 1.5.6 error when editing product

Posted: Fri Jul 04, 2014 9:09 pm
by Antoni4
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;