Warning: pg_query_params() [function.pg-query-params]: Query failed: ERROR: syntax error at or near "reilly"
LINE 1: ...word as word from search2_word where word = 'o'reilly'
^
ERROR: unnamed prepared statement does not exist
ERROR: portal "" does not exist
ERROR: portal "" does not exist in /usr/local/apache2/func/NCCommon/NCDBConnector.inc.php on line 87
Warning: pg_numrows(): supplied argument is not a valid PostgreSQL result resource in /usr/local/apache2/apps/order/search/kakou2/modules/kakou2/nc_search2_common.php on line 313
Warning: pg_query_params() [function.pg-query-params]: Query failed: ERROR: unterminated quoted string at or near "''' "
LINE 1: ...ynonym_word as word from search2_word where word = '''
^
ERROR: unnamed prepared statement does not exist
ERROR: portal "" does not exist
ERROR: portal "" does not exist in /usr/local/apache2/func/NCCommon/NCDBConnector.inc.php on line 87
db error : select synonym_word as word from search2_word where word = '''
Warning: pg_query_params() [function.pg-query-params]: Query failed: ERROR: syntax error at or near "reilly"
LINE 1: ...ct synonym_word from search2_word where word = 'o'reilly' or...
^
ERROR: unnamed prepared statement does not exist
ERROR: portal "" does not exist
ERROR: portal "" does not exist in /usr/local/apache2/func/NCCommon/NCDBConnector.inc.php on line 87
db error : select w2.word as word from ( select synonym_word from search2_word where word = 'o'reilly' or word = 'O'REILLY' ) w1 left outer join search2_word w2 on w2.synonym_word = w1.synonym_word
Warning: pg_fetch_array() expects parameter 1 to be resource, boolean given in /usr/local/apache2/apps/order/search/kakou2/modules/kakou2/nc_search2_common.php on line 227
Warning: pg_query_params() [function.pg-query-params]: Query failed: ERROR: syntax error at or near "reilly"
LINE 13: word in ('o', ''', 'reilly', 'rei', 'lly')
^
ERROR: unnamed prepared statement does not exist
ERROR: portal "" does not exist
ERROR: portal "" does not exist in /usr/local/apache2/func/NCCommon/NCDBConnector.inc.php on line 87
Warning: pg_fetch_row() expects parameter 1 to be resource, boolean given in /usr/local/apache2/func/NCCommon/NCDBConnector.inc.php on line 117
SQLエラー
select count(*)
from
(
select
cs.company_id
from
search2_word_score s
left outer join search2_company_score cs on s.object_id = cs.company_id
left outer join search2_mask mask on cs.company_id = mask.object_id
inner join company c on c.id = cs.company_id
where
word in ('o', ''', 'reilly', 'rei', 'lly')
and s.weighted_score > 0
and (s.score * cs.katuryoku_weight * coalesce(mask.mask_score_weight, 1) > 0)
and c.apply = 1
and c.id >= 1000
group by
cs.company_id having ( max ( case when s.word in ('o') then 1 else 0 end)
+ max ( case when s.word in (''') then 1 else 0 end)
+ max ( case when s.word in ('reilly') then 1 else 0 end)
>= 3 ) or ( max ( case when s.word in ('rei') then 1 else 0 end)
+ max ( case when s.word in ('lly') then 1 else 0 end)
>= 2 ) ) a
Warning: pg_query_params() [function.pg-query-params]: Query failed: ERROR: syntax error at or near "reilly"
LINE 1: ...word as word from search2_word where word = 'o'reilly'
^
ERROR: unnamed prepared statement does not exist
ERROR: portal "" does not exist
ERROR: portal "" does not exist in /usr/local/apache2/func/NCCommon/NCDBConnector.inc.php on line 87
Warning: pg_numrows(): supplied argument is not a valid PostgreSQL result resource in /usr/local/apache2/apps/order/search/kakou2/modules/kakou2/nc_search2_common.php on line 313
Warning: pg_query_params() [function.pg-query-params]: Query failed: ERROR: unterminated quoted string at or near "''' "
LINE 1: ...ynonym_word as word from search2_word where word = '''
^
ERROR: unnamed prepared statement does not exist
ERROR: portal "" does not exist
ERROR: portal "" does not exist in /usr/local/apache2/func/NCCommon/NCDBConnector.inc.php on line 87
db error : select synonym_word as word from search2_word where word = '''
Warning: pg_query_params() [function.pg-query-params]: Query failed: ERROR: syntax error at or near "reilly"
LINE 1: ...ct synonym_word from search2_word where word = 'o'reilly' or...
^
ERROR: unnamed prepared statement does not exist
ERROR: portal "" does not exist
ERROR: portal "" does not exist in /usr/local/apache2/func/NCCommon/NCDBConnector.inc.php on line 87
db error : select w2.word as word from ( select synonym_word from search2_word where word = 'o'reilly' or word = 'O'REILLY' ) w1 left outer join search2_word w2 on w2.synonym_word = w1.synonym_word
Warning: pg_fetch_array() expects parameter 1 to be resource, boolean given in /usr/local/apache2/apps/order/search/kakou2/modules/kakou2/nc_search2_common.php on line 227
Warning: pg_query_params() [function.pg-query-params]: Query failed: ERROR: syntax error at or near "reilly"
LINE 90: s.word in ('o', ''', 'reilly', 'rei', 'lly...
^
ERROR: unnamed prepared statement does not exist
ERROR: portal "" does not exist
ERROR: portal "" does not exist in /usr/local/apache2/func/NCCommon/NCDBConnector.inc.php on line 87
Warning: pg_fetch_all() expects parameter 1 to be resource, boolean given in /usr/local/apache2/func/NCCommon/NCDBConnector.inc.php on line 102
Warning: pg_query_params() [function.pg-query-params]: Query failed: ERROR: syntax error at or near "Reilly"
LINE 18: AND ( l.keyword like '%O'Reilly%' ) ORDER BY l.emid...
^
ERROR: unnamed prepared statement does not exist
ERROR: portal "" does not exist
ERROR: portal "" does not exist in /usr/local/apache2/func/NCCommon/NCDBConnector.inc.php on line 87
Warning: pg_fetch_all() expects parameter 1 to be resource, boolean given in /usr/local/apache2/func/NCCommon/NCDBConnector.inc.php on line 102 (cache) エミダス工場検索３α | 挑戦する製造業のために／ＮＣネットワーク