Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

SQL error: REK_ZONES_TO_GEO_ZONES' doesn't exist


Recommended Posts

Posted (edited)

I've recently switched server and had to reinstall OSC. This is the fifth installation in 3 days I believe... ANYWAY! Today as I am about to "turn on" the usual shipping options I've always used (and they've worked fine so far both on old and new server) out of the blue comes the following error-message:

 

1146 - Table 'bonza_osc1.REK_ZONES_TO_GEO_ZONES' doesn't exist

 

select zone_id from REK_ZONES_TO_GEO_ZONES where geo_zone_id = '2' and zone_country_id = '' order by zone_id

 

Now what is that all about? What am I supposed to poke around in to fix that?

 

:angry:

 

ANY suggestion appreciated.

Edited by modix
  • 4 months later...
Posted (edited)
I've recently switched server and had to reinstall OSC. This is the fifth installation in 3 days I believe... ANYWAY! Today as I am about to "turn on" the usual shipping options I've always used (and they've worked fine so far both on old and new server) out of the blue comes the following error-message:

Now what is that all about? What am I supposed to poke around in to fix that?

 

:angry:

 

ANY suggestion appreciated.

 

 

I had a similar error

 

Did you create the zones2.php by using edit-replace of ZONES for ZONES2, and zones for zones2?

 

If you did, in the zones 2 file, there is one line that needs to keep

ZONES_TO_GEO_ZONES (or whatever the syntax is)

 

The error message tells you which line it is

 

Even if you use lots of zones modules (e.g. zones.php through zones99.php) you still need to keep the ZONES and GEO-ZONES in all of them, on that line, without numbers

 

 

Gaz

Edited by totalnumpty

Wearing a seatbelt prevents head injuries when the computer crashes - - - Yeah Right!!! - not in this office.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Unfortunately, your content contains terms that we do not allow. Please edit your content to remove the highlighted words below.
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...