WordPress.org

Ready to get started?Download WordPress

Forums

Database Problem (4 posts)

  1. Anonymous
    Unregistered
    Posted 10 years ago #

    When I followed the 5 Minute installation instruction, I get the following error:
    Database error: [BLOB column 'optionvalue' can't be used in key specification with the used table type]
    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) )
    Option Tables created okay.
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (49, 'days', 'days', null,null,1)
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (49, 'posts', 'posts', null,null,2)
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (49, 'paged', 'posts paged', null,null,3)
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (50, 'daily', 'daily', null,null,1)
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (50, 'weekly', 'weekly', null,null,2)
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (50, 'monthly', 'monthly', null,null,3)
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (50, 'postbypost','post by post',null,null,4)
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (51, 'hours', 'hours', 23, -23, null)
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (9, '0', 'Sunday', null,null,1)
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (9, '1', 'Monday', null,null,2)
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (9, '6', 'Saturday', null,null,3)
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (55, 'publish', 'Publish', null,null,1)
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (55, 'draft', 'Draft', null,null,2)
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (55, 'private', 'Private', null,null,3)
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (56, 'open', 'Open', null,null,1)
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (56, 'closed', 'Closed', null,null,2)
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (57, 'open', 'Open', null,null,1)
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (57, 'closed', 'Closed', null,null,2)
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (58, '1', 'Checked', null,null,1)
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (58, '0', 'Unchecked', null,null,2)
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (59, 'SELECT cat_id AS value, cat_name AS label FROM wp_categories order by cat_name', '', null,null,1)
    Option Data inserted okay.
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (62, 'number', 'Number', null,null,1)
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (62, 'char', 'Character', null,null,2)
    Database error: [Table 'WP.wp_optionvalues' doesn't exist]
    INSERT INTO wp_optionvalues (option_id, optionvalue, optionvalue_desc, optionvalue_max, optionvalue_min, optionvalue_seq) VALUES (62, 'image', 'Image', null,null,3)
    I am running MySQL 4.0.20..

  2. lane
    Member
    Posted 10 years ago #

    Are you using a MySQL username/password account with create privilages for your database?

  3. Anonymous
    Unregistered
    Posted 10 years ago #

    I get the SAME THING! I entered all of that correctly.
    By any chance, does the PHP config file need an Admin panel username and password input?

  4. OperaManiac
    Member
    Posted 10 years ago #

    it needs a user name and password that has been assigned to the database name concerned

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.