Jump to content
  • Checkout
  • Login
  • Get in touch

osCommerce

The e-commerce.

Help! Error when trying to add zone to my Table Shipping Module


Tiff13

Recommended Posts

I was trying to make my table rate be for US only. My Tables shipping modules were working fine. But when I added the Zone US to one of them I get this error and can't even modify in ADMIN now to remove that module. Please help no one can place orders now.

 

1146 - Table 'waybent1_hoashop2.TABLEPREMIUM_ZONES_TO_GEO_ZONES' doesn't exist

 

select zone_id from TABLEPREMIUM_ZONES_TO_GEO_ZONES where geo_zone_id = '2' and zone_country_id = '' order by zone_idexcl.png

Link to comment
Share on other sites

When you get UPPERCASE_ERRORS like that it normally means you're missing a define in a php file somewhere.

 

In this case you're probably missing the define for TABLEPREMIUM_ZONES_TO_GEO_ZONES in /includes/database_tables.php.

 

It will need defined in the catalog and admin files.

If I suggest you edit any file(s) make a backup first - I'm not perfect and neither are you.

 

"Given enough impetus a parallelogramatically shaped projectile can egress a circular orifice."

- Me -

 

"Headers already sent" - The definitive help

 

"Cannot redeclare ..." - How to find/fix it

 

SSL Implementation Help

 

Like this post? "Like" it again over there >

Link to comment
Share on other sites

When you get UPPERCASE_ERRORS like that it normally means you're missing a define in a php file somewhere.

 

In this case you're probably missing the define for TABLEPREMIUM_ZONES_TO_GEO_ZONES in /includes/database_tables.php.

 

It will need defined in the catalog and admin files.

 

Thank you ... so now I get

1054 - Unknown column 'geo_zone_id' in 'where clause'

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

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...