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
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsSurveySurveyagain, thiis dbo.sysobjects thingagain, thiis dbo.sysobjects thing
Previous
 
Next
New Post
11/6/2006 6:28 AM
 
shai eden

Joined: 7/10/2006
Posts: 165

Hi

For me, the most known error with dnn, which I meet again & again, is this thing with the sysobjects table in the DB. Everytime there is a new upgrade to a module I get this somehow again...
So, maybe it's time 1 and 4 all - to call all developers to make it a developing rule:

DO NOT USE THIS IN YOUR SQL:
{databaseOwner}sysobjects

USE ONLY THIS:
DBO.sysobjects

Why?
Because not everybody are the actual DBO of the DB, many users (like me) are using a different userID as the portal owner.

For instance, the new survey module, which got out earlier this month, is, again, with the same error.

So... DNN Developers, Module Developers, Please notice.
 
New Post
11/6/2006 8:16 AM
 
Michael Washington


Michael Washington's Avatar

www.LightSwitchHelpWebsite.com
Joined: 7/17/2004
Posts: 3526

The script commands "{databaseOwner}" and "{objectQualifier}" indicate that they are to be replaced by configuration settings in the web.config file. Normally "{databaseOwner}" is set to ".dbo" and  "{objectQualifier}" is set to nothing (it would not have a setting). However, if alternate settings were indicated in the web.config file, those settings would be inserted into the script.

What version of DotNetNuke did you use to install the module?


Michael Washington
http://ADefWebserver.com
www.ADefHelpDesk.com
A Free Open Source DotNetNuke Help Desk Module
 
New Post
11/6/2006 8:25 AM
 
shai eden

Joined: 7/10/2006
Posts: 165

Hi

This I know...

But if you change the DBO value in your web.config then {databaseOwner} will become the user you changed to.

When, always, the sysobjects table belogns to 'DBO'.

In the sql file, it seems all ok, you even wrote dbo.sysobjects most of the times, but 1 time is saying: {databaseOwner}.sysobjects - and thats when it falls.

When writing a sql script about this table, you should always use 'dbo.' - that will work for everybody. When using {databaseOwner} it will work for only those who are using the DB as DBO, and didn't change the web.config.

After changing it to DBO.sysobjects - it installed with no errors.

Only now, I have a different error, mentioned in another topic here.
 
New Post
11/6/2006 8:49 AM
 
Michael Washington


Michael Washington's Avatar

www.LightSwitchHelpWebsite.com
Joined: 7/17/2004
Posts: 3526
I could not find the place where I did that. Can you tell me the name of the script you had to make the change to? Thanks

Michael Washington
http://ADefWebserver.com
www.ADefHelpDesk.com
A Free Open Source DotNetNuke Help Desk Module
 
New Post
11/6/2006 9:59 AM
 
shai eden

Joined: 7/10/2006
Posts: 165

Zip File: Survey_04.00.20_Source.zip

File: 03.03.00.SqlDataProvider.sql

Line 47:

if exists (select * from {databaseOwner}sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}GetSurvey]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

Should Be:

if exists (select * from DBO.sysobjects where id = object_id(N'{databaseOwner}[{objectQualifier}GetSurvey]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)

Hope it helps
Eden
 
 Page 1 of 2
12Next 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsSurveySurveyagain, thiis dbo.sysobjects thingagain, thiis dbo.sysobjects thing


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.