Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: Timout on search page  (Read 1483 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.014 seconds with 20 queries.