Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-10016

set_config_count() fails on PostreSQL 7

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 3.0.9-RC1
    • None
    • None
    • None
    • PostgreSQL 7.4.23

      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'

            Oleg Oleg [X] (Inactive)
            bantu Andreas Fischer [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: