WordPress Multiuser – Dec 10th snapshot

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.

Comments

comments

11 Replies to “WordPress Multiuser – Dec 10th snapshot”

  1. 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!

  2. 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.

  3. 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!

  4. I think you’ve been hit by this “feature” of WordPress, others were caught out by it too.
    There’s a very easy fix:

    • Edit your options database table and fix the siteurl value.
    • Now, open up wp-inst/wp-login.php and comment out the following lines: 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.

  5. 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!

  6. 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!

  7. 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.

  8. 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! 🙂

  9. 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) )

Leave a Reply