Problem after migrate a new server

[pepplanas]

Well I changed my oscommerce from one server to another new one last weekend.

I'm experiencing some extrange probs server based, it seems. I'm the admin of the server so it's suposed I have to be able to manage it, but it doesn't seem so.

 

I have a 1064 syntax prob only on updates catalod products. When I update for example an stock product cuantity or description, first of all description apears to be deleted on the preview and on update I got the syntax error:

1064 - You have an error in your SQL syntax near ' products_model = , products_image = , products_price = , products_date_availabl' at line 1

 

It seems that querie have been cutted, products_date_availabl table it's obvius that dont exists. So, I checked mysql variables and it seems all ok.

 

I checked categories.php for any corruption of the file and seems to be ok too.

 

Well then I tried to install a new snapshot to be sure, last one aviable. And I don't get the error on update a product, but description gets deleted too, as in the original snapshot, but in this case all values are related to the product is deleted, even product_name.

 

I'm updating products descriptions and stocks directly on the db throught phpmyadmin now, till I can imagine what can be the problem cause all catalog publicside keep running ok.

 

If anybody knows what can be I would really apreciate the help.

I've already checked forums and seem its not a normal prob.

 

 

Regards

[Ajeh]

If this is the paste of the error msg, you have a field misspelled:

 

1064 - You have an error in your SQL syntax near ' products_model = , products_image = , products_price = , products_date_availabl' at line 1

 

products_date_availabl needs an E on the end.

[pepplanas]

Maybe I didn't explain the problem correctly.

I know its an E missed, but in the query, not in the script that generates the query, that is the problem.

 

 

 

Regards