Another Problem Here, Help please!

by 13 replies
21
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 = '29'

[TEP STOP]


Can anyone tell me what's going on here??

Sorry to trouble you guys...

Ed
#programming #problem
  • Another issue that cropped up..

    1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 1

    select o.orders_id, o.customers_name, o.payment_method, o.date_purchased, o.last_modified, o.currency, o.currency_value, s.orders_status_name, ot.text as order_total from orders o left join orders_total ot on (o.orders_id = ot.orders_id), orders_status s where o.orders_status = s.orders_status_id and s.language_id = '1' and ot.class = 'ot_total' order by o.orders_id DESC limit -20, 20

    [TEP STOP]

    The problems are just pouring in.. Someone help please? Thanks..

    Ed
    • [1] reply
    • Man..

      1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 1

      select r.tax_rates_id, z.geo_zone_id, z.geo_zone_name, tc.tax_class_title, tc.tax_class_id, r.tax_priority, r.tax_rate, r.tax_description, r.date_added, r.last_modified from tax_class tc, tax_rates r left join geo_zones z on r.tax_zone_id = z.geo_zone_id where r.tax_class_id = tc.tax_class_id limit -20, 20

      [TEP STOP]

      Head spinning already..

      Ed
  • from - SQL Limit - MySQL Limit - SQL Limit Results

    first X number of results, or to show a range from X - Y results. It is phrased as Limit X, Y

    Why do you have a -ve number for X - it should be always be +ve. What are you trying to do? I don't like using a limit in a live code - it seems the wrong way to get the result to me.
    • [ 1 ] Thanks
    • [2] replies
    • Are you getting these at the moment on different pages / parts of the script or have you resolved the first 2? Did you create the database successfully?

      "1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '-20, 20' at line 1"

      -20 is not a valid offset..... 'limit 20 would retrieve 20 records from the set, limit X, 20 would retreive 20 records from the set starting at ofset X.


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

      impossible yto say without seeing your DB structure..... its telling you products_id doesnt exist on your table 'products' which you aliased as p ...
      • [ 1 ] Thanks
      • [1] reply
    • James,

      I am not a coder, I basically purchased this script at an affordable rates and discover much problems with it.. So.... I do not understand what you're commenting on.. But.. Nevertheless, I thank you for giving me some of your time!

      Ed

  • Hi,

    It looks like you are in over your head here. Let me ask you. Did the program work the first time you installed it and then you tried to make some modifications, or has it failed to work from the start?

    What is the name of the program and where did you get it from?

    Lisa
  • Looking at the database schema - (they haven't even stripped out their product details unless you uploaded all those zip files! )

    INSERT INTO `products_attributes_download` VALUES (35, 'loveallnight.zip', 7, 1);
    INSERT INTO `products_attributes_download` VALUES (36, 'sexlastlonger.zip', 7, 1);
    INSERT INTO `products_attributes_download` VALUES (39, 'hypnosis.zip', 7, 1);
    INSERT INTO `products_attributes_download` VALUES (40, '120cardtricks.zip', 7, 1);
    INSERT INTO `products_attributes_download` VALUES (41, 'premium.zip', 7, 1);
    INSERT INTO `products_attributes_download` VALUES (42, 'lowfat.zip', 7, 1);
    INSERT INTO `products_attributes_download` VALUES (43, 'PS2Cheats.zip', 7, 1);
    INSERT INTO `products_attributes_download` VALUES (44, 'yoga.zip', 7, 1);
    INSERT INTO `products_attributes_download` VALUES (45, 'arcadegamer.zip', 7, 1);
    INSERT INTO `products_attributes_download` VALUES (48, 'sexpositions.zip', 7, 1);

    Moving on - it's an old script made circa 2006 so PHP version might be a problem.
    I'd just ask for a refund and look for something that does work. If you get no response from them, then just do a charge back on your card or a dispute with paypal or whaterver to get your money back. Don't waste any more time on this, it isn't going to work. (It's bugging me that I think I've seen this script before)

    Take a look at some of the free alternatives like Zen Cart or some of the paid alternatives, personally I wouldn't waste any more time on this one.

    Kindest regards,

    Janet
    • [ 1 ] Thanks
    • [1] reply
    • Houston, I think we Have a Problem,! Sorry,Count Resist!:confused: ,, Had to Bring a Smile I Hope!!!!,Jack
Join the discussion

Next Topics on Trending Feed

  • 21

    Another Problem Here, Help please!

    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 = '29'