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

ESM minor bug error #2

Closed aurelient closed 10 years ago

aurelient commented 10 years ago

Not breaking anything but this error comes up when calling the experience sampling window :

Jul 17 18:13:15 aureliens-mbp.lan selfspy[53600] : 2014-07-17 18:13:15.677 selfspy[53600:507] Taking Experience Screenshot Jul 17 18:13:15 aureliens-mbp.lan selfspy[53600] : screencapture -x -C ~/.selfspy/screenshots/140717-181315677951-experience.jpg Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 2014-07-17 18:13:16.206 selfspy[53600:507] An uncaught exception was raised Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 2014-07-17 18:13:16.206 selfspy[53600: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:13:16 aureliens-mbp.lan selfspy[53600] : 2014-07-17 18:13:16.209 selfspy[53600:507](Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 0 CoreFoundation 0x00007fff957ad25c exceptionPreprocess + 172 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 1 libobjc.A.dylib 0x00007fff93753e75 objc_exception_throw + 43 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 2 CoreFoundation 0x00007fff957ace09 -[NSException raise] + 9 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 3 _objc.so 0x0000000103a20c61 PyObjCErr_ToObjCWithGILState + 46 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 4 _objc.so 0x0000000103a0e0b5 PyObjCFFI_MakeClosure + 5008 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 5 _objc.so 0x0000000103a0256f ffi_closure_unix64_inner + 509 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 6 _objc.so 0x0000000103a01c36 ffi_closure_unix64 + 70 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 7 AppKit 0x00007fff926d61c8 -[NSMenuItem _corePerformAction] + 394 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 8 AppKit 0x00007fff926d5f04 -[NSCarbonMenuImpl performActionWithHighlightingForItemAtIndex:] + 117 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 9 AppKit 0x00007fff9272540d -[NSMenu _internalPerformActionForItemAtIndex:] + 35 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 10 AppKit 0x00007fff92725289 -[NSCarbonMenuImpl _carbonCommandProcessEvent:handlerCallRef:] + 104 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 11 AppKit 0x00007fff926cbff6 NSSLMMenuEventHandler + 716 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 12 HIToolbox 0x00007fff940681d4 _ZL23DispatchEventToHandlersP14EventTargetRecP14OpaqueEventRefP14HandlerCallRec + 892 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 13 HIToolbox 0x00007fff94067787 _ZL30SendEventToEventTargetInternalP14OpaqueEventRefP20OpaqueEventTargetRefP14HandlerCallRec + 385 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 14 HIToolbox 0x00007fff9407b880 SendEventToEventTarget + 40 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 15 HIToolbox 0x00007fff940b1640 _ZL18SendHICommandEventjPK9HICommandjjhPKvP20OpaqueEventTargetRefS5_PP14OpaqueEventRef + 420 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 16 HIToolbox 0x00007fff940e4228 SendMenuCommandWithContextAndModifiers + 59 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 17 HIToolbox 0x00007fff940e41d0 SendMenuItemSelectedEvent + 178 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 18 HIToolbox 0x00007fff940e40af ZL19FinishMenuSelectionP13SelectionDataP10MenuResultS2 + 94 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 19 HIToolbox 0x00007fff940c219e _ZL19PopUpMenuSelectCoreP8MenuData5PointdS1_tjPK4RecttjS4_S4_PK10CFStringPP13OpaqueMenuRefPt + 1726 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 20 HIToolbox 0x00007fff940c12f6 _HandlePopUpMenuSelection7 + 596 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 21 AppKit 0x00007fff92724161 _NSSLMPopUpCarbonMenu3 + 4153 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 22 AppKit 0x00007fff92723116 _NSPopUpCarbonMenu3 + 39 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 23 AppKit 0x00007fff92722dd6 -[NSCarbonMenuImpl popUpMenu:atLocation:width:forView:withSelectedItem:withFont:withFlags:withOptions:] + 350 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 24 AppKit 0x00007fff92b14729 +[NSStatusBarButtonCell popupStatusBarMenu:inRect:ofView:withEvent:] + 699 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 25 AppKit 0x00007fff927e1b60 -[NSStatusBarButtonCell trackMouse:inRect:ofView:untilMouseUp:] + 153 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 26 AppKit 0x00007fff9272013d -[NSControl mouseDown:] + 706 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 27 AppKit 0x00007fff926a1a58 -[NSWindow sendEvent:] + 11296 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 28 AppKit 0x00007fff9279d11b -[NSStatusBarWindow sendEvent:] + 247 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 29 AppKit 0x00007fff926405d4 -[NSApplication sendEvent:] + 2021 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 30 AppKit 0x00007fff924909f9 -[NSApplication run] + 646 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 31 _objc.so 0x0000000103a01ab7 ffi_call_unix64 + 79 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] : 32 ??? 0x00000001004b4e70 0x0 + 4299902576 Jul 17 18:13:16 aureliens-mbp.lan selfspy[53600] :) Jul 17 18:13:21 aureliens-mbp.lan selfspy[53600] : took 720px image in 0.086 seconds Jul 17 18:13:22 aureliens-mbp.lan selfspy[53600] : took 720px image in 0.059 seconds

aurelient commented 10 years ago

Yep so looking at my database, I'm missing the experience.screenshot column. I've added it manually.

aurelient commented 10 years ago

The error is still around, I'll drop the table to see if creating a fresh one fixes the bug.

Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] : 2014-07-17 18:34:15.662 selfspy[54072: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:34:15 aureliens-mbp.lan selfspy[54072] : 2014-07-17 18:34:15.664 selfspy[54072:507](Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] : 0 CoreFoundation 0x00007fff957ad25c exceptionPreprocess + 172 Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] : 1 libobjc.A.dylib 0x00007fff93753e75 objc_exception_throw + 43 Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] : 2 CoreFoundation 0x00007fff957ace09 -[NSException raise] + 9 Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] : 3 _objc.so 0x0000000103a20c61 PyObjCErr_ToObjCWithGILState + 46 Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] : 4 _objc.so 0x0000000103a285f0 PyObjCPointer_New + 25606 Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] : 5 CoreFoundation 0x00007fff9570b044 __forwarding + 452 Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] : 6 CoreFoundation 0x00007fff9570adf8 _CF_forwarding_prep_0 + 120 Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] : 7 Foundation 0x00007fff95e870f4 NSFireTimer + 96 Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] : 8 CoreFoundation 0x00007fff957143e4 CFRUNLOOP_IS_CALLING_OUT_TO_A_TIMER_CALLBACK_FUNCTION + 20 Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] : 9 CoreFoundation 0x00007fff95713f1f CFRunLoopDoTimer + 1151 Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] : 10 CoreFoundation 0x00007fff957855aa CFRunLoopDoTimers + 298 Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] : 11 CoreFoundation 0x00007fff956cf6a5 CFRunLoopRun + 1525 Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] : 12 CoreFoundation 0x00007fff956cee75 CFRunLoopRunSpecific + 309 Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] : 13 HIToolbox 0x00007fff9408ea0d RunCurrentEventLoopInMode + 226 Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] : 14 HIToolbox 0x00007fff9408e7b7 ReceiveNextEventCommon + 479 Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] : 15 HIToolbox 0x00007fff9408e5bc _BlockUntilNextEventMatchingListInModeWithFilter + 65 Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] : 16 AppKit 0x00007fff9249d24e _DPSNextEvent + 1434 Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] : 17 AppKit 0x00007fff9249c89b -[NSApplication nextEventMatchingMask:untilDate:inMode:dequeue:] + 122 Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] : 18 AppKit 0x00007fff9249099c -[NSApplication run] + 553 Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] : 19 _objc.so 0x0000000103a01ab7 ffi_call_unix64 + 79 Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] : 20 ??? 0x000000010676cab0 0x0 + 4403415728 Jul 17 18:34:15 aureliens-mbp.lan selfspy[54072] :)

aurelient commented 10 years ago

Ok, now it works. Only this warning left:

: /Users/aurelien/Documents/workspace/selfspy/dist/selfspy.app/Contents/Resources/lib/python2.7/site-packages.zip/sqlalchemy/engine/default.py:461: SAWarning: Unicode type received non-unicode bind param value.