Title: Error update version 6.4.0 Last modified: January 21, 2022 --- # Error update version 6.4.0 * Resolved [escael](https://wordpress.org/support/users/escael/) * (@escael) * [4 years, 7 months ago](https://wordpress.org/support/topic/error-update-version-6-4-0/) * Hi, * After update the latest version, i had the next error: * [You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ‘CURRENT_TIMESTAMP’ at line 1] * ALTER TABLE wp_ewwwio_images ALTER updated SET DEFAULT CURRENT_TIMESTAMP * Thanks - This topic was modified 4 years, 7 months ago by [escael](https://wordpress.org/support/users/escael/). Viewing 12 replies - 1 through 12 (of 12 total) * [le.mag.cinema](https://wordpress.org/support/users/lemagcinema/) * (@lemagcinema) * [4 years, 7 months ago](https://wordpress.org/support/topic/error-update-version-6-4-0/#post-15279182) * After 6.4.0 installation I personnaly get a message on my administration interface of wordpress: You’ve got a critical error. Check your email administration address, or something like that … (but I did not receive any error, nor am I able to see any error on my error files ) * PS: I am on PHP 8.1 * Did you get the same behaviour ? * I had to go back to 6.3.0 (6.4.0) definitely breaks my wordpress administration page. * Plugin Author [Shane Bishop](https://wordpress.org/support/users/nosilver4u/) * (@nosilver4u) * [4 years, 6 months ago](https://wordpress.org/support/topic/error-update-version-6-4-0/#post-15284666) * [@escael](https://wordpress.org/support/users/escael/) I’m not sure how that’s possible, but we’ve had trouble before with older versions of MySQL that couldn’t handle that syntax for updating the table. * I’ll note that if you’re on PHP 8.1, that might be a possible lead on the error [@lemagcinema](https://wordpress.org/support/users/lemagcinema/) is experiencing. One of the changes in PHP 8.1 was to make MySQL errors into Exceptions–which means they could become fatal errors if WordPress is not catching them like it previously caught MySQL errors. * At any rate, if you could (both) post the site health report from Tools->Site Health, that might shed some light on a MySQL version that we haven’t accounted for yet. * Thread Starter [escael](https://wordpress.org/support/users/escael/) * (@escael) * [4 years, 6 months ago](https://wordpress.org/support/topic/error-update-version-6-4-0/#post-15284704) * Hi, sorry by not said before, but i am indeed using php version 8.1.1 * WP version: 5.8.8. Latest version Mysql: 8.0.27-0ubuntu0.20.04.1 for Linux on x86_64 Redis server v=5.0.7 * I hope can help you * Thanks * Plugin Author [Shane Bishop](https://wordpress.org/support/users/nosilver4u/) * (@nosilver4u) * [4 years, 6 months ago](https://wordpress.org/support/topic/error-update-version-6-4-0/#post-15285693) * Ugh, confirmed on my dev server running 8.0.27 also. I had figured that if MariaDB fixed the bug, surely MySQL 8 would have the fix also. But sadly not… You can manually set the default value for the ‘updated’ column to CURRENT_TIMESTAMP, but I’ll add a conditional for MySQL 8.0.x to make sure the next update uses the fall-back (slower) table upgrade method. * [le.mag.cinema](https://wordpress.org/support/users/lemagcinema/) * (@lemagcinema) * [4 years, 6 months ago](https://wordpress.org/support/topic/error-update-version-6-4-0/#post-15286310) * quite same configuration for me: php 8.1 and mysql 8 … as for now, I wait for the 6.4.1 release to fix it before upgrading … * Plugin Author [Shane Bishop](https://wordpress.org/support/users/nosilver4u/) * (@nosilver4u) * [4 years, 6 months ago](https://wordpress.org/support/topic/error-update-version-6-4-0/#post-15286499) * Hi folks, I’ve pushed a fix for the MySQL 8 glitch to our GitHub repo: [https://docs.ewww.io/article/73-update-from-github](https://docs.ewww.io/article/73-update-from-github) * Please confirm whether this resolves the MySQL issue–the plugin should be able to set the default value for the ‘updated’ column to CURRENT_TIMESTAMP. * [@lemagcinema](https://wordpress.org/support/users/lemagcinema/) if the fix resolves your issue, please do let me know. Still don’t know 100% if the two are connected since I don’t have any sites on PHP 8.1, but it’s a definite possibility. * [le.mag.cinema](https://wordpress.org/support/users/lemagcinema/) * (@lemagcinema) * [4 years, 6 months ago](https://wordpress.org/support/topic/error-update-version-6-4-0/#post-15288304) * I prefer not to install a version directly from github but instead wait for the 6.4.1 update. I do not need the 6.4.0 features for now. * (+ I guess you are able to install quickly a mysql 8 and check by yourself !) * Plugin Author [Shane Bishop](https://wordpress.org/support/users/nosilver4u/) * (@nosilver4u) * [4 years, 6 months ago](https://wordpress.org/support/topic/error-update-version-6-4-0/#post-15289217) * [@lemagcinema](https://wordpress.org/support/users/lemagcinema/) My dev site already is running MySQL 8, so that much I could easily verify 🙂 * We still don’t know whether your PHP 8.1 issue is connected to this one though, and I’ve had no other similar reports. * [@escael](https://wordpress.org/support/users/escael/) When you had that MySQL error, did it break the wp-admin like [@lemagcinema](https://wordpress.org/support/users/lemagcinema/) reported here: [https://wordpress.org/support/topic/fatal-error-when-upgrading-to-6-4-0/](https://wordpress.org/support/topic/fatal-error-when-upgrading-to-6-4-0/) * Thread Starter [escael](https://wordpress.org/support/users/escael/) * (@escael) * [4 years, 6 months ago](https://wordpress.org/support/topic/error-update-version-6-4-0/#post-15290202) * Hi, [@nosilver4u](https://wordpress.org/support/users/nosilver4u/) the latest version fix the problem. I have tested it in my local development and not problem. * About your mysql ask, it’s correct did broken the admin. * I wait for the finish version to upgrade in production environment. * Thank a lot * Plugin Author [Shane Bishop](https://wordpress.org/support/users/nosilver4u/) * (@nosilver4u) * [4 years, 6 months ago](https://wordpress.org/support/topic/error-update-version-6-4-0/#post-15290205) * Perfect, thanks for confirming! We’ll release the fix later this week or early next. * Plugin Author [Shane Bishop](https://wordpress.org/support/users/nosilver4u/) * (@nosilver4u) * [4 years, 6 months ago](https://wordpress.org/support/topic/error-update-version-6-4-0/#post-15298996) * I wanted to note that if folks are using WP 5.9, this should not be an issue anymore. They’ve worked a lot on PHP 8.0 & 8.1 compat for the 5.9 release which includes “reverting” the MySQL behavior change for SQL errors. * Thread Starter [escael](https://wordpress.org/support/users/escael/) * (@escael) * [4 years, 6 months ago](https://wordpress.org/support/topic/error-update-version-6-4-0/#post-15299750) * hi, that’s correct, the problem was fixed with the latest version of WP * Thanks - This reply was modified 4 years, 6 months ago by [escael](https://wordpress.org/support/users/escael/). Viewing 12 replies - 1 through 12 (of 12 total) The topic ‘Error update version 6.4.0’ is closed to new replies. * ![](https://ps.w.org/ewww-image-optimizer/assets/icon-256x256.png?rev=1582276) * [EWWW Image Optimizer](https://wordpress.org/plugins/ewww-image-optimizer/) * [Frequently Asked Questions](https://wordpress.org/plugins/ewww-image-optimizer/#faq) * [Support Threads](https://wordpress.org/support/plugin/ewww-image-optimizer/) * [Active Topics](https://wordpress.org/support/plugin/ewww-image-optimizer/active/) * [Unresolved Topics](https://wordpress.org/support/plugin/ewww-image-optimizer/unresolved/) * [Reviews](https://wordpress.org/support/plugin/ewww-image-optimizer/reviews/) * 12 replies * 3 participants * Last reply from: [escael](https://wordpress.org/support/users/escael/) * Last activity: [4 years, 6 months ago](https://wordpress.org/support/topic/error-update-version-6-4-0/#post-15299750) * Status: resolved