Here is the following SQL errors :

user error: You have an error in your SQL syntax near '' at line 1
query: SELECT COUNT(*) FROM node n LEFT JOIN buddylist b ON n.uid = b.buddy WHERE n.status = 1 AND b.uid = 1 AND in /home/httpd/vhosts/jordanwillms.com/httpdocs/drupal/includes/database.mysql.inc on line 66.

user error: You have an error in your SQL syntax near 'ORDER BY n.nid DESC LIMIT 0, 10' at line 1
query: SELECT n.nid, n.type, n.format, n.status FROM node n LEFT JOIN buddylist b ON n.uid = b.buddy WHERE n.status = 1 AND b.uid = 1 AND ORDER BY n.nid DESC LIMIT 0, 10 in /home/httpd/vhosts/jordanwillms.com/httpdocs/drupal/includes/database.mysql.inc on line 66.

When viewing 'my buddies posts'. Any idea how to fix? I downloaded drupal CVS and buddylist CVS just today. (All other aspects of the module work alright, except this)

Cheers!

Jordan
http://www.jordanwillms.com
http://www.pixelknowledge.com

Comments

Mad Maks’s picture

Mad Maks CreditAttribution: Mad Maks commented

I see the same error.

greetings

Mad Maks

Anonymous’s picture

(not verified) CreditAttribution: commented
Priority: Normal » Critical

resolved:

please see my blog for more info on how to download a working buddylist.module

I would update to drupal.org -- but alas, I do not know how.

Please download the module at : http://www.jordanwillms.com/index.php?p=25

Jordan Willms..
http://www.jordanwillms.com - Ramblings...
http://www.pixelknowledge.com - Business..

adrian’s picture

adrian CreditAttribution: adrian commented

This was fixed, and the module was tagged to 4.6.

Anonymous’s picture

(not verified) CreditAttribution: commented