21288 Posts in 5733 Topics by 2602 members
General Questions
SilverStripe Forums » General Questions » DB::query does NOT work on both Linux and Windows servers
General questions about getting started with SilverStripe that don't fit in any of the categories above.
Moderators: martimiz, Howard, Sean, Ryan M., biapar, Willr, Ingo, swaiba, simon_w
|
Page:
1
|
Go to End | |
| Author | Topic: | 873 Views |
-
DB::query does NOT work on both Linux and Windows servers
18 August 2010 at 1:00pm
This works on my Linux server but not on my Windows server:
DB::query("DELETE FROM FeatureAuthorScheduleItem WHERE `Date` < '".date('Y-m-d')."'");
This works on my Windows server but not on my Linux server:
DB::query("DELETE FROM featuredauthorscheduleitem WHERE `Date` < '".date('Y-m-d')."'");
How can I make this work on both servers? Is there a way to catch the error and try the second way if the first way fails?
-
Re: DB::query does NOT work on both Linux and Windows servers
18 August 2010 at 2:59pm
Wont that be a config setting in your MySQL. Looks like one only supports lower case table names. In your windows MySQL ini file you'll need to flag
lower_case_table_names = 2
| 873 Views | ||
|
Page:
1
|
Go to Top |
