id,summary,reporter,owner,description,type,status,priority,milestone,component,version,severity,resolution,keywords,cc
19748,dbDelta fails for capital prefixed tables,netweblogic,nacin,"Probably a linux/Windows mysql version issue since not all sites do this, but on some instances if your tables are using capitals, mySQL will fail to recognize a create statement should be an update of a present table.

Reason is because dbDelta checks lower cased names of the table to see if it should create or update a table.

Offending line is /wp-admin/includes/upgrade.php line 1471 

Changing this

{{{
$cqueries[trim( strtolower($matches[1]), '`' )] = $qry;
}}}


to


{{{
$cqueries[trim($matches[1], '`' )] = $qry;
}}}

and it works. Is there a reason why dbDelta forces a lowercase lookup for present tables on the DB?",defect (bug),closed,normal,3.4,Database,1.5,major,fixed,has-patch commit,netweblogic kpayne@… j.conti@… stephenh1988