Searchng shows the right thumbnails, but then don´t match with photos Searchng shows the right thumbnails, but then don´t match with photos
 

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]

Main Menu

Searchng shows the right thumbnails, but then don´t match with photos

Started by julianvillarejo, August 21, 2005, 02:42:20 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

julianvillarejo

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 :

Nibbler

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

julianvillarejo

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.