phpBB3 forum on Oracle DB

When you create a phpBB3 forum and use Oracle as the database host. make sure that you are using Oracle Database 10g or later as previous releases may cause unpredictable errors, i.e.:

SELECT a.*, b.*, ac.something…
FROM phpb3_forums a, phpb3_topics b…
LEFT JOIN phpb3_topics_watch ac ON …
WHERE a.topic_….

…will cause a ORA-00904: “A”: invalid identifier [904] as it seems it can not utilise both a.* and b.*

install phpbb3 forum on OAS

To install forum on Oracle Application Server:

  1. need access to OAS server (http server)
  2. log-in to OAS manager (em) and add a ‘virtual host’ under HTTP-Server
    -set path (Document Root:  i.e. ‘/phpbb3’ )
    -set port (any available ports, i.e. ‘8888’ )
  3. start the installation of phpBB3 from web browser
    Note: domain path ‘ 8888’ would point to ‘phpbb3’ dir
  4. phpBB3 install (needs at least php v4.3.5)
    -DB Type = oracle/mySQL-DB Server = (ip of DB may need to exist in tnsnames.ora)
    -DB Server port = 8888 (port specified in virtual hosts on server)
    -DB name = the name of the database on DB-server
    -DB user/pass = user login to access the DB (the DB-user which was created)
    -Proceed with other install options for phbb3 (general)
  5. after phpBB3 is installed remove/rename install dir from server (phpbb3 requirement)