likeabikemike

Max, basically you’re advising starting fresh with an all-new database. I tried that, only this time I pasted in MySQL code that I templated off of code generated in the old DB before dropping it. (The code displayed substitutes asterisks for the password, so it’s necessary to edit in the actual password.)

I created the new DB using phpMySQL, then executed the edited template code to:

CREATE USER 'siteacct'@'lab2' IDENTIFIED BY 'sitepassword';

GRANT ALL PRIVILEGES ON * . * TO 'siteacct'@'lab2' IDENTIFIED BY 'sitepassword' WITH MAX_QUERIES_PER_HOUR 0 MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0 MAX_USER_CONNECTIONS 0 ;

GRANT ALL PRIVILEGES ON <code>lab2</code> . * TO ''@'siteacct';

______________________
I think this is where I was before, except for granting ALL PRIVILEGES for the WP account only to the specific database.

Now I’m getting the following (which I think might be different from what I got before:
______________________

Can’t select database

We were able to connect to the database server (which means your username and password is okay) but not able to select the lab2 database.

Are you sure it exists?
Does the user siteacct have permission to use the lab2 database?
On some systems the name of your database is prefixed with your username, so it would be like username_lab2. Could that be the problem?

The user and the database both show in the phpMyAdmin, and it is listed as simply “lab2”. This seems to confirm that none of these are the problem, unless WP is looking for “siteuser_lab2”.

…Nope. If I change the username in wp-config.php to “siteuser_lab2”, I get the previous error message:

Error establishing a database connection

This either means that the username and password information in your wp-config.php file is incorrect or we can’t contact the database server at localhost. This could mean your host’s database server is down.

Are you sure you have the correct username and password?
Are you sure that you have typed the correct hostname?
Are you sure that the database server is running?

So, it seems that only granting privileges to the 1 database did make a difference, and got me closer, but not all the way there.

Any other ideas?

I was wondering about file permissions. WP instructions are far too casual about assumptions in this regard, not specifying what they should be. I found out through my own trial and error that everything needs to allow either the owner or group to be www-data (on Ubuntu), and set them that way (recursively). (And, actually wp-config.php group:user is set to www-data:root for me.) But if anything should be otherwise, I need to know.

Never mind. I found the topic in Chad Butler’s FAQ and will track down there.

Thanks Chad. Setting some checkbox fields to “required” will meet our needs for now. I’ll go back and learn how to code action hooks later. Turns it into even-driven programming. I’m starting to get it.

One additional question: with the checkbox-type wp-members user fields, I see no way to go back after they’re created to modify the “stored value when checked”. Any pointers there?

Same problem. Appeared as soon as I installed Download Manager plug-in, goes away as soon as I disable it. I’m brand new to WP, all my stuff is right out of the box and default so it’s not like I have an old version of WP or the plug-in or some exotic theme. Not impressed. So, this has been around for 4 months? Find a solution?

Didn’t fix mine. This is the very first thing I’ve tried with WP. Frustrating that what appears to be a popular plug-in comes in this broken state. Like, nobody noticed there was a bug? Like, oh BTW, before you use this, expect to do some googling for a bug fix. BS.