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

cast_expr_to_bigint does not work with large values and SQLServer

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Open (View Workflow)
    • Priority: Major
    • Resolution: Unresolved
    • Affects Version/s: 3.1.6
    • Fix Version/s: None
    • Labels:
      None
    • Environment:
      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

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

              Dates

              • Created:
                Updated: