The divine punishment problem was with my client machine and it’s more or less fine now.
After I’d finished that religious observance, I began to have problems with my server, whereon reside the WAMP family of divine servants, Apache web-server, MySQL DBMS and the delightful sprite, PHP.
Well, WAMP started to fail intermittently. It appeared to be associated with Google Desktop Search’s indexing operations so I disabled that. It seemed to be okay for a while. Then it happened again.
There appeared to be a connection with Windows’ own screensaver kicking in. When that happened, the MySQL server would fail, but not consistently. I disabled the screensaver and the frequency of the problem lessened. (I was testing all this from the ritually restored client machine, in case there was a networking component to the failure.)
I thought, ‘Dear Gods, screw this’ and I reinstalled WAMP, being careful to back up my databases and websites. (For simple laziness I have taken to installing a separate instance of Mediawiki for each project; it’s easier to plan and navigate the project, the harddisk footprint is small and they all use the same MySQL, so the processor overhead isn’t all that bad.)
The reinstall didn’t help and when I restored my databases, it saw the tables but said they didn’t exist if I tried to SQL them from the management interface. Whiskey Tango Foxtrot, thinks I. (It’s an ancient expression of dismay and concern among my people.)
I analyzed the Windows system logs, the MySQL error logs, the ini files. I examined the database files as if they were simple text files to see if the data was there; I was terrified I’d lost it all! Everything was where it should be, yet it wasn’t working.
Long story short, about 3:30 this morning I reinstalled WAMP again and everything worked as if there’d been no problem in the first place. I have no idea what I did or didn’t do rightly or wrongly; it just started to work.
My people’s ancient gods at work again.