Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2012
    Posts
    9
    Plugin Contributions
    0

    bug Unexplainable Database Error

    I am really hoping someone here can be of assistance as I have been reading posts, googling and trying almost everything for quite some time now, but without success...

    Background:
    My shop (www.experilab.co.za) has been running successfully now on ver1.3.9 for quite a few years.
    I recently took the step to upgrade to ver1.5.5, mainly to be able to make the site responsive.
    The updated version (still in test phase) is working very well, although I am still using the classic template (will only switch templates as a final step).
    I wrote a custom shipping module which required a new table in the database. This module has been running 100% on ver1.3.9 for more than 2 years now.

    Problem:
    As soon as I install the custom shipping module on version 1.5.5, the 'Go to checkout' and 'Estimate shipping' buttons produces an error. (Everything works again as soon as it is deleted).
    The debug logs provide the following clue: PHP Fatal error: 1146:Table 'experilabnew.TABLE_POSTALCODEZONE' doesn't exist. Only, this table DOES exist as confirmed by PHPMYADMIN.

    I have tried:
    Dropping the table and reinstalling.
    Deleting the shipping module and reinstalling.

    Additional Information:
    The database is a test database which was created via the export/import process as described in the upgrade instructions.
    No database prefix is used (old and new versions).
    The shipping module is unaltered between the two versions.
    Everything else on the new version seems to be working 100% using the test database.

    It seems as if the specific table (Type: InnoDB) is suddenly invisible to the module.

    ANY ideas to try, anyone?

    I can post the complete log as well as the shipping module file, if it would help.

    Please note I am only an amateur developer...

  2. #2
    Join Date
    Dec 2009
    Location
    Amersfoort, The Netherlands
    Posts
    2,285
    Plugin Contributions
    20

    Default Re: Unexplainable Database Error

    You need to tell Zen Cart there is a new new table. Go over to your old zc version and find the file that is containing the define for 'TABLE_POSTALCODEZONE', normally found in the folder 'includes/extra_datafiles' and/or 'YOUR_ADMINincludes/extra_datafiles', and copy this to your new Zen Cart install. That should solve your problem.

  3. #3
    Join Date
    Sep 2012
    Posts
    9
    Plugin Contributions
    0

    Default Re: Unexplainable Database Error

    Quote Originally Posted by Design75 View Post
    You need to tell Zen Cart there is a new new table. Go over to your old zc version and find the file that is containing the define for 'TABLE_POSTALCODEZONE', normally found in the folder 'includes/extra_datafiles' and/or 'YOUR_ADMINincludes/extra_datafiles', and copy this to your new Zen Cart install. That should solve your problem.
    Of course! (I actually knew that once upon a time...)

    The define was located in database_tables.php in the /includes/ directory. (And I must have put it there).

    Thanks for saving me!

  4. #4
    Join Date
    Dec 2009
    Location
    Amersfoort, The Netherlands
    Posts
    2,285
    Plugin Contributions
    20

    Default Re: Unexplainable Database Error

    Glad you found it. It is actually better to put it in a separate file, this way you will not lose the define on a next upgrade.

 

 

Similar Threads

  1. Database error 1030 Got error 127 from storage engine
    By kdlklm in forum General Questions
    Replies: 4
    Last Post: 9 Jul 2014, 04:55 PM
  2. Error importing old database to the new database
    By wmorris in forum Upgrading to 1.5.x
    Replies: 1
    Last Post: 3 Jan 2012, 08:27 AM
  3. Replies: 4
    Last Post: 15 Oct 2010, 07:18 AM
  4. PCI error: Potentially Exploitable Database Error Message -- links_alias table
    By srigari in forum All Other Contributions/Addons
    Replies: 5
    Last Post: 21 Jun 2009, 12:23 AM
  5. Replies: 2
    Last Post: 12 Aug 2008, 05:22 PM

Bookmarks

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
Zen-Cart, Internet Selling Services, Klamath Falls, OR