Invision Community 4: SEO, prepare for v5 and dormant account notifications Matt November 11, 2024Nov 11
Posted June 2, 2024Jun 2 I have a database that is showing 99 records. When I try to view the records, there are none. If I look at the table directly, there are no records. How would I have the system rebuild the record count?
June 3, 2024Jun 3 Author See images below. I'm coding API, and still learning, so I think something is getting added to the database... No matter what method I try, I cannot see any records. Even querying the database directly shows no records. (I never edit custom databases through my mysql tool) How can I have IPB verify the consistency of that custom database?
June 3, 2024Jun 3 Community Expert What action transpired prior to encountering this? Have you deleted or done something to the database? Unfortunately, MySQL management is outside our scope of support so if something has happened to your MySQL server which has truncated a table or caused data inconsistencies would be outside our scope of support. Our only recommendation would be to restore the database from a backup when it was correct.
June 3, 2024Jun 3 Author Actually, I fixed my API code. Once a new record was correctly entered, it rebuilt the count itself. Came here to type this and saw your reply.
June 3, 2024Jun 3 Community Expert Is there a way to delete multiple records at once / truncate? Moderation tools on the frontend.