Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2019
    Location
    usa
    Posts
    2
    Plugin Contributions
    0

    Default Missing Tables from upgrade 1.3.9-1.5.6

    I just completed and upgrade on my site, the zc installer did not return any errors. The admin page is not accessible returning "WARNING: An Error occurred, please refresh the page and try again." The debug logs in /logs returns issues with the query, but I am not able to find any information about this, admin_pages. This table is missing from my sql schema, but there is no documentation on the site.

    https://www.zen-cart.com/wiki/index....atabase_Schema

    I have checked php and mysql compatability, the site is running using IIS.

    [12-Feb-2019 17:33:02 Etc/Zulu] PHP Fatal error: 1146:Table 'rjgzen156n.admin_pages' doesn't exist :: SELECT page_key FROM admin_pages WHERE page_key = 'reportSalesWithGraphs' ==> (as called by) D:\zencartv2\87654321xyz\includes\functions\admin_access.php on line 866 <== in D:\zencartv2\includes\classes\db\mysql\query_factory.php on line 171

  2. #2
    Join Date
    Jul 2012
    Posts
    13,534
    Plugin Contributions
    16

    Default Re: Missing Tables from upgrade 1.3.9-1.5.6

    What zcInstall debug logs are there?

    If none are currently present in the logs directory, then suggest running zc_install again to see if you are offered the update option again.

    If offered to update, do so. Then before attempting to access the admin, review the newly created logs.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...
    Upgraded to Zen Cart V1.5.3 from V1.5.1 from V1.5.0 from V1.3.9h

  3. #3
    Join Date
    Feb 2019
    Location
    usa
    Posts
    2
    Plugin Contributions
    0

    Default Re: Missing Tables from upgrade 1.3.9-1.5.6

    Yes, there are collation errors, the new configuration file had a charset line that was not present in 1.3.9, I will restore the the sql, my concern is still with the missing tables, the rest of the logs are similar to the last line on the opening thread.

    The errors are referencing missing tables

    [12-Feb-2019 15:59:53 Etc/Zulu] PHP Notice: Undefined property: zcDatabaseInstaller::$filename in D:\zencart-1.5.6\zc_install\includes\classes\class.zcDatabaseInstaller.php on line 298
    [12-Feb-2019 15:59:53 Etc/Zulu] MySQL error 1146 encountered during zc_install:
    Table 'rjgzen156n.admin_pages' doesn't exist
    ALTER TABLE admin_pages MODIFY page_key VARCHAR(191) NOT NULL DEFAULT '';
    ---------------


    [12-Feb-2019 15:59:53 Etc/Zulu] PHP Notice: Undefined property: zcDatabaseInstaller::$filename in D:\zencart-1.5.6\zc_install\includes\classes\class.zcDatabaseInstaller.php on line 298
    [12-Feb-2019 15:59:53 Etc/Zulu] MySQL error 1146 encountered during zc_install:
    Table 'rjgzen156n.admin_pages_to_profiles' doesn't exist
    ALTER TABLE admin_pages_to_profiles MODIFY page_key varchar(191) NOT NULL default ''

  4. #4
    Join Date
    Jul 2012
    Posts
    13,534
    Plugin Contributions
    16

    Default Re: Missing Tables from upgrade 1.3.9-1.5.6

    Looking at the error message a little closer, might suggest downloading the software again. There was an update pushed towards the end of December to correct the variable usage of filename as compared to filename.
    ZC Installation/Maintenance Support <- Site
    Contribution for contributions welcome...
    Upgraded to Zen Cart V1.5.3 from V1.5.1 from V1.5.0 from V1.3.9h

 

 

Similar Threads

  1. v151 Upgrade from 1.3.8a to 1.5 copy missing data
    By Fallen Leaf in forum Upgrading to 1.5.x
    Replies: 3
    Last Post: 29 Mar 2014, 05:06 PM
  2. Replies: 2
    Last Post: 20 Jun 2012, 02:41 PM
  3. address missing from invoice after upgrade
    By metoo in forum Basic Configuration
    Replies: 19
    Last Post: 31 Mar 2012, 09:23 PM
  4. Database upgrade - will this wipe added tables from mods
    By PatF in forum Upgrading from 1.3.x to 1.3.9
    Replies: 13
    Last Post: 7 Aug 2010, 12:01 AM
  5. EZ Page link missing from admin>tools after upgrade
    By craftzombie in forum Upgrading from 1.3.x to 1.3.9
    Replies: 4
    Last Post: 16 Dec 2006, 02:43 AM

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