Developer forum

Forum » Dynamicweb 10 » After upgrade from Dw9 to DW10 - users no longer belongs to their groups

After upgrade from Dw9 to DW10 - users no longer belongs to their groups

E-mail notifications
Jan Sangill
Reply
Posted on 15/05/2025 13:23:11

Hi,
After an upgrade my users in the solution all still exist. But they dont belong to their correct groups.
Any idea whats gone wrong here?


Replies

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Posted on 15/05/2025 14:04:17
Reply
This post has been marked as an answer

In dw10, users relation to the group has been moved to a seperate table.

See more here: https://doc.dynamicweb.dev/documentation/fundamentals/dw9upgrade/changes9to10.html

When you upgrade, Dynamicweb automatically convert the old @-format to the new relation table.

If you upgrade, and then later move your user and group table again to the upgraded databasem the conversion will not run again.

Updates in DW10 are run by code - using an update ID.

In the database you can see the update specific to this upgrade:

SELECT [UpdateId]
      ,[UpdateProviderName]
      ,[UpdateTime]
  FROM [Updates]
  where updateid = 'cbb9700d-cea9-4a3b-ae20-dc29cd654be0'

You can remove the entry from the update table and restart the application - and then it will be re-run.

BR Nicolai

Votes for this answer: 1
 
Jan Sangill
Posted on 16/05/2025 08:47:27
Reply

Hi ,
Yes this was run on my upgrade, but nothing migrated. I just deleted the entry again and restarted the application. The entry is added again, but no migration happened.

However, I saw that an SQL error happened in my logs. So the cause was that my database had a compatibility level of a 100:/ I set it correct, and the migration happened.

Ty.:)

 
Nicolai Pedersen Dynamicweb Employee
Nicolai Pedersen
Posted on 16/05/2025 10:00:32
Reply

Hi Jan

Good find... Level 100 is old! I will see if we should have a check for db compat level at start up.

BR Nicolai

 

You must be logged in to post in the forum