coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Miscellaneous => Topic started by: SaigonK on July 02, 2005, 04:45:41 PM

Title: SQL Issues
Post by: SaigonK on July 02, 2005, 04:45:41 PM
I am doing a cleanup of my databse to remove old users and old entries, and I get this when i do a check:

Problems with indexes of table `cpg11d_pictures`
Warning More than one INDEX key was created for column `aid`
Warning More than one INDEX key was created for column `owner_id`


Any thoughts on how to cure it? It doesnt seem to be impacting things (yet) but I dont want to wait around for it to go bad.
Also, i have a user gallery that I cant seem to get rid of:

Mr. X's Gallery

I have searched the database and I cant find it anywhere, yet I can see it on the website. I have removed the user, deleted his photos, etc. but Still no luck...any ideas there?

Title: Re: SQL Issues
Post by: SaigonK on July 05, 2005, 03:32:40 AM
anyone?
Title: Re: SQL Issues
Post by: Joachim Müller on July 05, 2005, 08:38:33 AM
http://coppermine.sourceforge.net/faq.php#lamesupport