Tickets :: Comment on [#12976] No search possible because sesha_inventory WHERE sesha_inventory."stock

* Your Email Address
* Spam protection	Enter the letters below: .__ .___.__..__..__. \| \[__ \| \|\| \|\| \| \|__/\| \|__\\|__\|\|__\|
Comment	> 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 > ( > ) > > )
Attachment
Watch this ticket

Saved Queries