Παρουσίαση με Ετικέτες

• 2038
• Corruption
• Data
• DateTime
• Fix
• Future
• Overflow
• phpMyAdmin
• SQL
• Timestamp
• Types
• Updates
• WordPress
• wp_options

Fix: WordPress not detecting updates, wp_options table corruption
26 Ιανουαρίου 21 05:35 μμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   

I have been trying recently to troubleshoot a WordPress website that was not detecting available core and plugin updates. So I installed WordPress Debug Bar plugin and after enabling WP_DEBUG in wp-config.php I could open the Debug menu from the WordPress admin bar and see some errors being logged. At the wp-content/wp-debug.log file that I […]

Δημοσίευση στην κατηγορία: WordPress, Posts, Fix, Updates, Database, Corruption, MySQL, phpMyAdmin, wp_options

MySQL DATETIME vs TIMESTAMP and the year 2038
01 Νοεμβρίου 19 09:45 πμ | Μπιρμπίλης Γεώργιος | 0 σχόλια   

Judging from MySQL documentation at https://dev.mysql.com/doc/refman/8.0/en/datetime.html, it sounds best to use DATETIME rather than TIMESTAMP if you want your database to be future proof. After all 2038 is only 18+ years away. The DATETIME type is used for values that contain both date and time parts. MySQL retrieves and displays DATETIME values in 'YYYY-MM-DD HH:MM:SS' […]

Δημοσίευση στην κατηγορία: Posts, Data, Database, Types, SQL, DateTime, Future, Timestamp, Overflow, 2038, MySQL