Post by SparxGroup » Wed Jul 01, 2009 12:48 pm

A client has this error on their shop, can somebody help out?

Code: Select all

Error: Table 'bolarc_shopmate.cart_zone_to_geo_zone' doesn't exist
Error No: 1146
SELECT * FROM cart_zone_to_geo_zone WHERE geo_zone_id = '0' AND country_id = '153' AND (zone_id = '2344' OR zone_id = '0')

I have deleted the geo zones to try that but it still shows the error???

Any ideas please.

New member

Posts

Joined
Tue Feb 10, 2009 11:53 am

Post by Qphoria » Wed Jul 01, 2009 1:00 pm

Not OpenCart. No such table

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by SparxGroup » Wed Jul 01, 2009 1:18 pm

It is opencart. the bolarc_shopmate is the database. zone_to_geo_zone is the table... :S

New member

Posts

Joined
Tue Feb 10, 2009 11:53 am

Post by Qphoria » Wed Jul 01, 2009 7:09 pm

oh .. ok :) forgot about prefixes :P

Looks like it doesn't exist. so add it manually from the install sql file

Image
Donate!|OpenCart Basics|GeoZones
Image


User avatar
Administrator

Posts

Joined
Tue Jul 22, 2008 3:02 am

Post by Daniel » Thu Jul 02, 2009 8:35 am

remove the cart prefix from the config file. I'm assuming you did an upgrade?

OpenCart®
Project Owner & Developer.


User avatar
Administrator

Posts

Joined
Fri Nov 03, 2006 6:57 pm

Post by SparxGroup » Thu Jul 02, 2009 8:50 am

Actually thanks for that - it seems to be working fine now :)

New member

Posts

Joined
Tue Feb 10, 2009 11:53 am
Who is online

Users browsing this forum: No registered users and 37 guests