Oracle not visible for installation

All about webserver configurations, PHP and databases.

Moderator: Thorsten

Jack
Posts: 13
Joined: Wed Jul 29, 2009 2:09 am

Re: Oracle not visible for installation

Post by Jack » Thu Jul 30, 2009 8:42 pm

Also, columns with

Code: Select all

NOT NULL default ''
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:

Code: Select all

revision_id INTEGER NOT NULL DEFAULT 0,
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.

Thorsten
Posts: 14730
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Oracle not visible for installation

Post by Thorsten » Thu Jul 30, 2009 8:46 pm

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
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

Jack
Posts: 13
Joined: Wed Jul 29, 2009 2:09 am

Re: Oracle not visible for installation

Post by Jack » Thu Jul 30, 2009 9:16 pm

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.

Jack
Posts: 13
Joined: Wed Jul 29, 2009 2:09 am

Re: Oracle not visible for installation

Post by Jack » Thu Jul 30, 2009 9:32 pm

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,

Thorsten
Posts: 14730
Joined: Tue Sep 25, 2001 11:14 am
Location: #phpmyfaq
Contact:

Re: Oracle not visible for installation

Post by Thorsten » Fri Jul 31, 2009 4:39 pm

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
phpMyFAQ Maintainer and Lead Developer
amazon.de Wishlist

Post Reply