SQL update onepixel_log_tbl error?

Use this forum for all other questions regarding OpenEMM

Moderator: moderator

lesstra
Posts: 9
Joined: Thu Jan 26, 2012 10:54 am

SQL update onepixel_log_tbl error?

Post by lesstra »

Hi,
I'm using OpenEMM 2011 on Debian.
I started getting this error in the openemm@localhost mailbox:
sql:update onepixel_log_tbl set open_count = open_count+1 where company_id = ? and customer_id = ? and mailing_id = ?
Exception: org.springframework.jdbc.UncategorizedSQLException: PreparedStatementCallback; uncategorized SQLException for SQL [update onepixel_log_tbl set open_count = open_count+1 where company_id = ? and customer_id = ? and mailing_id = ?]; SQL state [HY000]; error code [1194]; Table 'onepixel_log_tbl' is marked as crashed and should be repaired; nested exception is java.sql.SQLException: Table 'onepixel_log_tbl' is marked as crashed and should be repaired
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:83)
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:80)
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607)
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:792)
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:850)
org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:858)
org.agnitas.dao.impl.OnepixelDaoImpl.writePixel(OnepixelDaoImpl.java:46)
org.agnitas.web.OnePixelCount.writePixelLogToDB(OnePixelCount.java:134)
org.agnitas.web.OnePixelCount.persistLog(OnePixelCount.java:127)
org.agnitas.web.OnePixelCount.service(OnePixelCount.java:116)
javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.springframework.orm.hibernate3.support.OpenSessionInViewFilter.doFilterInternal(OpenSessionInViewFilter.java:198)
org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
org.agnitas.web.filter.SerializeRequestFilter.doFilter(SerializeRequestFilter.java:28)
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
What is this table for, and how should I repair it since it is "marked as crashed" ?
Thanks.
maschoff
Site Admin
Posts: 2596
Joined: Thu Aug 03, 2006 10:20 am
Location: Munich, Germany
Contact:

Re: SQL update onepixel_log_tbl error?

Post by maschoff »

Somehow table 'onepixel_log_tbl' is unreadable or inconsistent. Please check the MySQL documentation on how to proceed. I personally have never seen an error message like this before.
OpenEMM Maintainer
Post Reply