<?xml version="1.0" encoding="UTF-8"?>        <rss version="2.0"
             xmlns:atom="http://www.w3.org/2005/Atom"
             xmlns:dc="http://purl.org/dc/elements/1.1/"
             xmlns:sy="http://purl.org/rss/1.0/modules/syndication/"
             xmlns:admin="http://webns.net/mvcb/"
             xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#"
             xmlns:content="http://purl.org/rss/1.0/modules/content/">
        <channel>
            <title>
									WordPress - Cleaning up dangling user meta data (wp_usermeta) - Web Development				            </title>
            <link>https://www.tweaking4all.com/forum/web-development/wordpress-cleaning-up-dangling-user-meta-data-wp_usermeta/</link>
            <description>Tweaking4All.com Discussion Board</description>
            <language>en-US</language>
            <lastBuildDate>Tue, 21 Jul 2026 01:05:27 +0000</lastBuildDate>
            <generator>wpForo</generator>
            <ttl>60</ttl>
							                    <item>
                        <title>WordPress - Cleaning up dangling user meta data (wp_usermeta)</title>
                        <link>https://www.tweaking4all.com/forum/web-development/wordpress-cleaning-up-dangling-user-meta-data-wp_usermeta/#post-4833</link>
                        <pubDate>Wed, 29 Mar 2023 11:51:12 +0000</pubDate>
                        <description><![CDATA[As some may have noticed, the Dutch forum took a nose dive and crashed the Dutch website constantly.Producing this error (posting the error, just in case someone is looking for this specific...]]></description>
                        <content:encoded><![CDATA[<p>As some may have noticed, the Dutch forum took a nose dive and crashed the Dutch website constantly.<br />Producing this error (posting the error, just in case someone is looking for this specific error):</p>
<pre contenteditable="false">Warning: Attempt to read property "roles" on bool in /home/user/public_html/wp-content/plugins/wpforo/classes/Members.php on line 1108

Fatal error: Uncaught Error: Attempt to assign property "roles" on bool in /home/user/public_html/wp-content/plugins/wpforo/classes/Members.php:1108 Stack trace: #0 /home/user/public_html/wp-content/plugins/wpforo/classes/Members.php(1166): wpforo\classes\Members-&gt;synchronize_user('2', Array) #1 /home/user/public_html/wp-content/plugins/wpforo/includes/installation.php(32): wpforo\classes\Members-&gt;synchronize_users(100) #2 /home/user/public_html/wp-content/plugins/wpforo/classes/Actions.php(20): wpforo_activation() #3 /home/user/public_html/wp-includes/class-wp-hook.php(308): wpforo\classes\Actions-&gt;wpforo\classes\{closure}('') #4 /home/user/public_html/wp-includes/class-wp-hook.php(332): WP_Hook-&gt;apply_filters('', Array) #5 /home/user/public_html/wp-includes/plugin.php(517): WP_Hook-&gt;do_action(Array) #6 /home/user/public_html/wp-content/plugins/wpforo/wpforo.php(279): do_action('wpforo_after_in...') #7 /home/user/public_html/wp-content/plugins/wpforo/wpforo.php(510): wpforo\wpforo-&gt;init_classes() #8 /home/user/public_html/wp-includes/class-wp-hook.php(308): wpforo\wpforo-&gt;init(Object(WP)) #9 /home/user/public_html/wp-includes/class-wp-hook.php(332): WP_Hook-&gt;apply_filters(NULL, Array) #10 /home/user/public_html/wp-includes/plugin.php(565): WP_Hook-&gt;do_action(Array) #11 /home/user/public_html/wp-includes/class-wp.php(797): do_action_ref_array('wp', Array) #12 /home/user/public_html/wp-includes/functions.php(1332): WP-&gt;main('') #13 /home/user/public_html/wp-blog-header.php(16): wp() #14 /home/user/public_html/index.php(17): require('/home/user/...') #15 {main} thrown in /home/user/public_html/wp-content/plugins/wpforo/classes/Members.php on line 1108</pre>
<p>It appears that the forum doesn't like dangling meta data in the <strong>wp_usermeta</strong> table.</p>
<p> </p>
<p>This is how I fixed the issue - wasn't that hard once you know where to look.</p>
<p>1. Made a backup of the tables<span> </span><strong>wp_usermeta</strong><span> </span>and<span> </span><strong>wp_users</strong>. Just in case.</p>
<p>2. Determine what records in<span> </span><strong>wp_usermeta</strong><span> </span>is no longer linked to an existing user (NULL).</p>
<pre contenteditable="false">SELECT *
FROM wp_usermeta LEFT OUTER JOIN wp_users on wp_usermeta.user_id=wp_users.ID
WHERE wp_users.ID IS NULL</pre>
<p>3. If all looks good, remove these rows </p>
<pre contenteditable="false">DELETE wp_usermeta
FROM wp_usermeta LEFT OUTER JOIN wp_users on wp_usermeta.user_id=wp_users.ID  
WHERE wp_users.ID IS NULL</pre>
<p>4. Test and verify if everything works as it should.</p>
<p> </p>]]></content:encoded>
						                            <category domain="https://www.tweaking4all.com/forum/web-development/">Web Development</category>                        <dc:creator>Hans</dc:creator>
                        <guid isPermaLink="true">https://www.tweaking4all.com/forum/web-development/wordpress-cleaning-up-dangling-user-meta-data-wp_usermeta/#post-4833</guid>
                    </item>
							        </channel>
        </rss>
		