Thread

This is an archived forum and the content is probably no longer relevant, but is provided here for posterity.

The active forums are here.

Error Number: 1091 Can't DROP 'member_id'

December 14, 2010 3:54pm

Subscribe [2]

#1 / Dec 14, 2010 3:54pm
Gert Timmerman
33 posts
I have updated to newest version of EE and now i want to update the forum module. When i click the module i get a error:
```
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`

Filename: modules/forum/upd.forum.php

Line Number: 829
```
I have searched for this error and check the bug tracker about this topic and this topic: http://ellislab.com/forums/viewthread/136850/

But i can’t resolve it.

I can see that the table don’t have any index of primary key. When i want to make member_id the primary key i get a duplicate error messages because we use multiple boards, so a user can get 2 rows for each board. When i make the combination of member_id and board_id the primary key i still get the error.

How do i resolve this???
#2 / Dec 15, 2010 4:40am

John Henry Donovan
12339 posts

Gert,

Did you use the version or the build docs to update EE?
What version did you upgrade from?

What version and build are showing in your footer. (Not the EE Info Accessory)

Regarding your forum. You have uploaded the recent build of the Forum Module files?
What Forum version is showing in your Module index page?