Warning in MySQL Warning in MySQL
 

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

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)