[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