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

VOTE_CONVERTED to huge for poll_option_id column

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • Affects Version/s: 3.0.x
    • Fix Version/s: None
    • Component/s: phpBB 2.0 convertor
    • Labels:
      None
    • Environment:
      PHP Environment:
      Database:

      Description

      The constant VOTE_CONVERTED (9999) is stored by the converter in a table column poll_option_id that is signed tinyint(4) (in mysql5).

      That of course creates an error "Out of range value adjusted for column 'poll_option_id'" when converting polls...

      According to Mysql max value is 125 for a signed tinyint
      http://dev.mysql.com/doc/refman/5.0/en/numeric-types.html

        Attachments

          Activity

            People

            Assignee:
            Kellanved Kellanved [X] (Inactive)
            Reporter:
            dokster dokster
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: