[resolved] Cannot post new activity
-
See screenshot: https://dl.dropbox.com/u/21711125/Screen%20Shot%202012-10-15%20at%201.26.02%20AM.png
I saw this error show up in Trac, where the update ‘posts’ but not really as there is no activity id … however the cases I googled said it was a Windows II7 issue. I am on an apache server, so this shouldn’t be an issue. ALL plugins but buddypress have been disabled.
Thoughts? Thanks in advance!
-
Nothing obvious springs to mind. Can you inspect the request that the AJAX makes when it posts a request in something like firebug, and show us what it’s sending?
Also. Try disabling javascript, then submitting an update. If it works, we know the javascript is playing up somewhere.
Could be a theme issue. Have you tried changing to bp-default theme and posting update?
Marcy, you’re going to have to trace the AJAX request backwards and see where it’s failing. I’m assuming this is an out-of-the-box javascript rather than a custom one you’ve written.
@djpaul pardon my ignorance but if i still get the error even when i am in bp-default and i have JS turned off, isn’t it not an ajax thing?
i’ll have one of my team members trace how the whole thing is failing though (that part is not my forte)
the error is printed when you try to post in a group or in your profil ?
the error is that $activity_id returend from ajax query is empty.
check your ajax.php and try to debug bp_dtheme_post_update() function.
@megainfo @djpaul i can’t post updates to groups *or* my profile.
this is what i get with debug on (mind you no errors in chrome dev tools)
`WordPress database error: [Unknown column ‘a.is_spam’ in ‘where clause’]
SELECT a.*, u.user_email, u.user_nicename, u.user_login, u.display_name FROM wp_bp_activity a LEFT JOIN wp_users u ON a.user_id = u.ID WHERE a.is_spam = 0 AND a.user_id IN ( 25 ) ORDER BY a.date_recorded DESC LIMIT 0, 20
WordPress database error: [Unknown column ‘a.is_spam’ in ‘where clause’]
SELECT count(a.id) FROM wp_bp_activity a USE INDEX (user_id) WHERE a.is_spam = 0 AND a.user_id IN ( 25 ) ORDER BY a.date_recorded DESC
WordPress database error: [Unknown column ‘is_spam’ in ‘field list’]
INSERT INTO wp_bp_activity ( user_id, component, type, action, content, primary_link, date_recorded, item_id, secondary_item_id, hide_sitewide, is_spam ) VALUES ( 25, ‘activity’, ‘activity_update’, ‘wec posted an update’, ‘ajax 2’, ‘http://tier1alumni.com/members/wec/’, ‘2012-11-02 00:53:15’, ”, ”, 0, 0 )
-1
`and then these are the headers chrome dev tools spits out once i remembered to turn XHR on (oops) ….
https://dl.dropbox.com/u/21711125/Screen%20Shot%202012-11-01%20at%208.01.53%20PM.pngRegarding the WP_DEBUG errors. Have you recently upgraded to BuddyPress 1.6+? There was a schema change, and we added the is_spam column in the wp_bp_activity table, and your error message says that it doesn’t exist.
Can you look inside your WordPress admin area, and check that you’ve not got some pending update action? https://i.imgur.com/MseHC.png
@djpaul
Nope, been running 1.6.1Are you on single or multisite installation? If multisite, is BP on main site (default) or defined/installed in subsite? Where are you hosted? Have you tried deactivating BP and re-uploading BP manually i.e. via FTP/cpanel/file manager, then activating BP and BP Default theme to check if issue is resolved?
I have the same issue – can’t post anything, and I posted the issue to “https://buddypress.org/community/groups/how-to-and-troubleshooting/forum/topic/having-problem-with-buddypress-and-events-manager/” as well.
Hope someone could help me figure out how to solve it. Thank you very much.
@wpinklady you have numerous issues in your installation. Answered you at link posted above. Please continue discussion there.
@mercime I am on a single install. it’s on hostgator running linux. I have tried switching to other themes and replacing BP and issue prevails. I’ve never had this issue with other 1.6.1 installs so I am wondering if something in my db is screwed up?
https://dl.dropbox.com/u/21711125/Screen%20Shot%202012-11-04%20at%208.23.34%20PM.png
Found this in BP trac. See if solution works in your installation https://buddypress.trac.wordpress.org/ticket/4523
(and thank you for your continued help!!!)
If you’re still getting those SQL errors in the database, that’s the first thing we to figure out. Let’s see what version your BP thinks it is.
Please look in the wp_options table and find a record with option_name= ‘_bp_db_version’, and let me know what the option_value is. (For BP 1.6.1, it should be 6066).
@djpaul it’s 6066
Baffling.
We could either lower your version number, so BP would re-run the update (I have no idea if this would have any other consequence), or add the missing column in manually:
Add a new column to the wp_bp_activity table:
name: is_spam
type: tinyint(1)
NOT NULL
DEFAULT 0Then add a new index key:
KEY is_spam (is_spam)Before you do this, find a way to trigger the SQL error in your log. Then modify the DB table, and then try to trigger the SQL error. Hopefully that’ll be fixed, and then we can see if it affects your activity posting error. Make sure you backup your database first
@djpaul I think I’d like to try rerunning the update first. what can I change the version number to to force that? and thank you!
If you have run into a bug with BuddyPress, it may still prevent a successful upgrade. Anything lower than 6066 should do it (e.g. 6065); the upgrade nag should appear again in wp-admin. Backup first. Good luck
dearest @djpaul, I changed version to 6065, re-ran wizard, and can now post updates YAY let’s close this thread YAYAYAYAY thank you!
- The topic ‘[resolved] Cannot post new activity’ is closed to new replies.