Closed (fixed)
Project:
Advanced Profile Kit
Version:
5.x-1.0-alpha3
Component:
Code
Priority:
Critical
Category:
Bug report
Assigned:
Unassigned
Reporter:
Created:
10 Mar 2008 at 14:26 UTC
Updated:
1 Oct 2009 at 19:50 UTC
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
Comment #1
zmove commentedSorry, 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.
Comment #2
vivianspencer commentedHi I'm actually getting the same problem, how did you fix the conflict
Comment #3
dailypress commentedI 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
Comment #4
vivianspencer commentedSorry, I didn't find a solution, I gave up