Results 1 to 5 of 5

Hybrid View

  1. #1
    Join Date
    Feb 2008
    Posts
    27
    Plugin Contributions
    0

    Default 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

  2. #2
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

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

    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 ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  3. #3
    Join Date
    Feb 2008
    Posts
    27
    Plugin Contributions
    0

    Default 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

  4. #4
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Cloned Table Rate Shipping 1146 Error

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

    That should contain all the defines ...
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  5. #5
    Join Date
    Feb 2008
    Posts
    27
    Plugin Contributions
    0

    Default Re: Cloned Table Rate Shipping 1146 Error

    Yay! Thanks!
    Brad

 

 

Similar Threads

  1. v155 cloned table shipping in v.1.5.5
    By earmsby in forum Built-in Shipping and Payment Modules
    Replies: 2
    Last Post: 12 Jun 2016, 03:41 AM
  2. v139h Shipping Module, Table Rate Error
    By wiccan0974 in forum Built-in Shipping and Payment Modules
    Replies: 3
    Last Post: 28 Feb 2012, 02:18 AM
  3. Cloned Table rate by price: only honors first shipping amount
    By creativearc in forum Built-in Shipping and Payment Modules
    Replies: 1
    Last Post: 27 Jun 2008, 05:22 PM
  4. Cloned Table Rate Module "Loops"
    By trippy1976 in forum Built-in Shipping and Payment Modules
    Replies: 4
    Last Post: 16 Jun 2007, 02:59 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg