Technical support This forum is closed.
Version 1.x > Technical support > SQL errors when editing roles View modes: 
User avatar
Member
Member
trint99 - 10/9/2006 4:56:25 PM
   
SQL errors when editing roles
I get frequent SQL errors when trying to set up users, roles and permissions. The stored procedures for these tasks are in the KenticoCMS database, but the tables that those stored procedures need to modify are in the KenticoUsers database, so the stored procs always get a "Invalid object name" error. Is this a configuration/installation error on my part? What is the proper fix?

Thanks,
Trint

User avatar
Member
Member
trint99 - 10/9/2006 4:57:39 PM
   
Re: SQL errors when editing roles
By the way, not all user actions cause this error. I have been able to add and edit users. Just not their permissions.

User avatar
Member
Member
trint99 - 10/9/2006 5:00:47 PM
   
Re: SQL errors when editing roles
I am using 1.9b upgraded from 1.8. (Would be nice if I could edit previous posts).

User avatar
Member
Member
trint99 - 10/9/2006 5:34:40 PM
   
Re: SQL errors when editing roles
Please delete this thread. I found that another developer had been monkeying with the database. I'll make sure his fingers are broken to prevent further problems. *wink*