Results 1 to 6 of 6
  1. #1
    Join Date
    May 2006
    Location
    UK
    Posts
    32
    Plugin Contributions
    0

    bug Search error '1109 Unknown table 'p' in field list' after upgrade from v137 to v138

    After upgrade, an error message appears in the search result page, says:

    Advanced Search
    1109 Unknown table 'p' in field list
    in:
    [select count(p.products_id) as total]

    The search and advanced search work fine before I upgraded the site.

    When I replaced the changed file /includes/modules/pages/advanced_search_result/header_php.php with the old one, then it works again.

    I haven't found anybody else posted this problem, I wonder if it's just me have this problem. Any ideas?
    To be simple and genuine - we are naturally the same.
    Review My Zen Cart Shop - Clothing & Accessories Wholesale , Silk Store , Studio Flash Lights

  2. #2
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Search error '1109 Unknown table 'p' in field list' after upgrade from v137 to v1

    Does this only happen for you with an upgrade, or also with a fresh install?
    Are you sure that the "new" header_php.php file was uploaded correctly? Did you have any customizations in it?
    What addons/contributions do you have installed?
    .

    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.

  3. #3
    Join Date
    May 2006
    Location
    UK
    Posts
    32
    Plugin Contributions
    0

    Default Re: Search error '1109 Unknown table 'p' in field list' after upgrade from v137 to v1

    Thank you for reply. It happens with an upgrade as well as a fresh install with no customizations and addons/contributions installed. So I don't think it's the addons which cause the problem.
    To be simple and genuine - we are naturally the same.
    Review My Zen Cart Shop - Clothing & Accessories Wholesale , Silk Store , Studio Flash Lights

  4. #4
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: Search error '1109 Unknown table 'p' in field list' after upgrade from v137 to v1

    I can't seem to reproduce this problem on a fresh install.

    What version of PHP and MySQL?
    What hosting platform? ie: linux/windows
    What's the URL?
    .

    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.

  5. #5
    Join Date
    May 2006
    Location
    UK
    Posts
    32
    Plugin Contributions
    0

    Default Re: Search error '1109 Unknown table 'p' in field list' after upgrade from v137 to v1

    PHP Version: 5.2.0
    Database: MySQL 5.0.27-community-log
    I'm testing the v138 at localhost at the moment. I havn't upgraded the real site yet.
    To be simple and genuine - we are naturally the same.
    Review My Zen Cart Shop - Clothing & Accessories Wholesale , Silk Store , Studio Flash Lights

  6. #6
    Join Date
    Oct 2010
    Posts
    27
    Plugin Contributions
    0

    Default Re: Search error '1109 Unknown table 'p' in field list' after upgrade from v137 to v1

    I have the very same issue since I upgraded to the most up to date version. Worked fine before but now it does not.

 

 

Similar Threads

  1. 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
  2. v139h 1109 Unknown table 'p' in field list
    By Dexter71 in forum General Questions
    Replies: 2
    Last Post: 12 Sep 2013, 07:11 PM
  3. Replies: 2
    Last Post: 20 Dec 2012, 07:31 PM
  4. Product Filter Module - 1109:Unknown table 'p' in field list
    By moesoap in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 28 May 2012, 01:40 PM
  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