Warning in MySQL Warning in MySQL
 

News:

CPG Release 1.6.28
added submissions from {406man}
cleaned up a few PHP (8.4) deprecations
fixed PHP deprecation in calendar
removed security vulnerability
(please upgrade when possible)

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)