Uploaded image for project: 'phpBB'
  1. phpBB
  2. PHPBB-1579

[MSSQL] Deleting "Report/Denial Reason"

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • None
    • 3.0.B2
    • ACP
    • None
    • PHP Environment:
      Database:

      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?

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

            DavidMJ DavidMJ
            kicok kicok
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Created:
              Updated:
              Resolved: