Crashed bare bones WP

  • Resolved skunkworks

    (@skunkworks)


    3 months, 3 weeks ago

    Upon plugin activation it causes:

    There has been a critical error on this website. Please check your site admin email inbox for instructions

    Error details

    When seeking help with this issue, you may be asked for some of the following information:
    WordPress version 6.6.1
    Active theme: Twenty Twenty-Four (version 1.2)
    Current plugin: AI Muse (version 1.2.2)
    PHP version 8.0.23



    Error Details
    =============
    An error of type E_ERROR was caused in line 712 of the file /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Connection.php. Error message: Uncaught Exception: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'json null,     prompt longtext not null, index tinyint not null default '0', ca' at line 1 in /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/src/Database/Connection.php:293<br>Stack trace:<br>#0 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Connection.php(705): AIMuse\Database\Connection->AIMuse\Database\{closure}('create tablew...', Array)
    #1 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Connection.php(672): AIMuseVendor\Illuminate\Database\Connection->runQueryCallback('create table w...', Array, Object(Closure))<br>#2 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/src/Database/Connection.php(303): AIMuseVendor\Illuminate\Database\Connection->run('create tablew...', Array, Object(Closure))
    #3 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Schema/Blueprint.php(109): AIMuse\Database\Connection->statement('create table w...')<br>#4 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Schema/Builder.php(364): AIMuseVendor\Illuminate\Database\Schema\Blueprint->build(Object(AIMuse\Database\Connection), Object(AIMuseVendor\Illuminate\Database\Schema\Grammars\MySqlGrammar))<br>#5 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Schema/Builder.php(227): AIMuseVendor\Illuminate\Database\Schema\Builder->build(Object(AIMuseVendor\Illuminate\Database\Schema\Blueprint))<br>#6 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/support/Facades/Facade.php(261): AIMuseVendor\Illuminate\Database\Schema\Builder->create('aimuse_template...', Object(Closure))<br>#7 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/database/migrations/0003_create_templates_table.php(31): AIMuseVendor\Illuminate\Support\Facades\Facade::__callStatic('create', Array)<br>#8 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Migrations/Migrator.php(472): AIMuseVendor\Illuminate\Database\Migrations\Migration@anonymous->up()<br>#9 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Migrations/Migrator.php(394): AIMuseVendor\Illuminate\Database\Migrations\Migrator->runMethod(Object(AIMuse\Database\Connection), Object(AIMuseVendor\Illuminate\Database\Migrations\Migration@anonymous), 'up')<br>#10 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Migrations/Migrator.php(403): AIMuseVendor\Illuminate\Database\Migrations\Migrator->AIMuseVendor\Illuminate\Database\Migrations\{closure}()<br>#11 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Migrations/Migrator.php(202): AIMuseVendor\Illuminate\Database\Migrations\Migrator->runMigration(Object(AIMuseVendor\Illuminate\Database\Migrations\Migration@anonymous), 'up')<br>#12 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Migrations/Migrator.php(167): AIMuseVendor\Illuminate\Database\Migrations\Migrator->runUp('/srv/users/serv...', 1, false)<br>#13 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Migrations/Migrator.php(112): AIMuseVendor\Illuminate\Database\Migrations\Migrator->runPending(Array, Array)<br>#14 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/src/Database.php(116): AIMuseVendor\Illuminate\Database\Migrations\Migrator->run(Array)<br>#15 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/src/App.php(147): AIMuse\Database->install()<br>#16 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/src/Wordpress/Hooks/Actions/AdminInitAction.php(20): AIMuse\App->install()<br>#17 /srv/users/[username]/apps/[sitename-staging]/public/wp-includes/class-wp-hook.php(324): AIMuse\Wordpress\Hooks\Actions\AdminInitAction->handle('')<br>#18 /srv/users/[username]/apps/[sitename-staging]/public/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters(NULL, Array)<br>#19 /srv/users/[username]/apps/[sitename-staging]/public/wp-includes/plugin.php(517): WP_Hook->do_action(Array)<br>#20 /srv/users/[username]/apps/[sitename-staging]/public/wp-admin/admin.php(175): do_action('admin_init')<br>#21 /srv/users/[username]/apps/[sitename-staging]/public/wp-admin/plugins.php(10): require_once('/srv/users/serv...')<br>#22 {main}<br><br>Next AIMuseVendor\Illuminate\Database\QueryException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'json null,promptlongtext not null,indextinyint not null default '0',ca' at line 1 (SQL: create table wp_0a0db1d0ff_aimuse_templates (id bigint unsigned not null auto_increment primary key, slug varchar(255) not null, category_id int unsigned not null, type varchar(255) not null default 'text', name varchar(255) not null, description varchar(255) null, enabled tinyint(1) not null default '1', option json null, prompt longtext not null, index tinyint not null default '0', capabilities json null, created_at timestamp null, updated_at timestamp null) default character set utf8mb4 collate 'utf8mb4_unicode_ci') in /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Connection.php:712
    Stack trace:
    #0 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Connection.php(672): AIMuseVendor\Illuminate\Database\Connection->runQueryCallback('create table w...', Array, Object(Closure))<br>#1 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/src/Database/Connection.php(303): AIMuseVendor\Illuminate\Database\Connection->run('create tablew...', Array, Object(Closure))
    #2 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Schema/Blueprint.php(109): AIMuse\Database\Connection->statement('create table `w...')
    #3 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Schema/Builder.php(364): AIMuseVendor\Illuminate\Database\Schema\Blueprint->build(Object(AIMuse\Database\Connection), Object(AIMuseVendor\Illuminate\Database\Schema\Grammars\MySqlGrammar))
    #4 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Schema/Builder.php(227): AIMuseVendor\Illuminate\Database\Schema\Builder->build(Object(AIMuseVendor\Illuminate\Database\Schema\Blueprint))
    #5 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/support/Facades/Facade.php(261): AIMuseVendor\Illuminate\Database\Schema\Builder->create('aimuse_template...', Object(Closure))
    #6 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/database/migrations/0003_create_templates_table.php(31): AIMuseVendor\Illuminate\Support\Facades\Facade::__callStatic('create', Array)
    #7 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Migrations/Migrator.php(472): AIMuseVendor\Illuminate\Database\Migrations\Migration@anonymous->up()
    #8 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Migrations/Migrator.php(394): AIMuseVendor\Illuminate\Database\Migrations\Migrator->runMethod(Object(AIMuse\Database\Connection), Object(AIMuseVendor\Illuminate\Database\Migrations\Migration@anonymous), 'up')
    #9 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Migrations/Migrator.php(403): AIMuseVendor\Illuminate\Database\Migrations\Migrator->AIMuseVendor\Illuminate\Database\Migrations\{closure}()
    #10 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Migrations/Migrator.php(202): AIMuseVendor\Illuminate\Database\Migrations\Migrator->runMigration(Object(AIMuseVendor\Illuminate\Database\Migrations\Migration@anonymous), 'up')
    #11 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Migrations/Migrator.php(167): AIMuseVendor\Illuminate\Database\Migrations\Migrator->runUp('/srv/users/serv...', 1, false)
    #12 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/vendor/illuminate/database/Migrations/Migrator.php(112): AIMuseVendor\Illuminate\Database\Migrations\Migrator->runPending(Array, Array)
    #13 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/src/Database.php(116): AIMuseVendor\Illuminate\Database\Migrations\Migrator->run(Array)
    #14 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/src/App.php(147): AIMuse\Database->install()
    #15 /srv/users/[username]/apps/[sitename-staging]/public/wp-content/plugins/ai-muse/src/Wordpress/Hooks/Actions/AdminInitAction.php(20): AIMuse\App->install()
    #16 /srv/users/[username]/apps/[sitename-staging]/public/wp-includes/class-wp-hook.php(324): AIMuse\Wordpress\Hooks\Actions\AdminInitAction->handle('')
    #17 /srv/users/[username]/apps/[sitename-staging]/public/wp-includes/class-wp-hook.php(348): WP_Hook->apply_filters(NULL, Array)
    #18 /srv/users/[username]/apps/[sitename-staging]/public/wp-includes/plugin.php(517): WP_Hook->do_action(Array)
    #19 /srv/users/[username]/apps/[sitename-staging]/public/wp-admin/admin.php(175): do_action('admin_init')
    #20 /srv/users/[username]/apps/[sitename-staging]/public/wp-admin/plugins.php(10): require_once('/srv/users/serv...')
    #21 {main}
     thrown
Viewing 4 replies - 1 through 4 (of 4 total)

  • hard to debug with this only log but seems like not properly installed mysql

    I installed this plugin on at least 4 different hosting and at least 2 different vps server and none of them gave this error.

    install your LAMPP stack properly. if you dont know how to do it just buy a managed hosting or managed server.

    • This reply was modified 2 months, 3 weeks ago by sinanisler.
    Thread Starter skunkworks

    (@skunkworks)

    install your LAMPP stack properly.

    if you dont know how to do it just buy a managed hosting or managed server.

    Was installed by the experts at Less Bits via ServerPilot.io which was created by Justin Samuel and Kevin Luikens. Confident that they know what they’re doing.

    Have used their products for just shy of 10 years and have never once had a situation prior where it seemed we didn’t have the basics installed properly.

    DigitalOcean VPS + ServerPilot + Cloudflare

    I wonder what is your output info.php phpinfo(); and what is your mysql version?

    I have couple vps too none of them have this issue. weird.

    Plugin Author AI Muse Dev.

    (@wpaimuse)

    This support ticket is being closed due to prolonged inactivity.

Viewing 4 replies - 1 through 4 (of 4 total)
  • You must be logged in to reply to this topic.