Uploaded image for project: 'phpBB3'
  1. phpBB3
  2. PHPBB3-8822

ORA-00932 error on updating phpbb_log

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Resolution: Fixed
    • 3.0.5
    • 3.0.6
    • Update system
    • None
    • PHP Environment: 5.2.11
      Database: Oracle 10.2

    Description

      Hi

      When upgrading from phpBB 3.0.2 to 3.0.5 using the automatic installer we receive the following message during the database upgrade phase. We are using Oracle 10.2.

      Updating data

      Progress :: . . . . . . . . . . . . . Done
      Result :: Some queries failed, the statements and errors are listing below.
      [list: 3uu8jz5h]

      • Error :: ORA-00932: inconsistent datatypes: expected - got CLOB
        SQL :: UPDATE phpbb_log SET log_operation = 'LOG_DELETE_TOPIC' WHERE log_operation = 'LOG_TOPIC_DELETED'

      Manually running the SQL statement with = replaced with like against the database does not result in an error:

      UPDATE phpbb_log SET log_operation = 'LOG_DELETE_TOPIC' WHERE log_operation like 'LOG_TOPIC_DELETED'

      Thanks

      Attachments

        Activity

          People

            Acyd Burn Meik Sievertsen [X] (Inactive)
            greenhac greenhac
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: