I have 2 users with the same permissions but one of them gets the following message when trying to access their basket or My eB. - "Object reference not set to an instance of an object".
The problem user was created in version 14 and migrated to v15 but has only just now tried to use eB. Can the basket and my eB be re-created easily?
founf the SQL to add missing baskets - will try this in our test system
tried the SQL but get this message
Msg 515, Level 16, State 2, Line 1
Cannot insert the value NULL into column 'namespace_id', table 'eBUpgrade.dbo.gui_folders'; column does not allow nulls. INSERT fails.
The statement has been terminated.
We did little modification on script and now it should work. Let us know the result.
insert into gui_folders (gui_folder_id, namespace_id, name, description) select s.value, 1, 'My eB', NULL from setting_defs sd inner join settings s on s.setting_id = sd.setting_id left join gui_folders f on f.gui_folder_id = s.value where sd.category_id = 2 and sd.object_type = 4 and sd.code in ('PersonalFolderId', 'PersonalBasketId') and f.gui_folder_id is null
Answer Verified By: Carma De Villiers