Поиск по лицевому счёту не работает!
Код: Выделить всё
Oct 07 15:11:16 ?Debug : 91b30700 RPC2Connection: URFA ping received, sending reply
Oct 07 15:11:16 ?Debug : 91b30700 RPC2Connection: Call: 0x1206 (rpcf_search_users_new)
Oct 07 15:11:16 ?Debug : 91b30700 RPC2Connection: Real Call: 0x1206 (rpcf_search_users_new)
Oct 07 15:11:16 ?Debug : 91b30700 RPCServer@0.0.0.0: Search poleCode <31>
Oct 07 15:11:16 ?Debug : 91b30700 RPCServer@0.0.0.0: Search select_type <0>
Oct 07 15:11:16 ?Debug : 91b30700 RPCServer@0.0.0.0: Search pattern sreq.what_id <3> sreq.criteria <1> sreq.pattern <7614>
Oct 07 15:11:16 ?Debug : 91b30700 DBConnectionPoolImpl: [2]: connection <0x2878390> is popped
Oct 07 15:11:16 ?Debug : 91b30700 DBConnectionPoolImpl: [2]: connection <0x2878390> is pushed back
Oct 07 15:11:16 ?Debug : 91b30700 DBConnectionPoolImpl: [2]: connection <0x28413e0> is popped
Oct 07 15:11:16 ?Debug : 91b30700 DBConnection_pgsql: Ctx: <0x2841da0> SQL SELECT query: SELECT login, password, basic_account, create_date, last_change_date,who_create, who_change, is_juridical, full_name, juridical_address, actual_address,work_telephone, home_telephone, mobile_telephone, web_page, icq_number, tax_number,kpp_number, bank_id, bank_account, comments, email, house_id, flat_number, entrance,floor, district, building, passport, personal_manager, connect_date, is_send_invoice,advance_payment, binded_currency_code, id, encrypted, till FROM users WHERE is_deleted='0' AND (basic_account LIKE '%7614%')
Oct 07 15:11:16 ERROR : 91b30700 DBConnection_pgsql: PgSQL query failed: ERROR: operator does not exist: integer ~~ unknown
LINE 1: ...ROM users WHERE is_deleted='0' AND (basic_account LIKE '%761...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Trying to reconnect, count: 0
Oct 07 15:11:17 ERROR : 91c31700 DBConnection_pgsql: PgSQL query failed: ERROR: operator does not exist: integer ~~ unknown
LINE 1: ...ROM users WHERE is_deleted='0' AND (basic_account LIKE '%761...
^
HINT: No operator matches the given name and argument type(s). You might need to add explicit type casts.
Trying to reconnect, count: 1
^C
Код: Выделить всё
NetUP UTM billing system core. Compile date: Sep 21 2016 00:13:16
Version:5.3-004-release-debian_jessie_x64 Rev #15919
upd:
basic_account
integer!
Так работает:
Код: Выделить всё
SELECT login, password, basic_account, create_date, last_change_date,who_create, who_change, is_juridical, full_name, juridical_address, actual_address,work_telephone, home_telephone, mobile_telephone, web_page, icq_number, tax_number,kpp_number, bank_id, bank_account, comments, email, house_id, flat_number, entrance,floor, district, building, passport, personal_manager, connect_date, is_send_invoice,advance_payment, binded_currency_code, id, encrypted, till FROM users WHERE is_deleted='0' AND basic_account = '7614'