Thread Rating:
  • 20 Vote(s) - 3.8 Average
  • 1
  • 2
  • 3
  • 4
  • 5
[For 1.6] [release] [updated for 1.6] Stopforumspam.com plugin for MyBB - Stop the Spam!
This user has been denied support. This user has been denied support.
[/quote]

What database engine are you using? MySQL?


[/quote]

Yes MYSQL.
I found the solutionBig Grin


Cause

MySQL 5.0 and higher have a strict mode that is currenty incompatible with a number of queries in Drupal. The Windows Installer from MySQL.com enables this strict mode by default.

Workaround

There are several workarounds

1. Replace in my.ini the current sql-mode line with sql-mode="MYSQL40"
2. Start MySQL with the option --sql-mode="MYSQL40"
3. Execute the query SET GLOBAL sql_mode='MYSQL40'

MySQL needs to be restarted before changes in my.ini have an effect. My.ini can be found in the MySQL installation directory or the Windows directory, depending on your configuration.

Note: After switching MySQL mode you have to recreate your Drupal database or your site will not function properly.
Reply


Messages In This Thread
RE: [release] [updated for 1.6] Stopforumspam.com plugin for MyBB - Stop the Spam! - by annaconda - 2011-03-23, 11:35 AM

Forum Jump:


Users browsing this thread: 2 Guest(s)