Small width layout Medium width layout Maximum width layout Small text Medium text Large text
     Search
Downloads Downloads Directory Directory Forums Forums Forge Forge Blogs Blogs        Marketplace Marketplace Careers Program Careers
Community › Forums Register  |  

telerik -- supercharge your DNN websites
  Ads  
Active Modules -- Active Forums for DotNetNuke
 


  Sponsors  

Meet Our Sponsors

CrystalTech Web Hosting™
Webhost4life, specialists in DNN hosting
Mad Development is a full service interactive agency focusing on the merge of design, technology, e-commerce, and affiliate marketing by providing total website solutions.
SteadyRain
DataSprings - Great Ideas. Always Flowing.
R2integrated - formerly bi4ce
 


DotNetNuke Forums
 
  Forum  DotNetNuke® Pro...  Feedback Module...  Guestbook entries missing
Previous Previous
 
Next Next
New Post 1/16/2008 10:00 AM
User is offline Ton Hermes
277 posts
www.watermansite.com
9th Ranked


Guestbook entries missing 

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
 
New Post 1/16/2008 10:13 AM
User is offline Sanjay Mehrotra
509 posts
www.acuitisolutions.com
8th Ranked




Re: Guestbook entries missing 

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 11:11 AM
User is offline Ton Hermes
277 posts
www.watermansite.com
9th Ranked


Re: Guestbook entries missing 

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
 
New Post 1/16/2008 11:31 AM
User is offline Sanjay Mehrotra
509 posts
www.acuitisolutions.com
8th Ranked




Re: Guestbook entries missing 

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 Previous
 
Next Next
  Forum  DotNetNuke® Pro...  Feedback Module...  Guestbook entries missing
 


Forum Policy

These Discussion Forums are dedicated to the discussion of the DotNetNuke Web Application Framework.

For the benefit of the community and to protect the integrity of the project, 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 DotNetNuke.
2. Discussion or promotion of DotNetNuke product releases under a different brand name are strictly prohibited.
3. No Flaming or Trolling.
4. No Profanity, Racism, or Prejudice.
5. Site Moderators have the final word on approving/removing a thread or post or comment.
6. English language posting only, please.

 


Ultra Media Gallery & Video Gallery
The most popular photo gallery and video gallery module. with Flash interface.
www.bizmodules.net
WDK Solutions
Quality modules for the DotNetNuke community. Check out our 'wild' modules!
wdkns.com
UK - DotNetNuke providers
UK providers of DNN module development and skin package design. Oxford Information Labs provides cost-effective solutions for businesses and organisations specialising in Skin design and bespoke module development.
www.oxil.co.uk

DotNetNuke Corporation   Terms Of Use  Privacy Statement
DotNetNuke®, DNN®, and the DotNetNuke logo are trademarks of DotNetNuke Corporation
Hosted by MaximumASP