Hi there,
I have confusing problem. There is a need to install WPMU with sub-directory on Nginx.
*With my server configuration there is no problems with subdomain install. It works perfectly.
After WPMU install with sub-directory option i get this error in nginx logs:
2009/10/08 02:11:18 [error] 15837#0: *215 FastCGI sent in stderr: "WordPress database error Table 'devbase.wp_sfsd3_blogs' doesn't exist for query SELECT * FROM wp_sfsd3_blogs WHERE domain = 'dev.domain.com' made by require, include, include_once, require_once, require_once
WordPress database error Table 'devbase.wp_sfsd3_sitemeta' doesn't exist for query SELECT meta_value FROM wp_sfsd3_sitemeta WHERE site_id = 1 AND meta_key = 'site_name' made by require, include, include_once, require_once, require_once, get_current_site_name
WordPress database error Table 'devbase.wp_sfsd3_blogs' doesn't exist for query SELECT blog_id FROM wp_sfsd3_blogs LIMIT 0,1 made by require, include, include_once, require_once, require_once
WordPress database error Table 'devbase.wp_sfsd3_sitemeta' doesn't exist for query SELECT meta_value FROM wp_sfsd3_sitemeta WHERE meta_key = 'wpmu_sitewide_plugins' AND site_id = 1 made by require, include, include_once, require_once, get_site_option" while reading upstream, client: 84.240.26.186, server: dev.domain.com, request: "POST /index.php HTTP/1.1", upstream: "fastcgi://127.0.0.1:9000", host: "dev.domain.com", referrer: "http://dev.domain.com/"
2009/10/08 02:11:40 [error] 15839#0: *226
Here is my Nginx configuration:
server
{
listen 80;
server_name dev.domain.com;
access_log /home/public_html/dev.domain.com/log/access.log;
error_log /home/public_html/dev.domain.com/log/error.log;
# rewrite rule for files
location ~* ^.+\.(xml|jpg|jpeg|gif|png|ico|css|zip|tgz|gz|rar|bz2|doc|xls|exe|pdf|ppt|txt|tar|mid|midi|wav|bmp|rtf|js|swf)$
{
root /home/public_html/dev.domain.com/public;
rewrite ^/files(/.*)$ /wp-content/blogs.php?file=$1 last;
expires 10d;
break;
}
# rewrite rule for sitemap under the lines that handles upload files
rewrite ^(.*/)?sitemap.xml wp-content/sitemap.php;
# rewrite errors
location /
{
root /home/public_html/dev.domain.com/public;
index index.php;
# WordPress pretty URLs: (as per dominiek.com)
if (-f $request_filename) {
break;
}
if (-d $request_filename) {
break;
}
rewrite ^(.+)$ /index.php?q=$1 last;
error_page 404 = /index.php?q=$uri;
#My IP
allow xx.xxx.xx.xxx;
deny all;
}
#send php requests to fast cgi
location ~ \.php$
{
fastcgi_pass 127.0.0.1:9000;
fastcgi_index index.php;
fastcgi_param SCRIPT_FILENAME /home/public_html/dev.domain.com/public$fastcgi_script_name;
include /usr/local/nginx/conf/fastcgi_params;
}
}
Any ideas?