Search The ForumSearch   RegisterRegister  LoginLogin

AfterLogic Aurora Files
 AfterLogic Forum : AfterLogic Aurora Files
Subject Topic: Impossible to create table Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
Send
Newbie
Newbie


Joined: 29 October 2023
Location: Italy
Online Status: Offline
Posts: 1
Posted: 29 October 2023 at 1:33pm | IP Logged Quote Send
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 View Send's Profile Search for other posts by Send
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
Posted: 29 October 2023 at 11:16pm | IP Logged Quote Igor
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 View Igor's Profile Search for other posts by Igor
 

If you wish to post a reply to this topic you must first login
If you are not already registered you must first register

  Post ReplyPost New Topic
Printable version Printable version

Forum Jump

Powered by Web Wiz Forums version 7.9
Copyright ©2001-2004 Web Wiz Guide