oscommerce2006 Posted March 6, 2006 Posted March 6, 2006 I keep getting the following message after installing the new low price configuration: 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 ' p.products_old_price, UNIX_TIMESTAMP(DATE_ADD(p.products_price_changed, INTERVA' at line 1 select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_old_price, UNIX_TIMESTAMP(DATE_ADD(p.products_price_changed, INTERVAL 31 DAY)) nlp_expires, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price, p.products_old_price, UNIX_TIMESTAMP(DATE_ADD(p.products_price_changed, INTERVAL 31 DAY)) nlp_expires,) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c 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 = '21' order by pd.products_name limit 0, 20 [TEP STOP] Does anyone know how i can correct this? I am getting quite desperate now. Many thanks,
Guest Posted March 6, 2006 Posted March 6, 2006 I keep getting the following message after installing the new low price configuration: 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 ' p.products_old_price, UNIX_TIMESTAMP(DATE_ADD(p.products_price_changed, INTERVA' at line 1 select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_old_price, UNIX_TIMESTAMP(DATE_ADD(p.products_price_changed, INTERVAL 31 DAY)) nlp_expires, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price, p.products_old_price, UNIX_TIMESTAMP(DATE_ADD(p.products_price_changed, INTERVAL 31 DAY)) nlp_expires,) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c 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 = '21' order by pd.products_name limit 0, 20 [TEP STOP] Does anyone know how i can correct this? I am getting quite desperate now. Many thanks, hi i have the same error of you exactly the same i need help like you to fix it keep my email whit you n if you got any response just tell me n i do the same here to bye
Guest Posted March 6, 2006 Posted March 6, 2006 I keep getting the following message after installing the new low price configuration: 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 ' p.products_old_price, UNIX_TIMESTAMP(DATE_ADD(p.products_price_changed, INTERVA' at line 1 select p.products_image, pd.products_name, p.products_id, p.manufacturers_id, p.products_price, p.products_old_price, UNIX_TIMESTAMP(DATE_ADD(p.products_price_changed, INTERVAL 31 DAY)) nlp_expires, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price, IF(s.status, s.specials_new_products_price, p.products_price, p.products_old_price, UNIX_TIMESTAMP(DATE_ADD(p.products_price_changed, INTERVAL 31 DAY)) nlp_expires,) as final_price from products_description pd, products p left join manufacturers m on p.manufacturers_id = m.manufacturers_id left join specials s on p.products_id = s.products_id, products_to_categories p2c 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 = '21' order by pd.products_name limit 0, 20 [TEP STOP] Does anyone know how i can correct this? I am getting quite desperate now. Many thanks, hi i have the same error of you exactly the same i need help like you to fix it keep my email whit you n if you got any response just tell me n i do the same here to bye
bluejae Posted June 20, 2007 Posted June 20, 2007 hi i have the same error of you exactly the same i need help like you to fix it keep my email whit you n if you got any response just tell me n i do the same here to bye has anyone successfully used this contribution?
bluejae Posted June 20, 2007 Posted June 20, 2007 has anyone successfully used this contribution? could anyone provide a screen shot of what this looks like after it's done? or perhaps a website that is currently using it. thank you
bluejae Posted June 20, 2007 Posted June 20, 2007 for some reason i can't edit my previous posts so i have to keep posting a new reply but i'd like to integrate this onto my site but would like to have an example of what the source code looks like. i don't have a backup database being hosted... and i don't want to risk uploading this code and then have something go wrong when you test new codes or contributions, how do you do it?
bluejae Posted June 20, 2007 Posted June 20, 2007 what is the difference between this contribution and the "specials" section in the admin for oscommerce? i'm looking for something that will automatically show a new low price whenever a price is changed lower... without having to individually add it into the specials and specifying a new low price or pecentage decrease. is this what this contribution does? i'd like to be able to use the Price Updater contribution from here and be able to change the price of mulitple products and have it show the new low price. is this possible?
Recommended Posts
Archived
This topic is now archived and is closed to further replies.