Hey ERPnext community,
I’m seeing something strange in my database today. It has to do with some records apparently not referencing correctly.
The situation looks like this;
- I should have 313 records in the Quality Inspection table on my prod server, (SVR-A) however when I looked this morning, there were only 23!
- investigating the database through Phpmyadmin, revealed that there were only 23 records in the table.
- Fortunately, I have a test server (SVR-B) that had recently been mirrored (about 1 week ago) and had all the 313 records still.
So I dumped the table from SVR-B with Phpmyadmin and, after backing up the problem server SVR-A, I dropped the table with only 23 records and imported the good table with the 313 records.
The results so far.
Even though all 313 records are in the table on SVR-A now, I can still only view 23 of the records in the QI module. Yes! That’s correct, the same 23 records that were there before the import are the only records that show up in the application. BTW - All filters are cleared and the List view has been reset to defaults so there are no unknown customizations:
I have been able to successfully go the URL of the missing QI’s directly from the browser. This is interesting and shows that the information is there but some ERPNext has somehow not indexed it?
The links in the reference documents are still there too. Meaning that I can go from one record to a QI record directly. ex: from a stock entry that has an item that had a quality inspection attached.
So far I have run, Bench update, build, and migrate, restarted the services and the server.
I’m stumped but have the feeling that one of you Database experts will tell me the simple answer that’s right under my nose. At least, I hope so.
Thanks in advance