Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: SQL Issues  (Read 3785 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?

SaigonK

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

anyone?

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
 

Page created in 0.022 seconds with 20 queries.