Yes, I know, I should have RTFM before futzing around with stuff. I changed the table prefix. In my defence, when I upgraded to 3.3.1, from 2.5 something or other, none of the stories showed up, despite them all still being there, when I checked in phpMyAdmin, in tables with 'AU' prefixes.
I'm a web developer (which is why my ego wouldn't let me read the instructions), so I'm comfortable with php and mySQL. Where do I go to fix my goof?
Go to your settings and add the tableprefix.
Admin>settings.
You mean the admin page? Because there's not a single page that will load. All I get is:
A fatal MySQL error was encountered.
Query: SELECT ap.*, author.uid as uid, author.penname as penname, author.email as email, author.password as password FROM AUfanfiction_authors as author LEFT JOIN AUfanfiction_authorprefs as ap ON ap.uid = author.uid WHERE author.uid = '1'
Error: (1146) Table 'maryavatar2.AUfanfiction_authorprefs' doesn't exist
Oh, right...you'll need to change it via phpMyAdmin then. It's in the settings table.
Nifty! That sorted it. Thank you 😉
