Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2019
    Location
    Lake Elsinore, CA
    Posts
    3
    Plugin Contributions
    0

    Default Template not working after MySQL update

    URL: projectft86.com
    Zencart Version 1.5.6c
    PHP Version: 7.2.21
    Database Engine: MySQL 5.7.27


    Template Description: YourStoreTemplate
    Template Author : Perfectus Web Insights | Perfectus
    Template Version : Version 2.4.8.1

    After upgrading MySQL a couple of our websites stopped working. 2 out of 6 are experiencing issues and displaying the "WARNING: An Error occurred, please refresh the page and try again." Only the two using this template are experiencing this issue.

    If we change the template back to zencart's responsive template then everything works fine again.

    We downloaded the newest version of the template for 1.5.6c and still no joy.

    I checked the debug file and the following errors appear:

    [21-Aug-2019 03:01:17 America/Denver] Request URI: //plus/read.php, IP address: 119.3.233.56
    #1 trigger_error() called at [/home/anythir3/public_html/projectft86/includes/classes/db/mysql/query_factory.php:171]
    #2 queryFactory->show_error() called at [/home/anythir3/public_html/projectft86/includes/classes/db/mysql/query_factory.php:143]
    #3 queryFactory->set_error() called at [/home/anythir3/public_html/projectft86/includes/classes/db/mysql/query_factory.php:270]
    #4 queryFactory->Execute() called at [/home/anythir3/public_html/projectft86/includes/functions/extra_functions/pzen_template.php:29]
    #5 get_pzen_template_data() called at [/home/anythir3/public_html/projectft86/includes/functions/extra_functions/pzen_template.php:23]
    #6 include(/home/anythir3/public_html/projectft86/includes/functions/extra_functions/pzen_template.php) called at [/home/anythir3/public_html/projectft86/includes/modules/extra_functions.php:43]
    #7 include(/home/anythir3/public_html/projectft86/includes/modules/extra_functions.php) called at [/home/anythir3/public_html/projectft86/includes/init_includes/init_general_funcs.php:42]
    #8 require(/home/anythir3/public_html/projectft86/includes/init_includes/init_general_funcs.php) called at [/home/anythir3/public_html/projectft86/includes/autoload_func.php:48]
    #9 require(/home/anythir3/public_html/projectft86/includes/autoload_func.php) called at [/home/anythir3/public_html/projectft86/includes/application_top.php:170]
    #10 require(/home/anythir3/public_html/projectft86/includes/application_top.php) called at [/home/anythir3/public_html/projectft86/index.php:26]
    --> PHP Fatal error: 1146:Table 'anythir3_shopsfm_projectft86.pzen_template' doesn't exist :: SELECT * FROM pzen_template ==> (as called by) /home/anythir3/public_html/projectft86/includes/functions/extra_functions/pzen_template.php on line 29 <== in /home/anythir3/public_html/projectft86/includes/classes/db/mysql/query_factory.php on line 171.

  2. #2
    Join Date
    Apr 2006
    Location
    West Salem, IL
    Posts
    2,520
    Plugin Contributions
    0

    Default Re: Template not working after MySQL update

    well it is looking for a table it can not find
    Code:
    --> PHP Fatal error: 1146:Table 'anythir3_shopsfm_projectft86.pzen_template' doesn't exist :: SELECT * FROM pzen_template ==> (as called by) /home/anythir3/public_html/projectft86/includes/functions/extra_functions/pzen_template.php on line 29 <== in /home/anythir3/public_html/projectft86/includes/classes/db/mysql/query_factory.php on line 171.
    Have you confirmed whether or not that table exists? if an update from an older version did that table exist in the older version? If clean install was all of the template install sql scripts run?
    Mike
    GeekHost - Zen Cart Certified & PCI Compliant Hosting
    The Zen Cart Forum...Better than a monitor covered with post-it notes!

  3. #3
    Join Date
    Jan 2019
    Location
    Lake Elsinore, CA
    Posts
    3
    Plugin Contributions
    0

    Default Re: Template not working after MySQL update

    We never touch the database aside from upgrading MySQL. The only websites that are affected were the ones using that's specific template. if I revert back to our old template or Zen cart responsive template on those two sites that are affected then everything works.

 

 

Similar Threads

  1. Coupon Admin not working after Update.
    By dachilla in forum Upgrading from 1.3.x to 1.3.9
    Replies: 7
    Last Post: 14 Jun 2011, 01:15 PM
  2. embeded code not working after update
    By willpower68 in forum Addon Payment Modules
    Replies: 2
    Last Post: 9 Jul 2010, 02:40 AM
  3. Currency Update not working after moving to new server
    By Debbiekipt in forum Currencies & Sales Taxes, VAT, GST, etc.
    Replies: 1
    Last Post: 30 May 2010, 01:03 PM
  4. website not working after update to 1.38
    By james739 in forum General Questions
    Replies: 5
    Last Post: 3 Jun 2008, 03:39 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