Can't create a new view I am having trouble creating a new View. I am just testing out the module, but when I click "Save" after setting everything up, I receive the following error:


  PDOException: SQLSTATE[HY000]: General error: 1267 Illegal mix of
  collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT)
  for operation '=': SELECT s.uid, c.updated FROM {ctools_object_cache}
  c INNER JOIN {sessions} s ON c.sid = s.sid WHERE s.sid &lt;> :session_id
  AND c.obj = :obj AND c.name = :name ORDER BY c.updated ASC; Array (
  [:session_id] => 3nTvCCvx2_Zopg07JqIBReKxL3TzvilIkwmHjFKZ93o [:obj] =>
  view [:name] => recently_posted_jobs ) in ctools_object_cache_test()
  (line 145 of
  /home1/mt/public_html/mtnet/sites/all/modules/ctools/includes/object-cache.inc).
  The website encountered an unexpected error. Please try again later.


Any ideas why this is happening?
Clear all your caches and try again.

You db seems to become corrupted or misconfigured. Your ctools module is using a different collation to store values in the db. So most of your site is utf8_general_ci and the ctools is using utf8_unicode_ci.

I gathered all of that from this line:


  (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=': SELECT s.uid, c.updated FROM {ctools_object_cache}




If the clearing of caches fails then...

If you have phpmyadmin installed, go to the site's db and check what the Collate value is. Try changing it to utf_8 or something.



NOTE: I would create a backup of the db before you play with any collate value stuff.