Make WordPress Core

Opened 3 months ago

Last modified 5 weeks ago

#61071 new enhancement

Need to display appropriate error messages when the database table is empty or corrupted.

Reported by: vishalvaland's profile vishalvaland Owned by:
Milestone: Awaiting Review Priority: normal
Severity: normal Version: 6.4
Component: Database Keywords: needs-patch 2nd-opinion
Focuses: Cc:

Description

A few days ago, I received a new issue from the client regarding the "Error Establishing Database Connection." Upon investigation, I discovered that this error occurred due to an empty or corrupted wp_options table. After repairing the table, the site functioned normally.

Given that the error message may mislead frontend developers into troubleshooting database connection issues unnecessarily, I recommend implementing a specific error message indicating that the connection is intact but the site is experiencing issues due to a corrupted or empty table. This will provide clearer guidance for troubleshooting.

Please review this suggestion and let me know if you have any questions or concerns.

Thank you!

Change History (2)

#1 @jrf
3 months ago

  • Component changed from Upgrade/Install to Database
  • Focuses sustainability coding-standards removed
  • Keywords needs-patch 2nd-opinion added; dev-feedback needs-testing reporter-feedback has-unit-tests removed
  • Type changed from defect (bug) to enhancement

#2 @deepakrohilla
5 weeks ago

@vishalvaland When WordPress encounters a corrupted or empty table in its database, it generate an error message indicating a database-related issue.

If WordPress can't establish a connection to the database due wrong host/username/password than it generates "Error establishing a database connection"

but if database connection has established and table is empty or corrupted than it generate
"One or more database tables are unavailable. The database may need to be repaired."

Last edited 5 weeks ago by deepakrohilla (previous) (diff)
Note: See TracTickets for help on using tickets.