Thread

Hello, I upgrade EE from 1.6.7 to 2.1 (not without complexities), and than I want to upgrade a forum.
As said in instructions, I placed contents in corresponding folders on server.
Than

Log into your ExpressionEngine Control Panel and visit this page:

Add-ons > Modules > Discussion Forum

Accessing that page will automatically tell ExpressionEngine to perform any internal updates that are needed for the new version.

But i get this error

A Database Error Occurred

Error Number: 1062

Duplicate entry '58-19' for key 1

ALTER TABLE `exp_forum_subscriptions` ADD PRIMARY KEY `topic_id_member_id` (`topic_id`, `member_id`)

I found a bug tracker https://support.ellislab.com/bugs/detail/10185/ and similar problem http://ellislab.com/forums/viewthread/136850/
but there are no any decision (

So, to recap: you’re running the very latest version and build of EE 2 suceesfully, and now want to upgrade the forum module?

thats riight I upgrade a EE and than I try to upgrade a forum module from 2.1.1 to 3.1

24here,

Does your 2.1 installation otherwise run properly? Was this the very first error you encountered when visiting the Discussion Forum page under Addons > Modules?

My first error was http://ellislab.com/forums/viewreply/774006/ but I click “Back” button on browser twice and the process go to the moment where I can push “Ignore the Template Warning” and the upgrade process end, than I go to Admin Panel and than I follow http://ellislab.com/expressionengine/user-guide/modules/forum/forum_update.html

Hi 24here,

To clarify, you’re still getting the error

A Database Error Occurred

Error Number: 1062

Duplicate entry '58-19' for key 1

ALTER TABLE `exp_forum_subscriptions` ADD PRIMARY KEY `topic_id_member_id` (`topic_id`, `member_id`)

when you visit the Discussion Forum page under Addons > Modules? Is it possible the forums were already upgraded at some point?

I upgraded EE without forum. I copy forum’s folders after EE upgrade, than go to Addons > Modules > Discussion Forum as said in user guide

Hi 24here,

Please go to CP Home > Tools > Data > SQL Manager > Manage Database Tables, select the exp_forum_subscriptions table and at the bottom choose “Repair selected tables”. Does that fix the error?

Cheers

Greg

Hi Greg

that problem fixed =) but the next problem when I click “Discussion Forum” is

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`

24here,

OK, we’re getting somewhere. Now do the same as Greg suggested before, but repair the exp_forum_read_topic table. What message (if any) do you get then?

24here,

OK, we’re getting somewhere. Now do the same as Greg suggested before, but repair the exp_forum_read_topic table. What message (if any) do you get then?

nothing, the same error,

Any suggestions?

Please check your email.

Hi 24here,

I was able to get your Forum upgraded to 3.1. Your forums are now working at http://www.yourdomain.ru/index.php/forum/

I ran into a couple other issues:

1. You had renamed your system directory but had not updated /index.php with the new directory name. Fixed.
2. You had a .htaccess file that was removing index.php from URLs, which I renamed to .htaccess_renamed. I also set your site’s index page back to index.php - leave this how it is until we get everything working, please.

As you’ll notice, if you go to your homepage at http://www.yourdomain.ru you get:

Unable to load requested field type file:  ft.lg_polls_q.php.

Confirm the fieldtype file is located in the expressionengine/third_party/ directory

It looks like you had some EE 1.x extensions in the mix with 2.x at some point, and some channels still have ‘missing’ fields associated with them. The solution is to do this:

1. Go to Admin > Channel Administration > Custom Fields

Do the following for Addons and LG Polls Custom Weblog Group:

2. Click Add/Edit Custom Fields
3. You will notice the fields that have problems, because the Field Type will be empty
4. Delete those problem fields.

You will lose some data related to the LG Polls extension when you do this, so backup your database first. Once you’ve removed those problem fields, you should be back up and running again. Do let us know how it works out.