 |
Apache2Triad Help, Support and Development
The apache2triad help , support and development forums
|
| View previous topic :: View next topic |
| Author |
Message |
philo23
Joined: 01 Mar 2006
Posts: 4
|
| Posted: Sat May 13, 2006 3:27 pm Post subject: MySQL Mode |
|
|
| i need to turn strict mode off its in the my.ini, but i dont know what to put into it. i've tryed leaving it blank. i've tryed everything i understand off the mysql manual, still no luck, any ideas? |
|
| Back to top |
|
Joshua Meadows (DemoRic)
Joined: 29 Dec 2004
Posts: 783
Location: S.E. Kansas
|
| Posted: Sat May 13, 2006 4:43 pm Post subject: |
|
|
Haven't tried it but a solution is in the manual
http://dev.mysql.com/doc/refman/5.0/en/server-sql-mode.html
To quote Samuel Fullman
Quote: I migrated from 4.0 to 5.0 and all of a sudden mysql's sensitivity went through the roof, and queries failed. You can override the features listed on this page by making your first query:
SET @@global.sql_mode='';
Which will take away all sql modes. The documentation didn't seem to be clear on this as far as NEGATING one of these flags but that's how it's done. |
|
| Back to top |
|
philo23
Joined: 01 Mar 2006
Posts: 4
|
| Posted: Sat May 13, 2006 7:23 pm Post subject: |
|
|
| tried that. it still doesnt work. any ideas? |
|
| Back to top |
|
| |
|