roller-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "weilei shen (JIRA)" <>
Subject [jira] Created: (ROL-1757) sharing my ways to solve oracle+roller problems
Date Mon, 03 Nov 2008 05:10:19 GMT
sharing my ways to solve oracle+roller problems

                 Key: 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
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
	at org.apache.roller.config.RollerRuntimeConfig.isFrontPageWeblog(
	at org.apache.roller.config.RollerRuntimeConfig.isSiteWideWeblog(
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.

View raw message