New Issue

Added by williamr 10 months ago

Hi again. I'm getting a new issue today. Corp members will not update now. Here is the ecm.log:

2012-07-24 23:47:35,478 [INFO ] ecm.apps.hr.tasks.members.tracking - fetching /corp/MemberTracking.xml.aspx...
2012-07-24 23:47:36,131 [INFO ] ecm.apps.hr.tasks.members.tracking - 15 members parsed, 0 changes since last scan
2012-07-24 23:47:36,225 [INFO ] ecm.apps.hr.tasks.members.security - fetching /corp/MemberSecurity.xml.aspx...
2012-07-24 23:47:36,984 [ERROR] ecm.apps.scheduler.models - Traceback (most recent call last):
  File "/usr/local/lib/python2.7/dist-packages/ecm-2.0.5.1-py2.7.egg/ecm/apps/scheduler/models.py", line 112, in run
    func(**args)
  File "/usr/local/lib/python2.7/dist-packages/ecm-2.0.5.1-py2.7.egg/ecm/apps/hr/tasks/members/__init__.py", line 25, in update
    security.update()
  File "/usr/local/lib/python2.7/dist-packages/Django-1.4-py2.7.egg/django/db/transaction.py", line 209, in inner
    return func(*args, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/ecm-2.0.5.1-py2.7.egg/ecm/apps/hr/tasks/members/security.py", line 83, in update
    titleDiffs = storeTitles(oldTitles, newTitles, currentTime)
  File "/usr/local/lib/python2.7/dist-packages/ecm-2.0.5.1-py2.7.egg/ecm/apps/hr/tasks/members/security.py", line 210, in storeTitles
    for tm in newTitles.values(): tm.save()
  File "/usr/local/lib/python2.7/dist-packages/Django-1.4-py2.7.egg/django/db/models/base.py", line 463, in save
    self.save_base(using=using, force_insert=force_insert, force_update=force_update)
  File "/usr/local/lib/python2.7/dist-packages/Django-1.4-py2.7.egg/django/db/models/base.py", line 551, in save_base
    result = manager._insert([self], fields=fields, return_id=update_pk, using=using, raw=raw)
  File "/usr/local/lib/python2.7/dist-packages/Django-1.4-py2.7.egg/django/db/models/manager.py", line 203, in _insert
    return insert_query(self.model, objs, fields, **kwargs)
  File "/usr/local/lib/python2.7/dist-packages/Django-1.4-py2.7.egg/django/db/models/query.py", line 1576, in insert_query
    return query.get_compiler(using=using).execute_sql(return_id)
  File "/usr/local/lib/python2.7/dist-packages/Django-1.4-py2.7.egg/django/db/models/sql/compiler.py", line 910, in execute_sql
    cursor.execute(sql, params)
  File "/usr/local/lib/python2.7/dist-packages/Django-1.4-py2.7.egg/django/db/backends/mysql/base.py", line 114, in execute
    return self.cursor.execute(query, args)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py", line 174, in execute
    self.errorhandler(self, exc, value)
  File "/usr/lib/python2.7/dist-packages/MySQLdb/connections.py", line 36, in defaulterrorhandler
    raise errorclass, errorvalue
IntegrityError: (1452, 'Cannot add or update a child row: a foreign key constraint fails (`ecm`.`hr_titlemembership`, CONSTRAINT `member_id_refs_characterID_7cbc609add174a2a` FOREIGN KEY (`member_id`) REFERENCES `hr_member` (`characterID`))')

Replies (2)

RE: New Issue - Added by williamr 10 months ago

After a little more research, found that this was related to Bug #206. Seems now to have worked itself out after about 6 hours.

RE: New Issue - Added by diabeteman 10 months ago

Hello William

yeah, I coded the parser presuming that :ccp: would keep their data consistent. Which apparently, is not the case :D

I replied on the issue but for now, when facing this problem, the best to do is wait for :ccp: to put their things together (takes a few hours at most)

(1-2/2)