Trending
Heat Index

Notice: Undefined variable: posts in /home/theserverside/public_html/wp-content/themes/engine/functions/theme.php on line 388

Notice: Trying to access array offset on value of type null in /home/theserverside/public_html/wp-content/themes/engine/functions/theme.php on line 388
Posts Tagged ‘mysql’
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 [...]

690
End of the line!
Latest Windows news
 
Read More
61
 
Read More
60
 
Read More
2902

Trending Topics
windows server
Development
hyper-v
News
SysAdmins
windows
containers
windows admin center
Web Technologies
Follow Us
Top Stories
 
 
 
 
 
 
 
 
Right Now
 
Windows Storage Replica: dealing with “WaitingForDestination” status
 
 
 
 
 
Top Five
Heat Index
 
1
Must Read:How to containerize Windows Admin Center
 
2
Must Read:How to run PHP 7 x64/x86 on Windows Azure Pack
 
3
Visual Studio: how to run Windows Phone and Android emulators in a virtual machine
 
4
WordPress and MySQL: fixing the wp_options table
 
5
The little virtual machine that is crashing Hyper-V on AMD

Warning: A non-numeric value encountered in /home/theserverside/public_html/wp-content/themes/engine/functions/loop.php on line 75