mysql error: [1062: Duplicate entry '65535'

[freaklance]

Hi all,
i run linpha 1.2.0 without any fault on a shared cheap linux hosting with MySql since 2,5 years.
I'm a newsman photographer and got almost 40000 photos and more than 2000 folders in the third level album.
This mornig, after running the create all thumb script (there is no script in the world i love so much) i had this list of several annoying errors:

mysql error: [1062: Duplicate entry '65535' for key 1] in EXECUTE("INSERT INTO FRK_third_lev_album (date, path, name, prev_alb_name) VALUES ('2009-03-24 15:45:46', 'albums/Tigullio/Eventi_Levante/100_anni_Rappini_Teresa','100_anni_Rappini_Teresa','Eventi_Levante')")

this is common in all errors:

mysql error: [1062: Duplicate entry '65535' for key 1] in EXECUTE("INSERT INTO FRK_third_lev_album (date, path, name, prev_alb_name)

An after, i've lost a lot of third level folders, even if the photos are there

in phpmyadmin i saw the third_lev_album table has smallint(5) for the value of the ID.
Do someone think i can alter the table to int in order to solve the error?
Is this safe?

Thounsands of thanks in advance

cheers

freaklance

[bzrudi]

Hi,

you are right. You ran into the smallint(5) limitation, so you should consider altering to int which will result in 2147483647 possible id's.
cheers bzrudi

BTW: You should considering updateing to latest because of security issues and other improvements if LinPHA is public.

Maybe of interest also, there is a cron script available in CVS which can be run by cron regulary to auto update all and everything...

[freaklance]

Hi Bzrudi,

i've no word of thanks for the great work and the help.
I still didn't update because of some minor changes i made in some scripts.

After your BTW i'm going to update and let's see what happens...

Thank you so much

Linpha is great for pro news photograpy

freaklance

P.S.
my linpha site is www.freakalnce.net

[freaklance]

Hi all,
i solved the error altering from smallint(5) to int (6) as expected.
However, i've lost some folder, i suppose the ones which were out of the smallint limit during the running of the create_all_thumb script.

Do someone think i can solve this issue recreating just the dirctories or i have to recreate everything (dir, thumb, exif and iptc)?
Is this recreate safe?

As usual, thanks a lot !

freaklance