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: Searchng shows the right thumbnails, but then donīt match with photos  (Read 2689 times)

0 Members and 1 Guest are viewing this topic.

julianvillarejo

  • Coppermine newbie
  • Offline Offline
  • Posts: 2

When I search some photos using a word from the title, the gallery finds the right thumbnails, but when I click over everyone the photo that shows doesnīt match

You can access the photo gallery clicking http://fotos.emcvillarejo.com. The site is in Spanish.

When it happens this is the debug information:

USER:
------------------
Array
(
    [ID] => 4973b195dff682b3166c18abad4177ed
    [am] => 1
    [liv] => Array
        (
           
  • => 36
  • [1] => 49
                [2] => 18
                [3] => 17
                [4] => 22
            )

       
[search] => ###vill
)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_group] => 1
    [user_active] => YES
    [user_name] => admin
    [user_password] => ********
    [user_lastvisit] => 2005-08-21 02:29:01
    [user_regdate] => 2005-07-17 12:41:34
    [user_group_list] =>
    [user_email] => julian@emcvillarejoc.om
    [user_website] => www.emcvillarejo.com
    [user_location] => Coslada
    [user_interests] =>
    [user_occupation] =>
    [user_actkey] =>
    [disk_max] => 0
    [disk_min] => 0
    [can_rate_pictures] => 1
    [can_send_ecards] => 1
    [ufc_max] => 3
    [ufc_min] => 3
    [custom_user_upload] => 0
    [num_file_upload] => 5
    [num_URI_upload] => 3
    [can_post_comments] => 1
    [can_upload_pictures] => 1
    [can_create_albums] => 1
    [has_admin_access] => 1
    [pub_upl_need_approval] => 0
    [priv_upl_need_approval] => 0
    [group_name] => Administrators
    [upload_form_config] => 3
    [group_quota] => 0
    [can_see_all_albums] => 1
    [group_id] => 1
    [groups] => Array
        (
            [1] => 1
        )

)

==========================
Queries:
------------------
Array
(
   
  • => SELECT extension, mime, content FROM cpg132_filetypes;
  • [1] => SELECT * FROM cpg132_users WHERE user_id='1'AND user_active = 'YES' AND user_password != '' AND BINARY MD5(user_password) = '410c79a01af1d0ab434db3614dba22de'
        [2] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg132_usergroups WHERE group_id in (1)
        [3] => SELECT group_name FROM  cpg132_usergroups WHERE group_id= 1
        [4] => DELETE FROM cpg132_banned WHERE expiry < '2005-08-21 02:41:57'
        [5] => SELECT * FROM cpg132_banned WHERE ip_addr='83.45.113.181' OR ip_addr='83.45.113.181' OR user_id=1
        [6] => SELECT pid FROM cpg132_pictures WHERE CONCAT(' ', keywords, ' ') LIKE '% vill %' OR filename LIKE '%vill%' OR title LIKE '%vill%' OR caption LIKE '%vill%' OR user1 LIKE '%vill%' OR user2 LIKE '%vill%' OR user3 LIKE '%vill%' OR user4 LIKE '%vill%'
        [7] => SELECT COUNT(*) FROM cpg132_pictures WHERE ( pid in (22,27,34,60,159,153,156,147,145,143,133,134,106,118,125,185,207,212,219,228,229,230,233,235,236,242,300) ) AND approved = 'YES'
        [8] => SELECT * FROM cpg132_pictures WHERE ( pid in (22,27,34,60,159,153,156,147,145,143,133,134,106,118,125,185,207,212,219,228,229,230,233,235,236,242,300) ) AND approved = 'YES'   LIMIT 0 ,1
        [9] => SELECT title, comments, votes, category, aid FROM cpg132_albums WHERE aid='2' LIMIT 1
        [10] => SELECT name, parent FROM cpg132_categories WHERE cid = '2'
        [11] => UPDATE cpg132_pictures SET hits=hits+1 WHERE pid='22'
        [12] => SELECT msg_id, msg_author, msg_body, UNIX_TIMESTAMP(msg_date) AS msg_date, author_id, author_md5_id, msg_raw_ip, msg_hdr_ip FROM cpg132_comments WHERE pid='22' ORDER BY msg_id ASC
    )

    ==========================
    GET :
    ------------------
    Array
    (
       
[album] => search
    [cat] => 0
    [pos] => 0
)

==========================
POST :
------------------
Array
(
)

==========================
VERSION INFO :
------------------
PHP version: 4.3.11 - OK
------------------
mySQL version: 3.23.58
------------------
Coppermine version: 1.3.3
==========================
Module: gd
------------------
GD Support enabled
GD Version bundled (2.0.28 compatible)
FreeType Support enabled
FreeType Linkage with freetype
GIF Read Support enabled
GIF Create Support enabled
JPG Support enabled
PNG Support enabled
WBMP Support enabled
XBM Support enabled
==========================
Module: mysql
------------------
Active Persistent Links 0
Active Links 1
Client API version 3.23.58
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib/mysql -lmysqlclient 
==========================
Module: zlib
------------------
ZLib Support enabled
Compiled Version 1.2.1.2
Linked Version 1.2.1.2
==========================
Server restrictions (safe mode)?
------------------
Directive | Local Value | Master Value
safe_mode | Off | Off
safe_mode_exec_dir | no value | no value
safe_mode_gid | Off | Off
safe_mode_include_dir | no value | no value
safe_mode_exec_dir | no value | no value
sql.safe_mode | Off | Off
disable_functions | no value | no value
file_uploads | On | On
include_path | .:/usr/share/pear | .:/usr/share/pear
open_basedir | /home/httpd/vhosts/emcvillarejo.com/subdomains/fotos/httpdocs:/tmp | no value
==========================
email
------------------
Directive | Local Value | Master Value
sendmail_from | no value | no value
sendmail_path | /usr/sbin/sendmail -t -i | /usr/sbin/sendmail -t -i
SMTP | localhost | localhost
smtp_port | 25 | 25
==========================
Size and Time
------------------
Directive | Local Value | Master Value
max_execution_time | 30 | 30
max_input_time | 60 | 60
upload_max_filesize | 2M | 2M
post_max_size | 8M | 8M
==========================
Page generated in 0.052 seconds - 13 queries in 0.008 seconds - Album set :
Logged

Nibbler

  • Guest

Clear your cookies. Please don't post debug info unless requested, as it makes reading the thread awkward.
Logged

julianvillarejo

  • Coppermine newbie
  • Offline Offline
  • Posts: 2

Sorry for the "long" question (for the debug information).

Thank you very much for your answer.
Thatīs right, but it is not a nice solution for the site visitors. I have found one solution for this cookies problem editing de search.php page (http://forum.coppermine-gallery.net/index.php?topic=14778.0)

I will try it.
Logged
Pages: [1]   Go Up
 

Page created in 0.02 seconds with 19 queries.