Using Oracle as the DB for PHP-Nuke

New Member Joined: Dec 07, 2004 Posts: 2

I was refered to this site from: Only registered users can see links on this board! Get registered or login!
I am using the V7.1 kit from: Only registered users can see links on this board! Get registered or login!

I am new to PHP-Nuke. I am trying to install it using Oracle 9.2 as the DB. I have the DB installed and created. I have Apache up and running. I have PHP installed and can access it from Apache.

I installed PHP-Nuke and did an initial pass at setting up config.php.

I ran into problems when I tried running nuke.sql. I saw that there was MySQL usage in there which was not the same as Oracle and/or ANSII. I saw in the installation instructions that oracle was one option for a db so I expected that someone must have gotten this working. I searched the web looking for a nuke.sql that would work for Oracle as well as any other required changes. I could not find anything! Surprised

I then started porting nuke.sql. I was not familiar with MySQL and discovered differences as I went. Most were easy to deal with, things such as syntax differences and the auto_increment feature. Then I ran into the fact that nuke.sql was using ANSII reserved keywords as column names! I could fix that in nuke.sql, but these names are referenced in the code! At this point I decided to try again to see if anyone has done this before.

Does anyone know if this has been done or have any suggestions about how to do it other than just searching and plowing through the code?

Site Admin/Owner Joined: Aug 27, 2002 Posts: 17088

I was an Oracle dba in my former life Laughing

and am quite well versed in MySQL and nuke. Trust me, there is no other way but the grunt way. I have never heard of anyone porting it. I had tried Oracle earlier on with nuke and gave up on it. Same with DB2. A tool that would probably assist you is http://phpxref.sourceforge.net/ . It's a great xref tool.

Posted: Tue Dec 07, 2004 11:56 am

Thanks for the answer. Not the one I was hoping for, but it is better to know.

Given that PHP-Nuke can't be run as is using an Oracle DB, what is the point of the option of setting the DB to oracle? Was this added in anticipation of other work being done to make PHP-Nuke portable to other DBs?

Posted: Tue Dec 07, 2004 12:01 pm

Possibly. The author , or most recent maintainer, does not have a reputation for being too thorough. The community usually picks up the pieces. The db layer might possibly be modified but I would more imagine that you will need to code your own functions and call them instead.

Posted: Tue Dec 07, 2004 2:17 pm

This may help you http://pear.php.net/package/DB

New Member Joined: Nov 03, 2006 Posts: 1

Raven wrote:

This may help you http://pear.php.net/package/DB

first of all i pay regards to all of u there who are helping people like me by discussions.

I also have a website running on phpnuke7.6 with mysql.

I want to use oracle database.
Is it possible. If yes please tell me how.

Posted: Fri Nov 03, 2006 9:11 am

Yes, it is possible. See http://pear.php.net/package/DB for examples of the differences in the calls. Other than that, neither time nor space allow me to do much more for you.

Posted: Sat Nov 04, 2006 9:18 am

This is interesting since we have been discussing in another thread the possibility and desirability of eliminating the so-called Database abstraction layer from nuke in favor of "native" calls. If you look at the files /db/db.php and then the various database specific programs in the /db directory you will see how FB (and I think he "borrowed" this from PHPBB but I'm not sure) tried to translate database specific "functions" into universal "calls" that could be made. We've already seen problems with mysql4.php in other threads and now it appears that Oracle and DB2 won't work either. Just adds to my questions about whether the layer is even useful. But that's neither here nor there in this thread.

If you look at the /db/oracle.php file specifically you will see the translation of the calls.

Posted: Sat Nov 04, 2006 1:37 pm

There are other DB abstraction scripts out there that we could consider. Again, a little off topic.

registered · Posted: Sat Nov 04, 2006 1:56 pm

Not only that, but each SQL statement would have to be reviewed to ensure it is ANSI standard in order to work across multiple RDBMS. Not sure we can say that for certain even...