Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

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
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumerror: Value cannot be null.error: Value cannot be null.
Previous
 
Next
New Post
7/28/2008 6:13 PM
 
Matthias Schlomann


Joined: 8/10/2003
Posts: 3594

Sure if you familar with T-SQL scripting and the database structure, you can use the SQL tool in the Host/System settings.

Regards
Matthias
DNN MVP
www.aarsys.de
Metro7 Skin
ShoutCastStats Module for DNN
 
New Post
7/28/2008 6:33 PM
 
Mark Hudy

Joined: 1/12/2005
Posts: 7

I have SQL Management Studio Express.  This is my 1st problem, there were no tables with a 'dnn_' prefix or any DNN tables that I could see when expanding my view on the 'DotNetNuke' database.

The tables were not listed therefore I posted here looking for help.  The tables are still NOT listed under SQL Management Studio Express?
 
New Post
7/28/2008 7:33 PM
 
Matthias Schlomann


Joined: 8/10/2003
Posts: 3594

Can you view procedures or views of the DNN databse?  if not you are not connected, or you didn't have permission to view the databases.  With SQL Management Studio Express you can view and modified the database.

Regards
Matthias
DNN MVP
www.aarsys.de
Metro7 Skin
ShoutCastStats Module for DNN
 
New Post
12/30/2008 3:48 PM
 
Joseph Roth

Joined: 8/3/2005
Posts: 12

Mark Hudy wrote
 

I was about to give up and then I found the SQL tool under the HOST menu.  Needed to be logged in as the SuperUser account to find it.

The following query displayed the errant post:

SELECT * from Forum_Posts
WHERE UserID = 0

Note: The PostID for this post is 137 and I knew the UserID for the user who posted was 17.

The following query fixed the errant post:

UPDATE Forum_Posts
SET UserID = 17
WHERE PostID = 137

My hats off to whomever included that nifty little SQL tool in the menu.  It saved the day.

 

 

Hey Mark - thanks for posting this - you saved my bacon! One question though - when I ran the SQL command:

SELECT * from Forum_Posts
WHERE UserID = 0

Nothing happened, it just gave a note that said the command successfully ran (or something like that).. any ideas why it didn't take me to that invalid/corrupt post?

Thanks again!

Joe
 
New Post
12/30/2008 5:18 PM
 
Chris Paterra


Joined: 4/5/2003
Posts: 4377

The SQL modules just runs SQL commands (some are off limits here for security reasons). These will either update the database and return a label message to you (like you have seen) or it will show results (in a grid) if your SQL was a SELECT statement. This is in no way tied to another module so it cannot navigate you to the forum module.

Chris Paterra

Get direct answers to your questions in the Community Exchange.
 
 Page 2 of 3
Previous123Next 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForumForumerror: Value cannot be null.error: Value cannot be null.


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