{"action":"closed","issue":{"url":"https://api.github.com/repos/seiferta/eMonitor/issues/41","repository_url":"https://api.github.com/repos/seiferta/eMonitor","labels_url":"https://api.github.com/repos/seiferta/eMonitor/issues/41/labels{/name}","comments_url":"https://api.github.com/repos/seiferta/eMonitor/issues/41/comments","events_url":"https://api.github.com/repos/seiferta/eMonitor/issues/41/events","html_url":"https://github.com/seiferta/eMonitor/issues/41","id":162344560,"number":41,"title":"Table emonitor.messages doesn't exist","user":{"login":"tobiby","id":7619632,"avatar_url":"https://avatars.githubusercontent.com/u/7619632?v=3","gravatar_id":"","url":"https://api.github.com/users/tobiby","html_url":"https://github.com/tobiby","followers_url":"https://api.github.com/users/tobiby/followers","following_url":"https://api.github.com/users/tobiby/following{/other_user}","gists_url":"https://api.github.com/users/tobiby/gists{/gist_id}","starred_url":"https://api.github.com/users/tobiby/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/tobiby/subscriptions","organizations_url":"https://api.github.com/users/tobiby/orgs","repos_url":"https://api.github.com/users/tobiby/repos","events_url":"https://api.github.com/users/tobiby/events{/privacy}","received_events_url":"https://api.github.com/users/tobiby/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":0,"created_at":"2016-06-26T20:05:31Z","updated_at":"2016-06-26T20:31:41Z","closed_at":"2016-06-26T20:31:41Z","body":"Nach dem ersten Start des Emonitor unter 32bit Linux mit mysql erhalte ich folgende Fehlermeldung:\r\n`ERROR:emonitor.communication:error telegram\r\nINFO:emonitor.communication:2 Communicator(s) loaded: telegram, mail\r\nINFO:emonitor.observer:observe folder ./data/income/ with watchdog observer\r\nTraceback (most recent call last):\r\n  File \"run.py\", line 5, in <module>\r\n    from emonitor import app\r\n  File \"/home/tobiby/eMonitor/emonitor/__init__.py\", line 8, in <module>\r\n    app = create_app()\r\n  File \"/home/tobiby/eMonitor/emonitor/app.py\", line 84, in create_app\r\n    configure_blueprints(app, DEFAULT_BLUEPRINTS)\r\n  File \"/home/tobiby/eMonitor/emonitor/app.py\", line 225, in configure_blueprints\r\n    blueprint.init_app(app)\r\n  File \"/home/tobiby/eMonitor/emonitor/modules/__init__.py\", line 82, in init_app\r\n    m = eval('m.%sModule' % str(name).title())(app)\r\n  File \"/home/tobiby/eMonitor/emonitor/modules/messages/__init__.py\", line 51, in __init__\r\n    Messages.initMessageTrigger()\r\n  File \"/home/tobiby/eMonitor/emonitor/modules/messages/messages.py\", line 182, in initMessageTrigger\r\n    job = scheduler.add_job(Messages.doMessageTrigger, name=\"messages\", id=\"messages\", trigger=MessageTrigger(Messages.getActiveMessages(), minutes=60))\r\n  File \"/home/tobiby/eMonitor/emonitor/modules/messages/messages.py\", line 175, in getActiveMessages\r\n    return Messages.query.filter(Messages.state > 0).filter(Messages.startdate <= datetime.datetime.now()).filter(Messages.enddate >= datetime.datetime.now()).order_by(Messages.startdate.asc()).all()\r\n  File \"/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/orm/query.py\", line 2398, in all\r\n    return list(self)\r\n  File \"/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/orm/query.py\", line 2515, in __iter__\r\n    return self._execute_and_instances(context)\r\n  File \"/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/orm/query.py\", line 2530, in _execute_and_instances\r\n    result = conn.execute(querycontext.statement, self._params)\r\n  File \"/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/engine/base.py\", line 914, in execute\r\n    return meth(self, multiparams, params)\r\n  File \"/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/sql/elements.py\", line 323, in _execute_on_connection\r\n    return connection._execute_clauseelement(self, multiparams, params)\r\n  File \"/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/engine/base.py\", line 1010, in _execute_clauseelement\r\n    compiled_sql, distilled_params\r\n  File \"/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/engine/base.py\", line 1146, in _execute_context\r\n    context)\r\n  File \"/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/engine/base.py\", line 1332, in _handle_dbapi_exception\r\n    exc_info\r\n  File \"/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/util/compat.py\", line 199, in raise_from_cause\r\n    reraise(type(exception), exception, tb=exc_tb)\r\n  File \"/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/engine/base.py\", line 1139, in _execute_context\r\n    context)\r\n  File \"/home/tobiby/.local/lib/python2.7/site-packages/sqlalchemy/engine/default.py\", line 442, in do_execute\r\n    cursor.execute(statement, parameters)\r\n  File \"/usr/lib/python2.7/dist-packages/MySQLdb/cursors.py\", line 226, in execute\r\n    self.errorhandler(self, exc, value)\r\n  File \"/usr/lib/python2.7/dist-packages/MySQLdb/connections.py\", line 36, in defaulterrorhandler\r\n    raise errorvalue\r\nsqlalchemy.exc.ProgrammingError: (_mysql_exceptions.ProgrammingError) (1146, \"Table 'emonitor.messages' doesn't exist\") [SQL: u'SELECT messages.monitors AS messages_monitors, messages.type AS messages_type, messages.attributes AS messages_attributes, messages.id AS messages_id, messages.name AS messages_name, messages.remark AS messages_remark, messages.startdate AS messages_startdate, messages.enddate AS messages_enddate, messages.state AS messages_state \\nFROM messages \\nWHERE messages.state > %s AND messages.startdate <= %s AND messages.enddate >= %s ORDER BY messages.startdate ASC'] [parameters: (0, datetime.datetime(2016, 6, 26, 21, 53, 41, 987084), datetime.datetime(2016, 6, 26, 21, 53, 41, 987182))]\r\n`\r\nNachdem ich die Tabelle manuell erzeugt habe funktioniert der Emonitor einwandfrei.\r\n"}}
{"actor":{"display_login":"seiferta"}}