| Author |
|
schwim
Valued Community Member
Joined: 21 November 2017
Location: United States
Online Status: Offline
Posts: 49
|
| Posted: 11 October 2018 at 3:23pm | IP Logged
|
|
|
Hi there guys,
Following this upgrade documentation, I retained the data directory from the original install but uploaded the rest of the 8.2.2.
Running update_dav.php, I got the following output:
Quote:
Detected MySQL.
Upgrading 'au_adav_calendars'
The 'synctoken' field already exists in the au_adav_calendars table.
It's likely you already upgraded, so we're simply leaving
the au_adav_calendars table alone
'au_adav_calendarchanges' already exists. Assuming that this part of the
upgrade was already completed.
Upgrading 'au_adav_addressbooks'
The 'synctoken' field already exists in the au_adav_addressbooks table.
It's likely you already upgraded, so we're simply leaving
the au_adav_addressbooks table alone
'au_adav_addressbookchanges' already exists. Assuming that this part of the
upgrade was already completed.
'calendarsubscriptions' already exists. Assuming that this part of the
upgrade was already completed.
'propertystorage' already exists. Assuming that this part of the
upgrade was already completed.
Upgrading cards table to 2.0 schema
Reading all old vcards and populating etag and size fields.
Upgrade to 2.0 schema completed.
Detected MySQL.
Upgrading 'au_adav_calendarobjects'
uid field exists. Assuming that this part of the migration has
Already been completed.
Creating 'schedulingobjects'
Done.
Upgrade to 2.1 schema completed.
Detected MySQL.
Upgrading 'propertystorage'
No data in table. Going to re-create the table.
Renaming propertystorage -> propertystorage_old9337 and creating new table.
Migrating vcardurl
Can't migrate vcardurlDone.
Upgrade to 3.0 schema completed.
Detected MySQL.
Creating 'calendarinstances'
calendarinstances exists. Assuming this part of the migration has already been done.
The calendars table has 3 columns already. Assuming this part of the migration was already done.
Upgrade to 3.2 schema completed.
Start UpgradePrincipals in calendarinstances table
Exception: ApiException in /home/schw/public_html/mail/system/Managers/Eav.php on line 254
|
|
|
Now I'm unable to use the mail system. When I try to login, I get the following error:
Quote:
| The username or password you entered is incorrect. (42S02 1146 Table 'schw_afterlogicpro.au_eav_attributes_bigint' doesn't exist [42S02]) |
|
|
Can anyone get me back into my mail system?
|
| Back to Top |
|
| |
Igor
AfterLogic Support
Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
|
| Posted: 11 October 2018 at 11:11pm | IP Logged
|
|
|
That's a known issue with 8.2.2, to work around it please try running the following queries:
Code:
USE databasename;
SET @prefix = 'au_';
SET @sql2 = CONCAT("CREATE TABLE IF NOT EXISTS ", @prefix, "eav_attributes_bigint (
`id` BIGINT(64) UNSIGNED NOT NULL AUTO_INCREMENT,
`id_entity` BIGINT(64) UNSIGNED DEFAULT NULL,
`name` VARCHAR(255) DEFAULT NULL,
`value` BIGINT(64),
PRIMARY KEY (`id`),
UNIQUE KEY `idx_unique` (`id_entity`, `name`),
KEY `fk_id_entity_idx` (`id_entity`),
CONSTRAINT ", @prefix, "fk_eav_attributes_bigint_id_entity FOREIGN KEY (`id_entity`) REFERENCES ", @prefix, "eav_entities (`id`)
ON DELETE CASCADE
ON UPDATE NO ACTION
)
ENGINE = InnoDB
AUTO_INCREMENT = 1
DEFAULT CHARSET = utf8;");
PREPARE stmt2 FROM @sql2;
EXECUTE stmt2;
DEALLOCATE PREPARE stmt2; |
|
|
The database name used in the first line is DBName value from data/settings/config.json file, the database prefix in the next line is DBPrefix from that same file.
Upon performing the above queries, try running dev/update_dav.php again.
Hope this helps.
--
Regards,
Igor, Afterlogic Support
|
| Back to Top |
|
| |
Igor
AfterLogic Support
Joined: 24 June 2008
Location: United States
Online Status: Offline
Posts: 6104
|
| Posted: 11 October 2018 at 11:14pm | IP Logged
|
|
|
Also, for now, we've added a link to this forum post to the upgrading instructions.
--
Regards,
Igor, Afterlogic Support
|
| Back to Top |
|
| |
MailBee.NET Objects 
MailBee.NET Queue 
MailBee Objects 
WebMail Pro PHP 
AfterLogic Aurora 
MailSuite Pro for Linux 
Unified Messaging Solution 
Search
Register
Login
Topic: 8.2.0 -> 8.2.2 upgrade failed
Privacy policy |
Refund policy