magic records being deleted

Posted by chris on Stack Overflow See other posts from Stack Overflow or by chris
Published on 2010-06-10T12:57:35Z Indexed on 2010/06/10 13:03 UTC
Read the original article Hit count: 302

Filed under:
|
|

i have customised oscommerce to pull in a csv file of products, delete anything thats not with an image/proper description/proper title gets removed.

The import runs on a cron job basis pulling information from a supplier, it hasnt run since yesterday but a product has disappeared-

Anyone who has used oscommerce will know that, product information is stored over multiple tables. example is-

products product_description

and so on. the thing that has got me that the information is deleted from the product table but not from the product_description table.

The product that is being deleted is a manually input one which carries a special tag/prefix on the model item of the product table. Therefore shouldn't be touched at all. Am clueles as what is going on.

Is there mysql integrity checks deleting records? could there be another plugin working on oscommerce?

© Stack Overflow or respective owner

Related posts about php

Related posts about mysql