Akward error message, did a search already
Ariadoss - April 8, 2006 - 16:14
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.
Collations, update.php
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.
It looks like that could be
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
Re:Akward Error message
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
This problem ceased after
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/