[
https://issues.apache.org/jira/browse/ROL-1757?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Glen Mazza closed ROL-1757.
---------------------------
Resolution: Not A Problem
Thanks for the information, we're closing this item (as it's probably against
an older version of both Oracle and Roller) but it still remains googleable for
those it might help.
> sharing my ways to solve oracle+roller problems
> -----------------------------------------------
>
> Key: ROL-1757
> URL: https://issues.apache.org/jira/browse/ROL-1757
> Project: Roller
> Issue Type: Bug
> Environment: oracle9i/oracle10，tomcat5.5，windows 2000/vista home basic
> Reporter: weilei shen
> Assignee: Roller Unassigned
>
> i met two errors when i use oracle database,now i found the way to solve
> it.(it's all ok when i use mssql2000)
> 1.error:Problem to register the user and receive the following message :"I'm
> sorry, but the administrator of this site has turned off new user
> registrations."
> oracle9i: be sure you have set correct access rights to roller_data
> then,Use Oracle JDBC 10g Drivers instead of the 9.x ones
> oracle10: it's caused by createdb.sql, some types are wrong.
> In createdb.sql, some type set to be clob type ,in fact,
> they are varchar
> i advise you to create table follow the files like
> *.hbm.xml under " org\apache\roller\pojos"
> 2.error:can't access to the userblog
> roller.log:
> DEBUG 2008-10-30 16:09:45,453 RollerRuntimeConfig:getProperty - fetched
> property [site.frontpage.weblog.handle=null]
> ERROR 2008-10-30 16:09:45,453 ApplicationDispatcher:invoke -
> Servlet.service() for servlet PageServlet threw exception
> java.lang.NullPointerException
> at
> org.apache.roller.config.RollerRuntimeConfig.isFrontPageWeblog(RollerRuntimeConfig.java:223)
> at
> org.apache.roller.config.RollerRuntimeConfig.isSiteWideWeblog(RollerRuntimeConfig.java:236)
> it's caused by [site.frontpage.weblog.handle=null].In table roller_properties
> , site.frontpage.weblog.handle is null.
> BUT if we set the handle in it, the frontpage will be the userblog. I perfer
> to set a blank space in it.
> you can rebuild the roller_properties .(the column VALUE shoule be varchar,so
> it's the createdb.sql error again. -_-!)
> my sql:
> create table roller_properties (
> name varchar(255) not null primary key,
> VALUE VARCHAR2(4000) default ' ' not null
> );
> my english is poor,i don't know whether you can understand what i say...
> hopes these can help you.
--
This message is automatically generated by JIRA.
If you think it was sent incorrectly, please contact your JIRA administrators
For more information on JIRA, see: http://www.atlassian.com/software/jira
