WordPress not working with mysql 5.0-alpha1 ?

  • Hello.
    I know this might be an odd request and I could be smacked for being bleeding edge. But I am trying to install wordpress (which is very impressive by the way) on a Freebsd machine which had mysql installed from ports. The ID reads:
    -su-2.05b# mysql -V
    mysql Ver 14.3 Distrib 5.0.0-alpha, for portbld-freebsd4.9 (i386)
    When I call install.php I see at the very top:
    SQL/DB Error:
    [Table ‘wp.wp_options’ doesn’t exist]
    SELECT option_name, option_value FROM wp_options
    When I continue it remains on the top, as soon as I click on step2 I get:
    SQL/DB Error:
    [Incorrect sub part key. The used key part isn’t a string, the used length is longer than the key part or the storage engine doesn’t support unique sub keys]
    and below that in a repeating fashion:
    SQL/DB Error:
    [Table ‘wp.wp_optionvalues’ doesn’t exist]
    Step 3 produces lots of errors in the fashion:
    SQL/DB Error:
    [Incorrect sub part key. The used key part isn’t a string, the used length is longer than the key part or the storage engine doesn’t support unique sub keys]
    CREATE TABLE wp_optionvalues ( option_id int(11) NOT NULL, optionvalue tinytext, optionvalue_desc varchar(255), optionvalue_max int(11), optionvalue_min int(11), optionvalue_seq int(11), UNIQUE (option_id, optionvalue(255)), INDEX (option_id, optionvalue_seq) )
    SQL/DB 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 ” at line 1]
    SELECT * FROM wp_options WHERE option_id =
    SQL/DB Error:
    [Duplicate entry ’55-0-default_post_status’ for key 1]
    INSERT INTO wp_options (option_id, option_name, option_type, option_value, option_description, option_admin_level, option_width) VALUES(55,’default_post_status’, 5, ‘publish’, ‘The default state of each new post’, 8, 20)
    SQL/DB 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 ” at line 1]
    SELECT * FROM wp_options WHERE option_id =
    I am using the latest tarball.
    Thanks for your hard work
    ADDON!
    I tried with the beta and the
    SQL/DB Error:
    [Incorrect sub part key. The used key part isn’t a string, the used length is longer than the key part or the storage engine doesn’t support unique sub keys]
    CREATE TABLE wp_optionvalues ( option_id int(11) NOT NULL, optionvalue tinytext, optionvalue_desc varchar(255), optionvalue_max int(11), optionvalue_min int(11), optionvalue_seq int(11), UNIQUE (option_id, optionvalue(255)), INDEX (option_id, optionvalue_seq) )
    SQL/DB Error:
    [Table ‘wp.wp_optionvalues’ doesn’t exist]
    SELECT * FROM wp_optionvalues WHERE option_id = ’49’ AND optionvalue = ‘days’
    errors in Step 3 remain. The other errors disappear as mentioned in the posts before

Viewing 7 replies - 1 through 7 (of 7 total)

  • Which version of WP?

    ya, but is your blog working after all these bugs ?!”.. if yes, it’s ok.. the installer is having weird behaviors in many installations… if no, you’re not the only one to have problem in a non-standard installation… ??

    This is called the Shushbh effect. Heck knows why. It does not seem to effect the install. If you can continue then just keep going. We do not mind a bit of bleeding edge here anyway! You may find the WP docs very informative ??

    Thread Starter dmalloc

    (@dmalloc)

    Hello ?? Thank you for you answers but the blog does not work correctly. All drop down fileds which should have some preset values in the Options area are empty. Sometimes errors pop open when I try to set an option, possibly indicating that the table is missing while trying to read the value.

    Thread Starter dmalloc

    (@dmalloc)

    Ok. Using this statement works:
    CREATE TABLE wp_optionvalues ( option_id int(11) NOT NULL, optionvalue tinytext, optionvalue_desc varchar(255), optionvalue_max int(11), optionvalue_min int(11), optionvalue_seq int(11), UNIQUE (option_id, optionvalue(85)), INDEX (option_id, optionvalue_seq) );
    Apparenlty the optionvalue(85) vs optionvalue(255) triggers the error.

    Thread Starter dmalloc

    (@dmalloc)

    and on we go with the odd effects.
    The original error code:
    SQL/DB Error:
    [Specified key was too long. Max key length is 500]
    ALTER TABLE wp_posts ADD INDEX ( post_name )
    SQL/DB Error:
    [Specified key was too long. Max key length is 500]
    ALTER TABLE wp_categories ADD INDEX ( category_nicename )
    The one I used which works:
    ALTER TABLE wp_posts ADD INDEX (post_name(166));
    ALTER TABLE wp_categories ADD INDEX (category_nicename(166));
    I just double checked. With the steps I mentioned here, the WP install now works without any flaws. The options show in the drop downs now.

    dr_njt

    (@dr_njt)

    try this:

    You need to disable Strict Mode in MySQL 5. If you have already installed MySQL 5 goto Start–>MySQL–>Server Config Wizard. Follow through the detailed config steps and deselect ‘Enable Strict Mode’.

Viewing 7 replies - 1 through 7 (of 7 total)
  • The topic ‘WordPress not working with mysql 5.0-alpha1 ?’ is closed to new replies.