Published date not set and unable to perform update #12

[Mats]

One of my sites is unable to perform update #12 and therefore not able to set published date. 

I've found some  similar issues but no solution has worked so far. Any ideas in how to get this working is highly appreciated.

[BitPoet]

Try adding this in site/config.php:

$config->dbSqlModes = array(
	"5.5.0" => "remove:STRICT_TRANS_TABLES,STRICT_ALL_TABLES,NO_ZERO_IN_DATE,ONLY_FULL_GROUP_BY"
);

 

[Mats]

Thanks @BitPoet! I'll try that.

[Mats]

Now i get this error in the SystemUpdaterModule: 

2018-01-26 19:30:40 ERROR: Update #12 ERROR: Failed to apply update 12 - SQLSTATE[HY000]: General error: 1 Can't create/write to file '/tmp/#sql_7b5f3_0.MYD' (Errcode: 28)

 

[BitPoet]

Looks like your tmp (root if not a separate drive) partition is running out of space (error code 28 = No space left on device).

[Mats]

Still no luck with this code. 

Why is the published filed a datetime field and created and modified timestamps?

[BitPoet]

Did you make some space in /tmp?

[Mats]

I changed the host so that error is gone. 

[BitPoet]

Can you show us the output of

SHOW VARIABLES LIKE 'sql_mode';

from MySQL? Which PW version are you installing / upgrading to?

[Mats]

Not sure on how to show sql_mode? 

sql_mode: NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION

I'm on ProcessWire 3.0.89 and Maria DB now.

 

[BitPoet]

What's the exact error you get?

[Mats]

I cant find any errors but the "Update #12: Initializing"  shows up in the system-updater log and in the SystemUpdaterModule every third second. 
If bypass the update (skip to update 13) the published date is saved but the existing pages doesn't seem to get any published date set:

From a another PW-site:
Update #12: Completed!
Update #12: Populated values to 'published' for 86 pages
Update #12: Added 'published' column to pages table 
Update #12: Initializing update