[PHPBB3-10016] set_config_count() fails on PostreSQL 7

XML

Word

Printable

Reported by Human-Bean on IRC.

General Error

SQL ERROR [ postgres ]

ERROR: cannot cast type character varying TO numeric []

SQL

UPDATE phpbb_movieconfig SET config_value = CAST(CAST(config_value AS DECIMAL(255, 0)) + 3 AS VARCHAR(255)) WHERE config_name = 'num_users'

caused

PHPBB3-10091 Bump minimum required postgresql version for 3.1

was caused by solution of

PHPBB3-9173 sql_config_count() artificially limits number scope to 4byte-integer on PostgreSQL and Firebird