Post by paul_232 » Fri Oct 03, 2014 11:22 pm

Have uploaded as instructed, no issues, have set top admin access rights, but can't find any reference to the tool within the admin system?

Any ideas?

Newbie

Posts

Joined
Fri Oct 03, 2014 11:18 pm

Post by Cue4cheap » Sat Oct 04, 2014 6:07 am

Do you have VQMod installed and working?
Mike

cue4cheap not cheap quality


Expert Member

Posts

Joined
Fri Sep 20, 2013 4:45 am

Post by adb34 » Sun Oct 05, 2014 3:05 am

The only problem I have is that I cannot generate products. I get an error message;
Error: Unknown column 'po.option_value' in 'field list'
Error No: 1054
SELECT p.product_id, po.option_id, po.option_value, po.required, od.name AS `option` FROM ( SELECT product_id FROM `open_product` WHERE product_id BETWEEN 28 AND 53 ORDER BY product_id ASC ) AS p INNER JOIN `open_product_option` po ON po.product_id=p.product_id INNER JOIN `open_option_description` od ON od.option_id=po.option_id AND od.language_id='1' ORDER BY p.product_id ASC, po.option_id ASC

New member

Posts

Joined
Sat Sep 20, 2014 8:49 pm

Post by adb34 » Sun Oct 05, 2014 9:10 pm

When I import the categories file it uploads ok and the changes can be seen. However, when I catalog/categories page there is nothing displayed on the page.

New member

Posts

Joined
Sat Sep 20, 2014 8:49 pm

Post by adb34 » Mon Oct 06, 2014 3:22 am

Further to the above problems I am now getting these error messages on the product page header;
Notice: Undefined index: option_value in /homepages/20/d503465712/htdocs/shops/OpenCart/opencart/admin/model/catalog/product.php on line 505Notice: Undefined index: option_value in /homepages/20/d503465712/htdocs/shops/OpenCart/opencart/admin/model/catalog/product.php on line 505Notice: Undefined index: option_value in /homepages/20/d503465712/htdocs/shops/OpenCart/opencart/admin/model/catalog/product.php on line 505Notice: Undefined index: option_value in /homepages/20/d503465712/htdocs/shops/OpenCart/opencart/admin/model/catalog/product.php on line 505Notice: Undefined index: option_value in /homepages/20/d503465712/htdocs/shops/OpenCart/opencart/admin/model/catalog/product.php on line 505Notice: Undefined index: option_value in /homepages/20/d503465712/htdocs/shops/OpenCart/opencart/admin/model/catalog/product.php on line 505Notice: Undefined index: option_value in /homepages/20/d503465712/htdocs/shops/OpenCart/opencart/admin/model/catalog/product.php on line 505Notice: Undefined index: option_value in /homepages/20/d503465712/htdocs/shops/OpenCart/opencart/admin/model/catalog/product.php on line 505Notice: Undefined index: option_value in /homepages/20/d503465712/htdocs/shops/OpenCart/opencart/admin/model/catalog/product.php on line 505

New member

Posts

Joined
Sat Sep 20, 2014 8:49 pm

Post by JNeuhoff » Mon Oct 06, 2014 5:33 am

adb34 wrote:Error: Unknown column 'po.option_value' in 'field list'
You are not using any of the Opencart 1.5.1.x to 1.5.6.x databases, with the corresponding OpenCart versions, because for all these versions there is a 'product_option.option_value'. Looks like you are not telling us the whole story here.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by adb34 » Tue Oct 07, 2014 10:52 pm

You are not using any of the Opencart 1.5.1.x to 1.5.6.x databases, with the corresponding OpenCart versions, because for all these versions there is a 'product_option.option_value'. Looks like you are not telling us the whole story here.
A have no idea what you are trying to say here, sorry. Are you talking about the database that is being used by my opencart, which is MySQL v5 or what?

New member

Posts

Joined
Sat Sep 20, 2014 8:49 pm

Post by JNeuhoff » Tue Oct 07, 2014 11:47 pm

No, I am talking about a specific DB table, namely the product_option. That one clearly has a field named option_value. Hence your error indicates that your are not using a standard OpenCart 1.5.x database.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by adb34 » Wed Oct 08, 2014 12:23 am

Hence your error indicates that your are not using a standard OpenCart 1.5.x database.
I am using MySQL v5 database for opencart. What database should I be using?

New member

Posts

Joined
Sat Sep 20, 2014 8:49 pm

Post by JNeuhoff » Wed Oct 08, 2014 12:31 am

Can someone else help him please? Yours is not a standard OpenCart database, you may use MySQL which is fine, but with different DB tables.

Export/Import Tool * SpamBot Buster * Unused Images Manager * Instant Option Price Calculator * Number Option * Google Tag Manager * Survey Plus * OpenTwig


User avatar
Guru Member
Online

Posts

Joined
Wed Dec 05, 2007 3:38 am


Post by adb34 » Wed Oct 08, 2014 11:18 pm

JNeuhoff wrote:Can someone else help him please? Yours is not a standard OpenCart database, you may use MySQL which is fine, but with different DB tables.
No need for the help. I have installed OpenCart V2 and Import/Export for that version

New member

Posts

Joined
Sat Sep 20, 2014 8:49 pm
Who is online

Users browsing this forum: No registered users and 116 guests