<?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>
									WPFORO overloading MYSQL server - General Discussions				            </title>
            <link>https://wpforo.com/community/general-discussions/wpforo-overloading-mysql-server/</link>
            <description>Discussion Board</description>
            <language>en-US</language>
            <lastBuildDate>Tue, 12 May 2026 21:23:22 +0000</lastBuildDate>
            <generator>wpForo</generator>
            <ttl>60</ttl>
							                    <item>
                        <title>RE: WPFORO overloading MYSQL server</title>
                        <link>https://wpforo.com/community/general-discussions/wpforo-overloading-mysql-server/#post-45524</link>
                        <pubDate>Mon, 31 Aug 2020 13:14:19 +0000</pubDate>
                        <description><![CDATA[@alvina
 
what about the PHP errors and DB errors I pasted?]]></description>
                        <content:encoded><![CDATA[<p>@alvina</p>
<p> </p>
<p>what about the PHP errors and DB errors I pasted?</p>]]></content:encoded>
						                            <category domain="https://wpforo.com/community/general-discussions/">General Discussions</category>                        <dc:creator>stevenminix</dc:creator>
                        <guid isPermaLink="true">https://wpforo.com/community/general-discussions/wpforo-overloading-mysql-server/#post-45524</guid>
                    </item>
				                    <item>
                        <title>RE: WPFORO overloading MYSQL server</title>
                        <link>https://wpforo.com/community/general-discussions/wpforo-overloading-mysql-server/#post-45521</link>
                        <pubDate>Mon, 31 Aug 2020 12:47:44 +0000</pubDate>
                        <description><![CDATA[@stevenminix,

So I still need to know from a developer here if those duplicates need to be dropped.

Yes, you can drop the duplicates.]]></description>
                        <content:encoded><![CDATA[<p>@stevenminix,</p>
<blockquote>
<p><span>So I still need to know from a developer here if those duplicates need to be dropped.</span></p>
</blockquote>
<p>Yes, you can drop the duplicates.</p>]]></content:encoded>
						                            <category domain="https://wpforo.com/community/general-discussions/">General Discussions</category>                        <dc:creator>Alvina</dc:creator>
                        <guid isPermaLink="true">https://wpforo.com/community/general-discussions/wpforo-overloading-mysql-server/#post-45521</guid>
                    </item>
				                    <item>
                        <title>RE: WPFORO overloading MYSQL server</title>
                        <link>https://wpforo.com/community/general-discussions/wpforo-overloading-mysql-server/#post-45519</link>
                        <pubDate>Mon, 31 Aug 2020 12:42:55 +0000</pubDate>
                        <description><![CDATA[@alvina
well your proprietary tables scanner shows nothing but clearly I proved that there are duplicate indexes in the table structures. So I still need to know from a developer here if th...]]></description>
                        <content:encoded><![CDATA[<p>@alvina</p>
<p>well your proprietary tables scanner shows nothing but clearly I proved that there are duplicate indexes in the table structures. So I still need to know from a developer here if those duplicates need to be dropped.</p>
<p> </p>
<p>as for the error logs. There were several PHP errors and some Database errors. I cant make heads or tails of them but I will paste them below for someone who knows what to look for.....</p>
<p> </p>
<blockquote>
<p> PHP Warning: strlen() expects parameter 1 to be string, object given in /home/sminix84/.com/wp-includes/formatting.php on line 3391<br /><br /> PHP Warning: A non-numeric value encountered in /home/sminix84//wp-content/plugins/video-embed-thumbnail-generator/video-embed-thumbnail-generator.php on line 1200<br /><br /> WordPress database error Duplicate key name 'meta_key' for query ALTER TABLE wp_bp_xprofile_meta ADD KEY `meta_key` (`meta_key`(191)) made by do_action('admin_init'), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, bp_admin_init, do_action('bp_admin_init'), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, bp_setup_updater, bp_version_updater, bp_core_install, bp_core_install_extended_profiles, dbDelta<br /><br /> WordPress database error Can't DROP INDEX `meta_key`; check that it exists for query ALTER TABLE wp_bp_xprofile_meta DROP INDEX meta_key made by do_action('admin_init'), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, bp_admin_init, do_action('bp_admin_init'), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, bp_setup_updater, bp_version_updater, bp_core_install, bp_pre_schema_upgrade<br /><br /> WordPress database error Can't DROP INDEX `meta_key`; check that it exists for query ALTER TABLE wp_bp_notifications_meta DROP INDEX meta_key made by do_action('admin_init'), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, bp_admin_init, do_action('bp_admin_init'), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, bp_setup_updater, bp_version_updater, bp_core_install, bp_pre_schema_upgrade<br /><br /> WordPress database error Can't DROP INDEX `meta_key`; check that it exists for query ALTER TABLE wp_bp_activity_meta DROP INDEX meta_key made by do_action('admin_init'), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, bp_admin_init, do_action('bp_admin_init'), WP_Hook-&gt;do_action, WP_Hook-&gt;apply_filters, bp_setup_updater, bp_version_updater, bp_core_install, bp_pre_schema_upgrade<br /><br /> PHP Warning: Use of undefined constant ‘__return_false’ - assumed '‘__return_false’' (this will throw an Error in a future version of PHP) in /home/sminix84//wp-includes/functions.php on line 7388<br /><br /> PHP Warning: Use of undefined constant ‘big_image_size_threshold’ - assumed '‘big_image_size_threshold’' (this will throw an Error in a future version of PHP) in /home/sminix84//wp-includes/functions.php on line 7388<br /><br /> PHP Warning: Declaration of Theme_Quiet_Skin::feedback($string) should be compatible with WP_Upgrader_Skin::feedback($string, ...$args) in /home/sminix84//wp-content/plugins/wp-script-core/admin/class/class-installer.php on line 165<br /><br /> PHP Warning: Declaration of Plugin_Quiet_Skin::feedback($string) should be compatible with WP_Upgrader_Skin::feedback($string, ...$args) in /home/sminix84//wp-content/plugins/wp-script-core/admin/class/class-installer.php on line 159</p>
</blockquote>]]></content:encoded>
						                            <category domain="https://wpforo.com/community/general-discussions/">General Discussions</category>                        <dc:creator>stevenminix</dc:creator>
                        <guid isPermaLink="true">https://wpforo.com/community/general-discussions/wpforo-overloading-mysql-server/#post-45519</guid>
                    </item>
				                    <item>
                        <title>RE: WPFORO overloading MYSQL server</title>
                        <link>https://wpforo.com/community/general-discussions/wpforo-overloading-mysql-server/#post-45518</link>
                        <pubDate>Mon, 31 Aug 2020 12:28:33 +0000</pubDate>
                        <description><![CDATA[@stevenminix,
Please navigate to Dashboard &gt; Forums &gt; Tools &gt; Debug &gt; Tables tab and check database tables. If you see any error, please click the  butt...]]></description>
                        <content:encoded><![CDATA[<p>@stevenminix,</p>
<p><span>Please navigate to </span><span>Dashboard &gt; Forums &gt; Tools &gt; Debug &gt; Tables</span><span> tab and check database tables. If you see any error, please click the </span><span></span><span> button. Then navigate to the Dashboard &gt; Forums &gt; Tools admin page and check the Errors &amp; Issues Tab.</span></p>
<p>Also, please read this FAQ topic: https://wpforo.com/community/faq/forum-is-slow/</p>]]></content:encoded>
						                            <category domain="https://wpforo.com/community/general-discussions/">General Discussions</category>                        <dc:creator>Alvina</dc:creator>
                        <guid isPermaLink="true">https://wpforo.com/community/general-discussions/wpforo-overloading-mysql-server/#post-45518</guid>
                    </item>
				                    <item>
                        <title>RE: WPFORO overloading MYSQL server</title>
                        <link>https://wpforo.com/community/general-discussions/wpforo-overloading-mysql-server/#post-45496</link>
                        <pubDate>Mon, 31 Aug 2020 05:01:47 +0000</pubDate>
                        <description><![CDATA[I have a very powerful dedicated server so I doubt it is my host.
 
I am using w3 total cache with all of the exclusions required to prevent caching on wpforo
 
I ran a database check of...]]></description>
                        <content:encoded><![CDATA[<p>I have a very powerful dedicated server so I doubt it is my host.</p>
<p> </p>
<p>I am using w3 total cache with all of the exclusions required to prevent caching on wpforo</p>
<p> </p>
<p>I ran a database check of my tables and DID get some issues showing up....</p>
<p> </p>
<p><strong>"</strong></p>
<div class="notice"><strong><img class="icon ic_s_notice" title="" src="https://pornranx.com:2083/cpsess8836526303/3rdparty/phpMyAdmin/themes/dot.gif" alt="" /> The indexes parentid and parentid_2 seem to be equal and one of them could possibly be removed.</strong></div>
<div class="notice"><strong><img class="icon ic_s_notice" title="" src="https://pornranx.com:2083/cpsess8836526303/3rdparty/phpMyAdmin/themes/dot.gif" alt="" /> The indexes status and status_2 seem to be equal and one of them could possibly be removed.</strong></div>
<div class="notice"><strong><img class="icon ic_s_notice" title="" src="https://pornranx.com:2083/cpsess8836526303/3rdparty/phpMyAdmin/themes/dot.gif" alt="" /> The indexes order and order_2 seem to be equal and one of them could possibly be removed.</strong></div>
<div class="notice"><strong><img class="icon ic_s_notice" title="" src="https://pornranx.com:2083/cpsess8836526303/3rdparty/phpMyAdmin/themes/dot.gif" alt="" /> The indexes is_cat and is_cat_2 seem to be equal and one of them could possibly be removed.</strong></div>
<p><strong>Problems with indexes of table `wp_wpforo_posts`</strong></p>
<div class="notice"><strong><img class="icon ic_s_notice" title="" src="https://pornranx.com:2083/cpsess8836526303/3rdparty/phpMyAdmin/themes/dot.gif" alt="" /> The indexes email and email_2 seem to be equal and one of them could possibly be removed.</strong></div>
<div class="notice"><strong><img class="icon ic_s_notice" title="" src="https://pornranx.com:2083/cpsess8836526303/3rdparty/phpMyAdmin/themes/dot.gif" alt="" /> The indexes status and status_2 seem to be equal and one of them could possibly be removed.</strong></div>
<div class="notice"><strong><img class="icon ic_s_notice" title="" src="https://pornranx.com:2083/cpsess8836526303/3rdparty/phpMyAdmin/themes/dot.gif" alt="" /> The indexes is_first_post and is_first_post_2 seem to be equal and one of them could possibly be removed.</strong></div>
<div class="notice"><strong><img class="icon ic_s_notice" title="" src="https://pornranx.com:2083/cpsess8836526303/3rdparty/phpMyAdmin/themes/dot.gif" alt="" /> The indexes is_answer and is_answer_2 seem to be equal and one of them could possibly be removed.</strong></div>
<div class="notice"><strong><img class="icon ic_s_notice" title="" src="https://pornranx.com:2083/cpsess8836526303/3rdparty/phpMyAdmin/themes/dot.gif" alt="" /> The indexes created and created_2 seem to be equal and one of them could possibly be removed.</strong></div>
<div class="notice"><strong><img class="icon ic_s_notice" title="" src="https://pornranx.com:2083/cpsess8836526303/3rdparty/phpMyAdmin/themes/dot.gif" alt="" /> The indexes userid and userid_2 seem to be equal and one of them could possibly be removed.</strong></div>
<div class="notice"><strong><img class="icon ic_s_notice" title="" src="https://pornranx.com:2083/cpsess8836526303/3rdparty/phpMyAdmin/themes/dot.gif" alt="" /> The indexes forumid and forumid_2 seem to be equal and one of them could possibly be removed.</strong></div>
<div class="notice"><strong><img class="icon ic_s_notice" title="" src="https://pornranx.com:2083/cpsess8836526303/3rdparty/phpMyAdmin/themes/dot.gif" alt="" /> The indexes topicid and topicid_2 seem to be equal and one of them could possibly be removed.</strong></div>
<p><strong>Problems with indexes of table `wp_wpforo_topics`</strong></p>
<div class="notice"><strong><img class="icon ic_s_notice" title="" src="https://pornranx.com:2083/cpsess8836526303/3rdparty/phpMyAdmin/themes/dot.gif" alt="" /> The indexes type and type_2 seem to be equal and one of them could possibly be removed.</strong></div>
<div class="notice"><strong><img class="icon ic_s_notice" title="" src="https://pornranx.com:2083/cpsess8836526303/3rdparty/phpMyAdmin/themes/dot.gif" alt="" /> The indexes modified and modified_2 seem to be equal and one of them could possibly be removed.</strong></div>
<div class="notice"><strong><img class="icon ic_s_notice" title="" src="https://pornranx.com:2083/cpsess8836526303/3rdparty/phpMyAdmin/themes/dot.gif" alt="" /> The indexes created and created_2 seem to be equal and one of them could possibly be removed.</strong></div>
<div class="notice"><strong><img class="icon ic_s_notice" title="" src="https://pornranx.com:2083/cpsess8836526303/3rdparty/phpMyAdmin/themes/dot.gif" alt="" /> The indexes first_postid and first_postid_2 seem to be equal and one of them could possibly be removed.</strong></div>
<div class="notice"><strong><img class="icon ic_s_notice" title="" src="https://pornranx.com:2083/cpsess8836526303/3rdparty/phpMyAdmin/themes/dot.gif" alt="" /> The indexes forumid and forumid_2 seem to be equal and one of them could possibly be removed."</strong></div>
<div> </div>
<div> </div>
<div>looks like some duplicate indexes? How do I fix this? Could this cause my slowdown and load issues?</div>
<div> </div>
<div>I HAVE ATTACHED A SCREENSHOT OF THE WPFORO_FORUMS TABLE STRUCTURE SO YOU CAN SEE THE DUPLICATE INDEXES. <strong>SHOULD i DROP THE DUPLICATES?</strong></div>
<div id="wpfa-0" class="wpforo-attached-file"><a class="wpforo-default-attachment" href="//wpforo.com/wp-content/uploads/wpforo/default_attachments/1598850482-bandicam-2020-08-30-23-06-34-429.jpg" target="_blank"><i class="fas fa-paperclip"></i>&nbsp;bandicam-2020-08-30-23-06-34-429.jpg</a></div>]]></content:encoded>
						                            <category domain="https://wpforo.com/community/general-discussions/">General Discussions</category>                        <dc:creator>stevenminix</dc:creator>
                        <guid isPermaLink="true">https://wpforo.com/community/general-discussions/wpforo-overloading-mysql-server/#post-45496</guid>
                    </item>
				                    <item>
                        <title>RE: WPFORO overloading MYSQL server</title>
                        <link>https://wpforo.com/community/general-discussions/wpforo-overloading-mysql-server/#post-45482</link>
                        <pubDate>Sun, 30 Aug 2020 18:38:27 +0000</pubDate>
                        <description><![CDATA[wpForo doesn&#039;t overload anything.
This could be related to your hosting, errors in your DB (check it within wpForo admin options and tools) or you use a caching with wpForo. Caching doesn&#039;t...]]></description>
                        <content:encoded><![CDATA[<p>wpForo doesn't overload anything.</p>
<p>This could be related to your hosting, errors in your DB (check it within wpForo admin options and tools) or you use a caching with wpForo. Caching doesn't work with wpForo and some caching plugins create problems with wpForo sessions (users get mixed login/logout statuses).</p>
<p> </p>]]></content:encoded>
						                            <category domain="https://wpforo.com/community/general-discussions/">General Discussions</category>                        <dc:creator>dimalifragis</dc:creator>
                        <guid isPermaLink="true">https://wpforo.com/community/general-discussions/wpforo-overloading-mysql-server/#post-45482</guid>
                    </item>
				                    <item>
                        <title>WPFORO overloading MYSQL server</title>
                        <link>https://wpforo.com/community/general-discussions/wpforo-overloading-mysql-server/#post-45478</link>
                        <pubDate>Sun, 30 Aug 2020 15:35:02 +0000</pubDate>
                        <description><![CDATA[WPFORO is overloading MYSQL. I have followed your tutorial on database tables to no effect.
 
 
&nbsp;bandicam-2020-08-30-09-20-08-959.jpg]]></description>
                        <content:encoded><![CDATA[<p>WPFORO is overloading MYSQL. I have followed your tutorial on database tables to no effect.</p>
<p> </p>
<p> </p>
<div id="wpfa-0" class="wpforo-attached-file"><a class="wpforo-default-attachment" href="//wpforo.com/wp-content/uploads/wpforo/default_attachments/1598801702-bandicam-2020-08-30-09-20-08-959.jpg" target="_blank"><i class="fas fa-paperclip"></i>&nbsp;bandicam-2020-08-30-09-20-08-959.jpg</a></div>]]></content:encoded>
						                            <category domain="https://wpforo.com/community/general-discussions/">General Discussions</category>                        <dc:creator>stevenminix</dc:creator>
                        <guid isPermaLink="true">https://wpforo.com/community/general-discussions/wpforo-overloading-mysql-server/#post-45478</guid>
                    </item>
							        </channel>
        </rss>
		