Sounds like you are running MySQL 5.0 with SQL strict mode enabled.
To disable strict mode open your my.cnf or my.ini in an editor and remove/comment out the following line:
<br />
sql-mode="STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION"<br />
```<br />
But then you'll have to restart the mysql database server.
Thanks so mutch this fixd my problem. i have read som otter posts and thay ware not to mutch help. but you are a bit unclear of vare to put the code (sql-mode=“STRICT_TRANS_TABLES,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION”
) i put it in php.ini (whitc i manuly created in the root of my domain (abov puplic_html vare cs-cart is located)