ERROR: Upgrade failed: DB: SQLSTATE[22004]: Null value not allowed: 1138 Invalid use of NULL value (SQL: ALTER TABLE email_log CHANGE assoc_type assoc_type BIGINT NOT NULL, CHANGE assoc_id assoc_id BIGINT NOT NULL)

Software Support
, ,
1

while trying to upgrade from ojs-3.2.1-5 to ojs-3.3.0-19 i have encountered following error

ERROR: Upgrade failed: DB: SQLSTATE[22004]: Null value not allowed: 1138 Invalid use of NULL value (SQL: ALTER TABLE email_log CHANGE assoc_type assoc_type BIGINT NOT NULL, CHANGE assoc_id assoc_id BIGINT NOT NULL)

is it safe to delete ?
DELETE FROM email_log WHERE assoc_id IS NULL;

or

any other suggestions?

@asmecher please help

2

Hi @suresh_patil,

Yes, you can delete those rows – though I’d suggest looking through them first to see if there’s anything you consider important.

Regards,
Alec Smecher
Public Knowledge Project Team

3

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