Bug tracker

This ticket has been moved to our new tracker. Open Ticket PHPBB3-1579 now.

[MSSQL] Deleting "Report/Denial Reason" (fix completed in vcs)

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()

Comments / History

Posted by DavidMJ (Former Team Member) on Aug 22nd 2006, 16:06

I can just use UPDATETEXT or the .WRITE clause of UPDATE

Linked ticket with changeset: r6333

Action performed by DavidMJ (Former Team Member) on Aug 30th 2006, 01:15

Ticket details

Related SVN changesets