Closed (fixed)
Project:
Workspace
Version:
4.7.x-1.x-dev
Component:
Code
Priority:
Normal
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
24 Apr 2006 at 20:36 UTC
Updated:
7 May 2006 at 19:35 UTC
user warning: Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (utf8_general_ci,COERCIBLE) for operation 'UNION' query: SELECT n.nid, n.uid, n.type, 0 AS cid, n.title, n.status, n.changed, s.comment_count, 1 AS node FROM node n LEFT JOIN node_comment_statistics s ON n.nid = s.nid WHERE n.uid = 1 UNION SELECT c.nid AS cnid, c.uid, "" AS type, c.cid, c.subject, c.status, c.timestamp, c.pid, 0 FROM comments AS c, node n LEFT JOIN node_comment_statistics s ON n.nid = s.nid WHERE c.uid = 1 ORDER BY changed DESC LIMIT 0, 50 in /home/mysite/public_html/includes/database.mysql.inc on line 120.
Comments
Comment #1
jvandyk commentedThis is not a problem with workspace, but with your database encoding. (See here.