THWright

Thank you for getting back to me.

From the admin backend, I deactivated the plugin, deleted it, then cleared the website’s cache (w3 total cache and Cloudflare), and then reinstalled it, but there has been no change.

Again, I tried changing the theme to some of the default WordPress themes and disabling every other plugin (as well as clearing the caches after this) but have found no change in behavior.

I’ve checked a few different browsers and a few devices, but all show the same issue.

I’ve created a new ticket, as I cannot find the original, but I have yet to receive a reply from the support email account for the new ticket.

I’m not seeing anything in my mail logs either.

I created a ticket but never heard back. The problem persists.

I have attempted both through the web UI and the CLI. In the site’s root dir, I have tried running the following with the below results.

$ wp redirection export all nginx.conf --format=nginx

Success: Exported 18 to nginx

$ cat nginx.conf

# Created by Redirection
# Mon, 06 Apr 2020 18:10:33 +0000
# Redirection 4.7.1 – https://redirection.me

server {
}

# End of Redirection

In the web UI, I have tried running the exporter (options: everything, nginx rewrites) and I receive the following output, both visiting the link directly and in the output window.

Nginx Access Log URI:
/wp-json/redirection/v1/export/all/nginx/?_wpnonce=47a7563dcd

data “# Created by Redirection\n# Mon, 06 Apr 2020 18:13:14 +0000\n# Redirection 4.7.1 – https://redirection.me\n\nserver {\n}\n\n# End of Redirection\n”
total 18

/wp-json/redirection/v1/export/all/apache/?_wpnonce=47a7563dcd

# Created by Redirection
# Mon, 06 Apr 2020 18:16:17 +0000
# Redirection 4.7.1 – https://redirection.me

<IfModule mod_rewrite.c>
RewriteCond %{HTTP_HOST} ^https\://domain\.com$ [NC]
…

(It would take a bit to sanitize the above. I have shortened it instead)

I am doing some research regarding moving some websites from Apache to Nginx and your plugin was on the list of those that needed to be compatible. I had read the documentation you provided and performed a subsequent search through the support but didn’t find any references. I wanted to verify with you just to make sure.

Thank you for the response!

Hello Jake,

I am not certain if my setup is common, but I haven’t done much customization besides the plugins installed. The theme is evolve.

My multisite is using a subdomain setup. I only have one instance of bbPress running, which is on forums.domain.com.

I am using CentOS 7, PHP 7 (believe handler is FCGI but uncertain) with Zend OpCache, Apache 2.4 w/ Event MPM, and MariaDB 10.x. I am more of a server admin than a developer, so my coding experience is limited and very copy/pasta friendly.

I have the following plugins installed; I have not seen any other conflicts as of yet.

+——————————————+———-+
| name | version |
+——————————————+———-+
| admin-bar-dashboard-control | 1.0.1 |
| advanced-nocaptcha-recaptcha | 2.3 |
| akismet | 3.1.11 |
| bbp-private-groups | 3.2.4 |
| bbpress | 2.5.10 |
| bbpress-admin-bar-addition | 1.7.1 |
| bbpress-improved-statistics-users-online | 1.4.02 |
| bbpress-do-short-codes | 1.0.3 |
| bbpress-protected-forums | 1.0 |
| bbpress-unread-posts-v2 | 1.0.8 |
| buddypress | 2.6.2 |
| easy-wp-smtp | 1.2.3 |
| gd-bbpress-attachments | 2.3.1 |
| gd-bbpress-tools | 1.8 |
| login-with-ajax | 3.1.6 |
| redux-framework | 3.6.1 |
| shortcodes-ultimate | 4.9.9 |
| tinymce-advanced | 4.3.10.1 |
| kt-tinymce-color-grid | 1.6 |
| wp-better-emails | 0.3 |
+——————————————+———-+

-Taylor

Hello Jake!

The error I am seeing is as follows. Once I activate the plugin, the backend and website return the following error.

There was a problem whilst updating the database. (Table ‘database.wp_8_usermeta’ doesn’t exist)

A WP multisite shares a users database, so that any user created on one of the sites is available on the others, thus in my database, I have a wp_usermeta whereas the error is referencing the site specific prefix (the _8).

This is the current issue I see which presents any use of the site while activated. I was going to take a look at the code but haven’t had a chance and won’t for some time. I’m unsure if other tables are being referenced besides this one.

I’m not seeing anything in a PHP error log. Apache error log shows following.

Frontend

[Thu Aug 18 08:37:17.947793 2016] [:error] [pid 24782:tid 140346403006208] [client ip.ad.dr.ess:39258] WordPress database error Duplicate key name ‘date_recorded’ for query ALTER TABLE wp_8_bbpas ADD INDEX date_recorded (date_recorded) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/bbpress-improved-statistics-users-online/bbpress-improved-statistics-users-online.php’), bbPress_Advanced_Statistics, bbPress_Advanced_Statistics::instance, bbPress_Advanced_Statistics->__construct, bbPress_Advanced_Statistics->install, bbPress_Advanced_Statistics->create_table, bbPress_Advanced_Statistics_Upgrade->__construct, bbPress_Advanced_Statistics_Upgrade->check_for_db_upgrade, bbPress_Advanced_Statistics_Upgrade->upgrade_the_db, dbDelta
[Thu Aug 18 08:37:17.948128 2016] [:error] [pid 24782:tid 140346403006208] [client ip.ad.dr.ess:39258] WordPress database error Duplicate key name ‘status’ for query ALTER TABLE wp_8_bbpas ADD INDEX status (status) made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/bbpress-improved-statistics-users-online/bbpress-improved-statistics-users-online.php’), bbPress_Advanced_Statistics, bbPress_Advanced_Statistics::instance, bbPress_Advanced_Statistics->__construct, bbPress_Advanced_Statistics->install, bbPress_Advanced_Statistics->create_table, bbPress_Advanced_Statistics_Upgrade->__construct, bbPress_Advanced_Statistics_Upgrade->check_for_db_upgrade, bbPress_Advanced_Statistics_Upgrade->upgrade_the_db, dbDelta
[Thu Aug 18 08:37:17.948432 2016] [:error] [pid 24782:tid 140346403006208] [client ip.ad.dr.ess:39258] WordPress database error Table ‘database.wp_8_usermeta’ doesn’t exist for query DELETE FROM wp_8_usermeta WHERE meta_key LIKE ‘%bbpress-advanced-statistics%’ made by require(‘wp-blog-header.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/bbpress-improved-statistics-users-online/bbpress-improved-statistics-users-online.php’), bbPress_Advanced_Statistics, bbPress_Advanced_Statistics::instance, bbPress_Advanced_Statistics->__construct, bbPress_Advanced_Statistics->install, bbPress_Advanced_Statistics->create_table, bbPress_Advanced_Statistics_Upgrade->__construct, bbPress_Advanced_Statistics_Upgrade->check_for_db_upgrade, bbPress_Advanced_Statistics_Upgrade->db_migration_1_1

From Backend

[Thu Aug 18 08:37:33.499534 2016] [:error] [pid 17612:tid 140346344257280] [client ip.ad.dr.ess:39950] WordPress database error Duplicate key name ‘date_recorded’ for query ALTER TABLE wp_8_bbpas ADD INDEX date_recorded (date_recorded) made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/bbpress-improved-statistics-users-online/bbpress-improved-statistics-users-online.php’), bbPress_Advanced_Statistics, bbPress_Advanced_Statistics::instance, bbPress_Advanced_Statistics->__construct, bbPress_Advanced_Statistics->install, bbPress_Advanced_Statistics->create_table, bbPress_Advanced_Statistics_Upgrade->__construct, bbPress_Advanced_Statistics_Upgrade->check_for_db_upgrade, bbPress_Advanced_Statistics_Upgrade->upgrade_the_db, dbDelta
[Thu Aug 18 08:37:33.499678 2016] [:error] [pid 17612:tid 140346344257280] [client ip.ad.dr.ess:39950] WordPress database error Duplicate key name ‘status’ for query ALTER TABLE wp_8_bbpas ADD INDEX status (status) made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/bbpress-improved-statistics-users-online/bbpress-improved-statistics-users-online.php’), bbPress_Advanced_Statistics, bbPress_Advanced_Statistics::instance, bbPress_Advanced_Statistics->__construct, bbPress_Advanced_Statistics->install, bbPress_Advanced_Statistics->create_table, bbPress_Advanced_Statistics_Upgrade->__construct, bbPress_Advanced_Statistics_Upgrade->check_for_db_upgrade, bbPress_Advanced_Statistics_Upgrade->upgrade_the_db, dbDelta
[Thu Aug 18 08:37:33.499789 2016] [:error] [pid 17612:tid 140346344257280] [client ip.ad.dr.ess:39950] WordPress database error Table ‘database.wp_8_usermeta’ doesn’t exist for query DELETE FROM wp_8_usermeta WHERE meta_key LIKE ‘%bbpress-advanced-statistics%’ made by require_once(‘wp-admin/admin.php’), require_once(‘wp-load.php’), require_once(‘wp-config.php’), require_once(‘wp-settings.php’), include_once(‘/plugins/bbpress-improved-statistics-users-online/bbpress-improved-statistics-users-online.php’), bbPress_Advanced_Statistics, bbPress_Advanced_Statistics::instance, bbPress_Advanced_Statistics->__construct, bbPress_Advanced_Statistics->install, bbPress_Advanced_Statistics->create_table, bbPress_Advanced_Statistics_Upgrade->__construct, bbPress_Advanced_Statistics_Upgrade->check_for_db_upgrade, bbPress_Advanced_Statistics_Upgrade->db_migration_1_1

Based on these, it almost seems like the last version of the plugin didn’t delete its database entries.

If you need software versions, feel free to let me know.

Let me know if I can provide anything else!

I have noticed this same thing. No matter how much I visit my forums or what I click on, they remain “unread”.

Adding the following to the class-bbcode.php creates the glow shortcode.

`add_shortcode(‘glow’,array(&$this,’shortcode_glow’));
add_shortcode(‘GLOW’,array(&$this,’shortcode_glow’));

function shortcode_glow($atts=array(),$content=NULL){
if(NULL===$content) return ”;
$attribs = implode(”,$atts);
$color=substr ($attribs, 1);
if(ctype_xdigit($color))
$color = ‘#’.$color;
return ‘<span style=”text-shadow: 0px 0px 7px ‘.$color.'”>’.$this->do_shortcode($content).'</span>’;
}`

I am seeing it appear in my backend Visual Editor but not in the bbPress visual editor.

WordPress 4.5.3
Latest bbPress