phocagallery id is null

[thierry_24h]

Hi,

Joomla - 3.4.8
Phoca Gallery- 4.2.1 (More than 14.000 photo)
Website http://www.les24heures.fr

I have migrate-from-joomla-2-5-to-joomla-3.x and now I have a problem with ‘multiple add’.
When I click on close, there is no thumbnail.
I have to go in phpmyadmin and manually change the phocagallery.id (who is null)
After this, thumbnail are generate and all is ok
What is my problem ?

Thanks

[Jan]

Hi, first try to update to latest version (I think this has nothing to do with the problem, but you should upgrade to 4.2.2)

Do you get any error there, some error message in the system, some javascript error?

Jan

[thierry_24h]

Hi, I upgrade. There is always the problem.
There is no error on the screen, no error in my log
which sets the no id? automatique id ? a variable in another table ?
A problem with mysql ?

Thank you

Thierry

[Jan]

Hi, which table and which column you are chaning?

There is standard autoincrement column ID, which means PHP does not set the ID as it does not know it, but MySQL detect the last ID and do a new ID + 1

What is the last ID you have (I think, it is not the case, that the integer is not enough for the count of IDs - as your count in this case will be larger than: 2.147.483.647, which I don't expect, it is)

Jan

Jan

[thierry_24h]

hi,
Table name is phocagallery - Column name is ID
Last ID is 13928

I change ID from 0 to the last value+1 for all news photos and after, i go in joomla admin, photo, select the categorie and it generate correctly

Thanks Jan for your help

[Jan]

Ok