Print Page - Sudden problem with batch add: pid=0

Title: Sudden problem with batch add: pid=0
Post by: fotofreek on September 17, 2006, 03:07:00 PM

Hi all,

After using coppermine for 2.5 years, I suddenly encounter a problem with the batch-add function (searchnew.php):
The directory listing appears, I select the directory, press [OK] and the blue [OK] bulb appears that the picture is succesfully added.
But coppermine will not show the picture, and if I peek into the _pictures table, I see that the added picture has a pid=0.
Any idea what can cause this sudden problem?

tia,

Victor

Title: Re: Sudden problem with batch add: pid=0
Post by: fotofreek on September 17, 2006, 09:12:04 PM

It is solved:
My hosting provider upgraded to mySql 5, that behaves a bit different on the auto_increment column attribute: the insert of a '' in an integer column will not increment to the next value. I was running an old picmgmt.inc.php that does try to insert a ''. Changed that to NULL, now everything is OK again.
I guess it is time for me to upgrade to CPG 1.4 ;)

Victor

Title: Re: Sudden problem with batch add: pid=0
Post by: Joachim Müller on September 17, 2006, 09:51:04 PM

Quote from: fotofreek on September 17, 2006, 09:12:04 PM
I guess it is time for me to upgrade to CPG 1.4 ;)

Definitely yes ;)

Thanks for returning and posting your solution.

coppermine-gallery.com/forum

Support => cpg1.3.x Support => Older/other versions => cpg1.3 Upload => Topic started by: fotofreek on September 17, 2006, 03:07:00 PM