Ticket #417 (closed バグ指摘: 修正済)

Opened 13 years ago

Last modified 9 years ago

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

diff.patch Download (2.1 KB) - added by Yammy 13 years ago.

Change History

comment:1 Changed 13 years ago by Yammy

  • Owner changed from somebody to Yammy
  • Status changed from new to assigned

Changed 13 years ago by Yammy

comment:2 Changed 13 years ago by Yammy

値をシングルクオーテーョン「'」で囲むように修正しました。

パッチを添付します。

http://svn.ec-cube.net/open_trac/attachment/ticket/417/diff.patch

comment:3 Changed 12 years ago by nanasess

  • Status changed from assigned to closed
  • Resolution set to 修正済

修正済みのようですので close します

comment:4 Changed 9 years ago by kim

  • 修正済み unset
  • Milestone set to EC-CUBE2.3.4

comment:5 Changed 9 years ago by kim

  • 修正済み set
Note: See TracTickets for help on using tickets.