jamie3000

I had this problem too… It was htaccess related.

I did not figure out how to confirm that my .htaccess files were being loaded. Reading up on the Apache docs, it says that using .htaccess should be avoided. My server had them (.htaccess files) disabled. (Running my own apache server here.)

Rather than put the directives in the .htaccess file, I put them into my httpd conf file. Now my (non-default) permalinks work for multisite, and I get better performance too.
(Okay, I am just echoing the performance thing from the Apache docs. I have no idea what the performance difference is.)

For me, I edited /etc/httpd/conf.d/website.conf and inserted at the top:

<Directory /var/www/html>
RewriteEngine On
RewriteBase /
RewriteRule ^index\.php$ – [L]
etc…
</Directory>

and it started working.

I have followed this procedure exactly, as well.

I get “Error establishing a database connection” after the final step of activating the options in wp-config.php

Repair Database shows:

wp_1_posts: Table ‘gmtwp.wp_1_posts’ doesn’t exist
wp_1_comments: Table ‘gmtwp.wp_1_comments’ doesn’t exist
wp_1_links: Table ‘gmtwp.wp_1_links’ doesn’t exist
wp_1_options: Table ‘gmtwp.wp_1_options’ doesn’t exist
wp_1_postmeta: Table ‘gmtwp.wp_1_postmeta’ doesn’t exist
wp_1_terms: Table ‘gmtwp.wp_1_terms’ doesn’t exist
wp_1_term_taxonomy: Table ‘gmtwp.wp_1_term_taxonomy’ doesn’t exist
wp_1_term_relationships: Table ‘gmtwp.wp_1_term_relationships’ doesn’t exist
wp_1_commentmeta: Table ‘gmtwp.wp_1_commentmeta’ doesn’t exist

My database user has, as far as I can tell, the proper database permissions:

| GRANT ALL PRIVILEGES ON *.* TO ‘wpuser’@’localhost’ IDENTIFIED BY PASSWORD ‘…’ WITH GRANT OPTION |
and
GRANT ALL PRIVILEGES ON *.* TO ‘wpuser’@’%’ WITH GRANT OPTION

The things that bug me are:
– Obviously, WordPress already created some tables using that id
– There is absolutely no debugging information, even with any combination of the following:

define(‘WP_DEBUG’, true);
define(‘WP_DEBUG_LOG’, true);
define(‘WP_DEBUG_DISPLAY’, false);
define(‘SAVEQUERIES’, true);

Any thoughts would be greatly appreciated!!!
Please help save my hair!

I seem to get the same error as bimki.
I have a fresh installation of wp 3.2.1.
I ran the installer, and it seems okay.
Then I tried to add a user, and I get that error, on line 318 of the driver.

Turning on debugging, I see the following: two error messages:

Error running :
SELECT SQL_CALC_FOUND_ROWS wp_users.ID FROM wp_users WHERE 1=1 ORDER BY user_login ASC LIMIT 20
---- converted to ----
SELECT DISTINCT wp_users."ID" FROM wp_users WHERE 1=1 ORDER BY user_login ASC LIMIT 20
----
ERROR:  for SELECT DISTINCT, ORDER BY expressions must appear in select list
LINE 1: ...CT wp_users."ID" FROM wp_users WHERE 1=1 ORDER BY user_login...
                                                             ^
---------------------
Error running :
SELECT COUNT(NULLIF(<code>meta_value</code> LIKE '%administrator%', FALSE)), COUNT(NULLIF(<code>meta_value</code> LIKE '%editor%', FALSE)), COUNT(NULLIF(<code>meta_value</code> LIKE '%a
uthor%', FALSE)), COUNT(NULLIF(<code>meta_value</code> LIKE '%contributor%', FALSE)), COUNT(NULLIF(<code>meta_value</code> LIKE '%subscriber%', FALSE)), COUNT(*) FROM wp_user
meta WHERE meta_key = 'wp_capabilities'
---- converted to ----
SELECT COUNT(NULLCASE WHEN meta_value ILIKE '%administrator%' THEN  FALSE)) ELSE  COUNT(NULLIF(meta_value ILIKE '%editor%', FALSE END), COUNT(NULLCASE W
HEN meta_value ILIKE '%author%' THEN  FALSE)) ELSE  COUNT(NULLIF(meta_value ILIKE '%contributor%', FALSE END), COUNT(NULLCASE WHEN meta_value ILIKE '%su
bscriber%' THEN  FALSE)) ELSE  COUNT(* END FROM wp_usermeta WHERE meta_key = 'wp_capabilities'
----
ERROR:  syntax error at or near "WHEN"
LINE 1: SELECT COUNT(NULLCASE WHEN meta_value ILIKE '%administrator%...

For the first error, I am guessing the ORDER BY could be ignored completely… it’s just counting, right?