Mats Posted January 26, 2018 Share Posted January 26, 2018 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. Link to comment Share on other sites More sharing options...
BitPoet Posted January 27, 2018 Share Posted January 27, 2018 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" ); 1 Link to comment Share on other sites More sharing options...
Mats Posted January 27, 2018 Author Share Posted January 27, 2018 Thanks @BitPoet! I'll try that. Link to comment Share on other sites More sharing options...
Mats Posted January 27, 2018 Author Share Posted January 27, 2018 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) Link to comment Share on other sites More sharing options...
BitPoet Posted January 27, 2018 Share Posted January 27, 2018 Looks like your tmp (root if not a separate drive) partition is running out of space (error code 28 = No space left on device). 1 Link to comment Share on other sites More sharing options...
Mats Posted January 28, 2018 Author Share Posted January 28, 2018 Still no luck with this code. Why is the published filed a datetime field and created and modified timestamps? Link to comment Share on other sites More sharing options...
BitPoet Posted January 28, 2018 Share Posted January 28, 2018 Did you make some space in /tmp? Link to comment Share on other sites More sharing options...
Mats Posted January 28, 2018 Author Share Posted January 28, 2018 I changed the host so that error is gone. Link to comment Share on other sites More sharing options...
BitPoet Posted January 28, 2018 Share Posted January 28, 2018 Can you show us the output of SHOW VARIABLES LIKE 'sql_mode'; from MySQL? Which PW version are you installing / upgrading to? Link to comment Share on other sites More sharing options...
Mats Posted January 28, 2018 Author Share Posted January 28, 2018 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. Link to comment Share on other sites More sharing options...
BitPoet Posted January 28, 2018 Share Posted January 28, 2018 What's the exact error you get? Link to comment Share on other sites More sharing options...
Mats Posted January 28, 2018 Author Share Posted January 28, 2018 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 Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now