I can look into this tomorrow. Please let me know if someone is already working on this. Thanks, Gail
----- Original Message ----- > From: "Sanne Grinovero" <sa...@hibernate.org> > To: "Gail Badner" <gbad...@redhat.com>, "Davide D'Alto" <dav...@hibernate.org> > Cc: "hibernate-dev" <hibernate-dev@lists.jboss.org>, "Sanne Grinovero" > <sa...@hibernate.org> > Sent: Wednesday, February 11, 2015 10:57:55 PM > Subject: Re: [hibernate-dev] in.relation.to error when posting a new blog > entry > > Hi, sorry I forgot about this and I'm currently away so if someone could > look at it that would be great. > I suspect it's a broken foreign key on MySQL, hopefully the error message > will have some details? Some table maintenance should do the trick. > You'll have to ssh into in.relation.to and from there connect to the MySQL > console. The connection details are in the datasource description deployed > in the AS (I don't remember them but that's a good place to read the > hostname and access credentials to the db). > The firewall on the db server will not allow you to connect from your own > place, so make sure you use the MySQL console from the in.relation.to > server. > An alternative might be to use the AWS dashboard, maybe it has some tools > for db maintenance? I usually use the terminal myself. > > Thanks > Sanne > > On Thu, 12 Feb 2015 02:36 Gail Badner <gbad...@redhat.com> wrote: > > > I ran into the same thing a couple of weeks ago when I deleted some spam > > comments before trying to create new weblog. I asked Sanne about this and > > he mentioned that he's seen this happen after deleting spam comments. He > > said it would require some clean up, but he didn't have time. > > > > Sanne, I know you're very busy. Can you point one of us in the right > > direction to clean up what is necessary? > > > > Thanks, > > Gail > > ----- Original Message ----- > > > From: "Davide D'Alto" <dav...@hibernate.org> > > > To: "hibernate-dev" <hibernate-dev@lists.jboss.org> > > > Sent: Wednesday, February 11, 2015 7:42:52 AM > > > Subject: [hibernate-dev] in.relation.to error when posting a new blog > > entry > > > > > > Hi, > > > I'm trying to create a new blog entry on in.relation.to > > > but an exception occurs about the violation of an integrity constraint. > > > > > > Any idea on how to solve the issue? > > > > > > Thanks, > > > Davide > > > > > > _______________________________________________ > > > hibernate-dev mailing list > > > hibernate-dev@lists.jboss.org > > > https://lists.jboss.org/mailman/listinfo/hibernate-dev > > > _______________________________________________ hibernate-dev mailing list hibernate-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev
