MSSQL doesn't allow to use "UPDATE" statement to update field with
text or
ntext data type. Maybe you should use varchar data type in column
prefix_reports.report_text?
- Code: Select all
SQL ERROR [ mssql ]
Invalid operator for data type. Operator equals add, type equals text.
Invalid operator for data type. Operator equals %ls, type equals %ls. [403]
SQL
UPDATE phpbb_reports SET reason_id = 4, report_text = 'The reported post contains links to pirated or illegal software ' + report_text WHERE reason_id = 1
BACKTRACE
FILE: includes/db/mssql.php
LINE: 132
CALL: dbal->sql_error()
FILE: includes/acp/acp_reasons.php
LINE: 233
CALL: dbal_mssql->sql_query()
FILE: includes/functions_module.php
LINE: 361
CALL: acp_reasons->main()
FILE: adm/index.php
LINE: 83
CALL: p_master->load_active()