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?

        Attachments

          Activity

            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: