This forum has moved to a new location and is in read-only mode. Please visit talk.octobercms.com to access the new location.

  1. Forum
  2. FormTools Support
  3. MariaDB error when installing or updating a plugin
bas52531
bas52531

i get an error when i try to update or install a plugin and i dont understand the error. can someone help me with this.

"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ') default character set utf8mb4 collate utf8mb4_unicode_ci' at line 1 (SQL: create table `bd_projecten_table` () default character set utf8mb4 collate utf8mb4_unicode_ci)" on line 664 of /var/www/vhosts/dencarp.nl/httpdocs/vendor/laravel/framework/src/Illuminate/Database/Connection.php

Thankyou in advance

daftspunky
daftspunky
Moderator

In your config/database.php file, try changing the character set to something simpler:

'mysql' => [
    // ...
    'charset'   => 'utf8',
    'collation' => 'utf8_unicode_ci',
    // ...
],

Maybe it will bring you better luck

bas52531
bas52531

daftspunk said:

In your config/database.php file, try changing the character set to something simpler:

'mysql' => [
   // ...
   'charset'   => 'utf8',
   'collation' => 'utf8_unicode_ci',
   // ...
],

Maybe it will bring you better luck

Thank you for the reply, this didnt seem to help. i will try reinstall the site.

thankyou!

1-3 of 3

You cannot edit posts or make replies: the forum has moved to talk.octobercms.com.