forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: Mimer on October 23, 2007, 08:49:31 am

Title: Warning in MySQL
Post by: Mimer 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)

Title: Re: Warning in NySQL
Post by: Sami on October 23, 2007, 08:55:18 am

More detail please ...
- link?
- did you install any plugin or mod?

Title: Re: Warning in MySQL
Post by: Nibbler on October 23, 2007, 10:13:26 am

http://forum.coppermine-gallery.net/index.php?topic=43471.0

Title: Re: Warning in MySQL
Post by: Mimer 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

Title: Re: Warning in MySQL
Post by: Mimer on October 23, 2007, 10:31:22 am

Hi

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

Thanks.

Mimer  8)

Title: Re: Warning in MySQL
Post by: Joachim Müller 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.

Title: Re: Warning in MySQL
Post by: Mimer 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 (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)