2510 Posts in 675 Topics by 520 members
Data Model Questions
SilverStripe Forums » Data Model Questions » lowercase table hack
Moderators: martimiz, Howard, Sean, Ryan M., biapar, Willr, Ingo, swaiba
|
Page:
1
|
Go to End | |
| Author | Topic: | 1829 Views |
-
lowercase table hack
24 August 2009 at 3:52pm Last edited: 24 August 2009 3:53pm
I recently ended up with a database in which all tables where lowercase.
I used the following rather dirty hack to fix this:
put the following code in line ~ 189 of sapphire/core/model/DatabaseAdmin.php
$t = $dataClass;
if(DB::query('SELECT * FROM information_schema.tables WHERE table_schema like binary "'.strtolower($t).'" or Table_Name like binary "'.strtolower($t).'";')->value()) {
DB::query('RENAME TABLE `'.strtolower($t).'` TO `'.($t).'` ;');
}put the following code in around line 275 of sapphire/core/model/MySQLDatabase.php...
public function fieldList($table) {
$t = $table;
if(DB::query('SELECT * FROM information_schema.tables WHERE table_schema like binary "'.strtolower($t).'" or Table_Name like binary "'.strtolower($t).'";')->value()) {
DB::query('RENAME TABLE `'.strtolower($t).'` TO `'.($t).'` ;');
} -
Re: lowercase table hack
12 September 2009 at 12:15am
Hi!
I'm pretty sure you build your database on a wamp installation.
You have to configure your database:
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
Cheers,
Malte
-
Re: lowercase table hack
9 December 2009 at 5:58pm
Legend this was really annoying the hell out of me!
| 1829 Views | ||
|
Page:
1
|
Go to Top |
