phpMyFAQ

Also, columns with are failing because empty values ('') are translated as null in oracle.

And there are some issues with INT datatypes and INTEGER UNSIGNED datatypes.

I'm not sure why this column is failing in faqdata: I could modify the statements and create the tables, but it could be hard to track down the other queries that access them. Especially since all of the 'comment' columns would be renamed.

Hi,

okay, I committed the fix for the query() method in 2.0.16, 2.5.1 and 2.6.0-alpha. Is it possible to send me a list of tables which didn't executed during the installation. I think we're on a good way!

Thanks for your help!!!

bye
Thorsten

faqcategoryrelations
INDEX idx_records ON faqcategoryrelations
faqchanges
faqcomments
faqconfig
faqdata
faqdata_revisions
faqgroup
faqgroup_right
faqlinkverifyrules
faqnews
faqright
faquserdata

I can quickly generate the errors for each. I'll post proposed solutions.

For each table I show

Table
Failing line
Error Report
Possible solution

faqcategoryrelations
category_lang VARCHAR(5) NOT NULL default '',
ORA-00907: missing right parenthesis
Either allow NULL, or choose different default (there's a second line like this for record_lang)

INDEX idx_records ON faqcategoryrelations
(can't run until faqcategoryrelations done)

faqchanges
revision_id INTEGER NOT NULL DEFAULT 0,
ORA-00907: missing right parenthesis
??

faqcomments
comment CLOB NOT NULL,
ORA-00904: : invalid identifier
Rename column

faqconfig
config_name VARCHAR(255) NOT NULL default '',
ORA-00907: missing right parenthesis
Either allow NULL, or choose different default

faqdata
revision_id INTEGER NOT NULL DEFAULT 0,
ORA-00907: missing right parenthesis
??

faqdata_revisions
revision_id INTEGER NOT NULL DEFAULT 0,
ORA-00907: missing right parenthesis
?? Also need to rename the 'comment' column

faqgroup
UNIQUE INDEX name(name)
ORA-00906: missing left parenthesis
??

faqgroup_right
group_id INT(11) NOT NULL,
ORA-00907: missing right parenthesis
Should be NUMBER(11) ?

faqlinkverifyrules
id int(11) NOT NULL default '0',
Should be NUMBER(11) ?


faqnews
comment CHAR(1) default 'n',
ORA-00904: : invalid identifier
Rename column

faqright
right_id INTEGER UNSIGNED NOT NULL,
ORA-00907: missing right parenthesis
I don't think INTEGER UNSIGNED is valid, need to check

faquserdata
last_modified VARCHAR(14)(14) NULL,
ORA-00907: missing right parenthesis
Change to
last_modified VARCHAR(14) NULL,

Hi,

okay... the "comment" issue is a big showstopper. If I change this for Oracle, I have to change this for all databases. This is a bigger change that only can be done for version 2.6.

bye
Thorsten