search

activityhistory / selfspy

Modified version of Selfspy computer activity tracker for academic study
GNU General Public License v3.0
12 stars 1 forks source link

global hotkey issue #1

Closed aurelient closed 10 years ago

aurelient commented 10 years ago

Application crashing Cmd+Shift+Enter :

Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 2014-07-17 18:10:01.056 selfspy[53355:507] Showing Experience Sampling Window on Request... Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 2014-07-17 18:10:01.056 selfspy[53355:507] Taking Experience Screenshot Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : screencapture -x -C ~/.selfspy/screenshots/140717-181001057183-experience.jpg Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 2014-07-17 18:10:01.426 selfspy[53355:507] An uncaught exception was raised Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 2014-07-17 18:10:01.426 selfspy[53355:507] <class 'sqlalchemy.exc.OperationalError'>: (OperationalError) no such column: experience.screenshot u'SELECT DISTINCT experience.id AS experience_id, experience.created_at AS experience_created_at, experience.message AS experience_message, experience.screenshot AS experience_screenshot \nFROM experience ORDER BY experience.id DESC\n LIMIT ? OFFSET ?' (5, 0) Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 2014-07-17 18:10:01.427 selfspy[53355:507](Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 0 CoreFoundation 0x00007fff957ad25c __exceptionPreprocess + 172 Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 1 libobjc.A.dylib 0x00007fff93753e75 objc_exception_throw + 43 Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 2 CoreFoundation 0x00007fff957ace09 -[NSException raise] + 9 Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 3 _objc.so 0x0000000103a20c61 PyObjCErr_ToObjCWithGILState + 46 Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 4 _objc.so 0x0000000103a0e0b5 PyObjCFFI_MakeClosure + 5008 Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 5 _objc.so 0x0000000103a0256f ffi_closure_unix64_inner + 509 Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 6 _objc.so 0x0000000103a01c36 ffi_closure_unix64 + 70 Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 7 HIToolbox 0x00007fff940681d4 _ZL23DispatchEventToHandlersP14EventTargetRecP14OpaqueEventRefP14HandlerCallRec + 892 Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 8 HIToolbox 0x00007fff94067787 _ZL30SendEventToEventTargetInternalP14OpaqueEventRefP20OpaqueEventTargetRefP14HandlerCallRec + 385 Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 9 HIToolbox 0x00007fff940675f7 SendEventToEventTargetWithOptions + 43 Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 10 HIToolbox 0x00007fff9409cf77 _ZL29ToolboxEventDispatcherHandlerP25OpaqueEventHandlerCallRefP14OpaqueEventRefPv + 1759 Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 11 HIToolbox 0x00007fff94068724 _ZL23DispatchEventToHandlersP14EventTargetRecP14OpaqueEventRefP14HandlerCallRec + 2252 Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 12 HIToolbox 0x00007fff94067787 _ZL30SendEventToEventTargetInternalP14OpaqueEventRefP20OpaqueEventTargetRefP14HandlerCallRec + 385 Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 13 HIToolbox 0x00007fff9407b880 SendEventToEventTarget + 40 Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 14 AppKit 0x00007fff9249d786 _DPSNextEvent + 2770 Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 15 AppKit 0x00007fff9249c89b -[NSApplication nextEventMatchingMask:untilDate:inMode:dequeue:] + 122 Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 16 AppKit 0x00007fff9249099c -[NSApplication run] + 553 Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 17 _objc.so 0x0000000103a01ab7 ffi_call_unix64 + 79 Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 18 ??? 0x0000000105615a50 0x0 + 4385233488 Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] :) Jul 17 18:10:01 aureliens-mbp.lan selfspy[53355] : 2014-07-17 18:10:01.437 selfspy[53355:507] Exiting Selfspy...

aurelient commented 10 years ago

Ok problem fixed by dropping the experience table and re-creating it.

acrule commented 10 years ago

Yes, I added a couple tables to the Selfspy database and added a couple columns to existing tables. You'll need to recreate the database for these revisions to work.