File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
http://aspose.com/file-tools
The moose likes JForum and the fly likes some problem about Oracle upgrade script Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Products » JForum
Bookmark "some problem about Oracle upgrade script" Watch "some problem about Oracle upgrade script" New topic
Author

some problem about Oracle upgrade script

Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
I have installed jforum v2.1.7 two months ago, and upgrade to v2.1.8 some days ago. I am using Oracle10G database. some problems, bug? maybe...
-------------------------------------------------------------------------------------------------------------------------------------
At file "oracle_2.1.7_to_2.1.8.sql" :
CREATE INDEX idx_banlist_email ON jforum_banlist(banlist_email); ---this index is exist at old version
...
ALTER TABLE jforum_users ALTER COLUMN rank_id SET DEFAULT 0; ---error, it can run smoothly while be written as
ALTER TABLE jforum_users modify rank_id DEFAULT 0;
...
CREATE INDEX idx_extensions_ext ON jforum_extensions(extension); --- the index is exist with different name.
--------------------------------------------------------------------------------------------------------------------------------------

At file "oracle.sql":

there are two topic_id be selected, and lack \ at the end of the line. it must be:

--------------------------------------------------------------------------------------------------------------------------------------


that is all to this day. hope help.

by the way, I found there are some different between jforum2.1.8+mysql and jforum2.1.7+oracle->2.1.8oracle:

A) 2.1.8oracle lack two table named jforum_api and jforum_mail_integration
B)mysql less a column named "is_read" as number(1) at table jforum_forums_watch

what effect while lack tables named jforum_api and jforum_mail_integration?

[originally posted on jforum.net by Patrick]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
Thanks for figuring this out!

Also see this post for fixing an error related to the recent topics feed.

Cheers!
Alex
[originally posted on jforum.net by buijs]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
This is a fixed version for JForum v2.1.8 oracle.sql
[originally posted on jforum.net by andowson]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
buijs and andowson, thank you two.

can you answer me the last question in my original topic?


[originally posted on jforum.net by Patrick]
Migrated From Jforum.net
Ranch Hand

Joined: Apr 22, 2012
Posts: 17424
The two tables were not found in PostgreSQL, HSQLDB, MSSQL, too. They are related some experiment new feature still under development. So don't worry about it. JForum still can work correctly without these two tables.
[originally posted on jforum.net by andowson]
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: some problem about Oracle upgrade script
 
Similar Threads
How to put JFrom in my site???
SQL Exception when trying to view RSS feeds
Error accessing RSS links using Oracle
help:sqlServer SqlException : Invalid column name user_boigrpahy
RSS of latest entries