Details

      Description

      General Error
      SQL ERROR [ mssqlnative ]
       
      SQLSTATE: 42000 code: 156 message: [Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'user'. [156]
       
      SQL
       
      CREATE INDEX user ON phpbb_notifications(user_id, notification_read)
       
      BACKTRACE
       
      FILE: (not given by php)
      LINE: (not given by php)
      CALL: msg_handler()
       
      FILE: [ROOT]/phpbb/db/driver/driver.php
      LINE: 803
      CALL: trigger_error()
       
      FILE: [ROOT]/phpbb/db/driver/mssqlnative.php
      LINE: 144
      CALL: phpbb\db\driver\driver->sql_error()
       
      FILE: [ROOT]/phpbb/db/tools.php
      LINE: 1454
      CALL: phpbb\db\driver\mssqlnative->sql_query()
       
      FILE: [ROOT]/phpbb/db/tools.php
      LINE: 683
      CALL: phpbb\db\tools->_sql_run_sql()
       
      FILE: [ROOT]/install/install_install.php
      LINE: 1188
      CALL: phpbb\db\tools->sql_create_table()
       
      FILE: [ROOT]/install/install_install.php
      LINE: 96
      CALL: install_install->load_schema()
       
      FILE: [ROOT]/install/index.php
      LINE: 386
      CALL: install_install->main()
       
      FILE: [ROOT]/install/index.php
      LINE: 263
      CALL: module->load()

      The query should be:
      CREATE INDEX [user] ON [phpbb_notifications]([user_id], [notification_read])
      However MSSQL is the only db that uses the index name and does not prepend the table name.
      I wonder whether this is intentional? Patrick Webster, David Colón any idea?

        Activity

        There are no comments yet on this issue.

          People

          • Assignee:
            nickvergessen Joas Schilling
            Reporter:
            nickvergessen Joas Schilling
          • Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development