Warning: strpos() expects parameter 1 to be string, array given in /home/theserverside/public_html/wp-includes/blocks.php on line 20
sql | The Server Side Technology
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 ‘sql’
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 [...]

1201
End of the line!
Latest Windows news
 
Read More
150
 
Read More
85
 
Read More
4715

Trending Topics
windows server
SysAdmins
hyper-v
Development
windows
containers
windows admin center
News
Web Technologies
Follow Us
Top Stories
 
 
 
 
 
 
 
 
Right Now
 
Acronis Storage Gateway: how to replace a node for the Backup Service
 
 
 
 
 
Top Five
Heat Index
 
1
Must Read:How to containerize Windows Admin Center
 
2
The little virtual machine that is crashing Hyper-V on AMD
 
3
WordPress and MySQL: fixing the wp_options table
 
4
How to clear Powershell history (done right!)
 
5
Must Read:How to run PHP 7 x64/x86 on Windows Azure Pack

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