Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2006
    Posts
    7
    Plugin Contributions
    0

    Default Error 1109 Unkown Table

    When I am in my shopping cart and I click on an item to get the full description I get this:
    1109 Unknown table 'p' in field
    list
    in:
    [select count(p.prodcuts_id) as
    total]

    Does anyone know what this means or why this is happening?

    I am using 1.3.5 and I have had quite a bit of errors since I upgraded.

    Cliff

  2. #2

    Default Re: Error 1109 Unkown Table

    Do you have a solution for this problem?

    I have this problem too and i am looking for a solution.

    Bram

  3. #3
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Error 1109 Unkown Table

    If that error is listed exactly as you see it ...

    Go to the Tools ... Developer's Tool Kit ...

    In the bottom input box enter exactly: prodcuts_id

    Select Catalog/Admin ... Click Search ...

    What comes up with that typo?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

  4. #4

    Default Re: Error 1109 Unkown Table

    Thanx, I see the problem.

  5. #5
    Join Date
    Sep 2003
    Location
    Ohio
    Posts
    69,402
    Plugin Contributions
    6

    Default Re: Error 1109 Unkown Table

    What was the solution? Was this an add-on with a typo?
    Linda McGrath
    If you have to think ... you haven't been zenned ...

    Did YOU buy the Zen Cart Team a cup of coffee and a donut today? Just click here to support the Zen Cart Team!!

    Are you using the latest? Perhaps you've a problem that's fixed in the latest version: [Upgrade today!]
    Officially PayPal-Certified! Just click here

    Try our Zen Cart Recommended Services - Hosting, Payment and more ...
    Signup for our Announcements Forums to stay up to date on important changes and updates!

 

 

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. 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

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