[Bug] Add Modal does not work.

[losmicar]

Bug report

What I did

composer create-project laravel/laravel brid
composer config http-basic.backpackforlaravel.com user pass
added repo to composer.json
composer require backpack/crud
php artisan backpack:install
Installed all 3 premium addons (Backpack pro, DevTools, Backpack Editable Columns)
There were no error during the install process.

Licence I bought: Everything.

What I expected to happen

Login is working and DevTools listing is working displaying only Users model as expected. But when I click on Add Model app breaks.

What happened

An exception occurred while executing a query: SQLSTATE[HY000]: General error: 1 near "(": syntax error
https://capture.dropbox.com/mTOkDFg5Sd8cOVLO

What I've already tried to fix it

composer require --dev --with-all-dependencies backpack/devtools
composer update backpack/crud

Backpack, Laravel, PHP, DB version

PHP 8.1.12
Laravel version: 9.48.0
MySql 8.0
laravel/laravel - requires backpack/crud (^5.4)
backpack/devtools 1.3.0 requires backpack/crud (^5.3)
backpack/editable-columns 2.1.1 requires backpack/crud (^5.3.13)
backpack/generators v3.3.13 requires backpack/crud (^5.3.11)
backpack/pro 1.6.0 requires backpack/crud (^5.4.9)

When I run php artisan backpack:version the output is:

PHP VERSION:

PHP 8.1.12 (cli) (built: Oct 31 2022 22:06:27) (NTS)
Copyright (c) The PHP Group
Zend Engine v4.1.12, Copyright (c) Zend Technologies
with Zend OPcache v8.1.12, Copyright (c), by Zend Technologies

LARAVEL VERSION:

v9.48.0@c78ae7aeb0cbcb1a205050d3592247ba07f5b711

BACKPACK PACKAGE VERSIONS:

Operating System and Server Setup

I encountered the problem above on my Amazon Linux 2 EC2 instance.

Log

[previous exception] [object] (PDOException(code: HY000): SQLSTATE[HY000]: General error: 1 near "(": syntax error at /var/www/brid/vendor/laravel/framework/src/Illuminate/Database/PDO/Connection.php:81)
[stacktrace]
#0 /var/www/brid/vendor/laravel/framework/src/Illuminate/Database/PDO/Connection.php(81): PDO->query(' SEL...')
#1 /var/www/brid/vendor/doctrine/dbal/src/Connection.php(1064): Illuminate\Database\PDO\Connection->query(' SEL...')
#2 /var/www/brid/vendor/doctrine/dbal/src/Schema/SqliteSchemaManager.php(703): Doctrine\DBAL\Connection->executeQuery(' SEL...', Array)
#3 /var/www/brid/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php(561): Doctrine\DBAL\Schema\SqliteSchemaManager->selectTableColumns('main')
#4 /var/www/brid/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php(408): Doctrine\DBAL\Schema\AbstractSchemaManager->fetchTableColumnsByTable('main')
#5 /var/www/brid/vendor/doctrine/dbal/src/Schema/SqliteSchemaManager.php(57): Doctrine\DBAL\Schema\AbstractSchemaManager->doListTables()
#6 /var/www/brid/vendor/doctrine/dbal/src/Schema/AbstractSchemaManager.php(1651): Doctrine\DBAL\Schema\SqliteSchemaManager->listTables()
#7 /var/www/brid/vendor/backpack/crud/src/app/Library/Database/DatabaseSchema.php(36): Doctrine\DBAL\Schema\AbstractSchemaManager->createSchema()
#8 /var/www/brid/vendor/backpack/crud/src/app/Library/Database/DatabaseSchema.php(21): Backpack\CRUD\app\Library\Database\DatabaseSchema::generateDatabaseSchema('Backpack\\DevToo...', 'models')
#9 /var/www/brid/vendor/backpack/crud/src/app/Library/Database/TableSchema.php(12): Backpack\CRUD\app\Library\Database\DatabaseSchema::getForTable('Backpack\\DevToo...', 'models')
#10 /var/www/brid/vendor/backpack/crud/src/app/Models/Traits/HasRelationshipFields.php(132): Backpack\CRUD\app\Library\Database\TableSchema->__construct('Backpack\\DevToo...', 'models')
#11 /var/www/brid/vendor/backpack/crud/src/app/Library/CrudPanel/Traits/AutoSet.php(91): Backpack\DevTools\Models\Model::getDbTableSchema()
#12 /var/www/brid/vendor/backpack/crud/src/app/Library/CrudPanel/Traits/AutoSet.php(57): Backpack\CRUD\app\Library\CrudPanel\CrudPanel->getDbTableColumns()
#13 /var/www/brid/vendor/backpack/crud/src/app/Library/CrudPanel/Traits/AutoSet.php(116): Backpack\CRUD\app\Library\CrudPanel\CrudPanel->getDbColumnTypes()
#14 /var/www/brid/vendor/backpack/crud/src/app/Library/CrudPanel/Traits/FieldsProtectedMethods.php(230): Backpack\CRUD\app\Library\CrudPanel\CrudPanel->inferFieldTypeFromDbColumnType('name')
#15 /var/www/brid/vendor/backpack/crud/src/app/Library/CrudPanel/Traits/Fields.php(54): Backpack\CRUD\app\Library\CrudPanel\CrudPanel->makeSureFieldHasType(Array)
#16 /var/www/brid/vendor/backpack/crud/src/app/Library/CrudPanel/Traits/Fields.php(108): Backpack\CRUD\app\Library\CrudPanel\CrudPanel->makeSureFieldHasNecessaryAttributes(Array)
#17 /var/www/brid/vendor/backpack/crud/src/app/Library/CrudPanel/CrudField.php(375): Backpack\CRUD\app\Library\CrudPanel\CrudPanel->addField(Array)
#18 /var/www/brid/vendor/backpack/crud/src/app/Library/CrudPanel/CrudField.php(57): Backpack\CRUD\app\Library\CrudPanel\CrudField->save()
#19 /var/www/brid/vendor/backpack/crud/src/app/Library/CrudPanel/Traits/Fields.php(543): Backpack\CRUD\app\Library\CrudPanel\CrudField->__construct('name')
#20 /var/www/brid/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php(338): Backpack\CRUD\app\Library\CrudPanel\CrudPanel->field('name')
#21 /var/www/brid/vendor/backpack/devtools/src/Http/Controllers/ModelCrudController.php(158): Illuminate\Support\Facades\Facade::__callStatic('field', Array)
#22 /var/www/brid/vendor/backpack/crud/src/app/Http/Controllers/CrudController.php(121): Backpack\DevTools\Http\Controllers\ModelCrudController->setupCreateOperation()
#23 /var/www/brid/vendor/backpack/crud/src/app/Http/Controllers/CrudController.php(42): Backpack\CRUD\app\Http\Controllers\CrudController->setupConfigurationForCurrentOperation()
#24 /var/www/brid/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(162): Backpack\CRUD\app\Http\Controllers\CrudController->Backpack\CRUD\app\Http\Controllers\{closure}(Object(Illuminate\Http\Request), Object(Closure))
#25 /var/www/brid/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#26 /var/www/brid/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#27 /var/www/brid/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(Object(Illuminate\Http\Request), Object(Closure))
#28 /var/www/brid/app/Http/Middleware/CheckIfAdmin.php(66): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#29 /var/www/brid/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): App\Http\Middleware\CheckIfAdmin->handle(Object(Illuminate\Http\Request), Object(Closure))
#30 /var/www/brid/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php(50): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#31 /var/www/brid/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Routing\Middleware\SubstituteBindings->handle(Object(Illuminate\Http\Request), Object(Closure))
#32 /var/www/brid/vendor/backpack/crud/src/app/Http/Middleware/AuthenticateSession.php(62): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#33 /var/www/brid/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Backpack\CRUD\app\Http\Middleware\AuthenticateSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#34 /var/www/brid/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php(78): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#35 /var/www/brid/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\VerifyCsrfToken->handle(Object(Illuminate\Http\Request), Object(Closure))
#36 /var/www/brid/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#37 /var/www/brid/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\View\Middleware\ShareErrorsFromSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#38 /var/www/brid/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(121): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#39 /var/www/brid/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php(64): Illuminate\Session\Middleware\StartSession->handleStatefulRequest(Object(Illuminate\Http\Request), Object(Illuminate\Session\Store), Object(Closure))
#40 /var/www/brid/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Session\Middleware\StartSession->handle(Object(Illuminate\Http\Request), Object(Closure))
#41 /var/www/brid/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php(37): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#42 /var/www/brid/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Cookie\Middleware\AddQueuedCookiesToResponse->handle(Object(Illuminate\Http\Request), Object(Closure))
#43 /var/www/brid/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php(67): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#44 /var/www/brid/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Cookie\Middleware\EncryptCookies->handle(Object(Illuminate\Http\Request), Object(Closure))
#45 /var/www/brid/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#46 /var/www/brid/vendor/laravel/framework/src/Illuminate/Routing/Router.php(799): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#47 /var/www/brid/vendor/laravel/framework/src/Illuminate/Routing/Router.php(776): Illuminate\Routing\Router->runRouteWithinStack(Object(Illuminate\Routing\Route), Object(Illuminate\Http\Request))
#48 /var/www/brid/vendor/laravel/framework/src/Illuminate/Routing/Router.php(740): Illuminate\Routing\Router->runRoute(Object(Illuminate\Http\Request), Object(Illuminate\Routing\Route))
#49 /var/www/brid/vendor/laravel/framework/src/Illuminate/Routing/Router.php(729): Illuminate\Routing\Router->dispatchToRoute(Object(Illuminate\Http\Request))
#50 /var/www/brid/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(190): Illuminate\Routing\Router->dispatch(Object(Illuminate\Http\Request))
#51 /var/www/brid/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(141): Illuminate\Foundation\Http\Kernel->Illuminate\Foundation\Http\{closure}(Object(Illuminate\Http\Request))
#52 /var/www/brid/vendor/livewire/livewire/src/DisableBrowserCache.php(19): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#53 /var/www/brid/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Livewire\DisableBrowserCache->handle(Object(Illuminate\Http\Request), Object(Closure))
#54 /var/www/brid/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#55 /var/www/brid/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ConvertEmptyStringsToNull.php(31): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#56 /var/www/brid/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ConvertEmptyStringsToNull->handle(Object(Illuminate\Http\Request), Object(Closure))
#57 /var/www/brid/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php(21): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#58 /var/www/brid/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TrimStrings.php(40): Illuminate\Foundation\Http\Middleware\TransformsRequest->handle(Object(Illuminate\Http\Request), Object(Closure))
#59 /var/www/brid/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\TrimStrings->handle(Object(Illuminate\Http\Request), Object(Closure))
#60 /var/www/brid/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php(27): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#61 /var/www/brid/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\ValidatePostSize->handle(Object(Illuminate\Http\Request), Object(Closure))
#62 /var/www/brid/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php(86): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#63 /var/www/brid/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Foundation\Http\Middleware\PreventRequestsDuringMaintenance->handle(Object(Illuminate\Http\Request), Object(Closure))
#64 /var/www/brid/vendor/laravel/framework/src/Illuminate/Http/Middleware/HandleCors.php(49): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#65 /var/www/brid/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Http\Middleware\HandleCors->handle(Object(Illuminate\Http\Request), Object(Closure))
#66 /var/www/brid/vendor/laravel/framework/src/Illuminate/Http/Middleware/TrustProxies.php(39): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#67 /var/www/brid/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(180): Illuminate\Http\Middleware\TrustProxies->handle(Object(Illuminate\Http\Request), Object(Closure))
#68 /var/www/brid/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php(116): Illuminate\Pipeline\Pipeline->Illuminate\Pipeline\{closure}(Object(Illuminate\Http\Request))
#69 /var/www/brid/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(165): Illuminate\Pipeline\Pipeline->then(Object(Closure))
#70 /var/www/brid/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php(134): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#71 /var/www/brid/public/index.php(52): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#72 {main}

[pxpm]

Hey @losmicar

Thanks for the report.

I've just created a setup like you described, and everything worked for me.

It may be due to some server configuration, what version of SQLite are you running on your server ?

My phpinfo() return something like:

SQLite 3.x driver for PDO => Wez Furlong
SQLite3 => Scott MacVicar, Ilia Alshanetsky, Brad Dewar

Cheers

[losmicar]

Hi @pxpm,

Thank you for you reply. Here are the details you've asked for.

SQLite 3.x driver for PDO	Wez Furlong
SQLite3	Scott MacVicar, Ilia Alshanetsky, Brad Dewar

pdo_sqlite

SQLite Library	3.7.17

Here is the output of the php info.
http://losmi555.brid.tv/

Also I can share any access admin dashboard or directly to the server that you need for debugging purpose.

[pxpm]

Thanks @losmicar .

Can you check if this helps: #58 (comment)

It also seems that your sqlite library is a bit old, I am using 3.37 and the last one release was 3.40, so you may also want to update it, it may have some conflicting code between those versions ?

It is also related with: #54 (comment)

So I really think that the older version of SQLite is the problem here.

Cheers

[losmicar]

Hi @pxpm

I've upgraded SQLite to 3.9 and needed to compile it with SQLITE_ENABLE_COLUMN_METADATA flag to work.

It looks it is resolved!

[pxpm]

Thanks for getting back with that information @losmicar

We have an open PR that would make the SQLite errors more visible and easier to debug for the developer.

Thanks again 🙏
Cheers