[Modules/Console.php:51] Table ‘wp_glsr_ratings’ doesn’t exist

Resolved jasontdm
(@jasontdm)

2 years, 3 months ago

I have hundreds of reviews that were working fine prior to upgrade, after upgrade I don’t see any of them on the page when using the proper shortcode.

Here are the excat messages I am seeing in the console:

[2020-12-10 18:52:13] ERROR [Modules/Console.php:51] Table ‘mastermoversfl.wp_glsr_ratings’ doesn’t exist
[2020-12-10 18:52:13] WARNING [Modules/Console.php:51] InnoDB: The wp_glsr_ratings database table does not exist.
[2020-12-10 18:52:13] ERROR [Modules/Console.php:51] Table ‘mastermoversfl.wp_glsr_assigned_posts’ doesn’t exist
[2020-12-10 18:52:13] WARNING [Modules/Console.php:51] InnoDB: The wp_glsr_ratings database table does not exist.
[2020-12-10 18:52:13] ERROR [Modules/Console.php:51] Table ‘mastermoversfl.wp_glsr_assigned_terms’ doesn’t exist
[2020-12-10 18:52:13] WARNING [Modules/Console.php:51] InnoDB: The wp_glsr_ratings database table does not exist.
[2020-12-10 18:52:13] ERROR [Modules/Console.php:51] Table ‘mastermoversfl.wp_glsr_assigned_users’ doesn’t exist
[2020-12-10 18:52:13] ERROR [Modules/Console.php:51] Table ‘mastermoversfl.wp_glsr_ratings’ doesn’t exist
[2020-12-10 18:52:13] ERROR [Modules/Console.php:51] Table ‘mastermoversfl.wp_glsr_assigned_posts’ doesn’t exist
[2020-12-10 18:52:13] ERROR [Modules/Console.php:51] Table ‘mastermoversfl.wp_glsr_assigned_terms’ doesn’t exist
[2020-12-10 18:52:13] ERROR [Modules/Console.php:51] Table ‘mastermoversfl.wp_glsr_assigned_users’ doesn’t exist
[2020-12-10 18:52:13] WARNING [Modules/Console.php:51] InnoDB: The wp_glsr_ratings database table does not exist.
[2020-12-10 18:52:13] ERROR [Modules/Console.php:51] Table ‘mastermoversfl.wp_glsr_ratings’ doesn’t exist
[2020-12-10 18:52:13] WARNING [Modules/Console.php:51] InnoDB: The wp_glsr_ratings database table does not exist.
[2020-12-10 18:52:13] WARNING [Modules/Console.php:51] InnoDB: The wp_glsr_assigned_posts database table does not exist.
[2020-12-10 18:52:13] ERROR [Modules/Console.php:51] Table ‘mastermoversfl.wp_glsr_ratings’ doesn’t exist
[2020-12-10 18:52:13] WARNING [Modules/Console.php:51] InnoDB: The wp_glsr_assigned_posts database table does not exist.
[2020-12-10 18:52:13] WARNING [Modules/Console.php:51] InnoDB: The wp_glsr_assigned_terms database table does not exist.
[2020-12-10 18:52:13] ERROR [Modules/Console.php:51] Table ‘mastermoversfl.wp_glsr_ratings’ doesn’t exist
[2020-12-10 18:52:13] WARNING [Modules/Console.php:51] InnoDB: The wp_glsr_assigned_terms database table does not exist.
[2020-12-10 18:52:14] ERROR [Modules/Console.php:51] Table ‘mastermoversfl.wp_glsr_ratings’ doesn’t exist
[2020-12-10 18:52:14] ERROR [Modules/Console.php:51] Table ‘mastermoversfl.wp_glsr_ratings’ doesn’t exist
[2020-12-10 18:59:55] ERROR [Modules/Console.php:51] Table ‘mastermoversfl.wp_glsr_ratings’ doesn’t exist

When I look in phpMyadmin, the database tables it’s referencing don’t appear to exist and they are not being created. Based off the troubleshooting documentation, I wasn’t able to correct the problem.

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

Viewing 6 replies - 1 through 6 (of 6 total)

Plugin Author Gemini Labs
(@geminilabs)

2 years, 3 months ago

@jasontdm Have you read this? https://wordpress.org/support/topic/%F0%9F%9A%A8-read-this-if-your-reviews-are-broken-after-updating-to-v5-2/

Thread Starter jasontdm
(@jasontdm)

2 years, 3 months ago

Yes, and steps have been followed there as well.

Plugin Author Gemini Labs
(@geminilabs)

2 years, 3 months ago

You held down the ALT key before running the Migrate Plugin tool? The button should change from “run migrations” to “run all migrations”.

If you did that and it still didn’t work, please use the Contact Support section on the Hep page and send me your console log and the Site Reviews system info files.

Thread Starter jasontdm
(@jasontdm)

2 years, 3 months ago
Thread Starter jasontdm
(@jasontdm)

2 years, 3 months ago
Amazing support. Helped me immediately, troubleshot until the issue was located, and provided me the eventual fix. What an above and beyond type of person!
- This reply was modified 2 years, 3 months ago by jasontdm.
Plugin Author Gemini Labs
(@geminilabs)

2 years, 3 months ago

Thanks @jasontdm

In this instance the problem was caused by the wp-config.php file which had incorrect values in the DB_CHARSET and DB_COLLATE constants which were preventing WordPress from creating the custom Site Reviews database tables.

To fix the problem, the solution was to either remove those constants from the wp-config.php file, or make sure sure the defined values were correct.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘[Modules/Console.php:51] Table ‘wp_glsr_ratings’ doesn’t exist’ is closed to new replies.

Views