Ravens PHP Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Other - Discussion
Author Message
tlekas
New Member
New Member



Joined: Dec 07, 2004
Posts: 2

PostPosted: Tue Dec 07, 2004 11:22 am Reply with quote

I was refered to this site from: http://phpnuke-ca.com/modules.php?name=Forums&file=viewtopic&p=688#688
I am using the V7.1 kit from: http://www.phpnuke.org/

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?
 
View user's profile Send private message
Raven
Site Admin/Owner



Joined: Aug 27, 2002
Posts: 17088

PostPosted: Tue Dec 07, 2004 11:40 am Reply with quote

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 [ Only registered users can see links on this board! Get registered or login! ] . It's a great xref tool.
 
View user's profile Send private message
tlekas







PostPosted: Tue Dec 07, 2004 11:56 am Reply with quote

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?
 
Raven







PostPosted: Tue Dec 07, 2004 12:01 pm Reply with quote

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







PostPosted: Tue Dec 07, 2004 2:17 pm Reply with quote

This may help you [ Only registered users can see links on this board! Get registered or login! ]
 
xsalias
New Member
New Member



Joined: Nov 03, 2006
Posts: 1

PostPosted: Fri Nov 03, 2006 8:57 am Reply with quote

Raven wrote:
This may help you [ Only registered users can see links on this board! Get registered or login! ]
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.
 
View user's profile Send private message
Raven







PostPosted: Fri Nov 03, 2006 9:11 am Reply with quote

Yes, it is possible. See [ Only registered users can see links on this board! Get registered or login! ] for examples of the differences in the calls. Other than that, neither time nor space allow me to do much more for you.
 
fkelly
Former Moderator in Good Standing



Joined: Aug 30, 2005
Posts: 3312
Location: near Albany NY

PostPosted: Sat Nov 04, 2006 9:18 am Reply with quote

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.
 
View user's profile Send private message Visit poster's website
Raven







PostPosted: Sat Nov 04, 2006 1:37 pm Reply with quote

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



Joined: Aug 29, 2004
Posts: 9457
Location: Arizona

PostPosted: Sat Nov 04, 2006 1:56 pm Reply with quote

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

_________________
Where Do YOU Stand?
HTML Newsletter::ShortLinks::Mailer::Downloads and more... 
View user's profile Send private message Visit poster's website
Display posts from previous:       
Post new topic   Reply to topic    Ravens PHP Scripts And Web Hosting Forum Index -> Other - Discussion

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You can attach files in this forum
You can download files in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 6 Hours
 
Forums ©