Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: SQL Issues  (Read 3696 times)

0 Members and 1 Guest are viewing this topic.

SaigonK

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 59
SQL Issues
« 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?

Logged

SaigonK

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 59
Re: SQL Issues
« Reply #1 on: July 05, 2005, 03:32:40 am »
anyone?
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: SQL Issues
« Reply #2 on: July 05, 2005, 08:38:33 am »
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.019 seconds with 19 queries.