Page 1 of 2 12 LastLast
Results 1 to 10 of 16
  1. 28 Feb 2007, 08:06 AM #1
    JayCali
    JayCali is offline New Zenner
    Join Date
    Feb 2007
    Posts
    3
    Plugin Contributions
    0

    Default 1054 Unknown column 'p.products_id' in 'on clause'

    Hi All,

    I just moved my ZenCart to a different web host. But now I am getting the following error message, "1054 Unknown column 'p.products_id' in 'on clause' ".

    How do I fix this?

    Please help as I have been struggling with this.. :-(

    Thanks,
    Jerome
  2. 28 Feb 2007, 08:20 AM #2
    DrByte's Avatar
    DrByte
    DrByte is offline Sensei
    Join Date
    Jan 2004
    Posts
    66,443
    Plugin Contributions
    279

    Default Re: 1054 Unknown column 'p.products_id' in 'on clause'

    Zen Cart Version 1.2.x wasn't built for compatibility with MySQL 5, but your new host appears to be using MySQL 5.
    Either that or you've done an upgrade and didn't complete the database table-structure upgrade.
    .

    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. 9 Mar 2007, 01:23 AM #3
    AngelT
    AngelT is offline New Zenner
    Join Date
    Oct 2006
    Location
    New York
    Posts
    75
    Plugin Contributions
    0

    red flag Re: 1054 Unknown column 'p.products_id' in 'on clause'

    Hello,

    I am Having the same problem: "1054 Unknown column 'p.products_id' in 'on clause' " but I have not move to any other host and I am using the same MYSQL version. It is I have not done any change to the database and I am having this problem.

    Could you help me with this please?

    Thank you!

    Radhames Lopez
  4. 9 Mar 2007, 05:36 PM #4
    DrByte's Avatar
    DrByte
    DrByte is offline Sensei
    Join Date
    Jan 2004
    Posts
    66,443
    Plugin Contributions
    279

    Default Re: 1054 Unknown column 'p.products_id' in 'on clause'

    1. Did you recently make any changes or customizations to your site?
    2. Did you recently install any mods/contributions/addons? If so, which ones?
    3. Please go to Admin->Tools->Server Info and post all the information you see there above the blue PHP logo/bar.
    .

    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. 9 Mar 2007, 11:15 PM #5
    AngelT
    AngelT is offline New Zenner
    Join Date
    Oct 2006
    Location
    New York
    Posts
    75
    Plugin Contributions
    0

    red flag Re: 1054 Unknown column 'p.products_id' in 'on clause'

    Hi DrByte,

    I have not installed anything new.

    The customization I did was to the text files controling the main page, page 2, page 3 and page 4. And also I did changes to the files where the Shipping & Returns, Privacy Notice, Conditions of Use, Contact Us, Gift Certificate FAQ and Newsletter Unsubscribe are already.

    All those changes are working find. This was only text change.

    What you say about admin/Tools/Server Info. I do not see any information to post there above the blue PHP Logo/Bar, but it seems to be that changes were done to MYSQL database. I see there the following:

    [FONT="Tahoma"]Server Host: neptune (192.168.1.21)
    Database Host: mysql.catalog.com (209.217.33.160)
    Server OS: SunOS 5.9 Database: MySQL 5.0.27-standard-log
    Server Date: 03/09/2007 15:45:29 Database Date: 03/09/2007 15:45:24
    Server Up Time: 3:45pm up 7 day(s), 11:27, 1 user, load average: 35.79, 21.12, 25.50
    PHP Version: 4.4.4 (Zend: 1.3.0)
    HTTP Server: Apache[/FONT]


    Please let me know what and how can I post the information you told me is on admin/Tools/Serfer info. Because all the information over there is just as display only. Or if there is another actions I could take.

    Best Regards,

    Radhames Lopez
  6. 10 Mar 2007, 06:38 AM #6
    DrByte's Avatar
    DrByte
    DrByte is offline Sensei
    Join Date
    Jan 2004
    Posts
    66,443
    Plugin Contributions
    279

    Default Re: 1054 Unknown column 'p.products_id' in 'on clause'

    The only other information you missed was the Zen Cart version history information shown between the info you copied and the blue bar containing the PHP version number ... you see the Zen Cart logo, and then Zen Cart and Zen Cart Database version information. What's in there?
    .

    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.
  7. 10 Mar 2007, 06:42 AM #7
    DrByte's Avatar
    DrByte
    DrByte is offline Sensei
    Join Date
    Jan 2004
    Posts
    66,443
    Plugin Contributions
    279

    Default Re: 1054 Unknown column 'p.products_id' in 'on clause'

    Quote Originally Posted by AngelT View Post
    I am Having the same problem: "1054 Unknown column 'p.products_id' in 'on clause' " but I have not move to any other host and I am using the same MYSQL version. It is I have not done any change to the database and I am having this problem.
    Quote Originally Posted by AngelT View Post
    it seems to be that changes were done to MYSQL database. I see there the following:

    Code:
    Server OS: SunOS 5.9                          Database: MySQL 5.0.27-standard-log  
Server Date: 03/09/2007 15:45:29        Database Date: 03/09/2007 15:45:24  
Server Up Time: 3:45pm up 7 day(s), 11:27, 1 user, load average: 35.79, 21.12, 25.50 
PHP Version: 4.4.4 (Zend: 1.3.0)
    1. Please talk to your host or webserver administrator and find out when they upgraded to MySQL 5.0
    It looks like the server was last rebooted a week ago.

    2. Note that there are known problems with older versions of Zen Cart having incompatibilities when running under MySQL 5.
    Upgrading to the latest version of Zen Cart is an ideal starting point, as all the known issues have been addressed there. Currently the latest is v1.3.7.
    .

    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.
  8. 13 Mar 2007, 12:26 AM #8
    AngelT
    AngelT is offline New Zenner
    Join Date
    Oct 2006
    Location
    New York
    Posts
    75
    Plugin Contributions
    0

    red flag Re: 1054 Unknown column 'p.products_id' in 'on clause'

    Hi DrByte,

    In the mean times I changed a program to point to mysql4 version. And it is temporarely working fine.

    But I agree with you to migrate to the last ZenCart version. Then I have question for you my friend about it:

    a) I never have upgrade to a new version.
    b) I have not done structure changes in programs but cosmetic changes like:
    1) Adding the Business Logo to the shooping cart.
    2) Policies for Shipping and Returns, Conditions of Use, Warranty,Privacy
    Notice, Contact Us ... Main Page, Page 1 -- Page4, etc.
    3)
    c) I assume that all the data base changes like my admin settings will not be lost with an upgrade.

    d) I also do not know if the guy wotking on this before me implemented the shopping cart using the same directories that Zen Cart recomend.

    So do you think I will loose all the changes if I upgrade to a new Zen Cart version or should I continue to do so without any problems?

    Thank you DrByte.

    Best Regards,

    Radhames
  9. 22 Mar 2007, 11:18 PM #9
    AngelT
    AngelT is offline New Zenner
    Join Date
    Oct 2006
    Location
    New York
    Posts
    75
    Plugin Contributions
    0

    red flag Re: 1054 Unknown column 'p.products_id' in 'on clause'

    Quote Originally Posted by DrByte View Post
    1. Please talk to your host or webserver administrator and find out when they upgraded to MySQL 5.0
    It looks like the server was last rebooted a week ago.

    2. Note that there are known problems with older versions of Zen Cart having incompatibilities when running under MySQL 5.
    Upgrading to the latest version of Zen Cart is an ideal starting point, as all the known issues have been addressed there. Currently the latest is v1.3.7.
    --------------------------------------------------------------------------------------------

    To solve this problem I have decided to update to the new ZenCart version: But I want to do a backup before downloading the new version. To do the backup I have to FTP to my account (www.mydomain.com/admin) then I receive a windows to log in, I am using the same user and password to log in to my admin. Should be them differents user and password? If so, do you have an idea who can help me to get them? I did not do the installation originally.

    Thank you!

    Best Regards,

    Radhames
  10. 23 Mar 2007, 09:28 AM #10
    DrByte's Avatar
    DrByte
    DrByte is offline Sensei
    Join Date
    Jan 2004
    Posts
    66,443
    Plugin Contributions
    279

    Default Re: 1054 Unknown column 'p.products_id' in 'on clause'

    Here are some tips on doing backups:
    https://www.zen-cart.com/tutorials/index.php?article=54
    https://www.zen-cart.com/tutorials/i...hp?article=103
    https://www.zen-cart.com/tutorials/i...hp?article=100
    https://www.zen-cart.com/tutorials/index.php?article=99
    https://www.zen-cart.com/tutorials/i...hp?article=108
    https://www.zen-cart.com/tutorials/index.php?article=98
    http://www.zen-cart.com/wiki/index.php/LocalCopySite

    Remember - you need to backup the files in FTP as well as your database in MySQL. The FAQ links above talk about both.
    .

    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.
 

 
Page 1 of 2 12 LastLast
« Previous Thread | Next Thread »

Similar Threads

  1. 1054 Unknown column 'p.products_id' in 'on clause'
    By cathytsui in forum General Questions
    Replies: 0
    Last Post: 23 Jul 2009, 02:07 PM
  2. 1054 Unknown column 'p.products_id' in 'on clause'
    By jeffnord in forum Setting Up Categories, Products, Attributes
    Replies: 30
    Last Post: 30 Apr 2009, 05:22 PM
  3. 1054 Unknown column 'p.products_id' in 'on clause'
    By phylrust in forum General Questions
    Replies: 3
    Last Post: 5 Jan 2009, 08:36 PM
  4. 1054 Unknown column 'p.products_id' in 'on clause'
    By crazylane in forum General Questions
    Replies: 14
    Last Post: 4 Aug 2008, 02:21 PM
  5. 1054 Unknown column 'p.products_id' in 'on clause'
    By pepsishot in forum General Questions
    Replies: 14
    Last Post: 27 Aug 2007, 03:52 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
  •  

Forum Rules

disjunctive-egg
Content and Graphics Copyright (c) 2003 - 2026 Zen Ventures, LLC - all rights reserved
Zen Cart® is a Registered Trademark of Zen Ventures, LLC