Hi Peter,

I have just recently upgraded from DNN 3.2.2 to 5.4.4. With this upgrade, I also upgraded DMX from 3.4.6 to 5.2.11. I followed all the guides for running scripts to convert the data for the new version. The problem that I am having is mainly with the missing categories.
For example, I have a document which belongs to 3 different categories in the previous version, but after the updrade, it only shows the last category in the list. The first two are missing. When I look in the database, all 3 categories exist in the table DMX_Entries for that document, but it just doesn't show on the user interface.

Is there a way to get all the categories back? Please advise.

Thanks
Yiji

Hi Yiji,

1. Which "list" are you referring to? The list on the details panel?
2. If you click on the various categories in the tree, do you see the document com up on the right?
3. You confirmed the document was still linked by going to the database and checking DMX_EntryCategories or did you see it in the edit screen of the entry?

Peter

[quote]
Posted By Peter Donker on 10 Jun 2011 11:46:23
Hi Yiji,

1. Which "list" are you referring to? The list on the details panel?
Yes
2. If you click on the various categories in the tree, do you see the document com up on the right?
When there are more than one caterory, it only shows the last category stored in the database.
3. You confirmed the document was still linked by going to the database and checking DMX_EntryCategories or did you see it in the edit screen of the entry?
I was looking at the wrong table. In GSW_DMX_Entries, all my category are there, but not in the DMX_EntryCategories.

Peter

[/quote]

There seems to be a problem with the upgrade script. Let me try to illustrate this by an example:

On my previous installation (DMX 3.4.6)
Table GSW_DMX_Entries
EntryId Categories
627 2;28;36;

After I upgrade to DMX 5.2.11, I lost the first two categories for this document.
GSW_DMX_EntryCategories

EntryId CategoryId
627 36

Ah, now I see what you mean. OK, let me check that bit.

Peter