By allen on

when i have a user that hasnt set up mypage i get the followoing error:

user error: You have an error in your SQL syntax near ') AND n.status = 1 AND '1' ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 10' at line 1
query: SELECT DISTINCT(n.nid), n.sticky, n.created FROM node n INNER JOIN term_node tn ON n.nid = tn.nid WHERE tn.tid IN () AND n.status = 1 AND '1' ORDER BY n.sticky DESC, n.created DESC LIMIT 0, 10 in /home/virtual/site247/fst/var/www/html/includes/database.mysql.inc on line 125.

once they set it up, it works fine.

anyone have a suggestion?

Comments

allen’s picture

allen commented

NOW im getting the same thing on nmoderation

user error: You have an error in your SQL syntax ne
ar 'ON nmuv.mid = v.mid JOIN node n ON n.nid = nmuv.gid JOIN users u ON n.uid = u.ui' at line 1
query: SELECT n.nid, u.name, n.title, n.changed, n.created, n.uid, v.vote, nmuv.uvid FROM nmoderation_uservotes nmuv JOIN nmoderation_votes v ON nmuv.mid = v.mid JOIN node n ON n.nid = nmuv.gid JOIN users u ON n.uid = u.uid WHERE n.status = 1 AND nmuv.uid = 1 AND nmuv.realm = 'node_nid' ORDER BY n.created DESC LIMIT 0, 50 in /home/virtual/site247/fst/var/www/html/includes/database.mysql.inc on line 125.

this one doesnt go away.