Search The ForumSearch   RegisterRegister  LoginLogin

AfterLogic WebMail Lite
 AfterLogic Forum : AfterLogic WebMail Lite
Subject Topic: Error: "Creating tables has failed" Post ReplyPost New Topic
Author
Message << Prev Topic | Next Topic >>
lazna
Newbie
Newbie


Joined: 12 July 2014
Online Status: Offline
Posts: 17
Posted: 22 May 2018 at 11:13am | IP Logged Quote lazna
Installing webmail instance. Connectivity test to MySQL server is OK, when click on "Create tables" got %SUBJ% error. From log file:



[18:12:10.05][3b988497] [POST(4)][ip:x.x.x.x] /?/Api/
[18:12:10.05][3b988497] POST > [Module, Method, TenantName, Parameters]
[18:12:10.05][3b988497]
[18:12:10.05][3b988497] (SELECT         
     entities.id as entity_id,
     entities.uuid as entity_uuid,
     entities.parent_uuid as parent_uuid,
     entities.entity_type,
     entities.module_name as entity_module,
     attrs.name as attr_name,
    attrs.value as attr_value,
     'int' as attr_type
FROM au_eav_entities as entities
      LEFT JOIN au_eav_attributes_int as attrs ON entities.id = attrs.id_entity
WHERE entities.id = -1)
UNION ALL

(SELECT         
     entities.id as entity_id,
     entities.uuid as entity_uuid,
     entities.parent_uuid as parent_uuid,
     entities.entity_type,
     entities.module_name as entity_module,
     attrs.name as attr_name,
    attrs.value as attr_value,
     'string' as attr_type
FROM au_eav_entities as entities
      LEFT JOIN au_eav_attributes_string as attrs ON entities.id = attrs.id_entity
WHERE entities.id = -1)
UNION ALL

(SELECT         
     entities.id as entity_id,
     entities.uuid as entity_uuid,
     entities.parent_uuid as parent_uuid,
     entities.entity_type,
     entities.module_name as entity_module,
     attrs.name as attr_name,
    attrs.value as attr_value,
     'text' as attr_type
FROM au_eav_entities as entities
      LEFT JOIN au_eav_attributes_text as attrs ON entities.id = attrs.id_entity
WHERE entities.id = -1)
UNION ALL

(SELECT         
     entities.id as entity_id,
     entities.uuid as entity_uuid,
     entities.parent_uuid as parent_uuid,
     entities.entity_type,
     entities.module_name as entity_module,
     attrs.name as attr_name,
    attrs.value as attr_value,
     'bool' as attr_type
FROM au_eav_entities as entities
      LEFT JOIN au_eav_attributes_bool as attrs ON entities.id = attrs.id_entity
WHERE entities.id = -1)
UNION ALL

(SELECT         
     entities.id as entity_id,
     entities.uuid as entity_uuid,
     entities.parent_uuid as parent_uuid,
     entities.entity_type,
     entities.module_name as entity_module,
     attrs.name as attr_name,
    attrs.value as attr_value,
     'datetime' as attr_type
FROM au_eav_entities as entities
      LEFT JOIN au_eav_attributes_datetime as attrs ON entities.id = attrs.id_entity
WHERE entities.id = -1)
UNION ALL

(SELECT         
     entities.id as entity_id,
     entities.uuid as entity_uuid,
     entities.parent_uuid as parent_uuid,
     entities.entity_type,
     entities.module_name as entity_module,
     attrs.name as attr_name,
    attrs.value as attr_value,
     'mediumblob' as attr_type
FROM au_eav_entities as entities
      LEFT JOIN au_eav_attributes_mediumblob as attrs ON entities.id = attrs.id_entity
WHERE entities.id = -1)
UNION ALL

(SELECT         
     entities.id as entity_id,
     entities.uuid as entity_uuid,
     entities.parent_uuid as parent_uuid,
     entities.entity_type,
     entities.module_name as entity_module,
     attrs.name as attr_name,
    attrs.value as attr_value,
     'double' as attr_type
FROM au_eav_entities as entities
      LEFT JOIN au_eav_attributes_double as attrs ON entities.id = attrs.id_entity
WHERE entities.id = -1)
[18:12:10.05][3b988497] DB ERROR < 42S22
1054
Unknown column 'entities.parent_uuid' in 'field list' [42S22]
[18:12:10.13][3b988497] API: AdminPanelWebclient::CreateTables
[18:12:10.13][3b988497] SELECT * FROM
     (
     SELECT
          # fields
          entities.id as attr_EntityId, entities.uuid as attr_UUID, entities.parent_uuid as attr_ParentUUID, entities.entity_type as attr_EntityType, entities.module_name as attr_ModuleName,
     `tbl_Login`.`value` as `attr_Login` #1
          # ------
     FROM au_eav_entities as entities #2
          #3 fields
          
     LEFT JOIN au_eav_attributes_string as `tbl_Login` ON `tbl_Login`.id_entity = entities.id AND `tbl_Login`.`name` = 'Login'
          # ------
     WHERE entities.entity_type = 'Aurora\\Modules\\Core\\Classes\\Channel' #4 ENTITY TYPE
           #5
           AND `tbl_Login`.`value` IS NOT NULL #6 WHERE
) AS S1
     ORDER BY `attr_Login` ASC #7 SORT
     LIMIT 1 /*8 LIMIT*/ OFFSET 0 /*9 OFFSET*/
[18:12:10.13][3b988497] DB ERROR < 42S22
1054
Unknown column 'entities.parent_uuid' in 'field list' [42S22]
[18:12:10.13][3b988497] Aurora\System\Exceptions\DbException: 42S22
1054
Unknown column 'entities.parent_uuid' in 'field list' [42S22] in C:\Inetpub\webmail\system\Db\Pdo\MySql.php:535
Stack trace:
#0 C:\Inetpub\webmail\system\Db\Pdo\MySql.php(336): Aurora\System\Db\Pdo\MySql->_setSqlError()
#1 C:\Inetpub\webmail\system\Db\Storage.php(189): Aurora\System\Db\Pdo\MySql->Execute('SELECT * FROM \n...')
#2 C:\Inetpub\webmail\system\Managers\Eav\Storages\Db\Storage.php(251): Aurora\System\Db\Storage->Execute('\nSELECT * FROM ...')
#3 C:\Inetpub\webmail\system\Managers\Eav\Storages\Db\Storage.php(285): Aurora\System\Managers\Eav\Storages\Db\Storage->getEntitiesUids('Aurora\\Modules\\...', 0, 1, Array, 'Login', 0)
#4 C:\Inetpub\webmail\system\Managers\Eav.php(220): Aurora\System\Managers\Eav\Storages\Db\Storage->getEntities('Aurora\\Modules\\...', Array, 0, 1, Array, 'Login', 0, Array)
#5 C:\Inetpub\webmail\modules\Core\Managers\Channels.php(61): Aurora\System\Managers\Eav->getEntities('Aurora\\Modules\\...', Array, 0, 1, Array, 'Login', 0)
#6 C:\Inetpub\webmail\modules\Core\Module.php(1499): Aurora\Modules\Core\Managers\Channels->getChannelList(0, 1)
#7 [internal function]: Aurora\Modules\Core\Module->CreateTables()
#8 C:\Inetpub\webmail\system\Module\AbstractModule.php(874): call_user_func_array(Array, Array)
#9 C:\Inetpub\webmail\system\Module\Decorator.php(41): Aurora\System\Module\AbstractModule->CallMethod('CreateTables', Array)
#10 C:\Inetpub\webmail\modules\AdminPanelWebclient\Module.php(25): Aurora\System\Module\Decorator->__call('CreateTables', Array)
#11 [internal function]: Aurora\Modules\AdminPanelWebclient\Module->CreateTables()
#12 C:\Inetpub\webmail\system\Module\AbstractModule.php(874): call_user_func_array(Array, Array)
#13 C:\Inetpub\webmail\modules\Core\Module.php(531): Aurora\System\Module\AbstractModule->CallMethod('CreateTables', Array, true)
#14 [internal function]: Aurora\Modules\Core\Module->EntryApi()
#15 C:\Inetpub\webmail\system\Module\AbstractModule.php(619): call_user_func_array(Array, Array)
#16 C:\Inetpub\webmail\system\Module\Manager.php(689): Aurora\System\Module\AbstractModule->RunEntry('api')
#17 C:\Inetpub\webmail\system\Application.php(87): Aurora\System\Module\Manager->RunEntry('api')
#18 C:\Inetpub\webmail\index.php(21): Aurora\System\Application::Start()
#19 {main}

Next Aurora\System\Exceptions\ApiException: 42S22
1054
Unknown column 'entities.parent_uuid' in 'field list' [42S22] in C:\Inetpub\webmail\system\Module\AbstractModule.php:896
Stack trace:
#0 C:\Inetpub\webmail\system\Module\Decorator.php(41): Aurora\System\Module\AbstractModule->CallMethod('CreateTables', Array)
#1 C:\Inetpub\webmail\modules\AdminPanelWebclient\Module.php(25): Aurora\System\Module\Decorator->__call('CreateTables', Array)
#2 [internal function]: Aurora\Modules\AdminPanelWebclient\Module->CreateTables()
#3 C:\Inetpub\webmail\system\Module\AbstractModule.php(874): call_user_func_array(Array, Array)
#4 C:\Inetpub\webmail\modules\Core\Module.php(531): Aurora\System\Module\AbstractModule->CallMethod('CreateTables', Array, true)
#5 [internal function]: Aurora\Modules\Core\Module->EntryApi()
#6 C:\Inetpub\webmail\system\Module\AbstractModule.php(619): call_user_func_array(Array, Array)
#7 C:\Inetpub\webmail\system\Module\Manager.php(689): Aurora\System\Module\AbstractModule->RunEntry('api')
#8 C:\Inetpub\webmail\system\Application.php(87): Aurora\System\Module\Manager->RunEntry('api')
#9 C:\Inetpub\webmail\index.php(21): Aurora\System\Application::Start()
#10 {main}
Back to Top View lazna's Profile Search for other posts by lazna
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6168
Posted: 23 May 2018 at 3:08am | IP Logged Quote Igor
Can you please confirm you're running the latest 8.1.12 version? It can be found as shown here.

--
Regards,
Igor, Afterlogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
lazna
Newbie
Newbie


Joined: 12 July 2014
Online Status: Offline
Posts: 17
Posted: 24 May 2018 at 3:17am | IP Logged Quote lazna
After upgrade to 8.1.12-build-a3 problem persist
Back to Top View lazna's Profile Search for other posts by lazna
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6168
Posted: 24 May 2018 at 3:18am | IP Logged Quote Igor
You mean you've created the new installation of 8.1.12, correct?

--
Regards,
Igor, Afterlogic Support
Back to Top View Igor's Profile Search for other posts by Igor
 
lazna
Newbie
Newbie


Joined: 12 July 2014
Online Status: Offline
Posts: 17
Posted: 24 May 2018 at 3:45am | IP Logged Quote lazna
Download last version, unpacked content of ZIP file into the directoty containing old version (overwriting files with same name). Than restart web server to ensure new files are loaded into memory.
Back to Top View lazna's Profile Search for other posts by lazna
 
Igor
AfterLogic Support
AfterLogic Support


Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6168
Posted: 24 May 2018 at 3:47am | IP Logged Quote Igor
OK but you also need to delete all tables from the database, and then run Create Tables again.

--
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