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-18.104.22.168-py2.7.egg/ecm/apps/scheduler/models.py", line 112, in run func(**args) File "/usr/local/lib/python2.7/dist-packages/ecm-22.214.171.124-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-126.96.36.199-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-188.8.131.52-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`))')
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
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)