Apache2Triad Help, Support and Development Forum Index Search Profile Log in to check your private messages Log in Register Memberlist Attachments Statistics Crew/Ranks Archive
 MySQL Mode
Google
Post new topic Reply to topic
Author Message
philo23
 
 


Joined: 01 Mar 2006
Posts: 4

PostPosted: Sat May 13, 2006 3:27 pm Reply with quoteBack to top

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?
View user's profileSend private messageAIM Address
Joshua Meadows (DemoRic)
support
support


Joined: 29 Dec 2004
Posts: 783
Location: S.E. Kansas

PostPosted: Sat May 13, 2006 4:43 pm Reply with quoteBack to top

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.
View user's profileSend private messageYahoo MessengerICQ Number
philo23
 
 


Joined: 01 Mar 2006
Posts: 4

PostPosted: Sat May 13, 2006 7:23 pm Reply with quoteBack to top

tried that. it still doesnt work. any ideas?
View user's profileSend private messageAIM Address
Display posts from previous:      
Post new topic Reply to topic


 Jump to:   



View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum
Powered by phpBB © 2001, 2002 phpBB Group :: FI Theme
All times are GMT