Upgrade error version OJS 3.4.0.5 to 3.4.0.6

Hello all,

I ran into a small error it seems during my last upgrade: 2024-08-04 19:09:51 [downgrade for "PKP\migration\upgrade\v3_4_0\I9830_FixEmptyUserLocales" unsupported: Downgrade not supported] ERROR: Upgrade failed: DB: SQLSTATE[22007]: Invalid datetime format: 1292 Truncated incorrect DOUBLE value: 'start' (SQL: update submissionssetsubmission_progress= wheresubmission_progress = 0)

Due to this the upgrade process will not continue.,

Any pointers and assistance are welcome!

Hi @Zarevac,

See:

Regards,
Alec Smecher
Public Knowledge Project Team

Thnx @asmecher , tried that and the error persists. Check the table itself and I have 25 entries like this: INSERT INTO submissions (submission_id, context_id, current_publication_id, date_last_activity, date_submitted, last_modified, stage_id, locale, status, work_type, submission_progress) VALUES (11, 1, 11, '2024-03-10 09:30:26', '2023-08-31 07:07:36', '2023-08-31 07:07:36', 5, 'en', 3, 0, ''),

Hi @Zarevac,

Can you clarify what you tried?

Thanks,
Alec Smecher
Public Knowledge Project Team

@asmecher nvm, I’m a knucklehead today. It worked (really stupid wont put it here so stupid).
But I applied the fix in the upgrade files and that worked :slight_smile:

Hi @Zarevac,

Not a problem, been there :slight_smile:

Regards,
Alec Smecher
Public Knowledge Project Team

This topic was automatically closed after 11 days. New replies are no longer allowed.