band

Some trouble while trying to import…

Database error: [Duplicate column name ‘post_excerpt’]
ALTER TABLE wp_posts ADD COLUMN post_excerpt text NOT NULL;

Database error: [Duplicate column name ‘post_status’]
ALTER TABLE wp_posts ADD post_status ENUM(‘publish’,’draft’,’private’) NOT NULL, ADD comment_status ENUM(‘open’,’closed’) NOT NULL, ADD ping_status ENUM(‘open’,’closed’) NOT NULL, ADD post_password varchar(20) NOT NULL;

That went well! Now let’s clean up the b2 database structure a bit…

Database error: [Can’t DROP ‘ID’. Check that column/key exists]
ALTER TABLE wp_posts DROP INDEX ID

One down, two to go…

Database error: [Table ‘band_B2.wp_settings’ doesn’t exist]
ALTER TABLE wp_settings DROP INDEX ID

So far so good.

Database error: [Can’t DROP ‘post_karma’. Check that column/key exists]
ALTER TABLE wp_posts DROP post_karma

Almost there…

Database error: [Can’t DROP ‘ID’. Check that column/key exists]
ALTER TABLE wp_users DROP INDEX ID

Right off the bat, I get this

“Sorry, I can’t write to the directory. You’ll have to either change the permissions on your WordPress directory or create your wp-config.php manually.”

Alrighty, I added the changes and the smilies show up, however when I click them nothing happens. Could it have something to do with this:

“Note: You cannot have clickable smilies AND the WYSIWYG editor. If both are present you will be able to see the smilies but nothing will happen when you click them. You will need to switch the new editor off for them to work”