Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Timout on search page  (Read 1485 times)

0 Members and 1 Guest are viewing this topic.

fval

  • Coppermine newbie
  • Offline Offline
  • Posts: 2
Timout on search page
« on: August 19, 2008, 07:16:13 pm »

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:

Code: [Select]
$result = cpg_db_query("select keywords FROM {$CONFIG['TABLE_PICTURES']} WHERE keywords <> '' $ALBUM_SET");
With my change:

Code: [Select]
$result = cpg_db_query("select distinct keywords FROM {$CONFIG['TABLE_PICTURES']} WHERE keywords <> '' $ALBUM_SET");
Logged
Pages: [1]   Go Up
 

Page created in 0.015 seconds with 20 queries.