After having changed host, I get a MySQL error when using workspace - also my workspace is always empty, except for files. Even if I create a node from within 'my workspace' it will not appear.
The only thing I can think of is a compatibility problem.
Before I was on MySQL 4
Now on 3.23
This is the error I get:
You have an error in your SQL syntax near 'UNION SELECT c.nid AS cnid, c.uid, "" AS type, c.cid, c.subject, c.status, c.tim' at line 1 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 node n, comments AS c LEFT JOIN node_comment_statistics s ON n.nid = s.nid WHERE c.uid = 1 ORDER BY changed DESC LIMIT 0, 20 i /home/www/includes/database.mysql.inc på linje 66.
I would love to have the module working again as it is great and my users love it!
Kind Regards,
Lennart Kiil
Comments
Comment #1
lennart commentedsorry - I did not realize 3.23 was not supported
Comment #2
(not verified) commentedComment #3
Dublin Drupaller commentedwas this fixed? I'm getting the same error as the original poster
Dub