id	summary	reporter	owner	description	type	status	priority	milestone	component	version	resolution	keywords	cc	modified_flg
417	PostgreSQL8.3環境でのペイジェントモジュールエラー	Yammy	Yammy	"PostgreSQL8.3以上ですと、型のチェックが厳しくなったようで、
ペイジェントモジュールにて以下のエラーが発生しました。
{{{
2009/01/27 09:43:50 [/shopping/load_payment_module.php] https://example.com/shopping/load_payment_module.php

SERVER_ADDR:0.0.0.0
REMOTE_ADDR:0.0.0.0
USER_AGENT:Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)

SELECT 
                                module_code,
                                memo01 as merchant_id,
                                memo02 as connect_id,
                                memo03 as payment,
                                memo04 as connect_password,
                                memo05 as other_param
                        FROM dtb_payment WHERE module_code = ? AND memo03 = 1
DB Error: unknown error

SELECT 
                                module_code,
                                memo01 as merchant_id,
                                memo02 as connect_id,
                                memo03 as payment,
                                memo04 as connect_password,
                                memo05 as other_param
                        FROM dtb_payment WHERE module_code = 'mdl_paygent' AND memo03 = 1 [nativecode=ERROR:  operator does not exist: text = 
integer
LINE 8: ...dtb_payment WHERE module_code = 'mdl_paygent' AND memo03 = 1
                                                                    ^
HINT:  No operator matches the given name and argument type(s). You might need to add explicit type casts.]

/var/www/sites/example/eccube/html/shopping/load_payment_module.php 53:require_once
/var/www/sites/example/eccube/data/downloads/module/mdl_paygent/paygent_credit.php 11:LC_Page_Mdl_Paygent_Helper->process
/var/www/sites/example/eccube/data/downloads/module/mdl_paygent/LC_Page_Mdl_Paygent_Helper.php 154:sfSendPaygentCredit
/var/www/sites/example/eccube/data/downloads/module/mdl_paygent/include.php 203:sfGetPaymentDB
/var/www/sites/example/eccube/data/downloads/module/mdl_paygent/include.php 824:SC_Query->getall
/var/www/sites/example/eccube/data/class/SC_Query.php 156:SC_DbConn->getAll
/var/www/sites/example/eccube/data/class/SC_DbConn.php 160:DB_common->getAll
/var/www/sites/example/eccube/data/module/DB/common.php 1610:DB_common->execute
/var/www/sites/example/eccube/data/module/DB/common.php 959:DB_pgsql->simpleQuery
/var/www/sites/example/eccube/data/module/DB/pgsql.php 338:DB_pgsql->pgsqlRaiseError
/var/www/sites/example/eccube/data/module/DB/pgsql.php 786:DB_common->raiseError
/var/www/sites/example/eccube/data/module/DB/common.php 1853:PEAR->raiseError
/var/www/sites/example/eccube/data/module/PEAR.php 557:DB_Error->DB_Error
/var/www/sites/example/eccube/data/module/DB.php 893:PEAR_Error->PEAR_Error
}}}
dtb_payment.note03のカラムの型がTEXTなのですが、検索条件に「1」とINTで
指定されているためエラーになっておりました。"	バグ指摘	closed	高	EC-CUBE2.3.4	フロント	2.1.2(正式版)	修正済			1