phpMyFAQ

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
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.

Also, columns with

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:

revision_id INTEGER NOT NULL DEFAULT 0,


I could ...

I extracted the other CREATE TABLE statements and ran them directly in oracle. They don't run for various reasons. For instance, 'comment' cannot be used as a column name in oracle because it's a reserved word.

I downloaded the newest 2.5.x Pandora and made a fresh install. I made the changes we discussed including


public function query($query)
{
$this->sqllog .= pmf_debug($query);
$stmt = oci_parse($this->conn, $query);
oci_execute($stmt, OCI_DEFAULT);

return $stmt;
}


I also changed the ...

I noticed that the query function in Oci8.php does not have a return value, while the other database types do return a value for query.
I tried replacing
oci_execute($stmt, OCI_DEFAULT);
with
return oci_execute($stmt, OCI_DEFAULT);
but that did not work.

As a test I ended the query with
return ...

In Oci8.php, the connect function had the line

if (empty($db) OR $this->conn == true) {

Based on the other files in PMF_DB, I changed this to
if (empty($db) || $this->conn == false) {

I'm still getting this error when trying to install:


|

Error: Please install your version of phpMyFAQ once ...

I mistyped that last command. This is what I did from the faq directory:

mv install/oracle.sql.php install/oci8.sql.php

I did
mv /install/oracle.sql.php /install/oci8.sql.php

I got past that error.

I'm getting database connection problems, but that's probably my fault and I'll experiment with it.

Thanks

I'm getting the same error. Maybe I should just install a newer version?

When I try to install I get

"Error: Invalid server type."

My settings:
SQL server: Oracle 8i and later (experimental)
SQL server host: localhost
SQL username: requestsFAQ
SQL password: ****
SQL database: testdb1
Table prefix:

Thank you for the incredibly fast response. After the fix, the oracle choice popped up.

I realize that MySQL has been tested more, but I'm hoping Oracle works out. We already have Oracle installed on this server and we're more familiar with it.

Thanks again.

Hello,

When I open the installer.php page, I see the full page. This includes “phpMyFAQ 2.0.15 Installation” and “Your PHP version: PHP 5.2.6”. However, the drop-down next to “SQL server” only provides the “MySQL 4.x…” choice and the “MySQL 4.1…” choice. I want to see “oracle” as a choice.

I have ...