René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Preview Error","articleBody":"Hi, \r\n\r\nI'm running DataJoint with Python3 on Windows with a locally hosted server. \r\nI reliably get an error when trying to inspect the content of a class:\r\n\r\nExample class definition:\r\n\r\n```\r\n@schema\r\nclass BehaviourRecording(dj.Manual):\r\n     definition = \"\"\"\r\n     # Individual recordings within a session\r\n     -\u003e Session\r\n     recording_number: int               # recording number within a session\r\n     ---\r\n     metadata_path : varchar(128)       # name of the experimenter\r\n     video_path : varchar(128)       # name of the experimenter\r\n     tracked : enum('Y', 'N')   # asdas\r\n     dlc_data: varchar(128)      # path to .h5 produced as a result of dlc tracking\r\n     \"\"\"\r\n```\r\n\r\n\r\nExample error:\r\n```\r\nrecordings = BehaviourRecording()\r\nrecordings.preview()\r\nTraceback (most recent call last):\r\n  File \"C:\\Users\\Federico\\Miniconda3\\envs\\CVenv\\lib\\site-packages\\IPython\\core\\interactiveshell.py\", line 3265, in run_code\r\n    exec(code_obj, self.user_global_ns, self.user_ns)\r\n  File \"\u003cipython-input-10-5ee312724859\u003e\", line 1, in \u003cmodule\u003e\r\n    recordings.preview()\r\n  File \"C:\\Users\\Federico\\Miniconda3\\envs\\CVenv\\lib\\site-packages\\datajoint\\relational_operand.py\", line 362, in preview\r\n    tuples = rel.fetch(limit=limit+1)\r\n  File \"C:\\Users\\Federico\\Miniconda3\\envs\\CVenv\\lib\\site-packages\\datajoint\\fetch.py\", line 59, in __call__\r\n    cur = self._relation.cursor(as_dict=as_dict, limit=limit, offset=offset, order_by=order_by)\r\n  File \"C:\\Users\\Federico\\Miniconda3\\envs\\CVenv\\lib\\site-packages\\datajoint\\relational_operand.py\", line 530, in cursor\r\n    return self.connection.query(sql, as_dict=as_dict)\r\n  File \"C:\\Users\\Federico\\Miniconda3\\envs\\CVenv\\lib\\site-packages\\datajoint\\connection.py\", line 136, in query\r\n    cur.execute(query, args)\r\n  File \"C:\\Users\\Federico\\Miniconda3\\envs\\CVenv\\lib\\site-packages\\pymysql\\cursors.py\", line 170, in execute\r\n    result = self._query(query)\r\n  File \"C:\\Users\\Federico\\Miniconda3\\envs\\CVenv\\lib\\site-packages\\pymysql\\cursors.py\", line 328, in _query\r\n    conn.query(q)\r\n  File \"C:\\Users\\Federico\\Miniconda3\\envs\\CVenv\\lib\\site-packages\\pymysql\\connections.py\", line 515, in query\r\n    self._execute_command(COMMAND.COM_QUERY, sql)\r\n  File \"C:\\Users\\Federico\\Miniconda3\\envs\\CVenv\\lib\\site-packages\\pymysql\\connections.py\", line 745, in _execute_command\r\n    raise err.InterfaceError(\"(0, '')\")\r\npymysql.err.InterfaceError: (0, '')\r\n```\r\n\r\n\r\nAny idea how to solve this? I can work around it using fetch, but it makes things more complicated.\r\n\r\nThank you!","author":{"url":"https://github.com/FedeClaudi","@type":"Person","name":"FedeClaudi"},"datePublished":"2018-11-01T19:43:28.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":19},"url":"https://github.com/515/datajoint-python/issues/515"}