1286 Unknown storage engine 'MyISAM'

[RegistroItaliano]

good morning,
I had to add a new list to the site, but when I try to create it I get this error

1286 Unknown storage engine 'MyISAM'

It's been a while since I modified the site but before it always created everything without problems.

The site works perfectly and if I try to connect to the DB it's ok

What could it be?

 

[troester]

Fabrik (user data) tables are created with ENGINE = MYISAM.

Which DB version is running on your server?
Which exact Joomla, Fabrik, php version?

 

[RegistroItaliano]

DB Versione del server: 8.0.36-28
Joomla 5.2.4
Fabrik 4.5.1

 

[troester]

Strange.
Please enable Joomla System Debug, try again and post the error stack.

 

[RegistroItaliano]

Call Stack​

#	Function	Location
1	()	JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:411
2	Joomla\Database\Mysqli\MysqliStatement->execute()	JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:651
3	Joomla\Database\DatabaseDriver->execute()	JROOT/administrator/components/com_fabrik/models/list.php:2426
4	FabrikAdminModelList->createDBTable()	JROOT/administrator/components/com_fabrik/models/list.php:771
5	FabrikAdminModelList->save()	JROOT/libraries/src/MVC/Controller/FormController.php:689
6	Joomla\CMS\MVC\Controller\FormController->save()	JROOT/administrator/components/com_fabrik/controllers/list.php:390
7	FabrikAdminControllerList->doSave()	JROOT/libraries/src/MVC/Controller/BaseController.php:730
8	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_fabrik/fabrik.php:104
9	require_once()	JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
10	Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}()	JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
11	Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch()	JROOT/libraries/src/Component/ComponentHelper.php:361
12	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/AdministratorApplication.php:150
13	Joomla\CMS\Application\AdministratorApplication->dispatch()	JROOT/libraries/src/Application/AdministratorApplication.php:205
14	Joomla\CMS\Application\AdministratorApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:306
15	Joomla\CMS\Application\CMSApplication->execute()	JROOT/administrator/includes/app.php:58
16	require_once()	JROOT/administrator/index.php:32

Errore precedente
Unknown storage engine 'MyISAM'

Call Stack​

#	Function	Location
1	()	JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:407
2	mysqli_stmt->execute()	JROOT/libraries/vendor/joomla/database/src/Mysqli/MysqliStatement.php:407
3	Joomla\Database\Mysqli\MysqliStatement->execute()	JROOT/libraries/vendor/joomla/database/src/DatabaseDriver.php:651
4	Joomla\Database\DatabaseDriver->execute()	JROOT/administrator/components/com_fabrik/models/list.php:2426
5	FabrikAdminModelList->createDBTable()	JROOT/administrator/components/com_fabrik/models/list.php:771
6	FabrikAdminModelList->save()	JROOT/libraries/src/MVC/Controller/FormController.php:689
7	Joomla\CMS\MVC\Controller\FormController->save()	JROOT/administrator/components/com_fabrik/controllers/list.php:390
8	FabrikAdminControllerList->doSave()	JROOT/libraries/src/MVC/Controller/BaseController.php:730
9	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/administrator/components/com_fabrik/fabrik.php:104
10	require_once()	JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:71
11	Joomla\CMS\Dispatcher\LegacyComponentDispatcher::Joomla\CMS\Dispatcher\{closure}()	JROOT/libraries/src/Dispatcher/LegacyComponentDispatcher.php:73
12	Joomla\CMS\Dispatcher\LegacyComponentDispatcher->dispatch()	JROOT/libraries/src/Component/ComponentHelper.php:361
13	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/AdministratorApplication.php:150
14	Joomla\CMS\Application\AdministratorApplication->dispatch()	JROOT/libraries/src/Application/AdministratorApplication.php:205
15	Joomla\CMS\Application\AdministratorApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:306
16	Joomla\CMS\Application\CMSApplication->execute()	JROOT/administrator/includes/app.php:58
17	require_once()	JROOT/administrator/index.php:32

 

[elmarra]

In your Phpmyadmin run sql:

SHOW ENGINES;

And check if Myisam is supported

 

[RegistroItaliano]

In your Phpmyadmin run sql:

SHOW ENGINES;

And check if Myisam is supported

Yes is supported

 

[troester]

Do you have only one Fabrik connection?
Pointing to the J! database?

 

[RegistroItaliano]

unfortunately not, there is another part of the wordpres site that points to the same DB

 

[troester]

Which connection did you select for your new list?
And on which DB did you do the MyISAM test?

 

[RegistroItaliano]

I selected the only connection to the Fabrik DB, and the test is done on the only DB they have where there is both Fabrick/Joomla and Wordpress

 

[troester]

What are you trying to do exactly?

Which Fabrik connections do you have, which one did you select for your list?
Which content type did you select?

 

[RegistroItaliano]

I just need to create a new list to record a list of payments

I try to create a default list


if I create the table with phpMyAdmin then it does not give me errors to create the list by combining it with the existing table.

 

[troester]

Which Fabrik connections do you have, which one did you select for your list?

No idea what is going on on your site/DB server...

It this a J!3/F3 updated site?

What are your Joomla DB settings (in globalConfig)?

 

[RegistroItaliano]

no it's a J4 updated to 5, but it worked before
and a fabrik 4 always updated



the fact that until 2 weeks ago it was working perfectly, I don't know if it is caused by fabrik or joomla updates

 

[troester]

It may also be e.g. a DB server change from your host.

You can try to hack Fabrik and modify
administrator\components\com_fabrik\models\list.php

Comment out line 2424 and see if this will do or give you an other error.
But this is really no general fix.

 

[RegistroItaliano]

gives exactly the same error.

the strange thing is that it creates list, form and groups but not the table in the DB

 

[troester]

Yes, DB user table creation is done at last..

But something is screwed up at your site.
Does your DB user (in globalConfig) has permission to create new tables?
(Maybe the error message is missleading)

 

[elmarra]

Very strange indeed, but I have always avoided Aruba.
As Beate told you, make sure that the user configured in Fabrik has permissions to create tables on the database.
If you want to rule out a hosting issue, create a backup and try to install your configuration elsewhere, so you can test and try to isolate the problem.

 

[p38]

I suggest use a db admin program (eg: Navicat) to clone a copy of the table.
Onc cloned, change to InnoDB table type an dtry on that table
1286 Unknown storage engine 'MyISAM' points to mysql db corruption and I dont think is related to Fabrik.