MySQL database incompatibility when going from 4.0 to 4.1?

Question

question

dclaar Suspended asked Jan 10, '11 dclaar Suspended posted Jan 10, '11

MySQL database incompatibility when going from 4.0 to 4.1?

Just updated to iTest 4.1. Now I cannot access the external report database! It complains that the format is wrong.

Well actually, I uninstalled 4.0 and installed 4.1. If I had done an actual update, would the database have been updated? If not, then this should be a huge big red flag! I was unable to find anything in the documentation about this issue: It should be very prominent. Fortunately, I don't have a lot in the database as of yet, but I'd be really unhappy if I did and there was no upgrade path.

Also, the error message does not appear to have been stored anywhere.

iTest installation - licensing documentation

10 |950

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Answer 1 · 2011-01-10T22:51:28Z

dclaar Suspended answered Jan 10, '11 dclaar Suspended posted Jan 10, '11

Oh, I see iTest External TestReport Database Update.sql, which appears to fix the problem. So we're back to documentation.

1

10 |950

Attachments: Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

RoyL commented · Jan 13, 2011 at 08:19 PM

To update the external database schema when upgrading iTest:

An admin user who is familiar with running SQL scripts should run the MySqlUpdate.sql script against the central reporting database schema.

The script appears in the

\installer\deliverables\external_database

folder of the iTest delivery .

Tip: You will find general instructions on running SQL scripts in the script that is used during initial database installation: MySqlSchema.sql (in the same folder).

(Thanks for discovering this doc issue, Doug. We added the info to the iTest Installation instructions.)

0 ·

question