SQL Issues SQL Issues
 

News:

CPG Release 1.6.28
added submissions from {406man}
cleaned up a few PHP (8.4) deprecations
fixed PHP deprecation in calendar
removed security vulnerability
(please upgrade when possible)

Main Menu

SQL Issues

Started by SaigonK, July 02, 2005, 04:45:41 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

SaigonK

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?


SaigonK


Joachim Müller