Posts Finally Working!

Last night I real­ized that some­thing was wrong with this blog. Sev­er­al days of posts had­n’t appeared, and I could­n’t even leave a com­ment on an old post. The error mes­sage I was get­ting (data­base access denied) made no sense. 

The MySQL infor­ma­tion had­n’t changed. I tried chang­ing the data­base pass­word and updat­ing the settings—nope, no good. I could view the DB in PHP­MyAd­min, and it was just fine. I could back up the data­base there, and change things, and I was using the same login infor­ma­tion. So why could­n’t Word­Press do anything?

We’ve been using 1&1 (now Ionos) for at least a year or so now, I think, and haven’t had any real com­plaints. I hate call­ing any­body’s tech sup­port, but they’re usu­al­ly bet­ter than most, as they haven’t out­sourced that to India. Reluc­tant­ly, I final­ly called.

If you ever call 1&1 and “Grace” answers, just hang up and try again. Bet­ter yet, keep her tied up on the phone and try from anoth­er line, just to be sure you’ll get some­one else. She sim­ply can’t under­stand Eng­lish well enough to func­tion in any job that requires tele­phone inter­ac­tion, and her tech­ni­cal skills seem to be abysmal (it was hard to tell, con­sid­er­ing the lan­guage issue). I was on the phone for more than 90 min­utes, and could­n’t get any­where. I kept ask­ing to speak to her super­vi­sor, and she kept being obstructionist. 

She asked me to spell the name of the affect­ed domain ( over and over and over again. I did so, very slow­ly and clear­ly, at least five times. What did she do? Inform me that was work­ing just fine, and ask me what error mes­sage I was getting!

Oth­er than the fact that they end with .com, do you find any sim­i­lar­i­ty in those names?

I final­ly got her to this site, where the errors were clear­ly vis­i­ble to every vis­i­tor. Then, final­ly, she start­ed talk­ing about esca­lat­ing the prob­lem to some­one else. She was­n’t sure who, though, and claimed that nobody there can make out­bound calls, so she could­n’t have that per­son (or her super­vi­sor) call me back. More hold­ing. Thank God­dess for unlim­it­ed cell min­utes! I real­ly, real­ly need to get a head­set, though, as I was in more and more pain from sim­ply hold­ing the telephone.

At near­ly 5, “Glen” final­ly got on the phone. He said he has no input regard­ing the hir­ing of “advi­sors” like “Grace.” If the sup­posed super­vi­sor does­n’t, who does? In any case, he final­ly pin­point­ed the prob­lem: the data­base was full. To be accu­rate, it was more than full, 47MB over the size limit! 

Hon­est­ly, I had­n’t checked that. But how could that hap­pen? And would­n’t I get some kind of notice or warn­ing? Well, no, they don’t have any­thing in place to warn users when data­bas­es are get­ting too big. That seems like a ridicu­lous­ly easy thing to put in place, but appar­ent­ly, it isn’t impor­tant to them.

I was aware of the 100MB lim­it 1&1 places on MySQL data­bas­es on our plan, but every time I’d looked at the usage, every data­base had 97MB free, or more! Blogs are most­ly text! The images I do post aren’t even stored in MySQL!

After get­ting off the phone, I looked at the size of each table. The cul­prit was the cache for the Joe Tan/Silas Part­ners Flickr pho­to album plu­g­in. I did­n’t notice, when I installed an upgrade to the plu­g­in, that it defaults to show­ing all of the Flickr groups you’re in. There’s no way that I can see to dis­able caching, either, and it seems that some­body browsed a lot of group pho­tos at some point over the week­end. Clear­ing that cache took me back to being way, way below the data­base size lim­it. If you use that plu­g­in (which is great, BTW), check the settings!

So that’s why you’re see­ing my blog posts appear late. It’s bet­ter than “the dog ate my blog posts,” at least. Isn’t it?

Cyn is Rick's wife, Katie's Mom, and Esther & Oliver's Mémé. She's also a professional geek, avid reader, fledgling coder, enthusiastic gamer (TTRPGs), occasional singer, and devoted stitcher.
Posts created 4255

One thought on “Posts Finally Working!

Comments are closed.

Related Posts

Begin typing your search term above and press enter to search. Press ESC to cancel.

Back To Top