[jira] Commented: (ROL-1757) sharing my ways to solve oracle+roller problems

["weilei shen (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/roller/browse/ROL-1757?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=14446#action_14446 ] 

weilei shen commented on ROL-1757:
----------------------------------

attention:

VALUE VARCHAR2(4000) default ' ' not null 

(there has a blank space between ' '  )

> sharing my ways to solve oracle+roller problems
> -----------------------------------------------
>
>                 Key: ROL-1757
>                 URL: https://issues.apache.org/roller/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.
-
You can reply to this email to add a comment to the issue online.