WordPress.org

Make WordPress Core

Opened 7 months ago

Closed 2 weeks ago

#45607 closed defect (bug) (invalid)

Table prefix makes WordPress

Reported by: joaomiguel Owned by:
Milestone: Priority: normal
Severity: normal Version: 5.0
Component: Database Keywords:
Focuses: Cc:

Description

In IIS using MySql.

If the table prefix on config file is on upper case and the db has the tables prefix in lower case, each page takes 4-5 seconds to load.
Correcting the value it takes less then 1 second.

It's a very difficult problem to debug because there is no errors and everything works fine.

The upper case to lower case can easily happen if the db has the lower case tables option active (I think it's the default for MySql)

Change History (2)

#1 @desrosj
6 months ago

  • Component changed from Query to Database

#2 @pento
2 weeks ago

  • Milestone Awaiting Review deleted
  • Resolution set to invalid
  • Status changed from new to closed

This likely due to Windows NTFS being case insensitive: MySQL can use a table even if the table name has the wrong case, but there may be issues.

This scenario is unsupported by WordPress, you should correct the case of the table prefix in your wp-config.php file.

Note: See TracTickets for help on using tickets.