Changing files through the web interface isn't really recommended, but it's an option for those that do not use git, or are away from their computer.To contribute to a translation directly from Git website: The Textpack tool will sync your alterations to all other Textpack files.safe_update('textpattern', "Posted = NOW()", "DATE(Posted) = 0"); safe_update('textpattern', "Expires = NULL", "DATE(Expires) = 0"); safe_update('textpattern', "Last Mod = Posted", "DATE(Last Mod) = 0"); safe_update('txp_discuss', "posted = NOW()", "DATE(posted) = 0"); safe_update('txp_file', "created = NOW()", "DATE(created) = 0"); safe_update('txp_file', "modified = created", "DATE(modified) = 0"); safe_update('txp_image', "date = NOW()", "DATE(date) = 0"); safe_update('txp_link', "date = NOW()", "DATE(date) = 0"); safe_update('txp_users', "last_access = NULL", "DATE(last_access) = 0"); safe_update('textpattern', "feed_time = DATE(Posted)", "feed_time = 0"); I have no idea if that works under other My SQL clients that don't have that setting applied. (The same might be true in Percona, which is you can't find the actual setting.If it does, then maybe it's a good enough patch to help both camps of people. You'd probably have to turn off strict mode altogether.) At any rate, your suggested fix works for me, at least in the sense that the admin area is functional, without errors.Whether it actually selects zero-valued dates in strict mode - or even whether it is possible to have legacy zero-valued dates in strict mode (for example, by having an installation where it was turned off in the past, had some zero-value dates inserted, then turned on) - I have no idea.But at least this works in a fresh install on current My SQL versions with their default settings.I wanted to change my author name associated with the field is set to “Jonathan” and replaces all instances with “Jonathan Stubbs”.Couple days back there was a commenter with the same name so I thought I should change my comments name too.
Many users of Textpattern like to use rss_admin_db_manager to tweak or update their sites. Go to textpattern.com/download and download the zip package of the latest version to your local machine. In brief, you’ll backup your current installation, overwrite your existing installation with new package files (with a few key exceptions), update your language preference(s), and address any problems indicated in the Diagnostics panel.As with any system upgrade, you’ll want to be sure you can fall back on your existing install should there ever be a problem; thus, you should back up your server files and create a database dump file ( file as a minimum.Make a copy of the current system (folders and files of the Textpattern installation).