Warning in MySQL Warning in MySQL
 

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]

Main Menu

Warning in MySQL

Started by Mimer, October 23, 2007, 08:49:31 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Mimer

Hi

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

QuoteProblems 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)

Sami

More detail please ...
- link?
- did you install any plugin or mod?
‍I don't answer to PM with support question
Please post your issue to related board


Mimer

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

Mimer

Hi

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

Thanks.

Mimer  8)

Joachim Müller

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.

Mimer

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)