-
Bug
-
Resolution: Fixed
-
Blocker
-
3.0.8
-
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
- is duplicated by
-
PHPBB-10215 Database updater fails on Oracle
- Closed