Using the latest Rules, Views, Token etc with Drupal 6x. But Not able to see any activity in the Activity stream.

Already tried clearing message cache. Tried rebuilding and it says it was able to build N node creation and M group joins etc. Still No luck. The nodes were originally in non-english. So I created a few nodes in english. But still it shows no activity yet. Already made sure there is a template created for both the languages when logging activity

Yes I am using table prefixes too. But that fix should be aleady in latest dev version downloaded today.

No errors in watchdog.
But got this error on form every time when I tried to save template for action or tried to clear message cache.

warning: mysqli_real_escape_string() expects parameter 2 to be string, array given in ../www.mysite.com/httpdocs/includes/database.mysqli.inc on line 329.

I do not get this error in other rules or modules so it is not related to database connection or views.

This looks very similar to #1286464: Activity stream remains blank but all the suggestions there did not help.

Comments

ajayg’s picture

ajayg commented

Here what I found so far. My activity_log_messages is empty. So Either rules are not getting triggered or somehow they fail so nothing gets written to table.
activity_log_templates is NOT empty.

icecreamyou’s picture

icecreamyou commented

I have never seen that error before. You can tell whether the rule is getting triggered by adding another action to the rule, like a "System > Display a message to the user" action so you can see right away that the rule triggered.

ajayg’s picture

ajayg commented

Confirmed the rule is getting fired using the method above (and I added the action at the end with a thought it will get fired only after all the actions to log are completed). Still no luck and baffled.
(The error above "mysqli_real_escape_string" does not happen when you create a node or rule getting fired) It happens only when saving template etc in admin menu.

Any suggestion in which function you write to DB or send to DB layer? I can start putting some watchdog statements there to condirm it is getting up to there or bailing out earlier.

icecreamyou’s picture

icecreamyou commented

activity_log.rules.inc lines 391-484

ajayg’s picture

ajayg commented

Thanks for your help. Found that "function activity_log_rules_admin_form_submit_before" is not getting executed. I wrote a watchdog debug message as soon as I enter that function and it does not log anything. So issue is somewhere upstream.

Turning on Rules debug, confirmed the Activity logging rules are not getting executed. Note there are no other errors in watchdog or on screen. The Activity proceeded as if normal content creation.

        0 ms "After saving new content" has been invoked.
        0.115 ms Executing the rule "Log activity when a node is created (not in a group)" on rule set "After saving new content"
        0.299 ms Condition "Updated content is published" evaluated to TRUE.
        0.851 ms Condition "Content was posted in a group" evaluated to FALSE.
        1.019 ms Warning: Unable to get variable ":global".
        1.055 ms Element "Log activity for the acting user" has not been executed. There are not all execution arguments needed by an input evaluator available.
        1.111 ms Warning: Unable to get variable ":global".
        1.163 ms Element "Log activity for related taxonomy terms" has not been executed. There are not all execution arguments needed by an input evaluator available.
        1.224 ms Warning: Unable to get variable ":global".
        1.256 ms Element "Log activity for the acting user's relationships" has not been executed. There are not all execution arguments needed by an input evaluator available.
        1.338 ms Action execution: "Show a configurable message on the site"
        1.438 ms Executing the rule "Log activity when a node is created in a group" on rule set "After saving new content"
        1.6 ms Condition "Updated content is published" evaluated to TRUE.
        2.468 ms Condition "Content was posted in a group" evaluated to FALSE.
        2.537 ms Evaluation of "After saving new content" has been finished.
    साहित्य लेखन तिसरी चाच्णी has been created.
icecreamyou’s picture

icecreamyou commented
Status: Active » Closed (duplicate)

Hmm, seems to be the same thing as https://drupal.org/node/1295488

mtconto’s picture

mtconto commented

has anyone solved this? I am getting the following. looks like my activity log is refreshing, but then it comes back with nothing. this is what i get in my rules log when i enter a status in fbss:

0 ms "User saves a status" has been invoked.
0.242 ms Executing the rule "Send Email" on rule set "User saves a status"
0.675 ms Condition "Status was posted to own profile" evaluated to TRUE.
0.848 ms Executing the rule "Log activity when a user saves a personal status update" on rule set "User saves a status"
1.192 ms Condition "User updated their own status" evaluated to TRUE.
57.906 ms Action execution: "Log activity for the acting user"
94.247 ms Action execution: "Log activity for the acting user's relationships"
108.692 ms Executing the rule "Log activity when a user sends a status message" on rule set "User saves a status"
109.088 ms Condition "User updated their own status" evaluated to TRUE.
109.241 ms Evaluation of "User saves a status" has been finished.

dhakshinait’s picture

dhakshinait commented

I installed Token 1.16 along with Activity log module latest dev release but still there is a error message while saving a rule

warning: mysqli_real_escape_string() expects parameter 2 to be string, array given in E:\xampp\htdocs\mysite\includes\database.mysqli.inc on line 329

Please tell me how can i clear this issue?

dhakshinait’s picture

dhakshinait commented
Issue summary: View changes

referenced other support requests