Hi,

I'm using the advanced profile combined with nodeprofile to create good profile page for user. I followed this tutorial to do that and going to the node profile part of the tutorial.

And when I come to the content tab of the panel module (the number 10 in the tutorial) I have an error :

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= comments. AND comments.uid = '1' LEFT JOIN dp_node_comment_statistics node_com' at line 1 query: SELECT DISTINCT(node.nid), node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed, users.name AS users_name, users.uid AS users_uid, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp FROM dp_node node LEFT JOIN dp_comments comments ON . = comments. AND comments.uid = '1' LEFT JOIN dp_node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid INNER JOIN dp_users users ON node.uid = users.uid WHERE (node.status = '1') AND (node.type IN ('blog','book','forum','advpoll_ranking','advpoll_binary','page','story')) AND (node.uid = '1' OR comments.uid = '1') ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 5 in D:\Taf\drupal5\includes\database.mysqli.inc on line 151.

and if I go to my account then, I have an error too :

user warning: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '= comments. AND comments.uid = '1' LEFT JOIN dp_node_comment_statistics node_com' at line 1 query: SELECT DISTINCT(node.nid), node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp_last_comment_timestamp, node.title AS node_title, node.changed AS node_changed, users.name AS users_name, users.uid AS users_uid, node_comment_statistics.comment_count AS node_comment_statistics_comment_count, node_comment_statistics.last_comment_timestamp AS node_comment_statistics_last_comment_timestamp FROM dp_node node LEFT JOIN dp_comments comments ON . = comments. AND comments.uid = '1' LEFT JOIN dp_node_comment_statistics node_comment_statistics ON node.nid = node_comment_statistics.nid INNER JOIN dp_users users ON node.uid = users.uid WHERE (node.status = '1') AND (node.type IN ('blog','book','forum','advpoll_ranking','advpoll_binary','page','story')) AND (node.uid = '1' OR comments.uid = '1') ORDER BY node_comment_statistics_last_comment_timestamp_last_comment_timestamp DESC LIMIT 0, 5 in D:\Taf\drupal5\includes\database.mysqli.inc on line 151.

Any help would be appreciated, I followed the tutorial, start it again 2 times, I have the error all the time...

Comments

zmove’s picture

Status: Active » Closed (fixed)

Sorry, I find the origin of the problem.

It was because I use nodecomment to manage my comments, and the default panel list the comment of the user. so there was a conflict with this panel.

vivianspencer’s picture

Hi I'm actually getting the same problem, how did you fix the conflict

dailypress’s picture

I am having the same problem. Whats the solution? It would be nice once you figure out the problem to write the solution as well.
tnx

vivianspencer’s picture

Sorry, I didn't find a solution, I gave up