Skip to:
Content
Pages
Categories
Search
Top
Bottom

[resolved] Cannot post new activity

Viewing 23 replies - 1 through 23 (of 23 total)
  • 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.


    @mercime
    Keymaster

    @mercime

    Could be a theme issue. Have you tried changing to bp-default theme and posting update?


    marcycapron
    Participant

    @marcycapron

    @mercime @djpaul hi! i still get the error with bp default.

    i turned off JS, still a problem. so very strange!

    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.


    marcycapron
    Participant

    @marcycapron

    @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)


    meg@info
    Participant

    @megainfo

    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.


    marcycapron
    Participant

    @marcycapron

    @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
    `


    marcycapron
    Participant

    @marcycapron

    @megainfo @djpaul

    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.png

    Regarding 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


    marcycapron
    Participant

    @marcycapron

    @djpaul
    Nope, been running 1.6.1 :(


    @mercime
    Keymaster

    @mercime

    Are 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?


    wpinklady
    Participant

    @wpinklady

    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.


    @mercime
    Keymaster

    @mercime

    @wpinklady you have numerous issues in your installation. Answered you at link posted above. Please continue discussion there.


    marcycapron
    Participant

    @marcycapron

    @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


    @mercime
    Keymaster

    @mercime

    Found this in BP trac. See if solution works in your installation https://buddypress.trac.wordpress.org/ticket/4523


    marcycapron
    Participant

    @marcycapron

    @mercime hey, so I changed %s to %d in both bp-core-schema (referred to in prior ticket within what you sent) and bp-activity-classes (for item_id and secondary_item_id) to no avail. I am probably not implementing a fix correctly because the ticket is a bit too vague for me. :(

    cc @djpaul


    marcycapron
    Participant

    @marcycapron

    (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).


    marcycapron
    Participant

    @marcycapron

    @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 0

    Then 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 :)


    marcycapron
    Participant

    @marcycapron

    @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 :)


    marcycapron
    Participant

    @marcycapron

    dearest @djpaul, I changed version to 6065, re-ran wizard, and can now post updates YAY let’s close this thread YAYAYAYAY thank you!

Viewing 23 replies - 1 through 23 (of 23 total)
  • The topic ‘[resolved] Cannot post new activity’ is closed to new replies.
Skip to toolbar