HOWTO: phpBB with Oracle

The 2.0.x discussion forum has been locked; this will remain read-only. The 3.0.x discussion forum has been renamed phpBB Discussion.
Locked
sufehmi
Registered User
Posts: 96
Joined: Sat Feb 15, 2003 8:54 pm
Location: Jakarta
Contact:

HOWTO: phpBB with Oracle

Post by sufehmi » Wed Apr 30, 2003 11:22 am

I'll post the steps required to enable phpBB to utilise Oracle database as its backend here.

If you have any questions/issues, please don't post here. I'd like to keep this thread clean, strictly only for phpBB-with-Oracle how-to.
But do feel free to post them on this thread instead:
http://www.phpbb.com/phpBB/viewtopic.php?t=91766

Thanks.

UPDATE:

:::: 27th August 2003
I have verified that the procedures listed in this page works with phpBB 2.0.6 as well.

There will be minor updates all over this page though (version number changes, some bug fixing, minor quirks, etc) so bear with me.
But in the meantime - yes, it works.
Last edited by sufehmi on Wed Aug 27, 2003 4:25 pm, edited 4 times in total.

sufehmi
Registered User
Posts: 96
Joined: Sat Feb 15, 2003 8:54 pm
Location: Jakarta
Contact:

Apache + PHP on Solaris

Post by sufehmi » Wed Apr 30, 2003 11:40 am

DESCRIPTION:
This post explains how to install Apache + PHP with oci8 interface (to enable access to Oracle8)


SOFTWARE VERSIONS:
Sun Solaris 8
Oracle client for Solaris v8.1.7
Oracle database for Solaris v9.2.0
Apache v1.3.28
PHP v4.3.3


REQUIREMENTS:
Oracle client v8.1.7 to be installed in the same box


NOTES:

# I've verified that this setup works with Oracle 9.
The trick is to compile PHP using the Oracle v8.1.7 client. The result will be able to communicate to Oracle9 server without problem.

# Originally I installed Apache + PHP on one of our Linux server. But the Oracle client won't install at all (needed to enable PHP's oci8 interface)
Somehow, the Oracle8 installation package I downloaded straight from Oracle's website has totally different layout than what's mentioned in various documentations - including Oracle's own installation manual.
We have the Oracle8 client for Solaris on CD, so I installed it instead. And it worked flawlessly.

# I downloaded everything to /u6/harry, installed Apache under /u6, and installed Oracle8 client under /u4/oracle/app/oracle/product/8.1.7
Feel free to substitute them as necessary.

# You may find various other packages listed below from:
http://www.sunfreeware.com

# If you're encountering error messages when compiling PHP regarding missing “oci.h”, this is most likely because the Oracle client that’s installed is not the Administration version.
The quickest solution is to copy from other Oracle client installation, all files on $ORACLE_HOME/rdbms/demo/ and $ORACLE_HOME/rdbms/public/ into $ORACLE_HOME/rdbms/demo/ in that server.



STEPS:
Don't type anything in the bracket, they're just my notes that explains the previous statement.

Code: Select all

cd /u6/harry
gunzip gcc-2.95.3-sol8-sparc-local.gz
pkgadd -d gcc-2.95.3-sol8-sparc-local
gunzip make-3.79.1-sol8-sparc-local.gz
pkgadd -d make-3.79.1-sol8-sparc-local
gunzip flex-2.5.4a-sol8-sparc-local.gz
pkgadd -d flex-2.5.4a-sol8-sparc-local
gunzip libgcc-3.0-sol8-sparc-local.gz
pkgadd -d libgcc-3.0-sol8-sparc-local
gunzip php-4.3.3.tar.gz
tar xvf php-4.3.3.tar
gunzip apache_1.3.28.tar.gz
tar xvf apache_1.3.28.tar
PATH=/usr/local/bin:/usr/ccs/bin:$PATH (to enable "make" to find its tools)

cd /u6/harry/apache_1.3.28
./configure --prefix=/u6/apache_1.3.28 --enable-module=most --enable-shared=max
LIBS=-lpthread ./config.status
make
make install

su - oracle (to activate the related Oracle environment variables)
cd /u6/harry/php-4.3.3
PATH=/usr/xpg4/bin:$PATH (to get "make" to use a copy of "sed" in /usr/xpg4/bin, which doesn't have the show-stopping bug)
./configure --with-oci8=/u4/oracle/app/oracle/product/8.1.7 --with-apxs=/u6/apache_1.3.28/bin/apxs
make
make install

cd ../apache_1.3.28
./config.status --activate-module=src/modules/php4/libphp4.module
make
make install
chown -R nobody /u6/apache_1.3.28
ln -s /u6/apache_1.3.28 /u6/apache

vi /u6/apache/conf/httpd.conf
Add the following lines in it:

Code: Select all

AddType application/x-httpd-php .php
Save, and quit. Then let's finish it off:

Code: Select all

cd /u6/apache/bin
./apachectl start
Last edited by sufehmi on Thu Sep 18, 2003 2:33 pm, edited 2 times in total.

sufehmi
Registered User
Posts: 96
Joined: Sat Feb 15, 2003 8:54 pm
Location: Jakarta
Contact:

Base phpBB install

Post by sufehmi » Wed Apr 30, 2003 12:21 pm

DESCRIPTION:
This post describes how to do the initial installation of phpBB, to be ready to use Oracle.


SOFTWARE VERSIONS:
phpBB v2.0.4


STEPS:
Basically, install phpBB v2.0.4 to use MySQL v3.x database.
Of course this will require you to have an existing MySQL installation somewhere.

Or if this is too much bother, just download the following:
http://www.harrysufehmi.com/files/phpBB ... hed.tar.gz
Then extract its contents to a directory, which can be served by your webserver.

If you download the following, you can skip patching the source code (as outlined in here) - except for the Oracle's environment variables:
http://www.harrysufehmi.com/files/phpBB ... hed.tar.gz

Anyway, let's go on - edit config.inc.php, and put in the following values:

Code: Select all

$dbms = 'oracle';
$dbhost = 'your_Oracle_SID';
$dbname = 'your_Oracle_SID';
$dbuser = 'your_Oracle_username';
$dbpasswd = 'your_Oracle_password';
That's it, you've done the base installation of phpBB.
Now you just need to patch it, and set up the Oracle database.
Last edited by sufehmi on Mon May 19, 2003 9:54 am, edited 2 times in total.

sufehmi
Registered User
Posts: 96
Joined: Sat Feb 15, 2003 8:54 pm
Location: Jakarta
Contact:

Oracle database setup

Post by sufehmi » Wed Apr 30, 2003 12:28 pm

DESCRIPTION:
This post describes how to set up an Oracle database to be used by phpBB.
It lists the content of 3 files; the first will build the necessary tables/sequences/triggers in the Oracle database, the second will build the indexes, and the third will populate the tables.


SOFTWARE VERSIONS:
Oracle database v8.1.7 (client/server), Oracle database v9.0.2 (server)


ASSUMPTIONS:
# An Oracle database has been set up and is fully working.
# Understanding of basic workings of Oracle.
# Ability to use SQLplus.


NOTES:
# The first file to be executed in SQLplus is called tables.sql, the second one is called indexes.sql, and the third one is called oracle_basic.sql
# Be warned that running these scripts will wipe out any existing phpBB tables.

STEPS:

tables.sql:

Code: Select all

REM ----------------------------------------------------------------------------------------------------
REM 
REM This script is used to built the relevant tables in an Oracle database
REM to prepare it to be used by phpBB (http://www.phpbb.com)
REM 
REM ----------------------------------------------------------------------------------------------------
REM Originally written by Alexander Lukanin (alex at tascom dot net dot dotru)
REM Testing and error corrections done by Stephen Booth (stephen_booth at birmingham dot gov dot dotuk)
REM "DROP TABLE"s added for convenience by Harry Sufehmi (harry_sufehmi at birmingham dot gov dot dotuk)
REM ----------------------------------------------------------------------------------------------------
REM 
REM === WARNING ===
REM This script will destroy all data in the related tables, naturally, because this script is supposed
REM to be run only on the initial installation of phpBB.
REM 
REM ----------------------------------------------------------------------------------------------------

DROP SEQUENCE phpbb_groups_id_seq;
CREATE SEQUENCE phpbb_groups_id_seq;

DROP SEQUENCE phpbb_banlist_id_seq;
CREATE SEQUENCE phpbb_banlist_id_seq;

DROP SEQUENCE phpbb_categories_id_seq;
CREATE SEQUENCE phpbb_categories_id_seq;

DROP SEQUENCE phpbb_disallow_id_seq;
CREATE SEQUENCE phpbb_disallow_id_seq;

DROP SEQUENCE phpbb_forum_prune_id_seq;
CREATE SEQUENCE phpbb_forum_prune_id_seq;

DROP SEQUENCE phpbb_posts_id_seq;
CREATE SEQUENCE phpbb_posts_id_seq;

DROP SEQUENCE phpbb_privmsgs_id_seq;
CREATE SEQUENCE phpbb_privmsgs_id_seq;

DROP SEQUENCE phpbb_ranks_id_seq;
CREATE SEQUENCE phpbb_ranks_id_seq;

DROP SEQUENCE phpbb_search_wordlist_id_seq;
CREATE SEQUENCE phpbb_search_wordlist_id_seq;

DROP SEQUENCE phpbb_smilies_id_seq;
CREATE SEQUENCE phpbb_smilies_id_seq;

DROP SEQUENCE phpbb_themes_id_seq;
CREATE SEQUENCE phpbb_themes_id_seq;

DROP SEQUENCE phpbb_topics_id_seq;
CREATE SEQUENCE phpbb_topics_id_seq;

DROP SEQUENCE phpbb_vote_desc_id_seq;
CREATE SEQUENCE phpbb_vote_desc_id_seq;

DROP SEQUENCE phpbb_words_id_seq;
CREATE SEQUENCE phpbb_words_id_seq;


DROP TABLE phpbb_auth_access;
CREATE TABLE phpbb_auth_access
    (group_id                       NUMBER DEFAULT '0'  NOT NULL,
    forum_id                       NUMBER DEFAULT '0'  NOT NULL,
    auth_view                      VARCHAR2(1) DEFAULT '0'  NOT NULL,
    auth_read                      VARCHAR2(1) DEFAULT '0'  NOT NULL,
    auth_post                      VARCHAR2(1) DEFAULT '0'  NOT NULL,
    auth_reply                     VARCHAR2(1) DEFAULT '0'  NOT NULL,
    auth_edit                      VARCHAR2(1) DEFAULT '0'  NOT NULL,
    auth_delete                    VARCHAR2(1) DEFAULT '0'  NOT NULL,
    auth_sticky                    VARCHAR2(1) DEFAULT '0'  NOT NULL,
    auth_announce                  VARCHAR2(1) DEFAULT '0'  NOT NULL,
    auth_vote                      VARCHAR2(1) DEFAULT '0'  NOT NULL,
    auth_pollcreate                VARCHAR2(1) DEFAULT '0'  NOT NULL,
    auth_attachments               VARCHAR2(1) DEFAULT '0'  NOT NULL,
    auth_mod                       VARCHAR2(1) DEFAULT '0'  NOT NULL);

DROP TABLE phpbb_banlist;
CREATE TABLE phpbb_banlist
    (ban_id                         NUMBER NOT NULL,
    ban_userid                     NUMBER,
    ban_ip                         VARCHAR2(8),
    ban_email                      VARCHAR2(255));

CREATE OR REPLACE TRIGGER phpbb_banlist_bi
BEFORE INSERT 
ON phpbb_banlist
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
    SELECT phpbb_banlist_ID_SEQ.NEXTVAL INTO :NEW.ban_id FROM DUAL;
END;
/
show errors

DROP TABLE phpbb_categories;
CREATE TABLE phpbb_categories
    (cat_id                         NUMBER NOT NULL,
    cat_title                      VARCHAR2(100),
    cat_order                      NUMBER NOT NULL);

CREATE OR REPLACE TRIGGER phpbb_categories_bi
BEFORE INSERT 
ON phpbb_categories
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
    SELECT phpbb_categories_ID_SEQ.NEXTVAL INTO :NEW.cat_id FROM DUAL;
END;
/
show errors


DROP TABLE phpbb_config;
CREATE TABLE phpbb_config
    (config_name                    VARCHAR2(255) NOT NULL,
    config_value                   VARCHAR2(255));


DROP TABLE phpbb_disallow;
CREATE TABLE phpbb_disallow
	(disallow_id                    NUMBER NOT NULL,
	disallow_username              VARCHAR2(25) DEFAULT ''  NOT NULL);

CREATE OR REPLACE TRIGGER phpbb_disallow_bi
BEFORE INSERT 
ON phpbb_disallow
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
    SELECT phpbb_disallow_ID_SEQ.NEXTVAL INTO :NEW.disallow_id FROM DUAL;
END;
/
show errors


DROP TABLE phpbb_forum_prune;
CREATE TABLE phpbb_forum_prune
    (prune_id                       NUMBER NOT NULL,
    forum_id                       NUMBER NOT NULL,
    prune_days                     NUMBER NOT NULL,
    prune_freq                     NUMBER NOT NULL);

CREATE OR REPLACE TRIGGER phpbb_forum_prune_bi
BEFORE INSERT 
ON phpbb_forum_prune
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
    SELECT phpbb_forum_prune_ID_SEQ.NEXTVAL INTO :NEW.prune_id FROM DUAL;
END;
/
show errors


DROP TABLE phpbb_forums;
CREATE TABLE phpbb_forums
    (forum_id                       NUMBER NOT NULL,
    cat_id                         NUMBER NOT NULL,
    forum_name                     VARCHAR2(150),
    forum_desc                     VARCHAR2(2000),
    forum_status                   NUMBER DEFAULT '0'  NOT NULL,
    forum_order                    NUMBER DEFAULT '1'  NOT NULL,
    forum_posts                    NUMBER DEFAULT '0'  NOT NULL,
    forum_topics                   NUMBER DEFAULT '0'  NOT NULL,
    forum_last_post_id             NUMBER DEFAULT '0'  NOT NULL,
    prune_next                     NUMBER,
    prune_enable                   VARCHAR2(1) DEFAULT '0'  NOT NULL,
    auth_view                      VARCHAR2(2) DEFAULT '0'  NOT NULL,
    auth_read                      VARCHAR2(2) DEFAULT '0'  NOT NULL,
    auth_post                      VARCHAR2(2) DEFAULT '0'  NOT NULL,
    auth_reply                     VARCHAR2(2) DEFAULT '0'  NOT NULL,
    auth_edit                      VARCHAR2(2) DEFAULT '0'  NOT NULL,
    auth_delete                    VARCHAR2(2) DEFAULT '0'  NOT NULL,
    auth_sticky                    VARCHAR2(2) DEFAULT '0'  NOT NULL,
    auth_announce                  VARCHAR2(2) DEFAULT '0'  NOT NULL,
    auth_vote                      VARCHAR2(2) DEFAULT '0'  NOT NULL,
    auth_pollcreate                VARCHAR2(2) DEFAULT '0'  NOT NULL,
    auth_attachments               VARCHAR2(2) DEFAULT '0'  NOT NULL);


DROP TABLE phpbb_groups;
CREATE TABLE phpbb_groups
    (group_id                       NUMBER NOT NULL,
    group_type                     NUMBER DEFAULT '1'  NOT NULL,
    group_name                     VARCHAR2(40),
    group_description              VARCHAR2(255),
    group_moderator                NUMBER DEFAULT '0'  NOT NULL,
    group_single_user              VARCHAR2(1) DEFAULT '1'  NOT NULL);

CREATE OR REPLACE TRIGGER phpbb_groups_bi
BEFORE INSERT 
ON phpbb_groups
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
    SELECT phpbb_groups_ID_SEQ.NEXTVAL INTO :NEW.group_id FROM DUAL;
END;
/
show errors


DROP TABLE phpbb_posts;
CREATE TABLE phpbb_posts
    (post_id                        NUMBER NOT NULL,
    topic_id                       NUMBER DEFAULT '0'  NOT NULL,
    forum_id                       NUMBER DEFAULT '0'  NOT NULL,
    poster_id                      NUMBER DEFAULT '0'  NOT NULL,
    post_time                      NUMBER DEFAULT '0'  NOT NULL,
    poster_ip                      VARCHAR2(8) NOT NULL,
    post_username                  VARCHAR2(25),
    enable_bbcode                  VARCHAR2(1) DEFAULT '1'  NOT NULL,
    enable_html                    VARCHAR2(1) DEFAULT '0'  NOT NULL,
    enable_smilies                 VARCHAR2(1) DEFAULT '1'  NOT NULL,
    enable_sig                     VARCHAR2(1) DEFAULT '1'  NOT NULL,
    post_edit_time                 NUMBER,
    post_edit_count                NUMBER DEFAULT '0'  NOT NULL);

CREATE OR REPLACE TRIGGER phpbb_posts_bi
BEFORE INSERT 
ON phpbb_posts
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
    SELECT phpbb_posts_ID_SEQ.NEXTVAL INTO :NEW.post_id FROM DUAL;
END;
/
show errors


DROP TABLE phpbb_posts_text;
CREATE TABLE phpbb_posts_text
    (post_id                        NUMBER DEFAULT '0'  NOT NULL,
    bbcode_uid                     VARCHAR2(10),
    post_subject                   VARCHAR2(60),
    post_text                      VARCHAR2(2000));


DROP TABLE phpbb_privmsgs;
CREATE TABLE phpbb_privmsgs
    (privmsgs_id                    NUMBER NOT NULL,
    privmsgs_type                  NUMBER DEFAULT '0'  NOT NULL,
    privmsgs_subject               VARCHAR2(255) DEFAULT '0'  NOT NULL,
    privmsgs_from_userid           NUMBER DEFAULT '0'  NOT NULL,
    privmsgs_to_userid             NUMBER DEFAULT '0'  NOT NULL,
    privmsgs_date                  NUMBER DEFAULT '0'  NOT NULL,
    privmsgs_ip                    VARCHAR2(8) NOT NULL,
    privmsgs_enable_bbcode         VARCHAR2(1) DEFAULT '1'  NOT NULL,
    privmsgs_enable_html           VARCHAR2(1) DEFAULT '0'  NOT NULL,
    privmsgs_enable_smilies        VARCHAR2(1) DEFAULT '1'  NOT NULL,
    privmsgs_attach_sig            VARCHAR2(1) DEFAULT '1'  NOT NULL);

CREATE OR REPLACE TRIGGER phpbb_privmsgs_bi
BEFORE INSERT 
ON phpbb_privmsgs
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
    SELECT phpbb_privmsgs_ID_SEQ.NEXTVAL INTO :NEW.privmsgs_id FROM DUAL;
END;
/
show errors


DROP TABLE phpbb_privmsgs_text;
CREATE TABLE phpbb_privmsgs_text
    (privmsgs_text_id               NUMBER DEFAULT '0'  NOT NULL,
    privmsgs_bbcode_uid            VARCHAR2(10) DEFAULT '0'  NOT NULL,
    privmsgs_text                  VARCHAR2(2000));


DROP TABLE phpbb_ranks;
CREATE TABLE phpbb_ranks
    (rank_id                        NUMBER NOT NULL,
    rank_title                     VARCHAR2(50) NOT NULL,
    rank_min                       NUMBER DEFAULT '0'  NOT NULL,
    rank_special                   VARCHAR2(1) DEFAULT '0',
    rank_image                     VARCHAR2(255));

CREATE OR REPLACE TRIGGER phpbb_ranks_bi
BEFORE INSERT 
ON phpbb_ranks
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
    SELECT phpbb_ranks_ID_SEQ.NEXTVAL INTO :NEW.rank_id FROM DUAL;
END;
/
show errors


DROP TABLE phpbb_search_results;
CREATE TABLE phpbb_search_results
    (search_id                      NUMBER DEFAULT '0'  NOT NULL,
    session_id                     VARCHAR2(32) DEFAULT ''  NOT NULL,
    search_array                   VARCHAR2(2000) NOT NULL);


DROP TABLE phpbb_search_wordlist;
CREATE TABLE phpbb_search_wordlist
    (word_text                      VARCHAR2(50) DEFAULT ''  NOT NULL,
    word_id                        NUMBER NOT NULL,
    word_common                    VARCHAR2(1) DEFAULT '0'  NOT NULL);

CREATE OR REPLACE TRIGGER phpbb_search_wordlist_bi
BEFORE INSERT 
ON phpbb_search_wordlist
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
    SELECT phpbb_search_wordlist_ID_SEQ.NEXTVAL INTO :NEW.word_id FROM DUAL;
END;
/
show errors


DROP TABLE phpbb_search_wordmatch;
CREATE TABLE phpbb_search_wordmatch
    (post_id                        NUMBER DEFAULT '0'  NOT NULL,
    word_id                        NUMBER DEFAULT '0'  NOT NULL,
    title_match                    VARCHAR2(1) DEFAULT '0'  NOT NULL);


DROP TABLE phpbb_sessions;
CREATE TABLE phpbb_sessions
    (session_id                     VARCHAR2(32) DEFAULT ''  NOT NULL,
    session_user_id                NUMBER DEFAULT '0'  NOT NULL,
    session_start                  NUMBER DEFAULT '0'  NOT NULL,
    session_time                   NUMBER DEFAULT '0'  NOT NULL,
    session_ip                     VARCHAR2(8) DEFAULT '0'  NOT NULL,
    session_page                   NUMBER DEFAULT '0'  NOT NULL,
    session_logged_in              VARCHAR2(1) DEFAULT '0'  NOT NULL);


DROP TABLE phpbb_smilies;
CREATE TABLE phpbb_smilies
    (smilies_id                     NUMBER NOT NULL,
    code                           VARCHAR2(50),
    smile_url                      VARCHAR2(100),
    emoticon                       VARCHAR2(75));

CREATE OR REPLACE TRIGGER phpbb_smilies_bi
BEFORE INSERT 
ON phpbb_smilies
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
    SELECT phpbb_smilies_ID_SEQ.NEXTVAL INTO :NEW.smilies_id FROM DUAL;
END;
/
show errors


DROP TABLE phpbb_themes;
CREATE TABLE phpbb_themes
    (themes_id                      NUMBER NOT NULL,
    template_name                  VARCHAR2(30) DEFAULT ''  NOT NULL,
    style_name                     VARCHAR2(30) DEFAULT ''  NOT NULL,
    head_stylesheet                VARCHAR2(100) DEFAULT NULL,
    body_background                VARCHAR2(100) DEFAULT NULL,
    body_bgcolor                   VARCHAR2(6) DEFAULT NULL,
    body_text                      VARCHAR2(6) DEFAULT NULL,
    body_link                      VARCHAR2(6) DEFAULT NULL,
    body_vlink                     VARCHAR2(6) DEFAULT NULL,
    body_alink                     VARCHAR2(6) DEFAULT NULL,
    body_hlink                     VARCHAR2(6) DEFAULT NULL,
    tr_color1                      VARCHAR2(6) DEFAULT NULL,
    tr_color2                      VARCHAR2(6) DEFAULT NULL,
    tr_color3                      VARCHAR2(6) DEFAULT NULL,
    tr_class1                      VARCHAR2(25) DEFAULT NULL,
    tr_class2                      VARCHAR2(25) DEFAULT NULL,
    tr_class3                      VARCHAR2(25) DEFAULT NULL,
    th_color1                      VARCHAR2(6) DEFAULT NULL,
    th_color2                      VARCHAR2(6) DEFAULT NULL,
    th_color3                      VARCHAR2(6) DEFAULT NULL,
    th_class1                      VARCHAR2(25) DEFAULT NULL,
    th_class2                      VARCHAR2(25) DEFAULT NULL,
    th_class3                      VARCHAR2(25) DEFAULT NULL,
    td_color1                      VARCHAR2(6) DEFAULT NULL,
    td_color2                      VARCHAR2(6) DEFAULT NULL,
    td_color3                      VARCHAR2(6) DEFAULT NULL,
    td_class1                      VARCHAR2(25) DEFAULT NULL,
    td_class2                      VARCHAR2(25) DEFAULT NULL,
    td_class3                      VARCHAR2(25) DEFAULT NULL,
    fontface1                      VARCHAR2(50) DEFAULT NULL,
    fontface2                      VARCHAR2(50) DEFAULT NULL,
    fontface3                      VARCHAR2(50) DEFAULT NULL,
    fontsize1                      NUMBER DEFAULT NULL,
    fontsize2                      NUMBER DEFAULT NULL,
    fontsize3                      NUMBER DEFAULT NULL,
    fontcolor1                     VARCHAR2(6) DEFAULT NULL,
    fontcolor2                     VARCHAR2(6) DEFAULT NULL,
    fontcolor3                     VARCHAR2(6) DEFAULT NULL,
    span_class1                    VARCHAR2(25) DEFAULT NULL,
    span_class2                    VARCHAR2(25) DEFAULT NULL,
    span_class3                    VARCHAR2(25) DEFAULT NULL,
    img_size_poll                  NUMBER,
    img_size_privmsg               NUMBER);

CREATE OR REPLACE TRIGGER phpbb_themes_bi
BEFORE INSERT
ON phpbb_themes
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
    SELECT phpbb_themes_ID_SEQ.NEXTVAL INTO :NEW.themes_id FROM DUAL;
END;
/
show errors



DROP TABLE phpbb_themes_name;
CREATE TABLE phpbb_themes_name
    (themes_id                      NUMBER DEFAULT '0'  NOT NULL,
    tr_color1_name                 VARCHAR2(50),
    tr_color2_name                 VARCHAR2(50),
    tr_color3_name                 VARCHAR2(50),
    tr_class1_name                 VARCHAR2(50),
    tr_class2_name                 VARCHAR2(50),
    tr_class3_name                 VARCHAR2(50),
    th_color1_name                 VARCHAR2(50),
    th_color2_name                 VARCHAR2(50),
    th_color3_name                 VARCHAR2(50),
    th_class1_name                 VARCHAR2(50),
    th_class2_name                 VARCHAR2(50),
    th_class3_name                 VARCHAR2(50),
    td_color1_name                 VARCHAR2(50),
    td_color2_name                 VARCHAR2(50),
    td_color3_name                 VARCHAR2(50),
    td_class1_name                 VARCHAR2(50),
    td_class2_name                 VARCHAR2(50),
    td_class3_name                 VARCHAR2(50),
    fontface1_name                 VARCHAR2(50),
    fontface2_name                 VARCHAR2(50),
    fontface3_name                 VARCHAR2(50),
    fontsize1_name                 VARCHAR2(50),
    fontsize2_name                 VARCHAR2(50),
    fontsize3_name                 VARCHAR2(50),
    fontcolor1_name                VARCHAR2(50),
    fontcolor2_name                VARCHAR2(50),
    fontcolor3_name                VARCHAR2(50),
    span_class1_name               VARCHAR2(50),
    span_class2_name               VARCHAR2(50),
    span_class3_name               VARCHAR2(50));



DROP TABLE phpbb_topics;
CREATE TABLE phpbb_topics
    (topic_id                       NUMBER NOT NULL,
    forum_id                       NUMBER DEFAULT '0'  NOT NULL,
    topic_title                    VARCHAR2(60) NOT NULL,
    topic_poster                   NUMBER DEFAULT '0'  NOT NULL,
    topic_time                     NUMBER DEFAULT '0'  NOT NULL,
    topic_views                    NUMBER DEFAULT '0'  NOT NULL,
    topic_replies                  NUMBER DEFAULT '0'  NOT NULL,
    topic_status                   VARCHAR2(3) DEFAULT '0'  NOT NULL,
    topic_vote                     VARCHAR2(1) DEFAULT '0'  NOT NULL,
    topic_type                     VARCHAR2(3) DEFAULT '0'  NOT NULL,
    topic_first_post_id            NUMBER DEFAULT '0'  NOT NULL,
    topic_last_post_id             NUMBER DEFAULT '0'  NOT NULL,
    topic_moved_id                 NUMBER DEFAULT '0'  NOT NULL);

CREATE OR REPLACE TRIGGER phpbb_topics_bi
BEFORE INSERT 
ON phpbb_topics
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
    SELECT phpbb_topics_ID_SEQ.NEXTVAL INTO :NEW.topic_id FROM DUAL;
END;
/
show errors


DROP TABLE phpbb_topics_watch;
CREATE TABLE phpbb_topics_watch
    (topic_id                       NUMBER DEFAULT '0'  NOT NULL,
    user_id                        NUMBER DEFAULT '0'  NOT NULL,
    notify_status                  VARCHAR2(1) DEFAULT '0'  NOT NULL);


DROP TABLE phpbb_user_group;
CREATE TABLE phpbb_user_group
    (group_id                       NUMBER DEFAULT '0'  NOT NULL,
    user_id                        NUMBER DEFAULT '0'  NOT NULL,
    user_pending                   VARCHAR2(1));


DROP TABLE phpbb_users;
CREATE TABLE phpbb_users
    (user_id                        NUMBER NOT NULL,
    user_active                    VARCHAR2(1) DEFAULT '1',
    username                       VARCHAR2(25) NOT NULL,
    user_password                  VARCHAR2(32),
    user_session_time              NUMBER DEFAULT '0'  NOT NULL,
    user_session_page              NUMBER DEFAULT '0'  NOT NULL,
    user_lastvisit                 NUMBER DEFAULT '0'  NOT NULL,
    user_regdate                   NUMBER DEFAULT '0'  NOT NULL,
    user_level                     NUMBER DEFAULT '0',
    user_posts                     NUMBER DEFAULT '0'  NOT NULL,
    user_timezone                  NUMBER DEFAULT '0'  NOT NULL,
    user_style                     NUMBER,
    user_lang                      VARCHAR2(255),
    user_dateformat                VARCHAR2(14) DEFAULT 'd M Y H:i' ,
    user_new_privmsg               NUMBER DEFAULT '0'  NOT NULL,
    user_unread_privmsg            NUMBER DEFAULT '0'  NOT NULL,
    user_last_privmsg              NUMBER DEFAULT '0'  NOT NULL,
    user_emailtime                 NUMBER,
    user_viewemail                 VARCHAR2(1),
    user_attachsig                 VARCHAR2(1),
    user_allowhtml                 VARCHAR2(1) DEFAULT '1',
    user_allowbbcode               VARCHAR2(1) DEFAULT '1',
    user_allowsmile                VARCHAR2(1) DEFAULT '1',
    user_allowavatar               VARCHAR2(1) DEFAULT '1'  NOT NULL,
    user_allow_pm                  VARCHAR2(1) DEFAULT '1'  NOT NULL,
    user_allow_viewonline          VARCHAR2(1) DEFAULT '1'  NOT NULL,
    user_notify                    VARCHAR2(1) DEFAULT '1'  NOT NULL,
    user_notify_pm                 VARCHAR2(1) DEFAULT '0'  NOT NULL,
    user_popup_pm                  VARCHAR2(1) DEFAULT '0'  NOT NULL,
    user_rank                      NUMBER DEFAULT '0',
    user_avatar                    VARCHAR2(100),
    user_avatar_type               NUMBER DEFAULT '0'  NOT NULL,
    user_email                     VARCHAR2(255),
    user_icq                       VARCHAR2(15),
    user_website                   VARCHAR2(100),
    user_from                      VARCHAR2(100),
    user_sig                       VARCHAR2(2000),
    user_sig_bbcode_uid            VARCHAR2(10),
    user_aim                       VARCHAR2(255),
    user_yim                       VARCHAR2(255),
    user_msnm                      VARCHAR2(255),
    user_occ                       VARCHAR2(100),
    user_interests                 VARCHAR2(255),
    user_actkey                    VARCHAR2(32),
    user_newpasswd                 VARCHAR2(32));


DROP TABLE phpbb_vote_desc;
CREATE TABLE phpbb_vote_desc
    (vote_id                        NUMBER NOT NULL,
    topic_id                       NUMBER DEFAULT '0'  NOT NULL,
    vote_text                      VARCHAR2(2000) NOT NULL,
    vote_start                     NUMBER DEFAULT '0'  NOT NULL,
    vote_length                    NUMBER DEFAULT '0'  NOT NULL);

CREATE OR REPLACE TRIGGER phpbb_vote_desc_bi
BEFORE INSERT 
ON phpbb_vote_desc
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
    SELECT phpbb_vote_desc_ID_SEQ.NEXTVAL INTO :NEW.vote_id FROM DUAL;
END;
/
show errors


DROP TABLE phpbb_vote_results;
CREATE TABLE phpbb_vote_results
    (vote_id                        NUMBER DEFAULT '0'  NOT NULL,
    vote_option_id                 NUMBER DEFAULT '0'  NOT NULL,
    vote_option_text               VARCHAR2(255) NOT NULL,
    vote_result                    NUMBER DEFAULT '0'  NOT NULL);


DROP TABLE phpbb_vote_voters;
CREATE TABLE phpbb_vote_voters
    (vote_id                        NUMBER DEFAULT '0'  NOT NULL,
    vote_user_id                   NUMBER DEFAULT '0'  NOT NULL,
    vote_user_ip                   VARCHAR2(8) NOT NULL);


DROP TABLE phpbb_words;
CREATE TABLE phpbb_words
    (word_id                        NUMBER NOT NULL,
    word                           VARCHAR2(100) NOT NULL,
    replacement                    VARCHAR2(100) NOT NULL);

CREATE OR REPLACE TRIGGER phpbb_words_bi
BEFORE INSERT 
ON phpbb_words
REFERENCING NEW AS NEW OLD AS OLD
FOR EACH ROW
BEGIN
    SELECT phpbb_words_ID_SEQ.NEXTVAL INTO :NEW.word_id FROM DUAL;
END;
/
show errors

indexes.sql:

Code: Select all

CREATE INDEX phpbb_auth_access_group_id ON phpbb_auth_access
(group_id ASC);

CREATE INDEX phpbb_auth_access_forum_id ON phpbb_auth_access
(forum_id ASC);

CREATE INDEX phpbb_user_group_group_id ON phpbb_user_group
(group_id ASC);

CREATE INDEX phpbb_user_group_user_id ON phpbb_user_group
(user_id ASC);

CREATE INDEX phpbb_groups_group_id ON phpbb_groups
(group_id ASC);

CREATE INDEX phpbb_groups_group_single_user ON phpbb_groups
(group_single_user ASC);

CREATE INDEX phpbb_banlist_ban_id ON phpbb_banlist
(ban_id ASC);

CREATE INDEX phpbb_categories_cat_id ON phpbb_categories
(cat_id ASC);

CREATE INDEX phpbb_categories_cat_order ON phpbb_categories
(cat_order ASC);

CREATE INDEX phpbb_config_config_name ON phpbb_config
(config_name ASC);

CREATE INDEX phpbb_disallow_disallow_id ON phpbb_disallow
(disallow_id ASC);

CREATE INDEX phpbb_forum_prune_prune_id ON phpbb_forum_prune
(prune_id ASC);

CREATE INDEX phpbb_forum_prune_forum_id ON phpbb_forum_prune
(forum_id ASC);

CREATE INDEX phpbb_forums_forum_id ON phpbb_forums
(forum_id ASC);

CREATE INDEX phpbb_forums_forum_order ON phpbb_forums
(forum_order ASC);

CREATE INDEX phpbb_forums_cat_id ON phpbb_forums
(cat_id ASC);

CREATE INDEX phpbb_forums_last_post_id ON phpbb_forums
(forum_last_post_id ASC);

CREATE INDEX phpbb_posts_post_id ON phpbb_posts
(post_id ASC);

CREATE INDEX phpbb_posts_forum_id ON phpbb_posts
(forum_id ASC);

CREATE INDEX phpbb_posts_topic_id ON phpbb_posts
(topic_id ASC);

CREATE INDEX phpbb_posts_poster_id ON phpbb_posts
(poster_id ASC);

CREATE INDEX phpbb_posts_post_time ON phpbb_posts
(post_time ASC);

CREATE INDEX phpbb_posts_text_post_id ON phpbb_posts_text
(post_id ASC);

CREATE INDEX phpbb_privmsgs_privmsgs_id ON phpbb_privmsgs
(privmsgs_id ASC);

CREATE INDEX phpbb_privmsgs_from_userid ON phpbb_privmsgs
(privmsgs_from_userid ASC);

CREATE INDEX phpbb_privmsgs_to_userid ON phpbb_privmsgs
(privmsgs_to_userid ASC);

CREATE INDEX phpbb_privmsgs_text_id ON phpbb_privmsgs_text
(privmsgs_text_id ASC);

CREATE INDEX phpbb_ranks_rank_id ON phpbb_ranks
(rank_id ASC);

CREATE INDEX phpbb_search_results_search_id ON phpbb_search_results
(search_id ASC);

CREATE INDEX phpbb_search_results_id ON phpbb_search_results
(session_id ASC);

CREATE INDEX phpbb_search_wordlist_text ON phpbb_search_wordlist
(word_text ASC);

CREATE INDEX phpbb_search_wordlist_word_id ON phpbb_search_wordlist
(word_id ASC);

CREATE INDEX phpbb_search_wordmatch_word_id ON phpbb_search_wordmatch
(word_id ASC);

CREATE INDEX phpbb_sessions_session_id ON phpbb_sessions
(session_id ASC);

CREATE INDEX phpbb_sessions_session_user_id ON phpbb_sessions
(session_user_id ASC);

CREATE INDEX phpbb_smilies_smilies_id ON phpbb_smilies
(smilies_id ASC);

CREATE INDEX phpbb_themes_themes_id ON phpbb_themes
(themes_id ASC);

CREATE INDEX phpbb_themes_name_themes_id ON phpbb_themes_name
(themes_id ASC);

CREATE INDEX phpbb_topics_topic_id ON phpbb_topics
(topic_id ASC);

CREATE INDEX phpbb_topics_forum_id ON phpbb_topics
(forum_id ASC);

CREATE INDEX phpbb_topics_topic_moved_id ON phpbb_topics
(topic_moved_id ASC);

CREATE INDEX phpbb_topics_topic_status ON phpbb_topics
(topic_status ASC);

CREATE INDEX phpbb_topics_topic_type ON phpbb_topics
(topic_type ASC);

CREATE INDEX phpbb_topics_watch_topic_id ON phpbb_topics_watch
(topic_id ASC);

CREATE INDEX phpbb_topics_watch_user_id ON phpbb_topics_watch
(user_id ASC);

CREATE INDEX phpbb_topics_watch_status ON phpbb_topics_watch
(notify_status ASC);

CREATE INDEX phpbb_users_user_id ON phpbb_users
(user_id ASC);

CREATE INDEX phpbb_users_user_session_time ON phpbb_users
(user_session_time ASC);

CREATE INDEX phpbb_vote_desc_vote_id ON phpbb_vote_desc
(vote_id ASC);

CREATE INDEX phpbb_vote_desc_topic_id ON phpbb_vote_desc
(topic_id ASC);

CREATE INDEX phpbb_vote_results_id ON phpbb_vote_results
(vote_option_id ASC);

CREATE INDEX phpbb_vote_results_vote_id ON phpbb_vote_results
(vote_id ASC);

CREATE INDEX phpbb_vote_voters_vote_id ON phpbb_vote_voters
(vote_id ASC);

CREATE INDEX phpbb_vote_voters_vote_user_ip ON phpbb_vote_voters
(vote_user_ip ASC);

CREATE INDEX phpbb_words_word_id ON phpbb_words
(word_id ASC);

oracle_basic.sql:
Please read the instructions below before you run this script.

Code: Select all

REM ----------------------------------------------------------------------------------------------------
REM 
REM This script is used to populate the relevant tables in an Oracle database
REM to prepare it to be used by phpBB (http://www.phpbb.com)
REM 
REM This script is to be run after tables.sql
REM 
REM ----------------------------------------------------------------------------------------------------
REM Originally written by Alexander Lukanin (alex at tascom dot net dotru)
REM Testing and error corrections done by Stephen Booth (stephen_booth at birmingham dot gov dot dotuk)
REM ----------------------------------------------------------------------------------------------------
REM 
REM Instructions:
REM 
REM # Change "www.myserver.tld" to your server's domain/IP address.
REM # Change "server_port" accordingly
REM # Change "script_path" accordingly
REM - The rest then should be changeable from phpBB's admin panel.
REM - Username is "Admin" with password "sapsap"
REM ----------------------------------------------------------------------------------------------------

INSERT INTO phpbb_config (config_name, config_value) VALUES ('config_id','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_disable','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('sitename','yourdomain.com');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('site_desc','A _little_ text to describe your forum');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_name','phpbb2mysql');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_path','/');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_domain','');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('cookie_secure','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('session_length','3600');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_html_tags','b,i,u,pre');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_bbcode','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_smilies','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_sig','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_namechange','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_theme_create','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_local','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_remote','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('allow_avatar_upload','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('override_user_style','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('posts_per_page','15');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('topics_per_page','50');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('hot_threshold','25');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_poll_options','10');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sig_chars','255');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_inbox_privmsgs','50');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_sentbox_privmsgs','25');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('max_savebox_privmsgs','50');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_sig','Thanks, The Management');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email','youraddress@yourdomain.com');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_delivery','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_host','');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_username','');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('smtp_password','');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('require_activation','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('flood_interval','15');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_email_form','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_filesize','6144');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_width','80');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_max_height','80');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_path','images/avatars');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('avatar_gallery_path','images/avatars/gallery');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('smilies_path','images/smiles');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_style','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_dateformat','D M d, Y g:i a');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_timezone','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('prune_enable','1');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('privmsg_disable','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('gzip_compress','0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_fax', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('coppa_mail', '');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_users', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('record_online_date', '0');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_name', 'www.myserver.tld');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('server_port', '80');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('script_path', '/phpBB2/');
INSERT INTO phpbb_config (config_name, config_value) VALUES ('version', '.0.4');


INSERT INTO phpbb_categories (cat_id, cat_title, cat_order) VALUES (1, 'Test category 1', 10);


INSERT INTO phpbb_forums (forum_id, forum_name, forum_desc, cat_id, forum_order, forum_posts, forum_topics, forum_last_post_id, auth_view, auth_read, auth_post, auth_reply, auth_edit, auth_delete, auth_announce, auth_sticky, auth_pollcreate, auth_vote, auth_attachments) VALUES (1, 'Test Forum 1', 'This is just a test forum.', 1, 10, 1, 1, 1, 0, 0, 0, 0, 1, 1, 3, 3, 1, 1, 3);


INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( -1, 'Anonymous', 0, 0, '', '', '', '', '', '', '', '', 0, NULL, '', '', '', 0, 0, 1, 0, 1, 0, 1, 1, NULL, '', '', 0, '', '', 0, 0);
INSERT INTO phpbb_users (user_id, username, user_level, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, user_viewemail, user_style, user_aim, user_yim, user_msnm, user_posts, user_attachsig, user_allowsmile, user_allowhtml, user_allowbbcode, user_allow_pm, user_notify_pm, user_popup_pm, user_allow_viewonline, user_rank, user_avatar, user_lang, user_timezone, user_dateformat, user_actkey, user_newpasswd, user_notify, user_active) VALUES ( 2, 'Admin', 1, 0, 'c4e7fae1c0d5c5daba89d6383d270567', 'admin@yourdomain.com', '', '', '', '', '', '', 1, 1, '', '', '', 1, 0, 1, 0, 1, 1, 1, 1, 1, 1, '', 'english', 0, 'd M Y h:i a', '', '', 0, 1);

INSERT INTO phpbb_ranks (rank_id, rank_title, rank_min, rank_special, rank_image) VALUES ( 1, 'Site Admin', -1, 1, NULL);


INSERT INTO phpbb_groups (group_id, group_name, group_description, group_single_user) VALUES (1, 'Anonymous', 'Personal User', 1);
INSERT INTO phpbb_groups (group_id, group_name, group_description, group_single_user) VALUES (2, 'Admin', 'Personal User', 1);


INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (1, -1, 0);
INSERT INTO phpbb_user_group (group_id, user_id, user_pending) VALUES (2, 2, 0);


INSERT INTO phpbb_topics (topic_id, topic_title, topic_poster, topic_time, topic_views, topic_replies, forum_id, topic_status, topic_type, topic_vote, topic_first_post_id, topic_last_post_id, topic_moved_id) VALUES (1, 'Welcome to phpBB 2', 2, '972086460', 0, 0, 1, 0, 0, 0, 1, 1, 0);


INSERT INTO phpbb_posts (post_id, topic_id, forum_id, poster_id, post_time, post_username, poster_ip) VALUES (1, 1, 1, 2, 972086460, NULL, '7F000001');
INSERT INTO phpbb_posts_text (post_id, post_subject, post_text) VALUES (1, NULL, 'This is an example post in your phpBB 2 installation. You may delete this post, this topic and even this forum if you like since everything seems to be working!');


INSERT INTO phpbb_themes (themes_id, template_name, style_name, head_stylesheet, body_background, body_bgcolor, body_text, body_link, body_vlink, body_alink, body_hlink, tr_color1, tr_color2, tr_color3, tr_class1, tr_class2, tr_class3, th_color1, th_color2, th_color3, th_class1, th_class2, th_class3, td_color1, td_color2, td_color3, td_class1, td_class2, td_class3, fontface1, fontface2, fontface3, fontsize1, fontsize2, fontsize3, fontcolor1, fontcolor2, fontcolor3, span_class1, span_class2, span_class3) VALUES (1, 'subSilver', 'subSilver', 'subSilver.css', '', 'E5E5E5', '000000', '006699', '5493B4', '', 'DD6900', 'EFEFEF', 'DEE3E7', 'D1D7DC', '', '', '', '98AAB1', '006699', 'FFFFFF', 'cellpic1.gif', 'cellpic3.gif', 'cellpic2.jpg', 'FAFAFA', 'FFFFFF', '', 'row1', 'row2', '', 'Verdana, Arial, Helvetica, sans-serif', 'Trebuchet MS', 'Courier, Courier New, sans-serif', 10, 11, 12, '444444', '006600', 'FFA34F', '', '', '');

INSERT INTO phpbb_themes_name (themes_id, tr_color1_name, tr_color2_name, tr_color3_name, tr_class1_name, tr_class2_name, tr_class3_name, th_color1_name, th_color2_name, th_color3_name, th_class1_name, th_class2_name, th_class3_name, td_color1_name, td_color2_name, td_color3_name, td_class1_name, td_class2_name, td_class3_name, fontface1_name, fontface2_name, fontface3_name, fontsize1_name, fontsize2_name, fontsize3_name, fontcolor1_name, fontcolor2_name, fontcolor3_name, span_class1_name, span_class2_name, span_class3_name) VALUES (1, 'The lightest row colour', 'The medium row color', 'The darkest row colour', '', '', '', 'Border round the whole page', 'Outer table border', 'Inner table border', 'Silver gradient picture', 'Blue gradient picture', 'Fade-out gradient on index', 'Background for quote boxes', 'All white areas', '', 'Background for topic posts', '2nd background for topic posts', '', 'Main fonts', 'Additional topic title font', 'Form fonts', 'Smallest font size', 'Medium font size', 'Normal font size (post body etc)', 'Quote & copyright text', 'Code text colour', 'Main table header text colour', '', '', '');


INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 1, ':D', 'icon_biggrin.gif', 'Very Happy');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 2, ':-D', 'icon_biggrin.gif', 'Very Happy');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 3, ':grin:', 'icon_biggrin.gif', 'Very Happy');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 4, ':)', 'icon_smile.gif', 'Smile');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 5, ':-)', 'icon_smile.gif', 'Smile');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 6, ':smile:', 'icon_smile.gif', 'Smile');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 7, ':(', 'icon_sad.gif', 'Sad');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 8, ':-(', 'icon_sad.gif', 'Sad');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 9, ':sad:', 'icon_sad.gif', 'Sad');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 10, ':o', 'icon_surprised.gif', 'Surprised');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 11, ':-o', 'icon_surprised.gif', 'Surprised');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 12, ':eek:', 'icon_surprised.gif', 'Surprised');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 13, ':shock:', 'icon_eek.gif', 'Shocked');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 14, ':?', 'icon_confused.gif', 'Confused');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 15, ':-?', 'icon_confused.gif', 'Confused');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 16, ':???:', 'icon_confused.gif', 'Confused');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 17, '8)', 'icon_cool.gif', 'Cool');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 18, '8-)', 'icon_cool.gif', 'Cool');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 19, ':cool:', 'icon_cool.gif', 'Cool');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 20, ':lol:', 'icon_lol.gif', 'Laughing');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 21, ':x', 'icon_mad.gif', 'Mad');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 22, ':-x', 'icon_mad.gif', 'Mad');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 23, ':mad:', 'icon_mad.gif', 'Mad');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 24, ':P', 'icon_razz.gif', 'Razz');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 25, ':-P', 'icon_razz.gif', 'Razz');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 26, ':razz:', 'icon_razz.gif', 'Razz');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 27, ':oops:', 'icon_redface.gif', 'Embarassed');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 28, ':cry:', 'icon_cry.gif', 'Crying or Very sad');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 29, ':evil:', 'icon_evil.gif', 'Evil or Very Mad');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 30, ':twisted:', 'icon_twisted.gif', 'Twisted Evil');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 31, ':roll:', 'icon_rolleyes.gif', 'Rolling Eyes');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 32, ':wink:', 'icon_wink.gif', 'Wink');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 33, ';)', 'icon_wink.gif', 'Wink');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 34, ';-)', 'icon_wink.gif', 'Wink');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 35, ':!:', 'icon_exclaim.gif', 'Exclamation');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 36, ':?:', 'icon_question.gif', 'Question');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 37, ':idea:', 'icon_idea.gif', 'Idea');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 38, ':arrow:', 'icon_arrow.gif', 'Arrow');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 39, ':|', 'icon_neutral.gif', 'Neutral');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 40, ':-|', 'icon_neutral.gif', 'Neutral');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 41, ':neutral:', 'icon_neutral.gif', 'Neutral');
INSERT INTO phpbb_smilies (smilies_id, code, smile_url, emoticon) VALUES ( 42, ':mrgreen:', 'icon_mrgreen.gif', 'Mr. Green');


INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 1, 'example', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 2, 'post', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 3, 'phpbb', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 4, 'installation', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 5, 'delete', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 6, 'topic', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 7, 'forum', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 8, 'since', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 9, 'everything', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 10, 'seems', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 11, 'working', 0 );
INSERT INTO phpbb_search_wordlist (word_id, word_text, word_common) VALUES ( 12, 'welcome', 0 );


INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 1, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 2, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 3, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 4, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 5, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 6, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 7, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 8, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 9, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 10, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 11, 1, 0 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 12, 1, 1 );
INSERT INTO phpbb_search_wordmatch (word_id, post_id, title_match) VALUES ( 3, 1, 1 );
commit;
Last edited by sufehmi on Fri Feb 13, 2004 4:21 pm, edited 4 times in total.

sufehmi
Registered User
Posts: 96
Joined: Sat Feb 15, 2003 8:54 pm
Location: Jakarta
Contact:

Getting it to work

Post by sufehmi » Wed Apr 30, 2003 12:45 pm

DESCRIPTION:
This post describes how to finally get phpBB up and running on Oracle database.


SOFTWARE VERSIONS:
phpBB v2.0.6
Oracle database v8.1.7 (client/server), Oracle database v9.0.2 (server)


NOTES:

# Andrew has done a stellar job, his patch fixes more bugs than the one listed in this post. You can find his patch here: http://www.sledgehammersolutions.co.uk/phpbb/

I'll keep this post only as a record, I strongly suggest that you deploy his patch instead of mine here.

Don't miss the list of extra patches which will be consolidated in here:
http://www.phpbb.com/phpBB/viewtopic.ph ... 593#928593

# Ideally, all changes should be done strictly within db/oracle.php
This HOWTO still include a step that modify index.php, however I'm not expert enough on regex so unable to move this change to db/oracle.php
You're most welcome if you could do this.


STEPS:

# Open db/oracle.php
You'll find that there are 2 declarations of sql_nextid(), one after the other.
Delete/remark the second one.

# Open index.php:

On line 150, you'll find these:

Code: Select all

WHERE p.post_id = f.forum_last_post_id(+)
AND u.user_id = p.poster_id(+)
Change it to:

Code: Select all

WHERE p.post_id (+) = f.forum_last_post_id
AND u.user_id (+) = p.poster_id
This will eliminate the presence of "phantom forum"
Thanks to Shurik for this.


# Open db/oracle.php:
On line 27, insert the following code:

Code: Select all

putenv('ORACLE_BASE=/u4/oracle/app/oracle');
putenv('ORACLE_HOME=/u4/oracle/app/oracle/product/8.1.7');
putenv('PATH=/u4/oracle/app/oracle/product/8.1.7/bin:/usr/bin:/bin:/etc:/usr/openwin/bin:/usr/local/bin');
putenv('ORACLE_DOC=$ORACLE_BASE/docs/8.1.7');
putenv('TNS_ADMIN=/u4/oracle/app/oracle/product/8.1.7/network/admin');
Of course, modify it first to reflect your own environment.

Some people may dislike this, but in our case I found out that it's impossible to get PHP to utilise existing environment variables.
Hence the statements above.

# Open db/oracle.php:
Look for:

Code: Select all

$temp_result = @OCIFetchInto($stmt, $temp_result, OCI_ASSOC+OCI_RETURN_NULLS); 
if($temp_result) 
                                { 
                                        return $temp_result['CURRVAL'];
And replace it with:

Code: Select all

$tmp_result = OCIFetchInto($stmt, $temp_result, OCI_ASSOC+OCI_RETURN_NULLS); 
if($tmp_result) 
                                { 
                                        return $temp_result['NEXTVAL'];
This will eliminate a problem where sql_nextid() doesn't return any value.

# Open db/oracle.php:
Look for:

Code: Select all

if( eregi("^(INSERT{1}|^INSERT INTO{1})[[:space:]][\"]?([a-zA-Z0-9\_\-]+)[\"]?", $this->last_query_text[$query_id], $tablename))
And replace it with:

Code: Select all

if(eregi("^(INSERT INTO{1}|^INSERT  INTO{1})[[:space:]][\"]?([a-zA-Z0-9\_\-]+)[\"]?", $this->last_query_text[$query_id], $tablename))
This will eliminate a problem where phpBB was unable to change the status of a private message to "sent" after being read by the recipient

# Open db/oracle.php:
Look for:

Code: Select all

}

if(eregi("^(INSERT|UPDATE) ", $query))
Just before that line, insert the following:

Code: Select all

        $start_row = $row_offset;
        $end_row = strval(intval($start_row) + intval($num_rows));
        $temp_query = $query;
        $temp_replacement = "WHERE rownum >= ".$start_row." AND rownum <= ".$end_row." AND ";
        $query = "SELECT * FROM (SELECT rownum AS xrownum, a.* FROM (".$temp_query.") a WHERE  rownum <= ".$end_row.") WHERE xrownum >= ".$start_row;
This will enable us to get around the lack of LIMIT option in an Oracle's SELECT query

# Open search.php:
Look for:

Code: Select all

$sql = "SELECT t.*, f.forum_id, f.forum_name, u.username
, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time
                                FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE .
" f, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2
                                WHERE t.topic_id IN ($search_results)
                                        AND t.topic_poster = u.user_id
                                        AND f.forum_id = t.forum_id
                                        AND p.post_id = t.topic_first_post_id
                                        AND p2.post_id = t.topic_last_post_id
                                        AND u2.user_id = p2.poster_id";
Remark that line, and replace it with the following:

Code: Select all

$sql = "SELECT t.*, f.forum_id as fforum_id, f.forum_name, u.username, u.user_id, u2.username as user2, u2.user_id as id2, p.post_username, p2.post_username AS post_username2, p2.post_time FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TABLE . " p2, " . USERS_TABLE . " u2 WHERE t.topic_id IN ($search_results) AND t.topic_poster = u.user_id AND f.forum_id = t.forum_id AND p.post_id = t.topic_first_post_id AND p2.post_id = t.topic_last_post_id AND u2.user_id = p2.poster_id";
There's only one difference, but that will make the search facility to be working properly.

# include/functions_search.php, line 243:
(credit goes to amannering)

Clicking on "new post" button will display an error message.
Here's the information on how to fix it:

look for :

Code: Select all

		if ( $match_sql != '' )
		{
			$sql = "INSERT IGNORE INTO " . SEARCH_MATCH_TABLE . " (post_id, word_id, title_match) 
				SELECT $post_id, word_id, $title_match  
					FROM " . SEARCH_WORD_TABLE . " 
					WHERE word_text IN ($match_sql)"; 
			if ( !$db->sql_query($sql) )
replace with:

Code: Select all

		if ( $match_sql != '' )
		{

			if (SQL_LAYER == 'oracle')
			{

				$sql = "INSERT INTO " . SEARCH_MATCH_TABLE . " (post_id, word_id, title_match) 
					SELECT $post_id, word_id, $title_match  
						FROM " . SEARCH_WORD_TABLE . " 
						WHERE word_text IN ($match_sql)"; 

			} else {

				$sql = "INSERT IGNORE INTO " . SEARCH_MATCH_TABLE . " (post_id, word_id, title_match) 
					SELECT $post_id, word_id, $title_match  
						FROM " . SEARCH_WORD_TABLE . " 
						WHERE word_text IN ($match_sql)"; 
			};


			if ( !$db->sql_query($sql) )


# search.php, line 710
(credit goes to amannering)

There's a problem where if you click on "Memberlist" button, then click on any user's name, then click on "Find all posts by <username>" link,
it will display an error message ("ambiguous column name")
Here's the information on how to fix it:

look for:

Code: Select all

		if ( $show_results == 'posts' )
		{
			$sql = "SELECT pt.post_text, pt.bbcode_uid, pt.post_subject, p.*, f.forum_id, f.forum_name, t.*, u.username, u.user_id, u.user_sig, u.user_sig_bbcode_uid  
				FROM " . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TEXT_TABLE . " pt 
				WHERE p.post_id IN ($search_results)
					AND pt.post_id = p.post_id
					AND f.forum_id = p.forum_id
					AND p.topic_id = t.topic_id
					AND p.poster_id = u.user_id";
		}
		else
replace with:

Code: Select all

		if ( $show_results == 'posts' )
		{

			if (SQL_LAYER == 'oracle') 
			{
				$sql = "SELECT pt.post_text, pt.bbcode_uid, pt.post_subject, p.*, f.forum_id as fforum_id, f.forum_name, t.topic_title, t.topic_poster, t.topic_time, t.topic_views, t.topic_replies, t.topic_status, t.topic_vote, t.topic_type, t.topic_first_post_id, t.topic_last_post_id, t.topic_moved_id, u.username, u.user_id, u.user_sig, u.user_sig_bbcode_uid                                    
					FROM " . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TEXT_TABLE . " pt 
					WHERE p.post_id IN ($search_results)
						AND pt.post_id = p.post_id
						AND f.forum_id = p.forum_id
						AND p.topic_id = t.topic_id
						AND p.poster_id = u.user_id";
			} else {
				$sql = "SELECT pt.post_text, pt.bbcode_uid, pt.post_subject, p.*, f.forum_id, f.forum_name, t.*, u.username, u.user_id, u.user_sig, u.user_sig_bbcode_uid  
					FROM " . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . USERS_TABLE . " u, " . POSTS_TABLE . " p, " . POSTS_TEXT_TABLE . " pt 
					WHERE p.post_id IN ($search_results)
						AND pt.post_id = p.post_id
						AND f.forum_id = p.forum_id
						AND p.topic_id = t.topic_id
						AND p.poster_id = u.user_id";
			}
		}
		else

Congratulations - your phpBB installation should work now.

Open it in your browser, and log in as user "Admin" with password "sapsap" - and start messing with it.


UPDATE
If you want to install phpBB on a three-tier infrastructure, then consult the following guide.
Last edited by sufehmi on Thu Jan 15, 2004 3:04 pm, edited 6 times in total.

sufehmi
Registered User
Posts: 96
Joined: Sat Feb 15, 2003 8:54 pm
Location: Jakarta
Contact:

Essential patches

Post by sufehmi » Thu Jan 15, 2004 3:03 pm

DESCRIPTION:
This post will list the essential patches not yet covered in the other posts.

This post will assume that you've deployed this patch to your phpBB installation:
http://www.sledgehammersolutions.co.uk/phpbb/


SOFTWARE VERSIONS:
phpBB v2.0.6
Oracle database v8.1.7 (client/server), Oracle database v9.0.2 (server)


PATCHES LIST:


[ 1 ] Remember to update your phpBB 2.0.6 installation to 2.0.6c, by following the simple instructions (one-line additions) on:
http://www.phpbb.com/phpBB/viewtopic.php?f=14&t=153818


[ 2 ] Unable to ban users

Description: If you use the old schema (the one in this thread has been updated), you'll encounter error message when trying to ban a user.

Solution:

Change the schema for phpbb_banlist from:

Code: Select all

CREATE TABLE phpbb_banlist (ban_id NUMBER NOT NULL, ban_userid NUMBER NOT NULL, ban_ip VARCHAR2(8) NOT NULL, ban_email VARCHAR2(255));
To:

Code: Select all

CREATE TABLE phpbb_banlist (ban_id NUMBER NOT NULL, ban_userid NUMBER, ban_ip VARCHAR2(8), ban_email VARCHAR2(255));

Gnolaum
Registered User
Posts: 8
Joined: Tue May 23, 2006 8:00 pm

Post by Gnolaum » Tue May 23, 2006 8:14 pm

Any chance to get an update on this? Preferably with phpbb 2.0.20 and Oracle Express (10g)?

Dance123
Registered User
Posts: 5
Joined: Wed Jan 24, 2007 9:43 am

Oracle schema

Post by Dance123 » Tue Jan 30, 2007 3:11 pm

hi,,

Can you share the oracle scripts required for creation of tables in phpbb2

Thanks in advance

sufehmi
Registered User
Posts: 96
Joined: Sat Feb 15, 2003 8:54 pm
Location: Jakarta
Contact:

Re:

Post by sufehmi » Sat May 26, 2007 9:19 am

Gnolaum wrote:Any chance to get an update on this? Preferably with phpbb 2.0.20 and Oracle Express (10g)?
Hi, please don't discuss here. You can talk about this patch in this thread instead.

Anyway, phpBB3 RC1 has been released, which support Oracle !
I highly advised you to try this instead, and report back any bugs you found to phpBB team asap. We've been waiting for this for years now, so let's help make phpBB3 ready for release folks !


cheers, HS

Locked

Return to “2.0.x Discussion”

Who is online

Users browsing this forum: No registered users and 7 guests