WordPress.org

Ready to get started?Download WordPress

Forums

WP Symposium
[resolved] database error: [Table '_user_activity' doesn't exist] (5 posts)

  1. MI C
    Blocked
    Posted 1 year ago #

    On updating the WP Symposium plugin from the previous version to the new version (13.02). I have this error at the bottom of the WP Symposium>>Installation page.

    WordPress database error: [Table 'wp_user_activity' doesn't exist]
    SELECT COUNT(*) FROM wp_user_activity WHERE user_ID = '1'

    WordPress database error: [Table 'wp_user_activity' doesn't exist]
    UPDATE wp_user_activity SET last_active = '1360953390' WHERE user_ID = '1'

    http://wordpress.org/extend/plugins/wp-symposium/

  2. robertd62
    Member
    Posted 1 year ago #

    Go to your installation screen for wps and find this on that screen:

    Refresh WP Symposium
    To re-run the database table creation/modifications, click here.
    This will not destroy any existing tables or data.

    Rub it and it should take care of your problem.

  3. MI C
    Blocked
    Posted 1 year ago #

    Followed your instructions, but it triggers the errors below:

    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_following ADD PRIMARY KEY (fid)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_news ADD PRIMARY KEY (nid)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_lounge ADD PRIMARY KEY (lid)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_groups ADD PRIMARY KEY (gid)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_group_members ADD PRIMARY KEY (gmid)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_gallery ADD PRIMARY KEY (gid)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_gallery_items ADD PRIMARY KEY (iid)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_events ADD PRIMARY KEY (eid)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_events_bookings ADD PRIMARY KEY (bid)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_likes ADD PRIMARY KEY vid (vid)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_topics_scores ADD PRIMARY KEY sid (sid)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_topics_images ADD PRIMARY KEY tmpid (tmpid)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_cats ADD PRIMARY KEY cid (cid)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_subs ADD PRIMARY KEY sid (sid)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_comments ADD PRIMARY KEY cid (cid)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_topics ADD PRIMARY KEY tid (tid)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_usermeta ADD PRIMARY KEY mid (mid)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_extended ADD PRIMARY KEY eid (eid)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_friends ADD PRIMARY KEY fid (fid)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_chat2 ADD PRIMARY KEY id (id)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_chat2_users ADD PRIMARY KEY id (id)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_chat2_typing ADD PRIMARY KEY id (typing_from)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_mail ADD PRIMARY KEY mail_mid (mail_mid)
    
    WordPress database error: [Multiple primary key defined]
    ALTER TABLE wp_symposium_styles ADD PRIMARY KEY sid (sid)
  4. robertd62
    Member
    Posted 1 year ago #

    Please take this for support the our site. http://wpsymposium.com Thank you

  5. simon.goodchild
    Member
    Plugin Author

    Posted 1 year ago #

    I'll close this topic now, if you would like further help probably best to start with the http://www.wpsymposium.com/discuss forum, or if a member, use the helpdesk (link on the same place).

    Regards,
    Simon

Topic Closed

This topic has been closed to new replies.

About this Plugin

About this Topic