Zen Cart Logo
Forums / Built-in Shipping and Payment Modules / Cloned Table Rate Shipping 1146 Error

Cloned Table Rate Shipping 1146 Error

Locked

Views: 1,195

Results 1 to 5 of 5
This thread is locked. New replies are disabled.
8 Mar 2008, 4:52 PM
#1
pillaroom avatar

pillaroom

New Zenner

Join Date:
Feb 2008
Posts:
27
Plugin Contributions:
0

Cloned Table Rate Shipping 1146 Error

Hi! My goal is to have 2 table rates for shipping, 1 for basic and 1 for expedited shipping. I followed the instructions at http://www.zen-cart.com/forum/showthread.php?t=85197. I changed all instances of 'table' to 'tebleexpedited'. Now I get the following error:

1146 Table 'Pillaroom1.TABLEEXPEDITED_CONFIGURATION' doesn't exist
in:
[select configuration_value from TABLEEXPEDITED_CONFIGURATION where configuration_key = 'MODULE_SHIPPING_TABLEEXPEDITED_STATUS']
If you were entering information, press the BACK button in your browser and re-check the information you had entered to be sure you left no blank fields.

My theory is that one of the 'tables' that I modified is trying to access the database and should have been left as 'table'.

Any idea where I should start?

Thank you so much!
Brad

8 Mar 2008, 5:04 PM
#2
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Cloned Table Rate Shipping 1146 Error

Cloning table.php is harder than others for that very reason ... there are actual table references to the database that do not get touched ... :eek:

Things like:
TABLE_CONFIGURATION

do NOT get changed to:
TABLEEXPEDITED_CONFIGURATION

Start over, and be careful that the global replace you are doing is not touching the references to database tables needed to run the shipping module ...

8 Mar 2008, 5:28 PM
#3
pillaroom avatar

pillaroom

New Zenner

Join Date:
Feb 2008
Posts:
27
Plugin Contributions:
0

Re: Cloned Table Rate Shipping 1146 Error

Thanks Ajeh! I hate to appear inept... but is there a way for me to know which are database references? Or, is it just TABLE_CONFIGURATION?

You are a huge help!
Brad

8 Mar 2008, 6:13 PM
#4
ajeh avatar

ajeh

Oba-san

Join Date:
Sep 2003
Location:
Ohio
Posts:
62,757
Plugin Contributions:
1

Re: Cloned Table Rate Shipping 1146 Error

Peek in the database file:
/includes/database_tables.php

That should contain all the defines ... :smile:

8 Mar 2008, 6:15 PM
#5
pillaroom avatar

pillaroom

New Zenner

Join Date:
Feb 2008
Posts:
27
Plugin Contributions:
0

Re: Cloned Table Rate Shipping 1146 Error

Yay! Thanks!
Brad