rick
/
admidio_python_api
3
0
Fork 0
Code Issues 1 Pull Requests 0 Releases 0 Wiki Activity
Labels Milestones
New Issue

#3 Events that cannot be attended break the API

Closed
opened 5 years ago by d.potter · 0 comments
d.potter commented 5 years ago
Collaborator

As soon as calendar entries without the possibility to attend are added, the API breaks. See error log:

  File "<..>/code/plugable-matrix-bot/plugins/admidio_events/admidio_python_api/admidio.py", line 39, in __init__                                                                                      
    self.initEvents()
  File "<..>/code/plugable-matrix-bot/plugins/admidio_events/admidio_python_api/admidio.py", line 97, in initEvents                                                                                    
    row[6], row[7], self)
  File "<..>/code/plugable-matrix-bot/plugins/admidio_events/admidio_python_api/event.py", line 25, in __init__                                                                                        
    self.__c.execute(sql)
  File "<..>/code/plugable-matrix-bot/lib/python3.7/site-packages/MySQLdb/cursors.py", line 198, in execute                                                                                            
    res = self._query(query)
  File "<..>/code/plugable-matrix-bot/lib/python3.7/site-packages/MySQLdb/cursors.py", line 304, in _query                                                                                             
    db.query(q)
  File "<..>/code/plugable-matrix-bot/lib/python3.7/site-packages/MySQLdb/connections.py", line 217, in query                                                                                          
    _mysql.connection.query(self, query)
MySQLdb._exceptions.OperationalError: (1054, "Unknown column 'None' in 'where clause'")
As soon as calendar entries without the possibility to attend are added, the API breaks. See error log: ``` File "<..>/code/plugable-matrix-bot/plugins/admidio_events/admidio_python_api/admidio.py", line 39, in __init__ self.initEvents() File "<..>/code/plugable-matrix-bot/plugins/admidio_events/admidio_python_api/admidio.py", line 97, in initEvents row[6], row[7], self) File "<..>/code/plugable-matrix-bot/plugins/admidio_events/admidio_python_api/event.py", line 25, in __init__ self.__c.execute(sql) File "<..>/code/plugable-matrix-bot/lib/python3.7/site-packages/MySQLdb/cursors.py", line 198, in execute res = self._query(query) File "<..>/code/plugable-matrix-bot/lib/python3.7/site-packages/MySQLdb/cursors.py", line 304, in _query db.query(q) File "<..>/code/plugable-matrix-bot/lib/python3.7/site-packages/MySQLdb/connections.py", line 217, in query _mysql.connection.query(self, query) MySQLdb._exceptions.OperationalError: (1054, "Unknown column 'None' in 'where clause'") ```
rick was assigned by d.potter 5 years ago
rick referenced this issue from a commit 5 years ago
Checks if rol id exists. Fixes #3
rick closed this issue 5 years ago
Sign in to join this conversation.
No Branch/Tag Specified
Branches Tags
master
Labels
Apply labels
Clear labels
No items
No Label
Milestone
Set milestone
Clear milestone
No items
No Milestone
Assignees
Assign users
Clear assignees
No Assignees
 rick
1 Participants
Notifications
Due Date

No due date set.

Dependencies

This issue currently doesn't have any dependencies.

Write Preview
Loading…
Cancel
Save
There is no content yet.
Delete Branch '%!s(MISSING)'

Deleting a branch is permanent. It CANNOT be undone. Continue?

No
Yes