[Erp5-dev] Resolving activity problem

[Guillaume Michon]

Hi all,

I recently had this problem when I wanted to make activities available on my
site (in event.log) :

"""
2004-07-27T14:21:32 PROBLEM(100) CMFActivity: Core call to tic or isAwake
failed for activity <Products.CMFActivity.Activity.SQLDict.SQLDict instance
at 0x4381b9cc>
Traceback (most recent call last):
File "/var/lib/zope/Products/CMFActivity/ActivityTool.py", line 282, in tic
activity.tic(self, processing_node) # Transaction processing is the
responsability of the activity
File "/var/lib/zope/Products/CMFActivity/Activity/Queue.py", line 107, in
tic
if self.dequeueMessage(activity_tool, processing_node):
File "/var/lib/zope/Products/CMFActivity/Activity/SQLDict.py", line 118, in
dequeueMessage
to_date=now_date, to_processing_date = max_processing_date)
File
"/usr/lib/zope/./build/build-base/python-2.3/build-lib/Shared/DC/ZRDB/DA.py",
line 449, in __call__
File "/usr/lib/zope/lib/python/Products/ZMySQLDA/db.py", line 330, in query
db.query(qs)
OperationalError: (1054, "Unknown column 'processing_date' in 'where clause'")
"""


The reason was that Jean-Paul changed table "message" structure, then my table
was not up to date. When a table structure change is made, SQL tables which
have been already created must be updated by hand. It is a thing to check
when erp5 seems broken.


The methods to create activity tables (after drop) are stored in ZODB at the
following url :
http://localhost:9080/erp5/portal_skins/activity/


Guillaume