All items are getting deleted

I want to offer proper comparison!

I know it's (too) much. However, I haven't had time to look at the possibilities (and consequences) of splitting data into several tables.

Anyway, until now I had no issues. And the amount has been around 2.4M for quite some weeks now. And even database connection errors would imho not cause the problem I am having. That would not prevent the script from updating records and on the other hand allow it to delete records...

unless you can find some error message from php or the webserver it's quite a black box to look at.

I looked at the output from some feeds and those look al right.

I know. I have checked every single log-file I know of on my server. No signs of problems. Even rebooted the server in a final attempt to get it working, to no avail.

When updating the data, the output (example first 3 records) looks correct and no error messages. The data just don't get inserted into the table anymore (or updated if data still exist).

I will dig further.

Guess I have found the cause. In the meantime, the item_id (autoincrement) had gone up to +16M. The maximum size of mediumint(, the type of that field is 16,777,215. So the script simply couln't add more records. I have flushed the table and am rebuilding it. If I'm not mistaken, this will have no consequences Google-wise...

I will change the type to one that can hold bigger numbers.