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 ForumsFeedbackFeedbackConversion from string "keyfield" to type Conversion from string "keyfield" to type 'Integer' is not valid.
Previous
 
Next
New Post
12/7/2008 11:36 AM
 

I was able to download and the copy the DLL file into the bin directory.  This allowed me to delete some of the new test comments I made, but it did not allow me to delete some old comments that were from a difference instance of a module.  The SQL worked for these older (different instance) comments.  Thanks for that.  BTW the SQL I used was:  DELETE FROM Feedback WHERE FeedbackID = [ID of the post you want to delete]

On the old instance of the module which I still use, I had deleted the feedback comments module that goes with it.  I was just using it for people to send me an email and I was not moderating, or using any subjects or categories or displaying any of the comments. 

Your directions on changing the stored procedcure are over my head.  I don't understand where to find it, what the file name is, and can I use NotePad to modify it?  Can you provide more specific instructions?

I don't remember if I deleted it and added a new one.  Maybe.  I've been trying lots of things to get this to work. 

What about an SQL for moving a feedback item from pending to published??  (I would like to fix this problem so I don't need this, but I need to get these things posted NOW.)

I have also changed the values on my one category and three subjects to either 1, 2, or 3.  This did nothing expect change the subject line of the email I receive.  The subject line is now the value instead of the name of the subject. 

Thanks for your help on this!

 

 
New Post
12/7/2008 11:46 AM
 

Lisa - if you look at the Feedback table, there should be a status column. If you change the value of that column this will move the items from pending to published, etc. This is usually handled on the front end from the moderate comments page which is why I'd recommended getting your ability to change statuses to be fixed which should then allow you to change the status. Were you able to navigate to the Moderate Comments page?
Sanjay


AcuitiDP - Oracle Data Provider for DotNetNuke
 
New Post
12/7/2008 12:46 PM
 

I can go the the Moderate Comments page.  That is ths page I'm on when I trying to click "Publish" for my pending comments.  Clicking Publish is what generates the initial error in my first post. 

If by Feeback table, you are referring to what you see on the Moderate Comments page -- then I don't see a status column.  The column labels are:  Subject, Message, From, Create Date

Below is what I'm looking at.  This is the only table I see and what I'm referring to as the Moderate Comments page. 

 

Moderate Feedback Posts

 


Return to Module




Page 1 of 1 First   Previous   Next   Last   
        Subject Message From Create Date
Publish Set Private Archive Delete Feedback on POOGI Newsletter Series I love them - they are brief and all make a great point. Submitted By: Jerry Shuster JShuster@iqpace.com 12/5/2008 5:09:43 PM
Publish Set Private Archive Delete Feedback on POOGI Newsletter Series Please do NOT remove it. It has a definite sprinkling of very valuable ideas. Thank you. Submitted By: Rene Fernandez-Noble aurenf@hotmail.com 12/5/2008 4:00:27 PM
Publish Set Private Archive Delete Feedback on POOGI Newsletter Series Very interesting...please continue. Submitted By: Jeff Sims myjeffsims@yahoo.com 12/5/2008 10:14:29 AM
Publish Set Private Archive Delete Feedback on POOGI Newsletter Series Yes Dr. Lisa, the POOGI series are useful for me. I'm following them. It would be very interesting to see the series keep covering the TOC Market/Sales, and continue up to the Strategy&Tactics processes. Hope other readers ask for the continuation. Rgds. Submitted By: Cesar Quiros cesarquiros@racsa.co.cr 12/5/2008 9:37:52 AM
Publish Set Private Archive Delete Feedback on POOGI Newsletter Series Please keep going with POOGI! I truly believe that you are enlightening the world as to the power of TOC. I can't tell you how many times I have quoted you since you began. Bob Submitted By: Bob Sproull ras8202@live.com 12/5/2008 4:12:18 AM
Publish Set Private Archive Delete Feedback on POOGI Newsletter Series It's an excellent series that delivers an understanding of the issues & what can be done to make improvements. It helps me in my marketing of consulting services & it delivers another touch to people in the sales funnel. I'd encourage you to continue the series. Thanks. John Submitted By: John Harkins harkins@gtjl.com.au 12/4/2008 11:37:28 PM
Publish Set Private Archive Delete Feedback on POOGI Newsletter Series I always read it, as a TOC reminder, and I often forward it to others. Submitted By: Jason Mellancon jkm@edgelight.net 12/4/2008 9:47:38 PM
Publish Set Private Archive Delete Feedback on POOGI Newsletter Series I am a Residential Design/ Builder for new homes and extensive remodeling. Our focus is energy efficient and green Build costruction disciplines. I do pick and choose from the factory settings because in essence my site built homes are similar to factory and production. I would like to hear about other topics. Thanks again for taking the time to share your knowledge. Sincerely, Dan Submitted By: Dan A. danander@centurytel.net 12/4/2008 9:05:21 PM
Publish Set Private Archive Delete Feedback on POOGI Newsletter Series I have really been enjoying this series, I have been along for the last 15. I read the Goal when it 1st came out, and have slowly been working on implementation. Thanks for sharing all you do. Sincerely, Keith Submitted By: Keith Garrison keith@gbfenterprises.com 12/4/2008 8:37:41 PM




Page 1 of 1 First   Previous   Next   Last   
      Subject Message From Create Date




Page 1 of 1 First   Previous   Next   Last   
      Subject Message From Create Date




Page 1 of 1 First   Previous   Next   Last   
      Subject Message From Create Date
 
New Post
12/7/2008 9:07 PM
 

Sanjay,

I asked my host to make the stored procedure changes and here is their response:

Lisa,
 
I updated the sp as specified in that forum post, but I am still showing that the error is still received. The same stack trace is received even after updating that sp.
 
Thanks,
Jeremy K.
Portal Web Hosting
 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsFeedbackFeedbackConversion from string "keyfield" to type Conversion from string "keyfield" to type 'Integer' is not valid.


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