forum.coppermine-gallery.net

Support => cpg1.4.x Support => Older/other versions => cpg1.4 miscellaneous => Topic started by: MarianneC on September 15, 2008, 11:16:26 pm

Title: [Solved]: Search Syntax Question
Post by: MarianneC on September 15, 2008, 11:16:26 pm
I did a search, and I'm not coming up with a match already existing for this question.

The search box on my site works perfectly.  I have it set to default to use the "AND" syntax. So far so good.

However, I also have a set of searches already set up.  They are for street addresses.  And some of the addresses are similar (i.e. they all have "46" in them.)  The results that come back are not clean.

Here is the page:

http://www.useaboston.com/artists_buildings.htm

Here is the things that I have tried:

Code: [Select]

  <a class="text" href="2008a/thumbnails.php?album=search&type=and&search=46 Plympton">46 Plympton Street (18)</a><br>

or

  <a class="text" href="2008a/thumbnails.php?album=search&type=full&search=46 Plympton">46 Plympton Street (18)</a><br>

or

<a class="text" href="2008a/thumbnails.php?album=search&type=full&search=46+Plympton">46 Plympton Street (18)</a><br>



None of those gets only the correct results.  They all get 46 Waltham as well as 546 Tremont in addition to  46 Plympton.

The last version (with 46+Plympton) apparently worked back in version 1.2 - because that's what I find in an older version of this website.

Any suggestions for how I set up this query in a URL so that it will come back with the proper results?

Many thanks!
Marianne
Title: Re: Search Syntax Question
Post by: Nibbler on September 16, 2008, 08:46:17 pm
Can you enable debug mode in config and post the debug output you get at the search results page please?
Title: Re: Search Syntax Question
Post by: MarianneC on September 16, 2008, 09:26:07 pm
Thanks, Nibbler.  This is what I got:

USER:
------------------
Array
(
    [ID] => 60cb2243ae4b39fa197a377f2a7c1a33
    [am] => 1
    [lang] => english
    [sort] => na
    [search] => Array
        (
            [search] => 46 Plympton
            [params] => Array
                (
                    [user4] => 1
                    [keywords] => 1
                    [caption] => 1
                    [title] => 1
                )

        )

)

==========================
USER DATA:
------------------
Array
(
    [user_id] => 1
    [user_name] => cfarris
    [groups] => Array
        (
           
        )

    [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
)

==========================
Queries:
------------------
Array
(
    [album] => search
    [type] => full
    [search] => 46 Plympton
)

==========================
POST :
------------------
Array
(
    [search] => 46 Plympton
    [params] => Array
        (
            [user4] => 1
            [keywords] => 1
            [caption] => 1
            [title] => 1
        )

)

==========================
VERSION INFO :
------------------
PHP version: 4.4.7 - OK
------------------
mySQL version: 4.1.22-standard
------------------
Coppermine version: 1.4.18(stable)
==========================
Module: GD
------------------
GD Version: bundled (2.0.28 compatible)
FreeType Support: 1
FreeType Linkage: with freetype
T1Lib Support:
GIF Read Support: 1
GIF Create Support: 1
JPG Support: 1
PNG Support: 1
WBMP Support: 1
XBM Support: 1
JIS-mapped Japanese Font Support:

==========================
Module: mysql
------------------
MySQL Supportenabled
Active Persistent Links 0
Active Links 1
Client API version 4.1.22
MYSQL_MODULE_TYPE external
MYSQL_SOCKET /var/lib/mysql/mysql.sock
MYSQL_INCLUDE -I/usr/include/mysql
MYSQL_LIBS -L/usr/lib -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/lib/php:/usr/local/lib/php | .:/usr/lib/php:/usr/local/lib/php
open_basedir | /home/cfarris:/usr/lib/php:/usr/local/lib/php:/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.105 seconds - 17 queries in 0.008 seconds - Album set : ; Meta set: ;

Title: Re: Search Syntax Question
Post by: Nibbler on September 16, 2008, 09:53:21 pm
I have it set to default to use the "AND" syntax. So far so good.

You need to do that properly by editing include/search.inc.php

Code: [Select]
$type = $_POST['type'] == 'AND' ? " AND " : " OR ";
Change that to

Code: [Select]
$type = $_POST['type'] == 'OR' ? " OR " : " AND ";
Using the link bypasses the form, so the method you used for your search form won't apply.
Title: Re: Search Syntax Question
Post by: MarianneC on September 17, 2008, 12:19:06 am
Thanks Nibbler.  That did the trick perfectly!