levonk

thanks

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.

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)"} []

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 @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

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

I have the code below.
[text* your-fname akismet:author placeholder default:user_first_name "First Name"]

If a user is logged in, it should have a default value of the first name, and if not logged in, the placeholder First Name. But when I log in it still shows First Name instead of the user_first_name. When I disable the bootstrap for CF7 it works.

It is not working for me.
[text* your-fname default:user_first_name placeholder "First Name"]

I also need to use akismet:author, so I tried other possible orders like
[text* your-fname akismet:author placeholder default:user_first_name "First Name"]

I tried
[text* your-fname default:user_first_name "First Name"]
And it used First Name as the value. Only after removing the value was I able to get the user_first_name to be used.

Hi Scott,

1. The validation would be true if paid false if not paid. I don’t know if that is the approach you have taken in the pro version. But if someone wants to allow other payment methods, like wire transfer, in addition to PayPal, then the validation should only record it in a hidden field that can be added to the email.
2. You can use the HTML5/CSS3 modal dialog or the Bootstrap JS Modal. call PayPal in an iFrame.
3. Whichever is easier to implement, as long as you can give the user an option to see the result of that field.

Hi Scott,

I don’t know how relation with the CF7 author is, but they seem to be friendly and take into consideration the requests. I am thinking of asking them to add more JS hooks especially a on_validate hook and possibly on_focus_out for the fields.

I still have a lot of work to do to figure out what I will need, but it seems for the PayPal integration add-on on_validate would be sufficient.

Another thought, how difficult would it be to validate the amount field through PayPal in a modal window and save the result (true, false) in a hidden field just in case other payment methods are also accepted?

Hi Scott,

I was checking the CF7 docs and one of the tips defines how you can redirect to another page using the on_sent_ok hook. I have not looked into all the hooks available but I presume there could be a on_submit or on_validation_ok hook which you could use, then capture the form data somehow and then redirect to PayPal before sending the email.

Thank you Scott. Unfortunately, this means I cannot use your plugin and I don’t know of any other plugin that will work.

When you find a solution I will happily get the pro plugin.

Same problem in the widget

https://bankstownuca.com.au
https://ccgathering.org

Thank you

The modified template needs to go into the main site’s theme folder. If two sites are using the same theme, then the template needs to be renamed for each site and included in the shortcode.