Error upgrading OJS database from 2.1.0-1 to 2.1.1

[mgoay]

I encountered the following error message when performing OJS database upgrade at command-line or web:

[data: upgrade/2.1.1_update.xml]
ERROR: Upgrade failed: DB: Field 'last_run' doesn't have a default value

At subsequent runs of the upgrade command, I encountered

[data: upgrade/2.1.1_update.xml]
ERROR: Upgrade failed: DB: Duplicate entry 'OPEN_ACCESS_NOTIFY' for key 2

Are these errors benign? I would appreciate any suggestions for how to correct the errors.

Many thanks,
Michael

[asmecher]

Hi Michael,

What DBMS and version are you running? This may be an ADODB bug -- if the schema is being correctly updated according to the schema descriptor, you shouldn't receive the message about last_run being null. (The subsequent error occurs because the updater is trying to insert a row that has already been inserted -- you can ignore this.)

I'd suggest the following. Update OJS's versions list manually with the following:

Code: Select all

UPDATE versions SET current = 0;
INSERT INTO versions (major, minor, revision, build, date_installed, current) VALUES (2, 1, 1, 0, now(), 1);

Now try running tools/upgrade.php with the "upgrade" command to re-sync the database schema with the XML descriptor.

Let me know if this works and if you're still receiving error messages.

Regards,
Alec Smecher
Open Journal Systems Team

[mgoay]

Awesome! That works.

I run MySQL 5.0.22.

Many thanks, Alec.

Regards,
Michael

[yaliang]

Dear Alec:

When I try to upgrade my OJS system from 2.1.0.1 to 2.1.1 with a full package, I got the following error message via the upgrade option of "If you are upgrading an existing installation of OJS 2.x, click here to proceed."

Errors occurred during installation:
A database error has occurred: Field 'last_run' doesn't have a default value

Could you give me any suggestion to solve the problem?

Thank you very much.

Yaliang

[asmecher]

Hi Yaliang,

The above instructions should complete the upgrade, or, if you'd rather start the upgrade again from backup, run the following command first:

Code: Select all

ALTER TABLE scheduled_tasks MODIFY COLUMN last_run datetime;

Then perform the upgrade as usual. Either way will work.

Regards,
Alec Smecher
Open Journal Systems Team

[yaliang]

Dear Alec:

Thanks for your help.
My ojs system was successfully updated.

Best wishes,

Yaliang