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

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsFeedbackFeedbackGuestbook entries missingGuestbook entries missing
Previous
 
Next
New Post
1/16/2008 1:00 PM
 

Hi,

In the feedback list I deleted some categories and added some subject.
The entries in the comment view are now "gone !!"
I think because I deleted a category where the entries belonged to.
Is there a way to get them back ?

With regards, Ton Hermes


Art is hard work, inspiration is the cream on top of it. See my watercolors at www.watermansite.com and my enamel art at www.watermanshop.com
 
New Post
1/16/2008 1:13 PM
 

Check whether you still have rows in the feedback table... Are you familiar with SQL Server? I can send you over a script to update your entries if you are comfortable doing that...

Sanjay

 

The other thing you could do is that if you go to the settings for ViewComments - you can set it to ALL so that it shows all posts irrespective of the category...

 


AcuitiDP - Oracle Data Provider for DotNetNuke
 
New Post
1/16/2008 2:11 PM
 

Hi Sanjay,

Please, send me the script.
I know somebody who is familiar wit sql an can help me with this.
Many thanks,

With regards, Ton Hermes


Art is hard work, inspiration is the cream on top of it. See my watercolors at www.watermansite.com and my enamel art at www.watermanshop.com
 
New Post
1/16/2008 2:31 PM
 

UPDATE    dbo.Feedback
SET              CategoryID = NULL
WHERE     (CategoryID IS NOT NULL) AND (CategoryID NOT IN
                          (SELECT     ListID
                            FROM          dbo.FeedbackList))

This is assuming that you are not using any objectQualifier and your databaseOwner is dbo. If it's not then you'd need to preface the table (for example dbo.feedback) with the correct objectQualifier and databaseOwner.

 

Thanks

Sanjay

 


AcuitiDP - Oracle Data Provider for DotNetNuke
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsFeedbackFeedbackGuestbook entries missingGuestbook entries missing


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