No matter what I do, I cannot shake this problem =( Okay, I had previously installed wordpress but decided not to use it, so I deleted the files but I forgot to go and delete the databases. So, this time, when I went to go install everything, I got this error:
Database error: [Table ‘wp_posts’ already exists]
CREATE TABLE wp_posts ( ID int(10) unsigned NOT NULL auto_increment, post_author int(4) 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 text NOT NULL, post_title text NOT NULL, post_category int(4) NOT NULL default ‘0’, post_excerpt text NOT NULL, post_lat float, post_lon float, post_status enum(‘publish’,’draft’,’private’) NOT NULL default ‘publish’, comment_status enum(‘open’,’closed’) NOT NULL default ‘open’, ping_status enum(‘open’,’closed’) 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, PRIMARY KEY (ID), KEY post_date (post_date), KEY post_date_gmt (post_date_gmt), KEY post_name (post_name), KEY post_status (post_status) )
Now, I went back and deleted all the wp_ tables and all the wordpress files, edited the config file so the table name was “blog_” instead of “wp_”, then uploaded everything and I got the same thing [except instead of “Table ‘wp_posts'” it was “Table ‘blog_posts'”] even though I KNOW they weren’t there before…what should I do?? =T Everything shows up fine on my site, but now I can’t log in without the password that’s randomly generated…
Some please, pretty please help?? =(
- The topic ‘Please help…’ is closed to new replies.