Details

    • Type: Bug
    • Status: Unverified Fix
    • Priority: Blocker
    • Resolution: Fixed
    • Affects Version/s: 3.0.8
    • Fix Version/s: 3.0.9-RC1
    • Component/s: Other
    • Labels:
      None
    • Environment:
      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

        Issue Links

          Activity

          There are no comments yet on this issue.

            People

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

              Dates

              • Created:
                Updated:
                Resolved:

                Development