WordPress.org

Ready to get started?Download WordPress

Forums

[resolved] Errors in my local testing server (4 posts)

  1. thamizhinpan
    Member
    Posted 5 years ago #

    I've installed a local server in my PC as my testing server.
    I'm trying to install wordpress in it.

    But when I install it, it give many errors.

    WordPress database error: [Specified key was too long. Max key length is 500]
    CREATE TABLE wp_terms ( term_id bigint(20) unsigned NOT NULL auto_increment, name varchar(200) NOT NULL default '', slug varchar(200) NOT NULL default '', term_group bigint(10) NOT NULL default 0, PRIMARY KEY (term_id), UNIQUE KEY slug (slug), KEY name (name) ) DEFAULT CHARACTER SET utf8

    WordPress database error: [Specified key was too long. Max key length is 500]
    CREATE TABLE wp_postmeta ( meta_id bigint(20) unsigned NOT NULL auto_increment, post_id bigint(20) unsigned NOT NULL default '0', meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (meta_id), KEY post_id (post_id), KEY meta_key (meta_key) ) DEFAULT CHARACTER SET utf8

    WordPress database error: [Specified key was too long. Max key length is 500]
    CREATE TABLE wp_posts ( ID bigint(20) unsigned NOT NULL auto_increment, post_author bigint(20) unsigned NOT NULL default '0', post_date datetime NOT NULL default '0000-00-00 00:00:00', post_date_gmt datetime NOT NULL default '0000-00-00 00:00:00', post_content longtext NOT NULL, post_title text NOT NULL, post_excerpt text NOT NULL, post_status varchar(20) NOT NULL default 'publish', comment_status varchar(20) NOT NULL default 'open', ping_status varchar(20) NOT NULL default 'open', post_password varchar(20) NOT NULL default '', post_name varchar(200) NOT NULL default '', to_ping text NOT NULL, pinged text NOT NULL, post_modified datetime NOT NULL default '0000-00-00 00:00:00', post_modified_gmt datetime NOT NULL default '0000-00-00 00:00:00', post_content_filtered text NOT NULL, post_parent bigint(20) unsigned NOT NULL default '0', guid varchar(255) NOT NULL default '', menu_order int(11) NOT NULL default '0', post_type varchar(20) NOT NULL default 'post', post_mime_type varchar(100) NOT NULL default '', comment_count bigint(20) NOT NULL default '0', PRIMARY KEY (ID), KEY post_name (post_name), KEY type_status_date (post_type,post_status,post_date,ID), KEY post_parent (post_parent) ) DEFAULT CHARACTER SET utf8

    WordPress database error: [Specified key was too long. Max key length is 500]
    CREATE TABLE wp_usermeta ( umeta_id bigint(20) unsigned NOT NULL auto_increment, user_id bigint(20) unsigned NOT NULL default '0', meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (umeta_id), KEY user_id (user_id), KEY meta_key (meta_key) ) DEFAULT CHARACTER SET utf8

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    DELETE FROM wp_usermeta WHERE user_id = 1 AND meta_key = 'first_name'

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    DELETE FROM wp_usermeta WHERE user_id = 1 AND meta_key = 'last_name'

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    SELECT * FROM wp_usermeta WHERE user_id = 1 AND meta_key = 'nickname'

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    INSERT INTO wp_usermeta (user_id,meta_key,meta_value) VALUES ('1','nickname','admin')

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    DELETE FROM wp_usermeta WHERE user_id = 1 AND meta_key = 'description'

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    DELETE FROM wp_usermeta WHERE user_id = 1 AND meta_key = 'jabber'

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    DELETE FROM wp_usermeta WHERE user_id = 1 AND meta_key = 'aim'

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    DELETE FROM wp_usermeta WHERE user_id = 1 AND meta_key = 'yim'

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    SELECT * FROM wp_usermeta WHERE user_id = 1 AND meta_key = 'rich_editing'

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    INSERT INTO wp_usermeta (user_id,meta_key,meta_value) VALUES ('1','rich_editing','true')

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    SELECT * FROM wp_usermeta WHERE user_id = 1 AND meta_key = 'comment_shortcuts'

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    INSERT INTO wp_usermeta (user_id,meta_key,meta_value) VALUES ('1','comment_shortcuts','false')

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    SELECT * FROM wp_usermeta WHERE user_id = 1 AND meta_key = 'admin_color'

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    INSERT INTO wp_usermeta (user_id,meta_key,meta_value) VALUES ('1','admin_color','fresh')

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    DELETE FROM wp_usermeta WHERE user_id = 1 AND meta_key = 'use_ssl'

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    SELECT * FROM wp_usermeta WHERE user_id = 1 AND meta_key = 'wp_capabilities'

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    INSERT INTO wp_usermeta (user_id,meta_key,meta_value) VALUES ('1','wp_capabilities','a:1:{s:10:\"subscriber\";b:1;}')

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    DELETE FROM wp_usermeta WHERE user_id = 1 AND meta_key = 'wp_user_level'

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    SELECT * FROM wp_usermeta WHERE user_id = 1 AND meta_key = 'default_password_nag'

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    INSERT INTO wp_usermeta (user_id,meta_key,meta_value) VALUES ('1','default_password_nag','1')

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    SELECT * FROM wp_usermeta WHERE user_id = 1 AND meta_key = 'wp_capabilities'

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    INSERT INTO wp_usermeta (user_id,meta_key,meta_value) VALUES ('1','wp_capabilities','a:1:{s:13:\"administrator\";b:1;}')

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    SELECT * FROM wp_usermeta WHERE user_id = 1 AND meta_key = 'wp_user_level'

    WordPress database error: [Table 'mydata.wp_usermeta' doesn't exist]
    INSERT INTO wp_usermeta (user_id,meta_key,meta_value) VALUES ('1','wp_user_level','10')

    WordPress database error: [Table 'mydata.wp_terms' doesn't exist]
    INSERT INTO wp_terms (name,slug,term_group) VALUES ('Uncategorized','uncategorized','0')

    WordPress database error: [Table 'mydata.wp_terms' doesn't exist]
    INSERT INTO wp_terms (name,slug,term_group) VALUES ('Blogroll','blogroll','0')

    WordPress database error: [Table 'mydata.wp_posts' doesn't exist]
    INSERT INTO wp_posts (post_author,post_date,post_date_gmt,post_content,post_excerpt,post_title,post_name,post_modified,post_modified_gmt,guid,comment_count,to_ping,pinged,post_content_filtered) VALUES ('1','2009-07-17 00:05:52','2009-07-16 18:35:52','Welcome to WordPress. This is your first post. Edit or delete it, then start blogging!','','Hello world!','hello-world','2009-07-17 00:05:52','2009-07-16 18:35:52','http://mytest.local/wordpress/?p=1','1','','','')

    WordPress database error: [Table 'mydata.wp_posts' doesn't exist]
    INSERT INTO wp_posts (post_author,post_date,post_date_gmt,post_content,post_excerpt,post_title,post_name,post_modified,post_modified_gmt,guid,post_type,to_ping,pinged,post_content_filtered) VALUES ('1','2009-07-17 00:05:52','2009-07-16 18:35:52','This is an example of a WordPress page, you could edit this to put information about yourself or your site so readers know where you are coming from. You can create as many pages like this one or sub-pages as you like and manage all of your content inside of WordPress.','','About','about','2009-07-17 00:05:52','2009-07-16 18:35:52','http://mytest.local/wordpress/?page_id=2','page','','','')

    Whats wrong in Server?

  2. Samuel B
    moderator
    Posted 5 years ago #

    looks like the install didn't create the db tables
    what are you using?
    this has never failed for me
    http://www.tamba2.org.uk/wordpress/xampp/

  3. thamizhinpan
    Member
    Posted 5 years ago #

    I'm using Apache server in windows XP
    MySQL database server with the support of php

  4. beesatmsu2
    Member
    Posted 4 years ago #

    how was the issue resolved? I have exactly the same errors.

    near the end it says wordpress was installed. but if I log in, it says I have no permission to do anything.

    running FreeBSD 4.10 (old, I know), apache 2.0, php 5.0 and mysql.

    thanks.

Topic Closed

This topic has been closed to new replies.

About this Topic