Date index for Oct 2003

Hi,

As for the scheduler, I can't find anything profile related in the menus.
Could you specify where I might find it?

When I try to upgrade the database, it detects I have a 0.8 database.
The output:

Start of conversion from 0.8 to 0.9.

Conversion failed!
[+00.44000s] Can't DROP 'currency'. Check that column/key exists (errno:
1091)
[+00.44039s] Invalid SQL: ALTER TABLE customer DROP currency

Conversion of 0.8 to 0.9 failed, stopping conversion.

I manually added the currency column so it is actually able to drop the
column and continue.
When I run the converter on the manually altered database:

Start of conversion from 0.8 to 0.9.
Conversion of 0.8 to 0.9 complete.

Start of conversion from 0.9 to 0.9.1.

Conversion failed!
[+00.14758s] Duplicate column name 'abbreviation' (errno: 1060)
[+00.14795s] Invalid SQL: ALTER TABLE project ADD abbreviation varchar(10)
[+00.24100s] Duplicate column name 'updated' (errno: 1060)
[+00.24138s] Invalid SQL: ALTER TABLE todo ADD updated datetime

Conversion of 0.9 to 0.9.1 failed, stopping conversion.

I checked the database and those two columns are already there.
I think achievo incorrectly detects my database version. I checked /upgrade
scripts, and I think I have a database somewhere between 0.6 and 0.8 as for
example I do not have the customer.currency field, but I do have the
(slightly different, though) hours_lock table.

I checked the upgrade scripts that came with my achievo 0.8 and I noticed
that the 0.6 to 0.8 update script differs from the 1.0 0.6-to-0.8 script....
maybe that's where things go wrong as achievo 1.0 expects me to have a
different 0.8 database than achievo 0.8 once created?

I hope you can help me...

PS: the duplicate keys only occur after I manually execute some of the SQL
queries in the /upgrade directory.

If you really want some table structures, I'd be happy to do a structure
dump for you...

Martin


> Martin wrote:
>
> > I am trying to upgrade from 0.8 to 1.0 RC1. After some initial problems
with
> > the setup.php script which tried to upgrade my database to 1.0,
everything
> > seemed to be ok. Except that regular users (non-administrator) are
unable to
> > access the scheduler. Anyone experienced the same or any trouble
upgrading
> > to 1.0RC1? I had a lot of MySQL errors about duplicate keys...
>
> Hmm, hard to tell what went wrong without the actual output. About the
> scheduler problem, did you check the profiles section and looked if the
> security profiles were converted correctly?
>
> The mysql errors sound scary. Is there a possibility that you would send
> me your 0.8 database (perhaps with anonimised data if you prefer) so I
> can run a test and see what went wrong? Perhaps there are some
> situations which the setup.php script does not handle gracefully yet.
>
> Greetings,
> Ivo