Trending
Heat Index
Posts Tagged ‘trick’
Most Recent
 
Read More
October 8, 2019

WordPress and MySQL: fixing the wp_options table

We had a weird problem when moving a WordPress website for a customer: after DUMPing it out of MySQL, we noted that the wp_options table had a problem, namely the table had no primary key and no index on the option_name field. We noted that because the WordPress website, once moved, looked akward and wrong, missing some key pieces and it also seemed to use settings that were old. The reason was that, with primary key missing, lots of duplicate records were stored inside the table and I’m pretty sure it was not what the website was meant to do. Field option_id was set to 0 in most cases when it should have been an auto-incremented integer plus it seemed [...]

142
End of the line!
Latest Windows news
 
Read More
35
 
Read More
279
 
Read More
72

Trending Topics
News
Development
Security
Executive
editor pick
sicurezza
Web Technologies
PHP
windows azure pack
Follow Us
Top Stories
 
 
 
 
 
 
 
 
Right Now
 
Acronis agent not registered, Windows Server core and SSL issues
 
 
 
 
 
Top Five
Heat Index
 
1
Must Read:How to run PHP 7 x64/x86 on Windows Azure Pack
 
2
Visual Studio: how to run Windows Phone and Android emulators in a virtual machine
 
3
Must Read:Say hello to next-gen Server Manager: Microsoft introduces project “Honolulu”
 
4
Must Read:La sentenza della Corte Europea di Giustizia sul Safe Harbour è la prima risposta al caso Snowden
 
5
Must Read:How to containerize Windows Admin Center