Results 1 to 8 of 8
  1. #1
    Join Date
    Mar 2004
    Posts
    149
    Plugin Contributions
    0

    Default PHP Fatal error: 1109:Unknown table 'p' in field list ...

    [[15-Nov-2020 00:38:02 UTC] Request URI: /index.php?main_page=shopping_cart, IP address: 24.113.181.201
    #1 trigger_error() called at [/home/herasonl/public_html/shop/includes/classes/db/mysql/query_factory.php:171]
    #2 queryFactory->show_error() called at [/home/herasonl/public_html/shop/includes/classes/db/mysql/query_factory.php:143]
    #3 queryFactory->set_error() called at [/home/herasonl/public_html/shop/includes/classes/db/mysql/query_factory.php:270]
    #4 queryFactory->Execute() called at [/home/herasonl/public_html/shop/includes/classes/split_page_results.php:78]
    #5 splitPageResults->__construct() called at [/home/herasonl/public_html/shop/includes/modules/kandi/new_products.php:16]
    #6 include(/home/herasonl/public_html/shop/includes/modules/kandi/new_products.php) called at [/home/herasonl/public_html/shop/includes/templates/kandi/templates/tpl_modules_whats_new.php:12]
    #7 require(/home/herasonl/public_html/shop/includes/templates/kandi/templates/tpl_modules_whats_new.php) called at [/home/herasonl/public_html/shop/includes/templates/kandi/templates/tpl_shopping_cart_default.php:202]
    #8 require(/home/herasonl/public_html/shop/includes/templates/kandi/templates/tpl_shopping_cart_default.php) called at [/home/herasonl/public_html/shop/includes/templates/kandi/common/tpl_main_page.php:198]
    #9 require(/home/herasonl/public_html/shop/includes/templates/kandi/common/tpl_main_page.php) called at [/home/herasonl/public_html/shop/index.php:97]

    [15-Nov-2020 00:38:02 UTC] PHP Fatal error: 1109:Unknown table 'p' in field list :: select count(p.products_id) as total ==> (as called by) /home/herasonl/public_html/shop/includes/classes/split_page_results.php on line 78 <== in /home/herasonl/public_html/shop/includes/classes/db/mysql/query_factory.php on line 171
    ]
    My Multi_Site Zen Carts
    http://herasonlinemarket.com

  2. #2
    Join Date
    Nov 2005
    Location
    los angeles
    Posts
    1,767
    Plugin Contributions
    4

    Default Re: PHP Fatal error: 1109:Unknown table 'p' in field list ...

    Quote Originally Posted by noppie View Post
    [[15-Nov-2020 00:38:02 UTC]
    #5 splitPageResults->__construct() called at [/home/herasonl/public_html/shop/includes/modules/kandi/new_products.php:16]
    i would compare the highlighted file with this one:

    https://github.com/zencart/zencart/b...w_products.php

    if i were a betting man, thats where i think your problem is.

    line 16...
    #vaccinesInArmsNotInFreezers
    email is hard....
    help out with the green....

  3. #3
    Join Date
    Mar 2004
    Posts
    149
    Plugin Contributions
    0

    Default Re: PHP Fatal error: 1109:Unknown table 'p' in field list ...

    Quote Originally Posted by carlwhat View Post
    i would compare the highlighted file with this one:

    https://github.com/zencart/zencart/b...w_products.php

    if i were a betting man, thats where i think your problem is.

    line 16...
    thank you.., but both files are the same..
    My Multi_Site Zen Carts
    http://herasonlinemarket.com

  4. #4
    Join Date
    Feb 2006
    Location
    Tampa Bay, Florida
    Posts
    7,542
    Plugin Contributions
    284

    Default Re: PHP Fatal error: 1109:Unknown table 'p' in field list ...

    Try includes/modules/pages/products_new/header_php.php
    That Software Guy. My Store: Zen Cart Modifications
    Available for hire - See my ad in Services
    Plugin Moderator, Documentation Curator, Chief Cook and Bottle-Washer.

  5. #5
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    10,034
    Plugin Contributions
    76

    Default Re: PHP Fatal error: 1109:Unknown table 'p' in field list ...

    Where did that 'kandi' template come from? Does it have a template override of the default-filter (i.e. /includes/index_filters/kandi/default_filter.php)? If so, compare that to the base (present in /includes/index_filters) version of that file.

  6. #6
    Join Date
    Nov 2005
    Location
    los angeles
    Posts
    1,767
    Plugin Contributions
    4

    Default Re: PHP Fatal error: 1109:Unknown table 'p' in field list ...

    Quote Originally Posted by noppie View Post
    thank you.., but both files are the same..
    i will try again.

    you need to compare this file:

    /home/herasonl/public_html/shop/includes/modules/kandi/new_products.php

    to this file:

    home/herasonl/public_html/shop/includes/modules/new_products.php

    if those 2 files are the same, then i submit to you your log file is wrong.

    reading log files can be tricky. but lets go over what we can see:

    • we are on the shopping cart page.
    • we are triggering a sql error on line 78 of the split_page_results class. that line on the base 156 looks to be where the error occurred. and that makes sense.
    • that was called from line 16 of the kandi modules of new_products.php.
    • line 16 of the base v156 modules of new_products is the initialization of an array. no way that line has anything to do with this error.
    • base v156 modules of new_products does not include the split_page_results class.
    • if it is the same as the base, why did kandi put it there?
    • line 16 will say something like $var = new splitPageResults($QUERY, number, etc.) $QUERY is where the problem is...



    just my guess based on reading the posted log file.

    best.
    #vaccinesInArmsNotInFreezers
    email is hard....
    help out with the green....

  7. #7
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    10,034
    Plugin Contributions
    76

    Default Re: PHP Fatal error: 1109:Unknown table 'p' in field list ...

    Nice analysis, @carlwhat!

  8. #8
    Join Date
    Jan 2004
    Posts
    66,024
    Blog Entries
    7
    Plugin Contributions
    261

    Default Re: PHP Fatal error: 1109:Unknown table 'p' in field list ...

    Two additional possible causes:
    - Maximum Value setting in the admin (mentioned in some related threads found when searching for this error)
    - code differences introduced by the multi-site mod that the store is using
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

 

 

Similar Threads

  1. Replies: 1
    Last Post: 1 Aug 2020, 10:48 PM
  2. v154 PHP Fatal error: 1109: Unknown table 'p' in field list
    By bobc in forum General Questions
    Replies: 24
    Last Post: 20 Jan 2017, 06:06 PM
  3. Replies: 2
    Last Post: 20 Dec 2012, 07:31 PM
  4. Replies: 5
    Last Post: 7 Nov 2010, 03:57 AM
  5. Links manager error 1109 Unknown table 'p' in field list
    By ctcentralinfo in forum General Questions
    Replies: 7
    Last Post: 27 Sep 2006, 10:10 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