[resolved] Search return 404 error? (4 posts)

  1. ruimacdonald
    Posted 2 years ago #

    I have created a page for search the database with the following code:

    #1. [abase form="search,1" table="calls" elements="name,entity,description,notes,link,year,month,day" columns="name,entity,description,notes!'75',year!'50',month!'25',day!'25'$Search Calls" echo="blue" ack="green"]

    #2. [abase table="calls" columns="name,entity,description,notes,link,year,month,day" echo=blue" ack="green"]

    And the result I have is a 404 error.

    You can see it here: http://noticiasongs.org/pesquisa-de-calls/

    Can you help, please?

    Rui Oliveira
    UN Online Volunteer


  2. ruimacdonald
    Posted 2 years ago #

    Ok, I have done some experiences and I found:

    1st the SEARCH is for the intire content of a field.

    2nd when I try to search a int field like the Year it gives a 404 error.

    Can't we change the Search for "like"?

    Please help to solve this issue.


    Rui Oliveira
    UN Online Volunteer

  3. kellmb
    Posted 2 years ago #

    I also really need the search to be 'LIKE' not exact. It would make your plugin work for me. Unfortunately it's not going to be usable for me as it is. It's a great plug in by the way, and with this change on the search it'd be 5 stars all the way :)

  4. Richard Halverson
    Plugin Author

    Posted 1 year ago #

    Please update to version 2.2.1. LIKE is used when you specify the operand in the field specification for the column. For example, [abase table="table1" form="1,search" columns="name"] will produce an SQL statement with a WHERE clause that searches name exactly: name='<name_value>'. [abase table="table1" form="1,search" columns="name=%name%"] will produce a WHERE clause that will search name='%<name_value>%'

Topic Closed

This topic has been closed to new replies.

About this Plugin

  • Frequently Asked Questions
  • Support Threads
  • Reviews

About this Topic


No tags yet.