• My hosting service (yahoo small business) recommended that I upgrade my version of wordpress and to deactivate certain plug ins and activate certain others. Which led to the “white screen of death”. I tried reinstalling wordpress and so now when I go to the blog I’m greeted with the WordPress Welcome screen which is good but when I click Install WordPress I’m given an error message which starts out like the following: (want to say in advance, any help is much appreciated) The URL for this blog is walterlynnmosley.com/blog

    [ Moderator note: code fixed. Please wrap code in the backtick character or use the code button. ]

    WordPress database error: [CREATE command denied to user 'walterlynn'@'localhost' for table 'wp_users']
    CREATE TABLE wp_users ( ID bigint(20) unsigned NOT NULL auto_increment, user_login varchar(60) NOT NULL default '', user_pass varchar(64) NOT NULL default '', user_nicename varchar(50) NOT NULL default '', user_email varchar(100) NOT NULL default '', user_url varchar(100) NOT NULL default '', user_registered datetime NOT NULL default '0000-00-00 00:00:00', user_activation_key varchar(60) NOT NULL default '', user_status int(11) NOT NULL default '0', display_name varchar(250) NOT NULL default '', PRIMARY KEY (ID), KEY user_login_key (user_login), KEY user_nicename (user_nicename) ) DEFAULT CHARACTER SET utf8
    
    WordPress database error: [CREATE command denied to user 'walterlynn'@'localhost' for table 'wp_usermeta']
    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: [CREATE command denied to user 'walterlynn'@'localhost' for table 'wp_terms']
    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: [CREATE command denied to user 'walterlynn'@'localhost' for table 'wp_term_taxonomy']
    CREATE TABLE wp_term_taxonomy ( term_taxonomy_id bigint(20) unsigned NOT NULL auto_increment, term_id bigint(20) unsigned NOT NULL default 0, taxonomy varchar(32) NOT NULL default '', description longtext NOT NULL, parent bigint(20) unsigned NOT NULL default 0, count bigint(20) NOT NULL default 0, PRIMARY KEY (term_taxonomy_id), UNIQUE KEY term_id_taxonomy (term_id,taxonomy), KEY taxonomy (taxonomy) ) DEFAULT CHARACTER SET utf8
    
    WordPress database error: [CREATE command denied to user 'walterlynn'@'localhost' for table 'wp_term_relationships']
    CREATE TABLE wp_term_relationships ( object_id bigint(20) unsigned NOT NULL default 0, term_taxonomy_id bigint(20) unsigned NOT NULL default 0, term_order int(11) NOT NULL default 0, PRIMARY KEY (object_id,term_taxonomy_id), KEY term_taxonomy_id (term_taxonomy_id) ) DEFAULT CHARACTER SET utf8
    
    WordPress database error: [CREATE command denied to user 'walterlynn'@'localhost' for table 'wp_commentmeta']
    CREATE TABLE wp_commentmeta ( meta_id bigint(20) unsigned NOT NULL auto_increment, comment_id bigint(20) unsigned NOT NULL default '0', meta_key varchar(255) default NULL, meta_value longtext, PRIMARY KEY (meta_id), KEY comment_id (comment_id), KEY meta_key (meta_key) ) DEFAULT CHARACTER SET utf8
    
    WordPress database error: [CREATE command denied to user 'walterlynn'@'localhost' for table 'wp_comments']
    CREATE TABLE wp_comments ( comment_ID bigint(20) unsigned NOT NULL auto_increment, comment_post_ID bigint(20) unsigned NOT NULL default '0', comment_author tinytext NOT NULL, comment_author_email varchar(100) NOT NULL default '', comment_author_url varchar(200) NOT NULL default '', comment_author_IP varchar(100) NOT NULL default '', comment_date datetime NOT NULL default '0000-00-00 00:00:00', comment_date_gmt datetime NOT NULL default '0000-00-00 00:00:00', comment_content text NOT NULL, comment_karma int(11) NOT NULL default '0', comment_approved varchar(20) NOT NULL default '1', comment_agent varchar(255) NOT NULL default '', comment_type varchar(20) NOT NULL default '', comment_parent bigint(20) unsigned NOT NULL default '0', user_id bigint(20) unsigned NOT NULL default '0', PRIMARY KEY (comment_ID), KEY comment_post_ID (comment_post_ID), KEY comment_approved_date_gmt (comment_approved,comment_date_gmt), KEY comment_date_gmt (comment_date_gmt), KEY comment_parent (comment_parent) ) DEFAULT CHARACTER SET utf8
Viewing 1 replies (of 1 total)
  • you should ALWAYS update.

    anyways, deactivate EVERY plugin.
    Is it fixed?

    If yes, then activate one plugin at the time, then look at your site (refresh), then go back to plugins page to active second one and so forth.

Viewing 1 replies (of 1 total)
  • The topic ‘upgrade/host problem’ is closed to new replies.