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

cast_expr_to_bigint does not work with large values and SQLServer

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Unresolved
    • Icon: Major Major
    • None
    • 3.1.6
    • None
    • PHP 5.3.27, SQLServer 12, IIS, Firefox 41.0

      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

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

              Created:
              Updated: