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: Warning in MySQL  (Read 2903 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
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 »

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
 

Page created in 0.022 seconds with 19 queries.