wpmudev / multi-db

Allows you to partition your large WordPress Multisite database across multiple servers for scalability.
GNU General Public License v2.0
90 stars 64 forks source link

Facing issue with option page setting #10

Open rohittheindiajobs opened 7 years ago

rohittheindiajobs commented 7 years ago

Apologies for my english.

After upgrading my network. I found that admin unable to save setting options from the setting pages.

On debugging , I noticed that wordpress sets the sql_mode as below on connecting to database.

but multi db does not had set following option so I had added below after mysql_connect function in db.php

@mysql_query("SET SESSION sql_mode='NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'",$dbh);