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

Cannot configure Q&A on Oracle

XMLWordPrintable

    • Icon: Bug Bug
    • Resolution: Fixed
    • Icon: Blocker Blocker
    • 3.0.9-RC1
    • 3.0.8
    • Other
    • None
    • PHP 5.2.17, Oracle 10g Express

      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

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

              Created:
              Updated:
              Resolved: