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: Warning in MySQL  (Read 2946 times)

0 Members and 1 Guest are viewing this topic.

Mimer

  • Translator
  • Coppermine frequent poster
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 129
    • Fjotte
Warning in MySQL
« on: October 23, 2007, 08:49:31 am »
Hi

I've noticed that MySQL gives me this warning when I check DB.

Quote
Problems with indexes of table `cpg141d_pictures`
More than one INDEX key was created for column `aid`


Is this an issue, or should I just ignore it?

Mimer  8)
« Last Edit: October 23, 2007, 12:39:36 pm by Nibbler »
Logged

Sami

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Gender: Male
  • Posts: 3686
  • BMossavari
    • My Project
Re: Warning in NySQL
« Reply #1 on: October 23, 2007, 08:55:18 am »
More detail please ...
- link?
- did you install any plugin or mod?
Logged
‍I don't answer to PM with support question
Please post your issue to related board

Nibbler

  • Guest
Re: Warning in MySQL
« Reply #2 on: October 23, 2007, 10:13:26 am »
Logged

Mimer

  • Translator
  • Coppermine frequent poster
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 129
    • Fjotte
Re: Warning in MySQL
« Reply #3 on: October 23, 2007, 10:26:58 am »
Link to my database?
Can't do mate  ;)

Gallery is running smoothly. No problems here.
It's when I'm in MySQL GUI checking and optimizing the DB I get this warning.

I'm running latest Coppermine with Stramms latest MOD pack.
These plugins:
Add thumbnails to Lightbox v1.2.3
Full-Size Photos Access Control v1.2
CPGMassImport v2.0
Onlinestats (Who is online) v1.2
Custom FilmStrip v1.0

Mimer  8)

Coppermine install: http://fjotte.dk/gal_da/
Forum install: Not bridged
Coppermine version: cpg1.4.13
Forum version: Not bridged
Test user account: test / test
Logged

Mimer

  • Translator
  • Coppermine frequent poster
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 129
    • Fjotte
Re: Warning in MySQL
« Reply #4 on: October 23, 2007, 10:31:22 am »
Hi

Problem solved.
Should have search this one. Sorry - I usely do.

Thanks.

Mimer  8)
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: Warning in MySQL
« Reply #5 on: October 23, 2007, 03:51:50 pm »
Quote from: Mimer on October 23, 2007, 10:31:22 am
Problem solved.
For the benefit of others, you might want to describe what you did to solve your issues.
Logged

Mimer

  • Translator
  • Coppermine frequent poster
  • **
  • Offline Offline
  • Gender: Male
  • Posts: 129
    • Fjotte
Re: Warning in MySQL
« Reply #6 on: October 23, 2007, 10:57:45 pm »
I did as describet in link from Nibbler:
http://forum.coppermine-gallery.net/index.php?topic=43471.0

I removed pic_aid and kept aid_approved.
Then I only have one INDEX key for column `aid`

Mimer  8)
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.041 seconds with 20 queries.