I just tried to do an upgrade from 2.661 to 3.333 (or whatever the latest version is), and I got the following error:

Error during upgrade: failed to execute statement create table mt_log ( log_id integer not null primary key auto_increment, log_author_id integer default 0, log_blog_id integer default 0, log_category varchar(255), log_class varchar(255) default 'system', log_ip varchar(16), log_level integer default 1, log_message varchar(255), log_metadata varchar(255), log_created_on datetime, log_created_by integer, log_modified_on timestamp not null, log_modified_by integer ): Table 'mt_log' already exists at /usr/home/simberg/domains/transterrestrial.com/lib/MT/Upgrade.pm line 1190.

Anyone know what the problem is, and how to fix?

(Good thing I backed up my installation and database...)

Once of the things I noticed was that it didn't count any of my postings towards the post count on the MT BLEG post. I'm thinking that it was because I don't have my e-mail attached to my name, and it didn't want to count it.

Of course, based on that error, it sounds like you need to delete the mt_log table to upgrade, which sounds, well, ludicrous. Wouldn't be much of an upgrade then, would it?

Is it (or are you) supposed to change the name of the old mt_log table to something like mt_log_old before upgrading or anything like that?

Is it (or are you) supposed to change the name of the old mt_log table to something like mt_log_old before upgrading or anything like that?

There's nothing in the upgrade instructions about it.

Rand

I came to the site a little while ago and it gave me, instead of the site, a login screen.

Dennis