Crashed bare bones WP

Resolved

(@skunkworks)

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)

sinanisler
(@sinanisler)

1 year, 9 months ago
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 1 year, 9 months ago by sinanisler.
Thread Starter skunkworks
(@skunkworks)

1 year, 9 months ago

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

sinanisler
(@sinanisler)

1 year, 9 months ago

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 wpaimuse
(@wpaimuse)

1 year, 6 months ago

This support ticket is being closed due to prolonged inactivity.

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

The topic ‘Crashed bare bones WP’ is closed to new replies.