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

Could not get style data via MySQL DB auto_increment_offset != 1

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Major Major
    • 3.2.10-RC1, 3.3.1-RC1
    • 3.1.4
    • Build System
    • None

      After phpBB3 installed, I got the error message:

      SQL ERROR [ mysqli ]

      You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 3 [1064]

      SQL

      SELECT * FROM phpbb_styles s WHERE s.style_id =

      BACKTRACE

      FILE: (not given by php)
      LINE: (not given by php)
      CALL: msg_handler()

      FILE: [ROOT]/phpbb/db/driver/driver.php
      LINE: 855
      CALL: trigger_error()

      FILE: [ROOT]/phpbb/db/driver/mysqli.php
      LINE: 193
      CALL: phpbb\db\driver\driver->sql_error()

      FILE: [ROOT]/phpbb/db/driver/factory.php
      LINE: 329
      CALL: phpbb\db\driver\mysqli->sql_query()

      FILE: [ROOT]/phpbb/user.php
      LINE: 238
      CALL: phpbb\db\driver\factory->sql_query()

      FILE: [ROOT]/index.php
      LINE: 29
      CALL: phpbb\user->setup()

      I made a simple patch taking a try to get a style for default usage.

      https://github.com/phpbb/phpbb/pull/3679

        1. phpbb3.1.4-bug-01.png
          200 kB
          changyy [X]
        2. phpbb3.1.4-bug-02.png
          49 kB
          changyy [X]
        3. phpbb3.1.4-bug-03.png
          30 kB
          changyy [X]

            Marc Marc
            changyy changyy [X] (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

              Created:
              Updated:
              Resolved: