-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I believe I've seen this before. It won't let you delete things that are referenced in the log/querylog (stored in the database).
Have you tried zeroing out the log, and then removing the account? __Jim On 5/22/2012 10:16 AM, Mike Haudenschild wrote: > Good afternoon, > > During our beta testing, I created a number of generic local accounts > (using vcld --setup). Now that we're moving into production, we're > using Shib and LDAP and I need to delete those local accounts. When I > try manually removing the user from the vcl.user table, I get the > following error: > > ERROR 1451 (23000): Cannot delete or update a parent row: a foreign key > constraint fails (`vcl/querylog`, CONSTRAINT `querylog_ibfk_1` FOREIGN > KEY (`userid`) REFERENCES `user` (`id`)) > > I'm hesitant to go poking about any further in the database. Is there a > standard procedure for removing local users? (Note: I'm on 2.2.1.) > > Thanks, > Mike > > -- > *Mike Haudenschild* > Education Systems Manager > Longsight Group > (740) 599-5005 x809 > m...@longsight.com <mailto:m...@longsight.com> > www.longsight.com <http://www.longsight.com> > - -- Jim O'Dell Network Analyst California State University Fullerton Email: jod...@fullerton.edu Phone: (657) 278-2256 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/ iEYEARECAAYFAk+7zOUACgkQREVHAOnXPYTPggCgjf83JqEUgV96hdEZ8jRPM7JD kyAAmwUSA1zOKUMPDC3W92eoFsm4q4LN =DIEC -----END PGP SIGNATURE-----