update problem v3.5.31

  • Resolved sventertain

    (@sventertain)


    1 month, 4 weeks ago

    hello,

    just wondering that my try to update from v3.5.31 to latest v3.6.1 throws a fatal error. it seems some database things went wrong. (see error code from wordpress email notice)

    your changelog says with v3.6.0 there is a new performance optimizer extension.
    what can i do? should i update to v3.6.0 first to get it work again?
    hope you can help. thanks in advance.

    best, sven

    —

    Fehler-Details

    Ein Fehler vom Typ E_ERROR wurde in der Zeile 296 der Datei /usr/www/users/xyz/stage.domain/wp-content/plugins/kadence-blocks/vendor/vendor-prefixed/stellarwp/db/src/DB/DB.php verursacht.

    Fehlermeldung:
    Uncaught KadenceWP\KadenceBlocks\StellarWP\DB\Database\Exceptions\DatabaseQueryException: Database Query in /usr/www/users/xyz/stage.domain/wp-content/plugins/kadence-blocks/vendor/vendor-prefixed/stellarwp/db/src/DB/DB.php:296

    Stack trace:
    0 /usr/www/users/xyz/stage.domain/wp-content/plugins/kadence-blocks/vendor/vendor-prefixed/stellarwp/db/src/DB/DB.php(81): KadenceWP\KadenceBlocks\StellarWP\DB\DB::runQueryWithErrorChecking()
    1 /usr/www/users/xyz/stage.domain/wp-content/plugins/kadence-blocks/vendor/vendor-prefixed/stellarwp/schema/src/Schema/Tables/Contracts/Table.php(539): KadenceWP\KadenceBlocks\StellarWP\DB\DB::delta()
    2 /usr/www/users/xyz/stage.domain/wp-content/plugins/kadence-blocks/includes/resources/Optimizer/Database/Viewport_Hash_Table.php(48): KadenceWP\KadenceBlocks\StellarWP\Schema\Tables\Contracts\Table->update()
    3 /usr/www/users/xyz/stage.domain/wp-content/plugins/kadence-blocks/vendor/vendor-prefixed/stellarwp/schema/src/Schema/Builder.php(299): KadenceWP\KadenceBlocks\Optimizer\Database\Viewport_Hash_Table->update()
    4 /usr/www/users/xyz/stage.domain/wp-content/plugins/kadence-blocks/vendor/vendor-prefixed/stellarwp/schema/src/Schema/Register.php(149): KadenceWP\KadenceBlocks\StellarWP\Schema\Builder->up()
    5 /usr/www/users/xyz/stage.domain/wp-content/plugins/kadence-blocks/vendor/vendor-prefixed/stellarwp/schema/src/Schema/Register.php(168): KadenceWP\KadenceBlocks\StellarWP\Schema\Register::table()
    6 /usr/www/users/xyz/stage.domain/wp-content/plugins/kadence-blocks/includes/resources/Database/Database_Provider.php(39): KadenceWP\KadenceBlocks\StellarWP\Schema\Register::tables()
    7 /usr/www/users/xyz/stage.domain/wp-content/plugins/kadence-blocks/vendor/vendor-prefixed/lucatume/di52/src/Container.php(462): KadenceWP\KadenceBlocks\Database\Database_Provider->register()
    8 /usr/www/users/xyz/stage.domain/wp-content/plugins/kadence-blocks/vendor/vendor-prefixed/stellarwp/prophecy-container/ContainerAdapter.php(80): KadenceWP\KadenceBlocks\lucatume\DI52\Container->register()
    9 /usr/www/users/xyz/stage.domain/wp-content/plugins/kadence-blocks/includes/resources/App.php(93): KadenceWP\KadenceBlocks\StellarWP\ProphecyMonorepo\Container\ContainerAdapter->register()
    10 /usr/www/users/xyz/stage.domain/wp-content/plugins/kadence-blocks/includes/resources/App.php(62): KadenceWP\KadenceBlocks\App->init()
    11 /usr/www/users/xyz/stage.domain/wp-content/plugins/kadence-blocks/includes/resources/App.php(77): KadenceWP\KadenceBlocks\App->__construct()
    12 /usr/www/users/xyz/stage.domain/wp-content/plugins/kadence-blocks/kadence-blocks.php(51): KadenceWP\KadenceBlocks\App::instance()
    13 /usr/www/users/xyz/stage.domain/wp-includes/class-wp-hook.php(341): kadence_blocks_init()
    14 /usr/www/users/xyz/stage.domain/wp-includes/class-wp-hook.php(365): WP_Hook->apply_filters()
    15 /usr/www/users/xyz/stage.domain/wp-includes/plugin.php(522): WP_Hook->do_action()
    16 /usr/www/users/xyz/stage.domain/wp-settings.php(593): do_action()
    17 /usr/www/users/xyz/stage.domain/wp-config.php(263): require_once(‘/usr/www/users/…’)
    18 /usr/www/users/xyz/stage.domain/wp-load.php(50): require_once(‘/usr/www/users/…’)
    19 /usr/www/users/xyz/stage.domain/wp-admin/admin.php(35): require_once(‘/usr/www/users/…’) 20 /usr/www/users/xyz/stage.domain/wp-admin/plugins.php(10): require_once(‘/usr/www/users/…’) 21 {main}

    thrown

Viewing 6 replies - 1 through 6 (of 6 total)
  • Thread Starter sventertain

    (@sventertain)

    1 month, 4 weeks ago

    Hello,

    it seems our database user doesn’t have all the necessary permissions to update the plugin. I’m just surprised that we never had this problem during normal operation in previous years.

    … working on fixing the permissions.

    Plugin Support architalevelup

    (@architabasandrai20)

    1 month, 3 weeks ago

    Hi @sventertain

    Thanks for your patience. I just saw your messages, as our Support team doesn’t work over the weekend.

    This issue isn’t caused by skipping versions or by the Performance Optimizer itself. Starting with Kadence Blocks 3.6.0, the plugin needs to create or update some database tables for the new optimizer features. From the error and stack trace, it looks like your database user doesn’t have the required permissions (for example CREATE or ALTER), so the update fails and triggers the fatal error.

    That also explains why everything worked fine for years and why the problem only appeared during the update. Earlier versions didn’t need to modify the database in this way.

    You don’t need to update to 3.6.0 first. Updating directly to 3.6.1 is fine. The same database changes are required either way.

    Once your host fixes the database permissions, you should be able to:

    • Reactivate Kadence Blocks, or
    • Rerun the update to 3.6.1

    and the database tables should be created successfully.

    After that, the site should load normally again. If anything still doesn’t look right once permissions are fixed, feel free to let us know and we can check further.

    If the issue persists after fixing the database permissions, can you please confirm the MySQL and PHP versions running on your site?

    I hope this helps. Let me know if we can assist you further.

    Best Regards,
    Archita 

    Plugin Support architalevelup

    (@architabasandrai20)

    1 month, 3 weeks ago

    Hi @sventertain

    I hope you’re doing well! I wanted to follow up on this issue. Were you able to get everything resolved, or do you still need assistance?

    Looking forward to your update!

    Best regards,
    Archita

    Thread Starter sventertain

    (@sventertain)

    1 month, 3 weeks ago

    Hey @archita,

    Thanks for checking in. I’ve forwarded the issue to the company’s admin, and a ticket has already been opened with their hosting provider. I’m still waiting for the fix, but I’m pretty sure it will be working then.

    I’ll get back to you.

    Best, Sven

    Plugin Support architalevelup

    (@architabasandrai20)

    1 month, 2 weeks ago

    Hi @sventertain

    Thank you for the update! I really appreciate you keeping me in the loop.

    I’ll check back in with you if I don’t hear anything in another few days, but feel free to reply whenever you’re ready!

    Best regards,
    Archita

    Thread Starter sventertain

    (@sventertain)

    1 month ago

    Hello,

    our database user’s permissions have now been adjusted and I was able to easily upgrade your plugin from 3.5.32 to 3.6.5.

    Best, Sven

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

You must be logged in to reply to this topic.