Media tabs not working after reinstall

  • Resolved Christopher Sem

    (@leoniscsem)


    2 years, 10 months ago

    When reinstalling the plugin from the same code base (i.e. using the same folder on the server), the media tabs are broken. Both in the personal profile and in the groups. Clearing the cache and deleting the files in the cache directory does not change this issue.

    When posting a picture (video, file, et cetera) on the activities tab from the personal profile, the picture shows up in the respective post, but not in the sidebar in the media category.

    When posting a file to a group, it should also show up in the group’s media tab, which it doesn’t.

    I installed the standard theme first, then Buddypress, then Youzify. In the initial instance installing Youzify triggered the Youzify UI to upload pictures for the user, and then for the group. This behaviour is also gone upon reinstall.

    Environment:

    Ubuntu 18.04
nginx 1.21.4
MariaDB 15.1
PHP FPM 7.4 / 8.1
WordPress 5.8.2
WP assigned memory 1024MB

    Youzify – latest version
    WP and plugins installed from WP CLI

    The page I need help with: [log in to see the link]

Viewing 4 replies - 1 through 4 (of 4 total)
  • Thread Starter Christopher Sem

    (@leoniscsem)

    I wanted to add a few more details and error logs:

    Linux kernel 5.4.0-90-generic x86_64
Web server	nginx/1.21.4
PHP version	7.4.27 (Supports 64bit values)
PHP SAPI	fpm-fcgi
PHP max input variables	1000
PHP time limit	3600
PHP memory limit	1024M
Max input time	3600
Upload max filesize	2048M
PHP post max size	2048M
Database	10.4.22-MariaDB-1:10.4.22+maria~bionic

    Debugging the media upload issues on profile:

    Main area (after posting a picture)

    WordPress database error: [Unknown column 'privacy' in 'field list']
SELECT privacy from wp_bp_activity WHERE id = 54

WordPress database error: [Column 'privacy' cannot be null]
INSERT INTO <code>wp_youzify_media</code> (<code>media_id</code>, <code>item_id</code>, <code>component</code>, <code>user_id</code>, <code>privacy</code>, <code>type</code>, <code>time</code>, <code>data</code>, <code>source</code>) VALUES ('5080', '54', 'activity', 1, NULL, 'image', '2022-01-01 06:55:05', '0', 'activity_photo')

    Sidebar Media Widget (when browsing a user, who definitely should have media items there):

    Photos tab:

    WordPress database error: [Unknown column 'a.privacy' in 'where clause']
SELECT m.id, m.media_id, m.item_id, m.data FROM wp_youzify_media AS m JOIN wp_bp_activity AS a ON m.item_id = a.id WHERE m.component = 'activity' AND a.hide_sitewide = 0 AND a.user_id = 1 AND a.privacy IN ( 'public', 'members', 'friends' ) AND a.is_spam = 0 AND a.type IN ('activity_photo','activity_slideshow','activity_quote','activity_link','new_avatar','new_cover') GROUP BY m.id ORDER BY m.id DESC LIMIT 9

# Sorry, no items found

WordPress database error: [Unknown column 'a.privacy' in 'where clause']
SELECT COUNT(*) FROM wp_youzify_media AS m JOIN wp_bp_activity AS a ON m.item_id = a.id WHERE m.component = 'activity' AND a.hide_sitewide = 0 AND a.user_id = 1 AND a.privacy IN ( 'public', 'members', 'friends' ) AND a.is_spam = 0 AND a.type IN ('activity_photo','activity_slideshow','activity_quote','activity_link','new_avatar','new_cover')

    Videos tab:

    WordPress database error: [Unknown column 'a.privacy' in 'where clause']
SELECT m.id, m.media_id, m.item_id, m.data FROM wp_youzify_media AS m JOIN wp_bp_activity AS a ON m.item_id = a.id WHERE m.component = 'activity' AND a.hide_sitewide = 0 AND a.user_id = 1 AND a.privacy IN ( 'public', 'members', 'friends' ) AND a.is_spam = 0 AND a.type IN ('activity_video') GROUP BY m.id ORDER BY m.id DESC LIMIT 9

# Sorry, no items found

WordPress database error: [Unknown column 'a.privacy' in 'where clause']
SELECT COUNT(*) FROM wp_youzify_media AS m JOIN wp_bp_activity AS a ON m.item_id = a.id WHERE m.component = 'activity' AND a.hide_sitewide = 0 AND a.user_id = 1 AND a.privacy IN ( 'public', 'members', 'friends' ) AND a.is_spam = 0 AND a.type IN ('activity_video')

    Audios tab:

    WordPress database error: [Unknown column 'a.privacy' in 'where clause']
SELECT m.id, m.media_id, m.item_id, m.data FROM wp_youzify_media AS m JOIN wp_bp_activity AS a ON m.item_id = a.id WHERE m.component = 'activity' AND a.hide_sitewide = 0 AND a.user_id = 1 AND a.privacy IN ( 'public', 'members', 'friends' ) AND a.is_spam = 0 AND a.type IN ('activity_audio') GROUP BY m.id ORDER BY m.id DESC LIMIT 6

# Sorry, no items found

WordPress database error: [Unknown column 'a.privacy' in 'where clause']
SELECT COUNT(*) FROM wp_youzify_media AS m JOIN wp_bp_activity AS a ON m.item_id = a.id WHERE m.component = 'activity' AND a.hide_sitewide = 0 AND a.user_id = 1 AND a.privacy IN ( 'public', 'members', 'friends' ) AND a.is_spam = 0 AND a.type IN ('activity_audio')

    Files tab:

    WordPress database error: [Unknown column 'a.privacy' in 'where clause']
SELECT m.id, m.media_id, m.item_id, m.data FROM wp_youzify_media AS m JOIN wp_bp_activity AS a ON m.item_id = a.id WHERE m.component = 'activity' AND a.hide_sitewide = 0 AND a.user_id = 1 AND a.privacy IN ( 'public', 'members', 'friends' ) AND a.is_spam = 0 AND a.type IN ('activity_file') GROUP BY m.id ORDER BY m.id DESC LIMIT 6

# Sorry, no items found

WordPress database error: [Unknown column 'a.privacy' in 'where clause']
SELECT COUNT(*) FROM wp_youzify_media AS m JOIN wp_bp_activity AS a ON m.item_id = a.id WHERE m.component = 'activity' AND a.hide_sitewide = 0 AND a.user_id = 1 AND a.privacy IN ( 'public', 'members', 'friends' ) AND a.is_spam = 0 AND a.type IN ('activity_file')
    • This reply was modified 2 years, 10 months ago by Christopher Sem. Reason: had given info about the wrong server in the previous post
    Plugin Support Youzify

    (@kainelabsteam)

    Hello @leoniscsem

    Thanks for reaching us

    Please make sure to do these steps:

    1. Make sure you are using the most updated versions of Youzify, WordPress & your theme.

    2. Deactivate all of your plugins. If this solves the problem, gradually activate your plugins one by one, until you spot the problematic plugin.

    3. If you have a caching plugin, make sure you deactivate it, or even better – purge the cache.

    4. Change your WordPress theme to WordPress TwentySeventeen (or other default WordPress theme).

    5. On your WordPress root folder, edit the wp-config.php and set the value of WP-DEBUG to true.

    Thread Starter Christopher Sem

    (@leoniscsem)

    Uhm, thank you for your feedback I guess. Before posting here I had done 1-4, and my second message is the output of WP-DEBUG.

    Plugin Support Youzify

    (@kainelabsteam)

    Hello @leoniscsem

    May I know, do you use the Free or Pro version?

    Best Regards, KaineLabs Team.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Media tabs not working after reinstall’ is closed to new replies.