MAILBEE POP3 SMTP WEBMAIL IMAP4 POP IMAP EMAIL COMPONENT VB ASP ACTIVEX COM VBA OCX NET .NET C# VB.NET ASP.NET DOWNLOAD QUEUE SSL SECURITY CENSOR ACCESS PARSER C++ DLL CONTROL LIBRARY MIME INTERFACE

AfterLogic WebMail Lite

AfterLogic Forum : AfterLogic WebMail Lite

Topic: Error: "Creating tables has failed"

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

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}

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6038

Posted: 23 May 2018 at 3:08am \| IP Logged

Can you please confirm you're running the latest 8.1.12 version? It can be found as shown here.

--
Regards,
Igor, Afterlogic Support

lazna
Newbie
Newbie

Joined: 12 July 2014
Online Status: Offline
Posts: 17

Posted: 24 May 2018 at 3:17am \| IP Logged

After upgrade to 8.1.12-build-a3 problem persist

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6038

Posted: 24 May 2018 at 3:18am \| IP Logged

You mean you've created the new installation of 8.1.12, correct?

--
Regards,
Igor, Afterlogic Support

lazna
Newbie
Newbie

Joined: 12 July 2014
Online Status: Offline
Posts: 17

Posted: 24 May 2018 at 3:45am \| IP Logged

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.

Igor
AfterLogic Support

Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6038

Posted: 24 May 2018 at 3:47am \| IP Logged

OK but you also need to delete all tables from the database, and then run Create Tables again.

--
Regards,
Igor, Afterlogic Support

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

Printable version

Forum Jump

.NET Components

ActiveX Components

Web scripts

Solutions

AfterLogic WebMail Lite