Ticket #417 (closed バグ指摘: 修正済)
PostgreSQL8.3環境でのペイジェントモジュールエラー
Reported by: | Yammy | Owned by: | Yammy |
---|---|---|---|
Priority: | 高 | Milestone: | EC-CUBE2.3.4 |
Component: | フロント | Version: | 2.1.2(正式版) |
Keywords: | Cc: | ||
修正済み: | yes |
Description
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で 指定されているためエラーになっておりました。
Attachments
Change History
comment:1 Changed 15 years ago by Yammy
- Owner changed from somebody to Yammy
- Status changed from new to assigned
comment:2 Changed 15 years ago by Yammy
値をシングルクオーテーョン「'」で囲むように修正しました。
パッチを添付します。
http://svn.ec-cube.net/open_trac/attachment/ticket/417/diff.patch
Note: See
TracTickets for help on using
tickets.