SQLCE with uComponents Multi Node Tree Picker (MNTP) throws exception
Hello,
I have this site with a SQL Server database, using the SQL Server Compact Toolbox plugin for VS 2012, I transfered it to a SQLCE database. I was using uComponents' Multi Node Tree Picker. Now any content nodes that had my datatype that used the MNTP throw an error in the CMS backoffice.
If I understand your post correctly your MNTP datatype does not exist anymore? If so have you then removed the property on the document type(s) that is using it? If not try removing it and see if that fixes it.
If the MNTP still exist but a configured startnode has been deleted then go to the datatype and change the start node.
I still have the MNTP and I still have my datatype "abc" that uses MNTP. If I go in developper and select my "abc" datatype, I get the same error message. If I create a new datatype using the MNTP, it seems to work. I'm digging around in the database, trying to find something "un-set" or something, but I really am running out of ideas.
When you look at your "abc" datatype that references the MNTP in the datatypes section what node does i start on? Does that node still exist? Try changing the start node and see if that makes a difference. I hope this makes sense :)
So changing the prevalues did not solve my issue. I tried deleting the cmsPropertyData values assigned to that data type and it got me access to that "abc" data type in the developper section. But my content nodes still throw errors when I consult them. I guess I'll wipe anything related to that data type in my database. Wonder what really is going on. Ohh well I have to move on from this though.
SQLCE with uComponents Multi Node Tree Picker (MNTP) throws exception
Hello,
I have this site with a SQL Server database, using the SQL Server Compact Toolbox plugin for VS 2012, I transfered it to a SQLCE database. I was using uComponents' Multi Node Tree Picker. Now any content nodes that had my datatype that used the MNTP throw an error in the CMS backoffice.
I looked in the table schemas and noticed a discrepency:
Hi Sebastian
If I understand your post correctly your MNTP datatype does not exist anymore? If so have you then removed the property on the document type(s) that is using it? If not try removing it and see if that fixes it.
If the MNTP still exist but a configured startnode has been deleted then go to the datatype and change the start node.
Hope this helps.
/Jan
I still have the MNTP and I still have my datatype "abc" that uses MNTP. If I go in developper and select my "abc" datatype, I get the same error message. If I create a new datatype using the MNTP, it seems to work. I'm digging around in the database, trying to find something "un-set" or something, but I really am running out of ideas.
Thanks for the help Jan
Hi Sébastian
When you look at your "abc" datatype that references the MNTP in the datatypes section what node does i start on? Does that node still exist? Try changing the start node and see if that makes a difference. I hope this makes sense :)
/Jan
Hi Jan,
Well before I migrated my database to SQLCE, I had these
And if i look at the same thing in my SQLCE database:
So the values of my "abc" datatype (id = 1222) look to be exactly as they were previously. If I run my site with the old database, it runs smoothly.
Now I went back and checked that value, it's set to "SYSTEM DATA: umbraco master root" so my "content" node basically, that is #66, value set to -1.
I changed that value in my SQLCE to 1327 (another valid node id), but got the same result.
I'll try changing all the values one by one, see if I find a culprit. I'll repost soon.
Thanks!
So changing the prevalues did not solve my issue. I tried deleting the cmsPropertyData values assigned to that data type and it got me access to that "abc" data type in the developper section. But my content nodes still throw errors when I consult them. I guess I'll wipe anything related to that data type in my database. Wonder what really is going on. Ohh well I have to move on from this though.
Thanks for the help Jan
Hi Sébastian
What version of Umbraco are you using? And do you by any chance have made an upgrade from 4.7.x to 4.8 while migrating the DB as well?
/Jan
Hi Jan,
I had 4.7.2 and had not upgraded to newer versions while doing this. I'll be doing the upgrading this afternoon or next week :)
Thanks
is working on a reply...