Hi, Yesterday we moved our Database to a new server, After which the site seems to be working fine but the Sitewide activity widget stopped working it stopped at the update before the migration.
Any idea what might be wrong?

Thanks
Manoj

[@r-a-y Keymaster 13 years, 10 months ago]

That’s a 3rd-party plugin by Buddydev.com:
http://buddydev.com/buddypress/buddypress-sitewide-activity-widget-for-buddypress-1-2-and-above/

I’d recommend you post on their site to get support.

[@mjc82in Participant 13 years, 10 months ago]

Well I dont think its the plugin problem, I dont think the wp_bp_activity table is being updated.

[@r-a-y Keymaster 13 years, 10 months ago]

A good way to check if the activity component is working is to disable the sitewide activity widget and then use the regular activity form to post.

See if activity posting works then. If it doesn’t try repairing the wp_bp_activity_table in the DB.

[@mjc82in Participant 13 years, 10 months ago]

well I checked the table directly and the last post is the old post nothing after that

[@r-a-y Keymaster 13 years, 10 months ago]

I skipped the part that said you moved your DB to a new server.

Make sure your wp-config.php has the correct information with regards to your DB host.

[@mjc82in Participant 13 years, 10 months ago]

Yes it does, because the entire site is running of that server everything seems to be working except the activity

[@r-a-y Keymaster 13 years, 10 months ago]

Did you try repairing the wp_bp_activity table?

[@mjc82in Participant 13 years, 10 months ago]

I actually did as soon as you suggested it, no success

[@mjc82in Participant 13 years, 10 months ago]

This is wierd, so the next post finally came (which is one more post).

This one is 8 hrs ago, The one before this is 1 day and 8 hrs (this is right before the move)

[@mjc82in Participant 13 years, 10 months ago]

you can check out the site
community.mis.temple.edu

[@r-a-y Keymaster 13 years, 10 months ago]

Gotcha.

Sounds like a timezone issue. Your server might need to be set to the correct timezone. Also try manually setting the timezone in the WordPress admin area:
https://codex.wordpress.org/Settings_General_SubPanel

[@mjc82in Participant 13 years, 10 months ago]

Thats already set, I again re-applied the setting, it still doesn’t work.

[@r-a-y Keymaster 13 years, 10 months ago]

What is already set? The WordPress timezone or your server’s timezone?

Your server’s timezone is different; get a system admin to verify that the server timezone is correct.

[@mjc82in Participant 13 years, 10 months ago]

both Server timezone and the wordpress timezone, both are same.

[@r-a-y Keymaster 13 years, 10 months ago]

What version of BuddyPress are you running?

[@mjc82in Participant 13 years, 10 months ago]

sorry got busy in the weekend, ok I resolved one issue.
i.e. Now it started updating again, The problem was on the new mysql server, Strict mode was on.

Now the problem is there is a delay of 6hrs before it gets updated. Definitely a time issue, But not sure where, because the time all looks to be correct.