First, I backed up the mysql db, and also took a snapshot of the Windows VM that is my OA host. I ran the upgrade, everything finished without error. But when I go to the OA Community logon page, I get the upgrade box, select that, and it keeps failing with the following error:
A Database Error Occurred
Error Number: 1467
Failed to read auto-increment value from storage engine
INSERT INTO `oa_location` (SELECT NULL, `name`,`type`,`room`,`suite`,`level`,`address`,`suburb`,`city`,`district`,`region`,`area`,`state`,`postcode`,`country`,`tags`,`phone`,`picture`,`latitude`,`longitude`,`geo`,`comments`,`icon`, `group_id` FROM `oa_location` WHERE id = 1)
Filename: C:\xampplite\open-audit\code_igniter\system\database\DB_driver.php
Line Number: 330
If there isn't an easy fix, wondering if I should setup a new OA 2.0.3 system, and restore from the mysql backup to populate all of the data? I already reverted back to 1.12.10 via the snapshot, but can easily try the upgrade again if there is a fix for this error
_________________ Server Info: running on a CentOS 7 vm OA Version: 2.0.6 @ 500 devices
|