Posted June 2, 20241 yr 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, 20241 yr 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, 20241 yr 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, 20241 yr 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, 20241 yr 8 minutes ago, Elon Report said: Is there a way to delete multiple records at once / truncate? Moderation tools on the frontend.