Details
-
Bug
-
Status: Closed (View Workflow)
-
Blocker
-
Resolution: Fixed
-
3.1.0-b1
-
None
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? Noxwizard, DavidIQ any idea?