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

lennart’s picture

Status: Active » Fixed

sorry - I did not realize 3.23 was not supported

Anonymous’s picture

Status: Fixed » Closed (fixed)
Dublin Drupaller’s picture

Version: » 4.7.x-1.x-dev

was this fixed? I'm getting the same error as the original poster

Dub