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

Cannot configure Q&A on Oracle

    XMLWordPrintable

Details

    • Bug
    • Status: Closed (View Workflow)
    • Blocker
    • Resolution: Fixed
    • 3.0.8
    • 3.0.9-RC1
    • Other
    • None
    • PHP 5.2.17, Oracle 10g Express

    Description

      When attempting to configure Q&A for the first time on Oracle, the following error is given:

      ORA-00911: invalid character [911]
      CREATE TABLE phpb9_captcha_questions ( question_id number(8) , strict number(1) DEFAULT '0' , lang_id number(8) DEFAULT '0' , lang_iso varchar2(30) DEFAULT '' , question_text clob DEFAULT '' , CONSTRAINT pk_phpb9_captcha_questions PRIMARY KEY (question_id) );

      Backtrace can be seen here: https://gist.github.com/1022176

      Oddly enough, running that query manually via Oracle's web query page it executes just fine. However, after doing that, another error is given while attempting to insert a question:

      ORA-01400: cannot insert NULL into ("PHPBB"."PHPBB_CAPTCHA_QUESTIONS"."QUESTION_ID") [1400]
      INSERT INTO phpbb_captcha_questions (question_text, strict, lang_iso, lang_id) VALUES ('This is a question, type "answer"', 0, 'en', 1)

      Backtrace: https://gist.github.com/1022185

      Attachments

        Issue Links

          Activity

            People

              naderman Nils Adermann
              Noxwizard Patrick Webster
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: