I don't know if this issue of activity module or usercomment module, but after enabling the last and trying to delete a comment as a user (blog author) it first gives this error:

Fatal error: Cannot use object of type stdClass as array in /home/mysite/public_html/sites/all/modules/activity/contrib/commentactivity/commentactivity.module on line 89

If I refresh the page it gives:

    * warning: Invalid argument supplied for foreach() in /home/mysite/public_html/modules/node/node.module on line 521.
    * warning: implode() [function.implode]: Invalid arguments passed in /home/mysite/public_html/modules/node/node.module on line 525.
    * 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 '' at line 1 query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM blog_node n INNER JOIN users u ON u.uid = n.uid INNER JOIN blog_node_revisions r ON r.vid = n.vid WHERE in /home/mysite/public_html/includes/database.mysql.inc on line 172.
    * warning: Invalid argument supplied for foreach() in /home/mysite/public_html/modules/node/node.module on line 521.
    * warning: implode() [function.implode]: Invalid arguments passed in /home/mysite/public_html/modules/node/node.module on line 525.
    * 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 '' at line 1 query: SELECT n.nid, n.vid, n.type, n.status, n.created, n.changed, n.comment, n.promote, n.sticky, r.timestamp AS revision_timestamp, r.title, r.body, r.teaser, r.log, r.format, u.uid, u.name, u.picture, u.data FROM blog_node n INNER JOIN users u ON u.uid = n.uid INNER JOIN blog_node_revisions r ON r.vid = n.vid WHERE in /home/mysite/public_html/includes/database.mysql.inc on line 172.

As a result comment is deleted, but not together with its subcomments (replies to that specific comment).

I also reported this to User Comment module: http://drupal.org/node/247187

Comments

jaydub’s picture

Should have been fixed as a result of this issue: http://drupal.org/node/230624

What version of activity are you running at the moment?

yngens’s picture

5.x-3.0-beta

jaydub’s picture

ok the fix was committed some time after the release you are using. It's
a simple fix however. Please refer to the patch in http://drupal.org/node/230624
It's literally a one-liner fix!

yngens’s picture

that patch gave a hunk, so i just downloaded and swtiched to dev version. beta is buggy

sirkitree’s picture

Status: Active » Closed (fixed)

Dev version is a lot more stable. we need to make a new release, I've just been busy. I'll try to make a new release today and then we're going to start work on the d6 port which jaydub says should be fairly easy.