showphoto: System error, unable to generate request form at this time.

[dumoulin]

Hi!

When I click on a thumbnail to see a photo, I get the message :

System error, unable to generate request form at this time.

Any idea what could be the problem?

Thanks in advance!

Richard

[dumoulin]

Ok more info here :

The problem started yesterday evening... I checked the code quickly and it is related to the Captcha. I turned off the captcha and the problem disappeared for now.

I checked the table pp_captcha and I have 352 820 rows in it. Looks like PP can't insert correctly in the table?

I tried INSERT INTO pp_captcha( id, code )
VALUES (
NULL , 'xy1za'
)

and I got a duplicate entry error.

I made a copy of the table and flushed the content.

I switched the Captcha to Yes and it is now working.

Maybe a job should clean the table daily or weekly?

Another solution would be to put the id used for the Captcha in the user session? (just an idea).

Any light on this would be really appreciated!

Thanks and have a great day!

Richard

[Chuck S]

Not sure why you would get that error. Null on an autoincrement field would simply use the next available number.

[dumoulin]

I did not check extensively the code that you use to generate the unique sequence but I think there is collision... The more entries in the table, the more collision.

I am just curious, why store this in a table...? Would it not be better in the php session?

[Chuck S]

I would suspect more a mysql issue over code issue personally. You can email us a url and admin login to the gallery and a login to see your database and its viewer so we can see the table.