Eliminate Extra Space in a Database Table Record
Making mistakes is part of the development process. The more mistakes are made the more experience and, as long as developers are documenting it, there’s more information out there for other developers to fix those problems when they experience those situations themselves.
Can’t Login to WordPress because Cookies are Blocked?!
I had an interesting experience as I was putting my site live from a default WordPress hack. Although I replaced the server URL with my domain, I was getting a number of errors and couldn’t log into the site.
Here are some of the errors I was looking at:
ERROR: Cookies are blocked due to unexpected output. For help, please see this documentation or try the support forums.
There were also a number of WARNING messages related to headers already being sent.
In the previous article I had wrote about changing the siteurl URL and home URL in the wp_options table.
Once I had my primary domain pointed at this hosting I needed to change that back. When I did that with the “home” URL, I pasted the URL from the first field. Since I was in a bit of a rush, I accidentally pasted some empty space too and didn’t catch it.
The Fix
The fix is quite easy when you figure out what was going on. To get rid of that space, follow these instructions:
- Log into phpMyAdmin
- Find the database table in question, in this case, wp_options
- Double click on the database table record that is causing the problem
- Highlight and delete the extra space
- Click off of the open record to Save the new data
That’s all. A simple lesson to be learned. Never rush critical data on your website. At the very least, keep a mental note (or better, a paper trail) of the steps you took when performing these actions. Retracing your steps may help you find a simple solution to a greater problem!
Life Rule:
Don’t rush important task, ever.