Error 1064 with sessions - HELP!

[sukarya]

Hi, i have a well modified store, I get the below error after making the nest steps (I know it has sometiong to do with sessions but can find it..)

 

steps: creating a user and inserting a product to the shopping cart --> log of --> login --> BOOM!!! the following error:

 

 

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 ' 125) and pd.language_id = '1'' at line 1

 

select pd.products_name, p.products_model, p.products_image, p.products_id, p.manufacturers_id, p.products_price, p.products_weight, p.products_quantity, p.products_price1, p.products_price2, p.products_price3,p.products_price4, p.products_price5, p.products_price6, p.products_price7, p.products_price8, p.products_price1_qty, p.products_price2_qty, p.products_price3_qty, p.products_price4_qty, p.products_price5_qty, p.products_price6_qty, p.products_price7_qty, p.products_price8_qty, p.products_qty_blocks, p.products_tax_class_id, IF(s.status, s.specials_new_products_price, NULL) as specials_new_products_price from products p left join specials s on p.products_id = s.products_id, products_description pd where p.products_status = '1' and pd.products_id = p.products_id and p.products_id in (, 125) and pd.language_id = '1'

 

[TEP STOP]

 

 

I tried changing the session setting s but nada...

 

Versions and Settings:

 

MySQL: 4.0.27-standard-log

PHP: 4.4.4 (Zend: 1.3.0)

Session settings:

 

Force Cookie Use True

Check SSL Session ID True

Check User Agent False

Check IP Address False

Prevent Spider Sessions True

Recreate Session True

 

 

need help...

Thanks Sharon.

[Guest]

http://www.oscommerce.com/forums/index.php?showtopic=144095

 

Pierre

[sukarya]

http://www.oscommerce.com/forums/index.php?showtopic=144095

 

Pierre

 

Thanks. I have digged threw the thread and added the fix but nothing changed.

Another thing is that im using MySQL: 4.0.27 and PHP: 4.4.4 (Zend: 1.3.0).

 

as I read, these should nt be a problem with this MySql version...

 

plssssss help...