Welcome Guest   | Login   
  Search  
  Index |  Recent Threads |  Register | 


Quick Go »
Thread Status: Normal
Total posts in this thread: 4
[Change thread status] [Delete this Thread] [Move this Thread]
[Add To My Favorites] [Watch this Thread] [Post new Thread]
Author
Previous Thread This topic has been viewed 159 times and has 3 replies Next Thread
jupdyke
New Member
Member's Avatar

USA
Joined: Sep 13, 2007
Posts: 13
Status: Offline
Edit this Post   Error message when trying to update category. Reply to this Post
Reply with Quote
[Delete this Thread]

I keep getting this error message when I try to update a catergory heading in my discussion group: "Error executing SQL in CategoryDAOImplJDBC.update."

I have sent a message to tech but have not received a reply.

Anybody got a work around or fix for this?

jupdyke
[Sep 19, 2007, 9:09:25 AM] [70.241.31.94] Show Post Printable Version    www.progenda.com    Hidden to Guest [Link] Report threatening post: please login first  Go to top 
support
localendar Expert
Member's Avatar


Joined: Aug 9, 2022
Posts: 6439
Status: Offline
Edit this Post   Re: Error message when trying to update category. Reply to this Post
Reply with Quote
[Delete this Post]

I did reply (somewhere) asking if you can send us the text you are using for a category name so we can try and duplicate the problem.

We are working on this issue (your message hasn't been ignored smile )
----------------------------------------
Marc Higgins
Support Associate, localendar.com
Follow us on Twitter! http://www.twitter.com/localendar_news
[Sep 19, 2007, 12:56:18 PM] [171.159.192.10] Show Post Printable Version [Link] Report threatening post: please login first  Go to top 
jupdyke
New Member
Member's Avatar

USA
Joined: Sep 13, 2007
Posts: 13
Status: Offline
Edit this Post   Re: Error message when trying to update category. Reply to this Post
Reply with Quote
[Delete this Post]

The Discussion Forum is for www.bmoaonline.com (There is a link to the forum.)

The first catgory is "Genneral Topics" I realized I misspelled "Genneral" and have been attempting to correct it but get the error message everytime I try to fix the problem.

Jack Updyke
jupdyke@progenda.com
[Sep 19, 2007, 4:48:33 PM] [70.241.31.94] Show Post Printable Version    www.progenda.com    Hidden to Guest [Link] Report threatening post: please login first  Go to top 
support
localendar Expert
Member's Avatar


Joined: Aug 9, 2022
Posts: 6439
Status: Offline
Edit this Post   Re: Error message when trying to update category. Reply to this Post
Reply with Quote
[Delete this Post]

Problem solved (sort of)
There is an index on the Category name table in our database that isn't correct. It's trying to enforce unique category names for *all* localendar users. And since someone else already has a forum called "General", your change is being rejected. I renamed it something similar but spelled correctly for now.

To fix this issue, we'll have to temporarily take some databases offline, so this probably wont be fixed until this weekend.
----------------------------------------
Marc Higgins
Support Associate, localendar.com
Follow us on Twitter! http://www.twitter.com/localendar_news
[Sep 24, 2007, 11:02:39 PM] [67.86.148.33] Show Post Printable Version [Link] Report threatening post: please login first  Go to top 
[Show Thread Printable Version] [Post new Thread]

Help! | Cobranding | Legal | Privacy Policy | About localendar.com | Contact Us