Timout on search page Timout on search page
 

News:

CPG Release 1.6.27
change DB IP storage fields to accommodate IPv6 addresses
remove use of E_STRICT (PHP 8.4 deprecated)
update README to reflect new website
align code with new .com CPG website
correct deprecation in captcha

Main Menu

Timout on search page

Started by fval, August 19, 2008, 07:16:13 PM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

fval

My database has to many keywords. Then the page stop by php timeout.

I did change SQL clause in include/keyword.inc.php, line 24.

Original:

$result = cpg_db_query("select keywords FROM {$CONFIG['TABLE_PICTURES']} WHERE keywords <> '' $ALBUM_SET");

With my change:

$result = cpg_db_query("select distinct keywords FROM {$CONFIG['TABLE_PICTURES']} WHERE keywords <> '' $ALBUM_SET");