OpenEMM Support Forum Index OpenEMM Support
Use this forum to get and provide free help regarding OpenEMM
 
 TOP   FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Blacklist - current Version

 
Post new topic   Reply to topic    OpenEMM Support Forum Index -> Using OpenEMM
View previous topic :: View next topic  
Author Message
thinwath



Joined: 26 Apr 2007
Posts: 13
PostPosted: Mon Mar 01, 2010 12:45 pm    Post subject: Blacklist - current Version Reply with quote
Hi,

I'm recieving following exception if I request the blacklist

Code:
11:42:49.611]Failed storing persistent session attribute `blacklistForm'.  Persistent session values must extend java.io.Serializable.
[11:42:49.611]java.io.NotSerializableException: java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask
[11:42:49.611]java.io.NotSerializableException: java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask
2010-03-01 11:42:50,127: INFO  [resin-tcp-connection-*:80-5] org.agnitas - Action: 1
2010-03-01 11:42:50,127: INFO  [resin-tcp-connection-*:80-5] org.agnitas - Action: 1
2010-03-01 11:42:50,127: ERROR [resin-tcp-connection-*:80-5] org.agnitas - blacklist: java.util.concurrent.ExecutionException: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT email, creation_date FROM cust_ban_tbl                   WHERE company_id= ? ORDER BY email asc  LIMIT ? , ? ]; SQL state [S1009]; error code [0]; Cannot convert value '0000-00-00 00:00:00' from column 2 to TIMESTAMP.; nested exception is java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 2 to TIMESTAMP.
java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222)
java.util.concurrent.FutureTask.get(FutureTask.java:83)
org.agnitas.web.BlacklistAction.prepareList(BlacklistAction.java:198)
org.agnitas.web.BlacklistAction.executeIntern(BlacklistAction.java:134)
org.agnitas.web.BlacklistAction.execute(BlacklistAction.java:100)
org.apache.struts.chain.commands.servlet.ExecuteAction.execute(ExecuteAction.java:58)
org.apache.struts.chain.commands.AbstractExecuteAction.execute(AbstractExecuteAction.java:67)
org.apache.struts.chain.commands.ActionCommandBase.execute(ActionCommandBase.java:51)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.commons.chain.generic.LookupCommand.execute(LookupCommand.java:304)
org.apache.commons.chain.impl.ChainBase.execute(ChainBase.java:190)
org.apache.struts.chain.ComposableRequestProcessor.process(ComposableRequestProcessor.java:283)
org.apache.struts.action.ActionServlet.process(ActionServlet.java:1913)
org.apache.struts.action.ActionServlet.doPost(ActionServlet.java:462)
javax.servlet.http.HttpServlet.service(HttpServlet.java:154)
javax.servlet.http.HttpServlet.service(HttpServlet.java:92)
com.caucho.server.dispatch.ServletFilterChain.doFilter(ServletFilterChain.java:106)
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:174)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
com.caucho.server.dispatch.FilterFilterChain.doFilter(FilterFilterChain.java:70)


It is clear whats happening here. Am I the only one who is facing this problem?
Back to top
View user's profile Send private message
thinwath



Joined: 26 Apr 2007
Posts: 13
PostPosted: Tue Mar 02, 2010 11:01 am    Post subject: Reply with quote
I updated the column to a proper date, now everything is working fine and as excepted.
Back to top
View user's profile Send private message
effgee



Joined: 28 Apr 2010
Posts: 10
PostPosted: Wed Apr 28, 2010 9:51 pm    Post subject: Reply with quote
Which log file are you looking at?
Could you give me more information about what you changed to fix this?
I am having an issue when I click on the blacklist I only get a blank page.

Thanks
Back to top
View user's profile Send private message
kan



Joined: 02 May 2010
Posts: 1
PostPosted: Sun May 02, 2010 3:00 pm    Post subject: Blacklist access only via original Admin user Reply with quote
Hello,

I'm new to OpenEMM, I'm using it under OpenSuSE-11.1
I noticed that Blacklist accessed only via original Admin user built within the package, for new users regarding timezone it show a blank screen.

Thanks,
Back to top
View user's profile Send private message
astacx



Joined: 15 Jun 2010
Posts: 1
Location: Solingen/Germany
PostPosted: Tue Jun 15, 2010 3:50 pm    Post subject: Re: Blacklist - current Version Reply with quote
Hi,

my name is Jens, i am also new here and this is my first post. We have some little problems after upgrading from 5.x to 6.0.

Here are some hints and questions.

thinwath wrote:
Hi,
Code:
---schnipp---
2010-03-01 11:42:50,127: ERROR [resin-tcp-connection-*:80-5] org.agnitas - blacklist: java.util.concurrent.ExecutionException: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [SELECT email, creation_date FROM cust_ban_tbl                   WHERE company_id= ? ORDER BY email asc  LIMIT ? , ? ]; SQL state [S1009]; error code [0]; Cannot convert value '0000-00-00 00:00:00' from column 2 to TIMESTAMP.; nested exception is java.sql.SQLException: Cannot convert value '0000-00-00 00:00:00' from column 2 to TIMESTAMP.
java.util.concurrent.FutureTask$Sync.innerGet(FutureTask.java:222)
java.util.concurrent.FutureTask.get(FutureTask.java:83)
org.agnitas.web.BlacklistAction.prepareList(BlacklistAction.java:198)
---schnapp---



The same bug appears here while the "Preview"-Function:
1) Schablonen (hmm, dont know how this is called in the english version)
2) Overview
3) select some
4) Content
5) Preview

At this Point we got an Error instead of the Preview and in the Log-File we have the "Cannot convert value '0000-00-00 00:00:00' from <> to TIMESTAMP"-Exception.

One possible solution is to append
[core]zeroDateTimeBehavior=convertToNull[/code]
to the jdbc.url= line in the config file emm.properties.

The complete line looks like
Code:
jdbc.url=jdbc:mysql://localhost/openemm?useUnicode=yes&characterEncoding=UTF-8&useOldAliasMetadataBehavior=true&zeroDateTimeBehavior=convertToNull


Out second problem is that nobody except the original admin user can access the blacklist. Digging around resulted in some confusion around the admin_tbl, group_tbl, admin_permission_tbl and admin_group_permission_tbl.

I do not understand, how the group tables will be modified. Webinterface?

How ever, adding the "blacklist"-permission manual to the admin_permission_tbl works and a ordinary user can see and manipulate the black list. Get the user_id for the user and add the permission:
Code:
select user_id, username, fullname from admin_tbl;
insert into admin_permission_tbl values (<<<user_id>>>, 'blacklist');


This permission will be automatic removed next time you change any user permissions in the webinterface. Its looks like one forgotten property in the webinterface: "backlist".

Please forgive me my bad english.


With kind regards
Jens
_________________
--
http://megasoft.de
Back to top
View user's profile Send private message Visit poster's website
Display posts from previous:   
Post new topic   Reply to topic    OpenEMM Support Forum Index -> Using OpenEMM All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


SourceForge.net Logo Powered by phpBB © 2001, 2005 phpBB Group