By Ariadoss on

This error message was spit out after an upgrade from 4.7 beta to 4.7 RC2, it only occured on one of my Drupal instalations and only on one page node.
User warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'OR format = 1' at line 1 query: SELECT * FROM filter_formats WHERE OR format = 1 in /home/ariadoss/includes/database.mysql.inc on line 108.

Another issue I have is I have this MySQL illegal mix of collations error. Is there an easy way to set all collations to utf8_general_ci? None of this is that serious, I'm sure I'll be able to figure it out, but it would be nice if someone else already knows the source of the first error.

⋅ Categories: Drupal 4.7.x

Comments

Steven’s picture

Steven commented

Running the update.php script should convert your tables to the right encoding/collation.

--
If you have a problem, please search before posting a question.

Michael M’s picture

Michael M commented

It looks like that could be a bug, because that SQL query is not correct and should not be sent to the db like that.

----
http://PointHomes.com

jdawson-1’s picture

jdawson-1 commented

I am receiving the same error regarding the filter_formats table. Does any one know how to fix this problem? Any further information would be appreciated.

Thanks

Jared

Ariadoss’s picture

Ariadoss commented

This problem ceased after downgrading to MySQL 4 from MySQL 5. However, I do run Drupal on my local machine, which is using MySQL 5 with no problems, I haven't had this issue on any of my sites since Drupal 4.7.1 was released.
-----
http://www.hogwartslive.com/
http://www.ariadoss.com/
http://www.wizards.pro/