A client is having the issue of multiple products that have just disappeared from Magento, and they are having to re-enter all of the data. I ruled out CSV issues because they have never used this method for uploading products. Below are a few of the possibilities I will be trying, but someone here may have a more educated answer. I am trying:
Clearing the compiler: The compiler is disabled, but the state is compiled.
Database size: I will try clearing the log tables in the database, which is over 1.5GB in size.
Reindex data: I will try reindexing all of the data, but this shouldn't be the case.
I am worried that it could be database corruption, does anyone have an idea about that?