Thread

Just upgraded from ExpressionEngine 1.6.9 to 2.1, and now I’m trying to upgrade the Discussion Forum module too, but when I click on the module I get the following message:

A Database Error Occurred
Error Number: 1091

Can’t DROP ‘member_id’; check that column/key exists

ALTER TABLE `exp_forum_read_topics` DROP KEY `member_id`

Using MySQL 4.1.11 and PHP 5.

Any ideas? :S

I’ve looked into the database and member_id is clearly there, so I don’t know what the problem is…

When I was about to update to EE 2.1, where it says “We have detected that you are currently running ExpressionEngine version 1.6.9. If you are ready to update ExpressionEngine to version 2.1.0 click the link below:” I got a PHP error:

A PHP Error was encountered

Severity: Notice

Message: unserialize() [function.unserialize]: Error at offset 2889 of 3748 bytes

Filename: core/Installer_Config.php

Line Number: 168

Not sure if that’s related.

Rolled back to 1.6.9 and repeated everything again; same result. :(

A Database Error Occurred
Error Number: 1091

Can’t DROP ‘member_id’; check that column/key exists

ALTER TABLE `exp_forum_read_topics` DROP KEY `member_id`

Did you also get the unserialize() error on the second try? I’d like to address that first to ensure the 2.1 upgrade went smoothly.

Yeah, on the second try I got the exact same error. Although if I press Back and try again the error does not appear again.

This is on a production server, btw. I’ve dumped the site and database over to MAMP, and tried updating to EE2.1 from there, and I got the same unserialize() PHP error prior to updating. AND, if I ignore the PHP error and continue with the upgrade, when it comes to upgrading the Forum module I get the same error as before.

So I guess it’s a problem with my database?

Macrike,

Are you using any add-ons/extensions on your 1.6.9 site?

I have the same problem:

A Database Error Occurred

Error Number: 1091

Can’t DROP ‘member_id’; check that column/key exists

ALTER TABLE `exp_forum_read_topics` DROP KEY `member_id`

Patata_killer,

I have replied to your thread here. There is no need to make multiple posts.