René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Error when accessing schema that already has ~log table but you don't have access to","articleBody":"```python\r\nnatexp = dj.create_virtual_module('scadena_natimexperiment', 'scadena_natimexperiment')\r\n```\r\n\r\n\r\n    ---------------------------------------------------------------------------\r\n\r\n    OperationalError                          Traceback (most recent call last)\r\n\r\n    /usr/local/lib/python3.5/dist-packages/datajoint/base_relation.py in insert(self, rows, replace, ignore_errors, skip_duplicates, ignore_extra_fields)\r\n        262                         placeholders=','.join('(' + ','.join(row['placeholders']) + ')' for row in rows)),\r\n    --\u003e 263                     args=list(itertools.chain.from_iterable((v for v in r['values'] if v is not None) for r in rows)))\r\n        264             except pymysql.err.OperationalError as err:\r\n\r\n\r\n    /usr/local/lib/python3.5/dist-packages/datajoint/connection.py in query(self, query, args, as_dict)\r\n        124                 warnings.simplefilter(\"ignore\")\r\n    --\u003e 125                 cur.execute(query, args)\r\n        126         except err.OperationalError as e:\r\n\r\n\r\n    /usr/local/lib/python3.5/dist-packages/pymysql/cursors.py in execute(self, query, args)\r\n        165 \r\n    --\u003e 166         result = self._query(query)\r\n        167         self._executed = query\r\n\r\n\r\n    /usr/local/lib/python3.5/dist-packages/pymysql/cursors.py in _query(self, q)\r\n        321         self._last_executed = q\r\n    --\u003e 322         conn.query(q)\r\n        323         self._do_get_result()\r\n\r\n\r\n    /usr/local/lib/python3.5/dist-packages/pymysql/connections.py in query(self, sql, unbuffered)\r\n        855         self._execute_command(COMMAND.COM_QUERY, sql)\r\n    --\u003e 856         self._affected_rows = self._read_query_result(unbuffered=unbuffered)\r\n        857         return self._affected_rows\r\n\r\n\r\n    /usr/local/lib/python3.5/dist-packages/pymysql/connections.py in _read_query_result(self, unbuffered)\r\n       1056             result = MySQLResult(self)\r\n    -\u003e 1057             result.read()\r\n       1058         self._result = result\r\n\r\n\r\n    /usr/local/lib/python3.5/dist-packages/pymysql/connections.py in read(self)\r\n       1339         try:\r\n    -\u003e 1340             first_packet = self.connection._read_packet()\r\n       1341 \r\n\r\n\r\n    /usr/local/lib/python3.5/dist-packages/pymysql/connections.py in _read_packet(self, packet_type)\r\n       1013         packet = packet_type(buff, self.encoding)\r\n    -\u003e 1014         packet.check_error()\r\n       1015         return packet\r\n\r\n\r\n    /usr/local/lib/python3.5/dist-packages/pymysql/connections.py in check_error(self)\r\n        392             if DEBUG: print(\"errno =\", errno)\r\n    --\u003e 393             err.raise_mysql_exception(self._data)\r\n        394 \r\n\r\n\r\n    /usr/local/lib/python3.5/dist-packages/pymysql/err.py in raise_mysql_exception(data)\r\n        106     errorclass = error_map.get(errno, InternalError)\r\n    --\u003e 107     raise errorclass(errno, errval)\r\n    \r\n\r\n    OperationalError: (1142, \"INSERT command denied to user 'ewang'@'10.21.17.251' for table '~log'\")\r\n\r\n    \r\n    During handling of the above exception, another exception occurred:\r\n\r\n\r\n    DataJointError                            Traceback (most recent call last)\r\n\r\n    \u003cipython-input-3-ad23ec27eb78\u003e in \u003cmodule\u003e()\r\n          4 detect = dj.create_virtual_module('detect', 'detect')\r\n          5 sort = dj.create_virtual_module('sort', 'sort')\r\n    ----\u003e 6 natexp = dj.create_virtual_module('scadena_natimexperiment', 'scadena_natimexperiment')\r\n          7 natimg = dj.create_virtual_module('scadena_synth_naturalimages', 'scadena_synth_naturalimages')\r\n\r\n\r\n    /usr/local/lib/python3.5/dist-packages/datajoint/__init__.py in create_virtual_module(modulename, dbname)\r\n         84     \"\"\"\r\n         85     mod = ModuleType(modulename)\r\n    ---\u003e 86     s = schema(dbname, mod.__dict__)\r\n         87     s.spawn_missing_classes()\r\n         88     mod.__dict__['schema'] = s\r\n\r\n\r\n    /usr/local/lib/python3.5/dist-packages/datajoint/schema.py in __init__(self, database, context, connection, create_tables)\r\n         71                 else:\r\n         72                     self.log('created')\r\n    ---\u003e 73         self.log('connect')\r\n         74         connection.register(self)\r\n         75 \r\n\r\n\r\n    /usr/local/lib/python3.5/dist-packages/datajoint/base_relation.py in __call__(self, event)\r\n        581                 version=version + 'py',\r\n        582                 host=platform.uname().node,\r\n    --\u003e 583                 event=event), ignore_errors=True, ignore_extra_fields=True)\r\n        584         except pymysql.err.OperationalError:\r\n        585             logger.info('could not log event in table ~log')\r\n\r\n\r\n    /usr/local/lib/python3.5/dist-packages/datajoint/base_relation.py in insert1(self, row, **kwargs)\r\n        123         For kwargs, see insert()\r\n        124         \"\"\"\r\n    --\u003e 125         self.insert((row,), **kwargs)\r\n        126 \r\n        127     def insert(self, rows, replace=False, ignore_errors=False, skip_duplicates=False, ignore_extra_fields=False):\r\n\r\n\r\n    /usr/local/lib/python3.5/dist-packages/datajoint/base_relation.py in insert(self, rows, replace, ignore_errors, skip_duplicates, ignore_extra_fields)\r\n        264             except pymysql.err.OperationalError as err:\r\n        265                 if err.args[0] == server_error_codes['command denied']:\r\n    --\u003e 266                     raise DataJointError('Command denied:  %s' % err.args[1])\r\n        267                 else:\r\n        268                     raise\r\n\r\n\r\n    DataJointError: Command denied:  INSERT command denied to user 'ewang'@'10.21.17.251' for table '~log'\r\n\r\n","author":{"url":"https://github.com/mudphudwang","@type":"Person","name":"mudphudwang"},"datePublished":"2017-10-21T22:00:50.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":7},"url":"https://github.com/379/datajoint-python/issues/379"}