Skip to content

Preview Error #515

Description

@FedeClaudi

Hi,

I'm running DataJoint with Python3 on Windows with a locally hosted server.
I reliably get an error when trying to inspect the content of a class:

Example class definition:

@schema
class BehaviourRecording(dj.Manual):
     definition = """
     # Individual recordings within a session
     -> Session
     recording_number: int               # recording number within a session
     ---
     metadata_path : varchar(128)       # name of the experimenter
     video_path : varchar(128)       # name of the experimenter
     tracked : enum('Y', 'N')   # asdas
     dlc_data: varchar(128)      # path to .h5 produced as a result of dlc tracking
     """

Example error:

recordings = BehaviourRecording()
recordings.preview()
Traceback (most recent call last):
  File "C:\Users\Federico\Miniconda3\envs\CVenv\lib\site-packages\IPython\core\interactiveshell.py", line 3265, in run_code
    exec(code_obj, self.user_global_ns, self.user_ns)
  File "<ipython-input-10-5ee312724859>", line 1, in <module>
    recordings.preview()
  File "C:\Users\Federico\Miniconda3\envs\CVenv\lib\site-packages\datajoint\relational_operand.py", line 362, in preview
    tuples = rel.fetch(limit=limit+1)
  File "C:\Users\Federico\Miniconda3\envs\CVenv\lib\site-packages\datajoint\fetch.py", line 59, in __call__
    cur = self._relation.cursor(as_dict=as_dict, limit=limit, offset=offset, order_by=order_by)
  File "C:\Users\Federico\Miniconda3\envs\CVenv\lib\site-packages\datajoint\relational_operand.py", line 530, in cursor
    return self.connection.query(sql, as_dict=as_dict)
  File "C:\Users\Federico\Miniconda3\envs\CVenv\lib\site-packages\datajoint\connection.py", line 136, in query
    cur.execute(query, args)
  File "C:\Users\Federico\Miniconda3\envs\CVenv\lib\site-packages\pymysql\cursors.py", line 170, in execute
    result = self._query(query)
  File "C:\Users\Federico\Miniconda3\envs\CVenv\lib\site-packages\pymysql\cursors.py", line 328, in _query
    conn.query(q)
  File "C:\Users\Federico\Miniconda3\envs\CVenv\lib\site-packages\pymysql\connections.py", line 515, in query
    self._execute_command(COMMAND.COM_QUERY, sql)
  File "C:\Users\Federico\Miniconda3\envs\CVenv\lib\site-packages\pymysql\connections.py", line 745, in _execute_command
    raise err.InterfaceError("(0, '')")
pymysql.err.InterfaceError: (0, '')

Any idea how to solve this? I can work around it using fetch, but it makes things more complicated.

Thank you!

Metadata

Metadata

Labels

No labels
No labels

Type

No type

Fields

No fields configured for issues without a type.

Projects

No projects

Milestone

No milestone

Relationships

None yet

Development

No branches or pull requests

Issue actions