[Tickets #12976] No search possible because sesha_inventory WHERE sesha_inventory."stock_id" LIKE '%%'

[noreply at bugs.horde.org]

DO NOT REPLY TO THIS MESSAGE. THIS EMAIL ADDRESS IS NOT MONITORED.

Ticket URL: http://bugs.horde.org/ticket/12976
------------------------------------------------------------------------------
  Ticket             | 12976
  Created By         | skhorde at smail.inf.fh-bonn-rhein-sieg.de
  Summary            | No search possible because sesha_inventory WHERE
                     | sesha_inventory."stock_id" LIKE '%%'
  Queue              | Sesha
  Version            | 1.0.0RC3
  Type               | Bug
  State              | Unconfirmed
  Priority           | 3. High
  Milestone          |
  Patch              |
  Owners             |
------------------------------------------------------------------------------


skhorde at smail.inf.fh-bonn-rhein-sieg.de (2014-02-18 08:50) wrote:

I tried searching for "Item Name" and a string,

The SQL query tried to use "stock_id" LIKE '%%', which is:

a) a NOOP, IMHO
b) invalid, because stock_id is INTEGER and LIKE requires character strings,
c) I did not selected "Stock ID" as property to search for,
d) I miss the search string I entered

I also miss the properties I've created, in order to search through them.

========

HORDE: [sesha] SQLSTATE[42883]: Undefined function: 7 ERROR:  operator  
does not exist: integer ~~ unknown#012LINE 1: ... sesha_inventory  
WHERE sesha_inventory."stock_id" LIKE '%%' ...#012                      
                                         ^#012HINT:  No operator  
matches the given name and argument type(s). You might need to add  
explicit type casts.

SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist:  
integer ~~ unknown LINE 1: ... sesha_inventory WHERE  
sesha_inventory."stock_id" LIKE '%%' ... ^ HINT: No operator matches  
the given name and argument type(s). You might need to add explicit  
type casts.

  1. Sesha_View_List->__construct() /var/www/horde/sesha/list.php:49
  2. Sesha_View_List->stock() /var/www/horde/sesha/lib/View/List.php:76
  3. Sesha_Driver_Rdo->findStock() /var/www/horde/sesha/lib/View/List.php:156
  4. iterator_to_array() /var/www/horde/sesha/lib/Driver/Rdo.php:594
  5. Horde_Rdo_List->rewind()
  6. Horde_Db_Adapter_Base->select() /usr/share/php/Horde/Rdo/List.php:133
  7. Horde_Db_Adapter_Base->execute()  
/usr/share/php/Horde/Db/Adapter/Base.php:405
  8. Sesha_View_List->__construct() /var/www/horde/sesha/list.php:49
  9. Sesha_View_List->stock() /var/www/horde/sesha/lib/View/List.php:76
10. Sesha_Driver_Rdo->findStock() /var/www/horde/sesha/lib/View/List.php:156
11. iterator_to_array() /var/www/horde/sesha/lib/Driver/Rdo.php:594
12. Horde_Rdo_List->rewind()
13. Horde_Db_Adapter_Base->select() /usr/share/php/Horde/Rdo/List.php:133
14. Horde_Db_Adapter_Base->execute()  
/usr/share/php/Horde/Db/Adapter/Base.php:405
15. PDO->query() /usr/share/php/Horde/Db/Adapter/Base.php:551

Details
The full error message is logged in Horde's log file, and is shown  
below only to administrators. Non-administrative users will not see  
error details.

Horde_Db_Exception Object
(
     [details] =>
     [logged] => 1
     [_logLevel:protected] => 0
     [message:protected] => SQLSTATE[42883]: Undefined function: 7  
ERROR:  operator does not exist: integer ~~ unknown
LINE 1: ... sesha_inventory WHERE sesha_inventory."stock_id" LIKE '%%' ...
                                                              ^
HINT:  No operator matches the given name and argument type(s). You  
might need to add explicit type casts.
     [string:Exception:private] =>
     [code:protected] => 42883
     [file:protected] => /usr/share/php/Horde/Db/Adapter/Base.php
     [line:protected] => 555
     [trace:Exception:private] => Array
         (
             [0] => Array
                 (
                     [file] => /usr/share/php/Horde/Db/Adapter/Base.php
                     [line] => 405
                     [function] => execute
                     [class] => Horde_Db_Adapter_Base
                     [type] => ->
                     [args] => Array
                         (
                             [0] => SELECT sesha_inventory.stock_id,  
sesha_inventory.stock_name, sesha_inventory.note FROM sesha_inventory  
WHERE sesha_inventory."stock_id" LIKE ? OR  
sesha_inventory."stock_name" LIKE ?
                             [1] => Array
                                 (
                                     [0] => %%
                                     [1] => %%
                                 )

                             [2] =>
                         )

                 )

             [1] => Array
                 (
                     [file] => /usr/share/php/Horde/Rdo/List.php
                     [line] => 133
                     [function] => select
                     [class] => Horde_Db_Adapter_Base
                     [type] => ->
                     [args] => Array
                         (
                             [0] => SELECT sesha_inventory.stock_id,  
sesha_inventory.stock_name, sesha_inventory.note FROM sesha_inventory  
WHERE sesha_inventory."stock_id" LIKE ? OR  
sesha_inventory."stock_name" LIKE ?
                             [1] => Array
                                 (
                                     [0] => %%
                                     [1] => %%
                                 )

                         )

                 )

             [2] => Array
                 (
                     [function] => rewind
                     [class] => Horde_Rdo_List
                     [type] => ->
                     [args] => Array
                         (
                         )

                 )