Advanced Search

Return to Snippet

Revision: 32810
at October 2, 2010 10:29 by roblynch
Initial Code 
$dbname = 'database_name';
preg_match("/Table '".$dbName."\.(.*)' doesn't exist/",$matches[2],$tables);
if(isset($tables[1]) && $tables[1] == true)
{
	$sql = 'RENAME TABLE '.strtolower($tables[1]).' TO '.$tables[1].';';
	mysql_query($sql);
	echo "<script type=\"text/javascript\" language=\"JavaScript\">window.location.reload();</script>";
}
Initial URL 

                                

                                                            

                                    

                                        

                                        Initial Description
                                        

                                    

                                    
This code should be inserted into /sapphire/core/model/MySQLDatabase.php at line 399 (after the if statment ends and before the user_error call)

Be sure to replace 'database_name' with, well you know...

When I used this I first loaded the home page.  This fixed a large number of the tables, then ran /dev/build and that fixed the rest.

                                

                                                            

                                    

                                        

                                        Initial Title
                                        

                                    

                                    
Automatically fix lower case table names in SilverStripe

                                

                                                            

                                    

                                        

                                        Initial Tags
                                        

                                    

                                    

                                

                                                            

                                    

                                        

                                        Initial Language
                                        

                                    

                                    
PHP