Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-14209

cast_expr_to_bigint does not work with large values and SQLServer

    XMLWordPrintable

Details

    • Bug
    • Status: Open (View Workflow)
    • Major
    • Resolution: Unresolved
    • 3.1.6
    • None
    • None
    • PHP 5.3.27, SQLServer 12, IIS, Firefox 41.0

    Description

      When SQLServer is the database updates to the phpbb_config table for "upload_dir_size" can fail, it appears if the value being added to config_value exceeds some value, likely 2^16. The only solution seems to be to use a CAST as a bigint. See the attachment for an example. It appears that the problem is occurring because an explicit SQL CAST function needs to be implemented for SQLServer in the DBAL. Please see the topic where the problem is described in more detail and some patch code I added to db.php for my client to temporarily get around the problem.

      https://www.phpbb.com/community/viewtopic.php?f=466&t=2338041

      Attachments

        Activity

          People

            Unassigned Unassigned
            MarkDHamill MarkDHamill
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

            Dates

              Created:
              Updated: