Thread

This question is related to this thread and this bug report.

Hello,

I’m working on a large project that has come to a stand still because of this bug. Our customer has over 850 product entries and we need to be able to move these entries to different channels. There are 10 channels that the products will be distributed to.

Steps to reproduce:

1. Install latest EE
2. Create two or more channels
3. Add several entries, all in the same channel
4. Go to Content/Edit
5. Click on an entry to edit
6. On the Edit Entry view, click the OPTIONS tab
7. Click the Channel drop down

Once you click the channel drop down, you will see that there are no other channels that can be selected and only the currently associated channel shows in the drop down.

Details of my install:

1. I’m on beta 2.1.4, Build: 20110201
2. All 10 channels share the same field group, category group and status group
3. Clean install, No extensions
4. Plugins installed are: ImageSizer and Low Replace

I upgraded to beta 2.1.4 because the thread above said this bug was fixed in that release, but it is not fixed.

Also in that thread there is a workaround mentioned, but it is not clear how the workaround is done.

Will someone please post step by step details for this workaround? An example SQL statement and explanation please.

Thank you.

After a reply from Greg in this thread http://ellislab.com/forums/viewthread/179340/ I took another look into the db. The channel_id for each entry is set correctly, so the SQL workaround would not work anyway.

Is there an ETA on the fix?

There are three tables that need to be changed:

exp_channel_titles
exp_channel_data

and exp_comments if you use comments.

Assuming you are moving entry_id 123 to a channel with the channel_id of 5, you’d do this:

update exp_channel_titles set channel_id = ‘5’ where entry_id = ‘123’
update exp_channel_data set channel_id = ‘5’ where entry_id = ‘123’
update exp_comments set channel_id = ‘5’ where entry_id = ‘123’