Author |
|
Send Newbie
Joined: 29 October 2023 Location: Italy
Online Status: Offline Posts: 1
|
Posted: 29 October 2023 at 1:33pm | IP Logged
|
|
|
Hi
Tryng to create tables for aurora the process terminate with error. The connection is set correctly and the first table "au_migrations" is created correctly.
The server run under Centos, MariaDb 10.1.33 and Php 7.4.33 and the log file:
"Next Illuminate\Database\QueryException: 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 'json null, `CreatedAt` timestamp null, `UpdatedAt` timestamp null) default chara' at line 1 (SQL: create table `au_core_users` (`Id` int unsigned not null auto_increment primary key, `UUID` varchar(255) not null, `Name` varchar(255) not null default '', `PublicId` varchar(255) not null, `IdTenant` int not null default '0', `IsDisabled` tinyint(1) not null default '0', `IdSubscription` int not null default '0', `Role` int not null default '2', `DateCreated` datetime null, `LastLogin` datetime null, `LastLoginNow` varchar(255) not null default '', `LoginsCount` int not null default '0', `Language` varchar(255) not null default '', `TimeFormat` int null default '1', `DateFormat` varchar(255) not null default '', `Question1` varchar(255) not null default '', `Question2` varchar(255) not null default '', `Answer1` varchar(255) not null default '', `Answer2` varchar(255) not null default '', `SipEnable` tinyint(1) not null default '1', `SipImpi` varchar(255) not null default '', `SipPassword` varchar(255) not null default '', `DesktopNotifications` tinyint(1) not null default '0', `Capa` varchar(255) not null default '', `CustomFields` varchar(255) not null default '', `FilesEnable` tinyint(1) not null default '1', `EmailNotification` varchar(255) not null default '', `PasswordResetHash` varchar(255) not null default '', `WriteSeparateLog` tinyint(1) not null default '0', `TokensValidFromTimestamp` int not null default '0', `DefaultTimeZone` varchar(255) not null default '', `Properties` json null, `CreatedAt` timestamp null, `UpdatedAt` timestamp null) default character set utf8 collate 'utf8_general_ci') in /wwdata/store/public/mystore/wwroot/cloud/vendor/illuminate/database/Connection.php:712
Stack trace:
#0 /wwdata/store/public/mystore/wwroot/cloud/vendor/illuminate/database/Connection.php(672): Illuminate\Database\Connection->runQueryCallback('create table `a...', Array, Object(Closure))
#1 /wwdata/store/public/mystore/wwroot/cloud/vendor/illuminate/database/Connection.php(502): Illuminate\Database\Connection->run('create table `a...', Array, Object(Closure))
#2 /wwdata/store/public/mystore/wwroot/cloud/vendor/illuminate/database/Schema/Blueprint.php(109): Illuminate\Database\Connection->statement('create table `a...')
#3 /wwdata/store/public/mystore/wwroot/cloud/vendor/illuminate/database/Schema/Builder.php(364): Illuminate\Database\Schema\Blueprint->build(Object(Illuminate\Database\MySqlConnection), Object(Illuminate\Database\Schema\Grammars\MySqlGrammar))
#4 /wwdata/store/public/mystore/wwroot/cloud/vendor/illuminate/database/Schema/Builder.php(227): Illuminate\Database\Schema\Builder->build(Object(Illuminate\Database\Schema\Blueprint))
#5 /wwdata/store/public/mystore/wwroot/cloud/modules/Core/Migrations/2021_05_28_000000_create_users_table.php(66): Illuminate\Database\Schema\Builder->create('core_users', Object(Closure))
#6 /wwdata/store/public/mystore/wwroot/cloud/vendor/illuminate/database/Migrations/Migrator.php(472): CreateUsersTable->up()
#7 /wwdata/store/public/mystore/wwroot/cloud/vendor/illuminate/database/Migrations/Migrator.php(394): Illuminate\Database\Migrations\Migrator->runMethod(Object(Illuminate\Database\MySqlConnection), Object(CreateUsersTable), 'up')
#8 /wwdata/store/public/mystore/wwroot/cloud/vendor/illuminate/database/Migrations/Migrator.php(403): Illuminate\Database\Migrations\Migrator->Illuminate\Database\Migrations\{closure}()
#9 /wwdata/store/public/mystore/wwroot/cloud/vendor/illuminate/database/Migrations/Migrator.php(202): Illuminate\Database\Migrations\Migrator->runMigration(Object(CreateUsersTable), 'up')
#10 /wwdata/store/public/mystore/wwroot/cloud/vendor/illuminate/database/Migrations/Migrator.php(167): Illuminate\Database\Migrations\Migrator->runUp('/wwdata/store...', 1, false)
#11 /wwdata/store/public/mystore/wwroot/cloud/vendor/illuminate/database/Migrations/Migrator.php(112): Illuminate\Database\Migrations\Migrator->runPending(Array, Array)
#12 /wwdata/store/public/mystore/wwroot/cloud/system/Console/Commands/Migrations/MigrateCommand.php(75): Illuminate\Database\Migrations\Migrator->run(Array, Array)
#13 /wwdata/store/public/mystore/wwroot/cloud/vendor/illuminate/database/Migrations/Migrator.php(606): Aurora\System\Console\Commands\Migrations\MigrateCommand->Aurora\System\Console\Commands\Migrations\{closure}()
#14 /wwdata/store/public/mystore/wwroot/cloud/system/Console/Commands/Migrations/MigrateCommand.php(87): Illuminate\Database\Migrations\Migrator->usingConnection(NULL, Object(Closure))
#15 /wwdata/store/public/mystore/wwroot/cloud/vendor/symfony/console/Command/Command.php(298): Aurora\System\Console\Commands\Migrations\MigrateCommand->execute(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\NullOutput))
#16 /wwdata/store/public/mystore/wwroot/cloud/modules/Core/Module.php(1727): Symfony\Component\Console\Command\Command->run(Object(Symfony\Component\Console\Input\ArrayInput), Object(Symfony\Component\Console\Output\NullOutput))
#17 [internal function]: Aurora\Modules\Core\Module->CreateTables()
#18 /wwdata/store/public/mystore/wwroot/cloud/system/Module/AbstractModule.php(812): call_user_func_array(Array, Array)
#19 /wwdata/store/public/mystore/wwroot/cloud/modules/Core/Module.php(668): Aurora\System\Module\AbstractModule->CallMethod('CreateTables', Array, true)
#20 [internal function]: Aurora\Modules\Core\Module->EntryApi()
#21 /wwdata/store/public/mystore/wwroot/cloud/system/Router.php(105): call_user_func_array(Array, Array)
#22 /wwdata/store/public/mystore/wwroot/cloud/system/Module/Manager.php(608): Aurora\System\Router->route('api')
#23 /wwdata/store/public/mystore/wwroot/cloud/system/Application.php(132): Aurora\System\Module\Manager->RunEntry('api')
#24 /wwdata/store/public/mystore/wwroot/cloud/system/Application.php(102): Aurora\System\Application->Route('api')
#25 /wwdata/store/public/mystore/wwroot/cloud/adminpanel/index.php(10): Aurora\System\Application::Start()
#26 {main}, Code: 42000, Message: 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 'json null, `CreatedAt` timestamp null, `UpdatedAt` timestamp null) default chara' at line 1 (SQL: create table `au_core_users` (`Id` int unsigned not null auto_increment primary key, `UUID` varchar(255) not null, `Name` varchar(255) not null default '', `PublicId` varchar(255) not null, `IdTenant` int not null default '0', `IsDisabled` tinyint(1) not null default '0', `IdSubscription` int not null default '0', `Role` int not null default '2', `DateCreated` datetime null, `LastLogin` datetime null, `LastLoginNow` varchar(255) not null default '', `LoginsCount` int not null default '0', `Language` varchar(255) not null default '', `TimeFormat` int null default '1', `DateFormat` varchar(255) not null default '', `Question1` varchar(255) not null default '', `Question2` varchar(255) not null default '', `Answer1` varchar(255) not null default '', `Answer2` varchar(255) not null default '', `SipEnable` tinyint(1) not null default '1', `SipImpi` varchar(255) not null default '', `SipPassword` varchar(255) not null default '', `DesktopNotifications` tinyint(1) not null default '0', `Capa` varchar(255) not null default '', `CustomFields` varchar(255) not null default '', `FilesEnable` tinyint(1) not null default '1', `EmailNotification` varchar(255) not null default '', `PasswordResetHash` varchar(255) not null default '', `WriteSeparateLog` tinyint(1) not null default '0', `TokensValidFromTimestamp` int not null default '0', `DefaultTimeZone` varchar(255) not null default '', `Properties` json null, `CreatedAt` timestamp null, `UpdatedAt` timestamp null) default character set utf8 collate 'utf8_general_ci')"
|
Back to Top |
|
|
Igor AfterLogic Support
Joined: 24 June 2008 Location: United States
Online Status: Offline Posts: 6094
|
Posted: 29 October 2023 at 11:16pm | IP Logged
|
|
|
Hello,
According to system requirements of Aurora Files, MySQL 5.7.8 or newer / MariaDB 10.2.7 or newer is required, and your database engine doesn't meet that requirement. The reason for such a requirement is that our product relies on JSON data type introduced in those versions, and your database engine does not recognize that syntax.
Hope this helps.
--
Regards,
Igor, Afterlogic Support
|
Back to Top |
|
|
|
|