EC-CUBE / EC-CUBE/ec-cube

WhereCustomizerがPostgreSQLでエラー

Open
#6,113 3 comments 1 reaction 0 assignees View on GitHub
bug bug:Low
Dominant language
PHP
Stars
788
Forks
719
Avg merge
4d 4h
Merged PRs (30d)
39

Description

### 概要(Overview)

#2285
追加した携帯電話番号カラムを検索に含めようとすると、PostgreSQLだと下記エラーが出て実行できない。どうもDoctrineのバグっぽい
```
An exception occurred while executing a query: SQLSTATE[25P02]: In failed sql transaction: 7 ERROR: current transaction is aborted, commands ignored until end of transaction block
```
```
SQLSTATE[22003]: Numeric value out of range: 7 ERROR: value "09018829619" is out of range for type integer CONTEXT: unnamed portal parameter $1 = '...'
```

## サンプルコード

OrderEntityにはmobile_phoneをstringで追加済み
```PHP
/**
* @ORM\Column(name="mobile_phone", type="string", nullable=true)
*/
public $mobile_phone;
```

```PHP
$params['multi']])];
}

/**
* OrderRepository::getQueryBuilderBySearchDataForAdmin に適用する.
*
* @return string
* @see \Eccube\Repository\OrderRepository::getQueryBuilderBySearchDataForAdmin()
* @see QueryKey
*/
public function getQueryKey()
{
return QueryKey::ORDER_SEARCH_ADMIN;
}
}
```

### 再現手順(Procedure)

1. traitを使ってOrderEntityに携帯番号カラムを追加
2. 上記のカスタマイザーを追加
3. 管理画面の受注検索でキーワードに携帯番号を入れて検索

### 環境(Environment)

EC-CUBE: 4.2.1
PostgreSQL 14.11
PHP 8.1.2
doctrine/dbal 3.7.2

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.