Only a few days since the last release this one should fix many or hopefully all the problems with missing pages, archives not working, etc.
The mod_rewrite rules have been significantly updated in this release.
Go to the download page for more info and links.
Look what I found today!
11 Comments
Kyle (1 comments.) on December 18, 2004 at 8:32 pm.
I’m trying to install wpmu on my server, but am receiving some errors. I know my database information is correct in wp-config. And I did chmod the requested files via ftp when installing, but I get these errors: http://kepplah.com/wpmu/. I also noticed that when it asked me about what id like my db extension to be, i chose wpmu_ which was not honored. Instead I got wp_main_ etc. I have a install of wp 1.3a5 on the same db, so i dont want to loose that. I noticed in wpmu-settings.php the $wpblog var was not being set right. Tracked that down to needing to edit the $base to the basedir wpmu is installed to. But that was evaling to “/”, and causing errors in the table creations. So i added this line:
if ($wpblog="/") $wpblog="";on line 21. That allowed the db to be created, but the filesystem errors persist.Also, in the admin panel, I get errors about the referrer-blacklist having sql syntax errors.
Feel free to email me for additional information, I appreciate your help. I woulda emailed you, but I couldn’t find an addy!
Donncha (1707 comments.) on December 20, 2004 at 11:27 am.
Kyle – I’m going to email you, but to address some of your points:
Follow the instructions given on that page to chmod the files and directories. It’s for your own security.
Michel_v has pointed out that WPMU uses dashes in mysql table names and this may cause problems in some situations.
Your confusion about the table names is understandable – the installer should create tables called $prefix_main_* to support multiple blogs in the one database. I’ll have to look at that for the next release.
rs on December 22, 2004 at 2:30 am.
I’m having this problem as well, and nothing I do seems to work:
I’ve received this error as well. I’m using mysql 3.23.58, apache 1.3.33, and php 4.1.
I don’t have connection errors, just dozens of mysql errors, the first of which is:
WordPress database error: [You have an error in your SQL syntax near '-inst_categories ( cat_ID int(4) NOT NULL auto_increment, cat_name varchar(5' at line 1]
CREATE TABLE wp_wp-inst_categories ( cat_ID int(4) NOT NULL auto_increment, cat_name varchar(55) NOT NULL default ”, category_nicename varchar(200) NOT NULL default ”, category_description text NOT NULL, category_parent int(4) NOT NULL default ’0′, PRIMARY KEY (cat_ID), UNIQUE KEY cat_name (cat_name), KEY category_nicename (category_nicename) )
and the last of which is:
WordPress database error: [You have an error in your SQL syntax near '-inst_comments SET comment_type='pingback', comment_content = REPLACE(comment_co' at line 1]
UPDATE wp_wp-inst_comments SET comment_type=’pingback’, comment_content = REPLACE(comment_content, ”, ”) WHERE comment_content LIKE ‘%’
Any tips for me?
Thanks!
Donncha (1707 comments.) on December 22, 2004 at 4:02 pm.
I think you’ve been hit by this “feature” of WordPress, others were caught out by it too.
There’s a very easy fix:
if ( dirname('http://' . $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF']) != get_settings('siteurl') )update_option('siteurl', dirname('http://' . $_SERVER['HTTP_HOST'] . $_SERVER['PHP_SELF']) );
The next release of WPMU will have those two lines commented out by default.
rs on December 22, 2004 at 5:26 pm.
Thanks for the tip!
Unfortunately, I forgot to mention that I get those errors when running wp-inst/wp-admin/install.php.
No tables get created – I just get a site-created email, and tons of SQL errors on my browser.
I’ve tried this on:
- A fedora core2 machine with apache 1.3.3, php 4.3.9, and mysql 3.23.56
- A FreeBSD 4.10 machine with apache 1.3.31, php 4.3.8 and mysql 3.23.52
- A redhat 9 machine with apache 2.0.40-21.9, mysql 4.0.17, and php 4.3.9
Tips? Thanks!
rs on December 22, 2004 at 5:30 pm.
More…
Chances are I’m just doing something wrong, but here’s what I’m doing, just in case.
- untarring wpmu in my webserver’s doc root
- creating a db + user + password with mysql_setpermission
- editing wp-inst/wp-config.php with my db connection info.
- running http://host/blog/index.php – all tests pass
- running http://host/blog/wp-inst/wp-admin/install.php
- entering blog name, and my email. click the submit button
- the resulting page just contains dozens of sql errors as bove, but I *do* get the site-created email.
Thanks for any tips!
Jared on December 26, 2004 at 5:18 am.
i get to the exact same point as above when i get loaded with mysql errors aswell….
Chuck McKinnon on January 12, 2005 at 11:10 pm.
I’m getting the exact same errors, at the exact same point. DB permissions are right. Folders are all 777 (I’m just testing wpmu, not running it in production; don’t panic). I have WP standard (an alpha 1.3 build) running on the same machine with no problems.
Yet if I go to wp-inst/wp-admin/install.php, enter my name and email, click Continue to Second Step, I get these exact SQL-syntax-error messages, and I too get the site-creation email.
I’m using the Jan. 12 snapshot. Help?
Thanks,
Chuck McKinnon.
Donncha (1707 comments.) on January 14, 2005 at 7:01 am.
If you’re getting SQL errors about table names with “wp-inst” in them make sure you’re not calling setup-config.php or install.php by the urls wp-inst/wp-admin/setup-config.php and wp-inst/wp-admin/install.php
The correct url should be http://example.com/main/wp-admin/setup-config.php and http://example.com/main/wp-admin/install.php
The “main” part of the url is handled by mod_rewrite. Follow the links in the installer and you’ll be fine!
Pingback: Holy Shmoly! :: WordPress Multiuser Snapshot (2 comments.)
Gnukerman (2 comments.) on February 20, 2005 at 11:34 pm.
I give up. I’ve done everything as written here 10 times and keep getting the same thing. It doesn’t matter whether it is wp-inst or main. The same errors are returned.
WordPress database error: [You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '/main_categories ( cat_ID int(4) NOT NULL auto_increment, c]
CREATE TABLE wp_/main_categories ( cat_ID int(4) NOT NULL auto_increment, cat_name varchar(55) NOT NULL default ”, category_nicename varchar(200) NOT NULL default ”, category_description text NOT NULL, category_parent int(4) NOT NULL default ’0′, PRIMARY KEY (cat_ID), UNIQUE KEY cat_name (cat_name), KEY category_nicename (category_nicename) )