Hi folks, I've been having a very strange set of problems. I already have MU running on this server using a different URL, but when I try to do a fresh install for another url, it says everything went fine when installing but it doesn't create the database tables. I then get the "fatal error" WP page when visiting the root of the site or wp-login.php as the database tables are not created.
Anyone experienced this? I couldn't find any posts on the forum with this problem, and it is hard to troubleshoot being that I don't really get any error until I try to log in. Why would it report a successful install if it isn't even adding the database tables?
when I do a fresh install this is what I get in the error log:
[client xx.xx.xx.xx] PHP Notice: Constant DB_NAME already defined in /usr/local/www/vhosts/wordpress.org/htdocs/wp-config.php on line 23, referer: http://wordpress.org/
[client xx.xx.xx.xx] PHP Notice: Constant DB_USER already defined in /usr/local/www/vhosts/wordpress.org/htdocs/wp-config.php on line 26, referer: http://wordpress.org/
[client xx.xx.xx.xx] PHP Notice: Constant DB_PASSWORD already defined in /usr/local/www/vhosts/wordpress.org/htdocs/wp-config.php on line 29, referer: http://wordpress.org/
[client xx.xx.xx.xx] PHP Notice: Constant DB_HOST already defined in /usr/local/www/vhosts/wordpress.org/htdocs/wp-config.php on line 32, referer: http://wordpress.org/
[client xx.xx.xx.xx] PHP Notice: Constant VHOST already defined in /usr/local/www/vhosts/wordpress.org/htdocs/wp-config.php on line 39, referer: http://wordpress.org/
[client xx.xx.xx.xx] WordPress database error Table 'db_wp.wp_blogs' doesn't exist for query SELECT * FROM wp_blogs WHERE domain = 'wordpress.org' AND path = '/' made by require, include, include_once, require_once, require_once, referer: http://wordpress.org/
that and a whole bunch more "doesn't exist" errors. I'm not sure what to deduce from the config vars being defined error.
Did you let the install create the config file for you?
yes. many times. I have gone through the correct process so many times. I've turned off a few other sites on this VPS and changed the wp-config.php filenames on those to see if that was where this was conflicting to no avail. The wp-config.php and .htaccess get created every time, just not the database.
The db user has to have ALL privileges on the db. (all caps for the command, not shouting ;P )
On some setups, which I can't understand, if the db user's password was less that 6 characters, it borked.
If this still doesn't work, go grab the WP 3.0 beta, it's almost at RC anyway, install it as usual, then create a network.
yikes. db user is root with all privileges.
password length > 6 chars
already tried WP 3.0 beta and need a newer version of MySQL.
This is just really odd. I just installed 2.9.2 a few months ago on this server.
I am going to have to update MySQL and try the WP 3.0 beta out again.
I know this is not a solution to this problem but running any site with root as your mysql user is a major security risk. The password is stored within your wp-config.php file and stored as plain text. The recent issue with Network Solutions is a perfect example of why this is a very bad idea.
Reference: http://www.theregister.co.uk/2010/04/12/network_solutions_wordpress_hack/
As said above, don't use the root user.
as said above, the user is not the root of this problem.
I just wonder how I get the 'Installation Finished!" page when no database tables are created...