Results 1 to 9 of 9

Thread: Error viewing products after wiping them all out.

  1. #1
    cdxrevvved
    Guest


    Default Error viewing products after wiping them all out.

    Hello all, been a while.. Had everything working once upon a time, but needed to wipe out and redo my products database. So, I deleted everything in there, categories, products and all. Then I added in some new categories and products, and now, it will display the categories just fine, but I get an error message like the one below.

    Looking over the database tables, everything appears in place just fine, no table configs have changed or anything. Any ideas what could be going on? I can do a table dump if needed.

    I think this is the right forum for the version Im using, i cant find a version number anywhere.. Aside from where it says osCommerce ms2-max.

    Thanks for you help!! Wanna get this back up by weeks end at the latest!

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

    select count(p.products_id) as total from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id, products_to_categories p2c left join specials s on p.products_id = s.products_id where p.products_status = '1' and p.products_id = p2c.products_id and pd.products_id = p2c.products_id and pd.language_id = '1' and p2c.categories_id = '279'

  2. #2
    osCMax Developer


    Error viewing products after wiping them all out.

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    22,983
    Total Contributions For

    michael_s     $ 10.00
    Rep Power
    591


    Default Re: Error viewing products after wiping them all out.

    Michael Sasek

    osCmax 2.5.4 is now available via auto-installation using Softaculous!

    Stay Up To Date with everything osCMax:
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  3. #3
    cdxrevvved
    Guest


    Default Re: Error viewing products after wiping them all out.

    Even though it was all working just perfect before i wiped out the products tonite? seems a little odd but worth a shot. =)

    Umm, one other thing. Gotta link? cant seem to find the link to download the update..

    Nvm. FOund it..
    Last edited by cdxrevvved; 01-08-2007 at 08:56 PM.

  4. #4
    osCMax Developer


    Error viewing products after wiping them all out.

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    22,983
    Total Contributions For

    michael_s     $ 10.00
    Rep Power
    591


    Default Re: Error viewing products after wiping them all out.

    If your server was recently upgraded to mysql 5 or php 5, the error would only crop up after the upgrade, so it is not strange at all really.
    Michael Sasek

    osCmax 2.5.4 is now available via auto-installation using Softaculous!

    Stay Up To Date with everything osCMax:
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  5. #5
    cdxrevvved
    Guest


    Default Re: Error viewing products after wiping them all out.

    Catch is, I didnt do any upgrades. Ive been running this same setup for at LEAST 8 months now. The site worked fine till i removed all the products to get the inventory updated.

    Ill install the patch tomorrow'ish and see if it fixes things for me. Currently Im running php 4.3.11 and mysql 5.0.21.

    Tomorrow shall be the test I guess. If it works, I owe ya one.. =)

  6. #6
    osCMax Developer


    Error viewing products after wiping them all out.

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    22,983
    Total Contributions For

    michael_s     $ 10.00
    Rep Power
    591


    Default Re: Error viewing products after wiping them all out.

    Odd... You should have always gotten that error if you have been on mysql 5... I think you will be ok after the update.

    Let me know if all goes well...or not.
    Michael Sasek

    osCmax 2.5.4 is now available via auto-installation using Softaculous!

    Stay Up To Date with everything osCMax:
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  7. #7
    cdxrevvved
    Guest


    Default Re: Error viewing products after wiping them all out.

    Well, first thing I noticed in the read me was: "DO NOT INSTALL ON A PLAIN OSCOMMERCE MS2 SHOP!" .. well, thats what I have.. MS2-MAX.

    So doing some searching I found this:
    1054 - Unknown column 'p.products_id' in 'on clause' - AWH Forums

    A one liner for the index.php page. Made 4 changes total in the file and works like a charm now!!!

  8. #8
    osCMax Developer


    Error viewing products after wiping them all out.

    michael_s's Avatar
    Join Date
    Jul 2002
    Location
    Phoenix, AZ
    Posts
    22,983
    Total Contributions For

    michael_s     $ 10.00
    Rep Power
    591


    Default Re: Error viewing products after wiping them all out.

    MS2Max is not a plain oscommerce MS2 shop. It is the v1.x version of osCMax.

    You posted to the wrong forum though... this is for discussing osCMax v2.0, and so I gave you the solution for v2.0... Next time make sure you post to the correct forum.

    Glad you found the solution to your problem.
    Michael Sasek

    osCmax 2.5.4 is now available via auto-installation using Softaculous!

    Stay Up To Date with everything osCMax:
    osCmax on Twitter - Up to the minute info as it happens. Know it first.

    osCmax Documentation

  9. #9
    cdxrevvved
    Guest


    Default Re: Error viewing products after wiping them all out.

    Ok. least I know which ver it is.. Still cant find a version number listed anywhere in the admin.. Ah well.. preciate the help!

Similar Threads

  1. Viewing Files
    By m_rockett in forum osCommerce 2.2 Installation Help
    Replies: 2
    Last Post: 05-06-2006, 11:43 AM
  2. Product picture viewing problems
    By Migraine in forum osCommerce 2.2 Modification Help
    Replies: 0
    Last Post: 04-18-2005, 04:42 AM
  3. Easier way of viewing and processing orders?
    By nfmg in forum osCmax v1.7 Discussion
    Replies: 1
    Last Post: 02-19-2005, 11:08 AM
  4. Getting 404 error when trying to view products
    By bethphilbin in forum osCommerce 2.2 Installation Help
    Replies: 8
    Last Post: 01-19-2005, 07:01 PM
  5. Problem viewing Enlarged pictures
    By pthurmond in forum osCmax v1.7 Discussion
    Replies: 2
    Last Post: 08-04-2004, 03:51 AM

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
  •