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?
Joshua Meadows (DemoRic) support
Joined: 29 Dec 2004
Posts: 783
Location: S.E. Kansas
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 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
