I was waiting for a "recommended version" of Activity for a long time. I just realized it's released yesterday finally. I put it on my site and got those

* warning: implode() [function.implode]: Invalid arguments passed in /home/topnet/public_html/iliski.com/sites/all/modules/activity/activity.module on line 557.
* 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 2 query: SELECT COUNT(*) FROM activity_targets activity_targets INNER JOIN activity activity ON activity.aid = activity_targets.aid WHERE activity_targets.target_uid IN () in /home/topnet/public_html/iliski.com/sites/all/modules/activity/activity.module on line 625.
* 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 ') ORDER BY activity.created DESC LIMIT 0, 6' at line 3 query: SELECT activity.*, activity_targets.target_uid, activity_targets.target_role FROM activity_targets activity_targets INNER JOIN activity activity ON activity.aid = activity_targets.aid WHERE activity_targets.target_uid IN () ORDER BY activity.created DESC LIMIT 0, 6 in /home/topnet/public_html/iliski.com/sites/all/modules/activity/activity.module on line 625.

I'm on Drupal 6.9.

CommentFileSizeAuthor
#9 activity.module.txt44.82 KBjaydub
#7 activity.module.393188.patch777 bytesjaydub

Comments

sirkitree’s picture

Title: Lots of errors » Activity targets warnings
Category: support » bug
Status: Active » Postponed (maintainer needs more info)

Are you upgrading from a dev version? a 5 version? brand new install? what all packaged activity modules do you have installed?

drupallogic’s picture

as I mentioned, it's a fresh install. I didn't upgrade anything.

I have enabled all Activity components. don't know which one is causing these errors...

drupallogic’s picture

I found out.

when I enable "User relationships activity" under Activity module, these errors happen!

sirkitree’s picture

Thanks, I'll start looking there.

jaydub’s picture

Assigned: Unassigned » jaydub
Status: Postponed (maintainer needs more info) » Active
jaydub’s picture

From your error message I can assume that the error is originating from a block but I am not sure which block or blocks is causing this. Can you verify for what block(s) you have enabled when you see the error?

jaydub’s picture

Status: Active » Needs review
StatusFileSize
new777 bytes

Do you know how to apply a patch? If so can you try applying the attached patch and let us know if this fixes the issue for you?

drupallogic’s picture

actually I don't know how to apply a patch, but I will search and learn.

jaydub’s picture

StatusFileSize
new44.82 KB

try this attached file. Copy it to your Activity module directory. Rename the file to activity.module (this is because the drupal project pages don't allow files uploaded with the .module extension).

jaydub’s picture

if you didn't try #9 you can try downloading the latest -dev snapshot as I've rolled the changes in #9 into the -dev tree.

tracerhand’s picture

I got this message when users signed up. Their confirmation email took them to a page where they're asked to change their password by clicking on a one-time login link and the subsquent page displayed this error. However, after reinstalling, the message seems to have disappeared.

drupallogic’s picture

I just uploaded 6.x-1.x-dev and it works fine. no errors yet. thank you!

meanwhile I'm not sure if I'm missing. Does Activity have the feature "Who looked to my profile?"

if not it will be great to add.

jaydub’s picture

#12 - the User Activity contrib module can track when a user views another user's profile page.

drupallogic’s picture

yes but it's different. if someone views my profile it's listed under his account that he viewed my profile.

but I can't see who viewed my profile when I go to my account. hope you add it.

jaydub’s picture

Title: Activity targets warnings » Track who looked at my profile
Version: 6.x-1.1 » 6.x-1.x-dev
Category: bug » feature
Status: Needs review » Active

Changing issue title to relate to request in #12

jaydub’s picture

Issue tags: +activity-6.x-1-2

tagging for release

jaydub’s picture

pushing to next release

sirkitree’s picture

Status: Active » Closed (won't fix)

closing. 1.x no longer supported.