Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2011
    Location
    Adelaide, Australia
    Posts
    1,670
    Plugin Contributions
    1

    Default error log Featured Products

    v157C various plugins

    I am getting this myDebug error related to Feature Products - /includes/templates/responsive_classic_1/templates/tpl_modules_products_featured_listing at line 20 referred to in below error shows a value of zero - I cannot relate that zero value to any settings I have in admin/configuration on the site that relate to featured products. The templates referred to below all exist where they have been 'required'

    any assistance would be appreciated - cheers, Mike

    Code:
    [02-Aug-2022 03:50:45 Australia/Sydney] Request URI: /index.php?main_page=featured_products, IP address: 119.123.169.251
    #1  trigger_error() called at [/home2/xxxx/public_html/includes/classes/db/mysql/query_factory.php:170]
    #2  queryFactory->show_error() called at [/home2/xxxx/public_html/includes/classes/db/mysql/query_factory.php:142]
    #3  queryFactory->set_error() called at [/home2/xxxx/public_html/includes/classes/db/mysql/query_factory.php:269]
    #4  queryFactory->Execute() called at [/home2/xxxx/public_html/includes/templates/responsive_classic_1/templates/tpl_modules_products_featured_listing.php:20]
    #5  require(/home2/xxxx/public_html/includes/templates/responsive_classic_1/templates/tpl_modules_products_featured_listing.php) called at [/home2/xxxx/public_html/includes/templates/responsive_classic_1/templates/tpl_featured_products_default.php:87]
    #6  require(/home2/xxxx/public_html/includes/templates/responsive_classic_1/templates/tpl_featured_products_default.php) called at [/home2/xxxx/public_html/includes/templates/responsive_classic_1/common/tpl_main_page.php:178]
    #7  require(/home2/xxxx/public_html/includes/templates/responsive_classic_1/common/tpl_main_page.php) called at [/home2/xxxx/public_html/index.php:94]
    --> PHP Fatal error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'limit 10' at line 1 ::  limit 10 ==> (as called by) /home2/xxxx/public_html/includes/templates/responsive_classic_1/templates/tpl_modules_products_featured_listing.php on line 20 <== in /home2/xxxx/public_html/includes/classes/db/mysql/query_factory.php on line 170.

  2. #2
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    12,614
    Plugin Contributions
    88

    Default Re: error log Featured Products

    Have changes been made to either /includes/modules/pages/featured_products/header_php.php or /includes/classes/split_page_results.php from the 'base' Zen Cart distribution?

  3. #3
    Join Date
    Jan 2011
    Location
    Adelaide, Australia
    Posts
    1,670
    Plugin Contributions
    1

    Default Re: error log Featured Products

    Quote Originally Posted by lat9 View Post
    Have changes been made to either /includes/modules/pages/featured_products/header_php.php or /includes/classes/split_page_results.php from the 'base' Zen Cart distribution?
    Many thanks Cindy - appears both files were remnants of the v155f version of this site missed in the upgrade.

 

 

Similar Threads

  1. v139h extra featured products on products page error
    By pbetts in forum General Questions
    Replies: 2
    Last Post: 5 Dec 2012, 08:33 PM
  2. 1064 SQL error on Featured Products page
    By rconway28 in forum General Questions
    Replies: 4
    Last Post: 8 Sep 2011, 03:38 AM
  3. 1064 SQL error on Featured Products page
    By stevelucky in forum General Questions
    Replies: 5
    Last Post: 24 Sep 2010, 01:15 PM
  4. Featured products sidebox pricing error
    By gmrm in forum General Questions
    Replies: 1
    Last Post: 6 Oct 2009, 03:09 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