Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeGetting StartedGetting StartedNew to DNN Plat...New to DNN Plat...Users table does not existUsers table does not exist
Previous
 
Next
New Post
3/21/2013 4:38 PM
 
I have made a module that use Users table of DNN.
But today I get wired error that Users table does not exist.
When I looked in database I saw that Users table name is actually dbo_Users.
I thought that DNN Users table always have the same name but it seams it is not.

What is the reason that dnn added that prefix to table (all DNN tables) and how can I know if table has that prefix?
 
New Post
3/21/2013 5:21 PM
 
Hello,

Well... a few things here...

First, you are getting that because DNN supports different prefixes on tables based on who the DB owner is as well as object qualifiers in the case of custom modules.

Second, you probably don't want to interact with DNN's users table directly. Instead, it is very strongly recommended you use the API. If you use the DNN API, then you never need to worry about what the table is called. There are very few cases where you'd want something that directly works with the users table... they are usually just maintenance modules and the like.

Mike
 
Previous
 
Next
HomeHomeGetting StartedGetting StartedNew to DNN Plat...New to DNN Plat...Users table does not existUsers table does not exist


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out