Critical Error

Here is the error message I received in my email:

Error Details

=============

An error of type E_ERROR was caused in line 291 of the file /????/????????/????????.org.au/wp-content/plugins/solid-performance/vendor/vendor-prefixed/stellarwp/db/src/DB/DB.php. Error message: Uncaught SolidWP\Performance\StellarWP\DB\Database\Exceptions\DatabaseQueryException: Database Query in /????/????????/????????.org.au/wp-content/plugins/solid-performance/vendor/vendor-prefixed/stellarwp/db/src/DB/DB.php:291

Stack trace:

#0 /????/????????/????????.org.au/wp-content/plugins/solid-performance/vendor/vendor-prefixed/stellarwp/db/src/DB/DB.php(76): SolidWP\Performance\StellarWP\DB\DB::runQueryWithErrorChecking()

#1 /????/????????/????????.org.au/wp-content/plugins/solid-performance/vendor/vendor-prefixed/stellarwp/schema/src/Schema/Tables/Contracts/Table.php(521): SolidWP\Performance\StellarWP\DB\DB::delta()

#2 /????/????????/????????.org.au/wp-content/plugins/solid-performance/vendor/vendor-prefixed/stellarwp/schema/src/Schema/Builder.php(270): SolidWP\Performance\StellarWP\Schema\Tables\Contracts\Table->update()

#3 /????/????????/????????.org.au/wp-content/plugins/solid-performance/vendor/vendor-prefixed/stellarwp/schema/src/Schema/Register.php(133): SolidWP\Performance\StellarWP\Schema\Builder->up()

#4 /????/????????/????????.org.au/wp-content/plugins/solid-performance/vendor/vendor-prefixed/stellarwp/schema/src/Schema/Register.php(150): SolidWP\Performance\StellarWP\Schema\Register::table()

#5 /????/????????/????????.org.au/wp-content/plugins/solid-performance/src/Performance/Database/Provider.php(53): SolidWP\Performance\StellarWP\Schema\Register::tables()

#6 /????/????????/????????.org.au/wp-content/plugins/solid-performance/src/Performance/Database/Provider.php(32): SolidWP\Performance\Database\Provider->register_schema()

#7 /????/????????/????????.org.au/wp-content/plugins/solid-performance/src/Performance/Core.php(173): SolidWP\Performance\Database\Provider->register()

#8 /????/????????/????????.org.au/wp-content/plugins/solid-performance/solid-performance.php(40): SolidWP\Performance\Core->init()

#9 /????/????????/????????.org.au/wp-includes/class-wp-hook.php(324): {closure}()

#10 /????/????????/????????.org.au/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters()

#11 /????/????????/????????.org.au/wp-includes/plugin.php(517): WP_Hook->do_action()

#12 /????/????????/????????.org.au/wp-settings.php(559): do_action()

#13 /????/????????/????????.org.au/wp-config.php(99): require_once('/home/ccgat206/...')

#14 /????/????????/????????.org.au/wp-load.php(50): require_once('/home/ccgat206/...')

#15 /????/????????/????????.org.au/wp-admin/admin.php(34): require_once('/home/ccgat206/...')

#16 /????/????????/????????.org.au/wp-admin/plugins.php(10): require_once('/home/ccgat206/...')

#17 {main}

?thrown

Hi @levonk,

I’m sorry you’re experiencing this issue, but thank you so much for reporting it and posting the errors.

It seems we’re not able to install or update our custom database tables, I think I may know why, would you be able to give this beta version a try? https://prophecy.solidwp.com/wp-content/uploads/2025/02/solid-performance.1.4.2-beta.1.zip

If it still causes a critical error, could you please:

1. Try it again but first enable WP_DEBUG and/or check your cPanel PHP error logs for more error detailed logs.
2. Log into your wp-admin and head over to Tools > Site Health and click the “Info” tab and let me know your WordPress Version, PHP version, your Database Extension and Database server version, please?
3. Verify your MySQL/MariaDB user has permissions to create database tables.

Please let me know and thank you.

• This reply was modified 2 weeks ago by Justin Frydman. Reason: added WordPress version

Hi @levonk ,

We identified another potential cause, please give this version a go and let me know: https://prophecy.solidwp.com/wp-content/uploads/2025/02/solid-performance.1.4.2-beta.2.zip

Thanks

Hi @defunctlife,

I did what you asked. I had the same problem.

1. Is there a way I can send you the Debug info instead of pasting it here?
2. WordPress version: 6.7.2, PHP version: 8.2.27, Database Extension: mysqli and Database server version: 8.0.41
3. Yes the user has permission to do everything according to cPanel

Hi @levonk,

I’m reaching out to our support team for the best way to this.

In the meantime, can you try this one, please? https://prophecy.solidwp.com/wp-content/uploads/2025/02/solid-performance.1.4.2-beta.4.zip

Make sure you have WP_DEBUG enabled, and you should see a solid_performance.EMERGENCY log when this fails, I just need the query_errors and query portion of it, something like this:

solid_performance.EMERGENCY: Unable to create or update database tables {"query_errors":{"db_delta_error":["Multiple primary key defined"]},"query":"ALTER TABLE wp_swp_timers ADD PRIMARY KEY (name)"

Thanks for your patience here.

Hi @defunctlife,

There was no solid_performance.EMERGENCY log. The WP_DEBUG log is below

Fatal error: Uncaught SolidWP\Performance\StellarWP\DB\Database\Exceptions\DatabaseQueryException: Database Query in /????/????????/?????????.org.au/wp-content/plugins/solid-performance/vendor/vendor-prefixed/stellarwp/db/src/DB/DB.php:291 Stack trace: #0 /????/????????/?????????.org.au/wp-content/plugins/solid-performance/vendor/vendor-prefixed/stellarwp/db/src/DB/DB.php(76): SolidWP\Performance\StellarWP\DB\DB::runQueryWithErrorChecking() #1 /????/????????/?????????.org.au/wp-content/plugins/solid-performance/vendor/vendor-prefixed/stellarwp/schema/src/Schema/Tables/Contracts/Table.php(521): SolidWP\Performance\StellarWP\DB\DB::delta() #2 /????/????????/?????????.org.au/wp-content/plugins/solid-performance/src/Performance/Lock/Tables/Cache_Lock.php(56): SolidWP\Performance\StellarWP\Schema\Tables\Contracts\Table->update() #3 /????/????????/?????????.org.au/wp-content/plugins/solid-performance/vendor/vendor-prefixed/stellarwp/schema/src/Schema/Builder.php(270): SolidWP\Performance\Lock\Tables\Cache_Lock->update() #4 /????/????????/?????????.org.au/wp-content/plugins/solid-performance/vendor/vendor-prefixed/stellarwp/schema/src/Schema/Register.php(133): SolidWP\Performance\StellarWP\Schema\Builder->up() #5 /????/????????/?????????.org.au/wp-content/plugins/solid-performance/vendor/vendor-prefixed/stellarwp/schema/src/Schema/Register.php(150): SolidWP\Performance\StellarWP\Schema\Register::table() #6 /????/????????/?????????.org.au/wp-content/plugins/solid-performance/src/Performance/Database/Provider.php(58): SolidWP\Performance\StellarWP\Schema\Register::tables() #7 /????/????????/?????????.org.au/wp-content/plugins/solid-performance/src/Performance/Database/Provider.php(34): SolidWP\Performance\Database\Provider->register_schema() #8 /????/????????/?????????.org.au/wp-content/plugins/solid-performance/src/Performance/Core.php(173): SolidWP\Performance\Database\Provider->register() #9 /????/????????/?????????.org.au/wp-content/plugins/solid-performance/solid-performance.php(40): SolidWP\Performance\Core->init() #10 /????/????????/?????????.org.au/wp-includes/class-wp-hook.php(324): {closure}() #11 /????/????????/?????????.org.au/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters() #12 /????/????????/?????????.org.au/wp-includes/plugin.php(517): WP_Hook->do_action() #13 /????/????????/?????????.org.au/wp-settings.php(559): do_action() #14 /????/????????/?????????.org.au/wp-config.php(99): require_once('/????/????????/…') #15 /????/????????/?????????.org.au/wp-load.php(50): require_once('/????/????????/…') #16 /????/????????/?????????.org.au/wp-admin/admin.php(34): require_once('/????/????????/…') #17 /????/????????/?????????.org.au/wp-admin/plugin-install.php(16): require_once('/????/????????/…') #18 {main} thrown in?/????/????????/?????????.org.au/wp-content/plugins/solid-performance/vendor/vendor-prefixed/stellarwp/db/src/DB/DB.php?on line?291

Hi @levonk,

If WP_DEBUG is defined as true, could you check other error_logs in your server or in cpanel for the solid_performance log entries?

If you’re using the beta.4 version above, it should log that error somewhere depending on your environment and configuration.

Thanks

I should clarify, the solid_performance.EMERGENCY would be a log entry in either your debug.log, or PHP error_log or both.

If it’s in the debug.log, it would be before the items you just pasted.

I was looking in the wrong folder. here is the last of those errors. There are 22 errors all the same.

[25-Feb-2025 04:13:03 UTC] [25/Feb/2025:04:13:03 +0000] solid_performance.EMERGENCY: Unable to create or update database tables {"query_errors":{"db_delta_error":["Specified key was too long; max key length is 1000 bytes"]},"query":"\n\t\t\tCREATE TABLE wptheo_swp_cache_lock (\n\t\t lock_name varchar(255) NOT NULL,\n\t\t lock_owner varchar(255) NOT NULL,\n\t\t expiration bigint NOT NULL,\n\t\t PRIMARY KEY (lock_name)\n\t\t) DEFAULT CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci","exception":"[object] (SolidWP\Performance\StellarWP\DB\Database\Exceptions\DatabaseQueryException(code: 0): Database Query at /????/????????/?????????.org.au/wp-content/plugins/solid-performance/vendor/vendor-prefixed/stellarwp/db/src/DB/DB.php:291)"} []

Thank you @levonk !

This one should fix it for you: https://prophecy.solidwp.com/wp-content/uploads/2025/02/solid-performance.1.4.2-beta.5.zip

Please let me know.

thank you @defunctlife,

It worked this time, and there does not seem to be any other errors coming up.

Could you tell me what the issue was?

Thank you.

That’s great to hear!

Your database server isn’t configured for large index keys, so we just shrunk them on our end, which is what they should be anyways for wider support.

However, the plugin was tested on many different systems/environments and we never ran into a server configured the same.

Thanks for helping us squash that bug, look out for the Solid Performance 1.4.2 release over the next few days.

@levonk 1.4.2 is now live with this fix.

Thanks again.

thanks