Vanilla Doesn't Work Well in MySQL Strict Mode

UnderDog

@cocomang said:
A very basic feature like giving moderators rights does not work with a fresh installation of vanilla.

So ... Open a new topic after you've searched and applied the proposed fixes from those search results. Tell what doesn't work.

peregrine

@cocomang said:

I I have no idea how to set sql-mode in mysql.ini as there is no mysql.ini or my.ini file anywhere on my computer. ......I have no idea how to set sql-mode in mysql.ini as there is no mysql.ini or my.ini file anywhere on my computer. ......I have no idea how to set sql-mode in mysql.ini as there is no mysql.ini or my.ini file anywhere on my computer.

as proposed before use google

https://www.google.com/search?q=+how+to+set+sql-mode++mysql.ini

yielded:

http://dev.mysql.com/doc/refman/5.1/en/server-sql-mode.html

a search for

https://www.google.com/search?q=where+is+my.cnf++my.ini

yielded

http://stackoverflow.com/questions/2482234/how-to-know-mysql-my-cnf-location

http://stackoverflow.com/questions/1712646/i-can-not-find-my-cnf-on-my-windows-computer

http://stackoverflow.com/questions/8404038/where-can-i-find-the-file-my-ini-file-for-windows-mysql-server

and lastly

http://opensourcedba.wordpress.com/2011/01/12/mysql-basics-part-3-–-your-my-cnf-or-my-ini-file/

there is, a service company that can search for you, and one can enter the command on your computer. But I don't know how much they charge for typing things into google.

@cocomang said:
I found a real fix that works

great.