Post by cmebd » Sat Jan 16, 2010 8:24 am

Need help badly.

Have received this error message:

Code: Select all

Error: Unknown column 'mode' in 'where clause'
Error No: 1054
SELECT * FROM oc_product_option WHERE product_id = '49' AND `mode` = 'select' ORDER BY sort_order
After clicking on "edit" from products list. This is a completely new install with only two mods installed.

TIA for any help.

Cheers

A stupid question is the one you -don't- ask.........(Anon)

)C1.5.0.1 (IN devel)
OC V1.4.9.5
OC V1.4.9.2
OC V1.4.7
OC V1.3.4


User avatar
Active Member

Posts

Joined
Fri Nov 13, 2009 11:17 am
Location - Tasmania, Australia

Post by Xsecrets » Sat Jan 16, 2010 8:28 am

one of those mods must have done this since as far as I know there is no mode field in the default database at all, and there are no problems adding products/options.

You'll probably need to specify which mods it is you are using.

OpenCart commercial mods and development http://spotonsolutions.net
Layered Navigation
Shipment Tracking
Vehicle Year/Make/Model Filter


Guru Member

Posts

Joined
Sun Oct 25, 2009 3:51 am
Location - FL US

Post by cmebd » Sat Jan 16, 2010 8:44 am

meant to add: If install instructions for each of the mods are of any help I can attach those......

Hi there,

I have installed the calendar/event module a header module (putting currency and login etc modules in header). Shopping cart module enhancement that adds a "view basket" after products added.

The front end is http://karoola.com.au/index.php.

I have deleted the default products together with their graphics in both image folder and cache.

Can't think of anything else I have done apart from css modifications.



Any help is more than appreciated.

Cheers

A stupid question is the one you -don't- ask.........(Anon)

)C1.5.0.1 (IN devel)
OC V1.4.9.5
OC V1.4.9.2
OC V1.4.7
OC V1.3.4


User avatar
Active Member

Posts

Joined
Fri Nov 13, 2009 11:17 am
Location - Tasmania, Australia
Who is online

Users browsing this forum: No registered users and 14 guests