Date index for Mar 2003
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Upgrade to 0.9.2 failure
- To: Date: Wed, 19 Mar 2003 10:14:48 +0100
- Delivered-to: mailing list achievo dot
- Mailing-list: contact achievo-help dot
- User-agent: Mozilla/5.0 (X11; U; SunOS sun4us; en-US; rv:1.1) Gecko/20020827
First, line 259 of class.setup.inc must be altered to
else if (in_array("schedule", $tablenames) && in_array("schedule_types",
$tablenames))
(missing the last $tablenames)
Secondly, I get the following errors:
*Upgrading from version 0.9*
Below is the result of the conversion. Please review if there are any
errors.
Also take note of any important messages.
Start of conversion from 0.9 to 0.9.1
Conversion of 0.9 to 0.9.1 complete.
Start of conversion from 0.9.1 to 0.9.2
*Conversion failed!*
[+00.68324s] Duplicate entry '0' for key 1 (errno: 1062)
[+00.68329s] Invalid SQL: ALTER TABLE hours_lock DROP PRIMARY KEY, ADD
PRIMARY KEY(id)
Conversion of 0.9.1 to 0.9.2 failed, stopping conversion.
*Please restore your backup*. Contact the Achievo developers who might
help you out in finding the cause of failure.
A dump from hours_lock gives the following result (after failed conversion);
+--------+---------------+----+
| week | userid | id |
+--------+---------------+----+
| 200235 | sofia23 | 0 |
| 200236 | sofia23 | 0 |
| 200237 | sofia23 | 0 |
| 200238 | sofia23 | 0 |
| 200239 | sofia23 | 0 |
| 200240 | sofia23 | 0 |
| 200235 | administrator | 0 |
....
Any ideas?
/Jonas