Toetsrooster

--> -->

<class 'MySQLdb._exceptions.OperationalError'>

Python 2.7.18: /usr/bin/python
Thu Aug 22 01:04:10 2024

A problem occurred in a Python script. Here is the sequence of function calls leading up to the error, in the order they occurred.

/home/hansbrinkman/contactverloren.dreamhosters.com/toetsrooster/toetsrooster.py in <module>()

296

297 try :

=> 298 main()

299 except :

300 ms.message(1, 'main error niveau 1 ', 'algemene fout')

main = <function main>

/home/hansbrinkman/contactverloren.dreamhosters.com/toetsrooster/toetsrooster.py in main(p_error='')

92 # Kijk of de inlog correct is (bv ingelogd, niet een andere sessie)

93 import trr_scherm10

=> 94 trr_scherm10.alle_schermen_login_check()

95

96 # Haal de menukeuze en formnaam

trr_scherm10 = <module 'trr_scherm10' from '/home/hansbrinkman/....dreamhosters.com/toetsrooster/trr_scherm10.pyc'>, trr_scherm10.alle_schermen_login_check = <function alle_schermen_login_check>

/home/hansbrinkman/contactverloren.dreamhosters.com/toetsrooster/trr_scherm10.py in alle_schermen_login_check()

140

141 # is de user nog correct ingelogd en nog actief?

=> 142 gbr_afkorting = mysql_data.haal_gbr_afkorting (cs.FORM_DATA.getvalue('gbr_id'))

143 if not gbr_afkorting :

144 # nee, de user is niet (meer) ingelogd of niet meer actief(!)

gbr_afkorting undefined, global mysql_data = <module 'mysql_data' from '/home/hansbrinkman/co...en.dreamhosters.com/toetsrooster/mysql_data.pyc'>, mysql_data.haal_gbr_afkorting = <function haal_gbr_afkorting>, global cs = <module 'trr_constants' from '/home/hansbrinkman...dreamhosters.com/toetsrooster/trr_constants.pyc'>, cs.FORM_DATA = FieldStorage(None, None, [MiniFieldStorage('jaarlaag', '2'), MiniFieldStorage('periode', '1')]), cs.FORM_DATA.getvalue = <bound method FieldStorage.getvalue of FieldStor...rlaag', '2'), MiniFieldStorage('periode', '1')])>

/home/hansbrinkman/contactverloren.dreamhosters.com/toetsrooster/mysql_data.py in haal_gbr_afkorting(p_gbr_id=None)

625 """

626 select_sql = select_sql %(p_gbr_id)

=> 627 cursMyDict.execute(select_sql)

628 cursor_dict = cursMyDict.fetchone()

629 #print cursor_dict

global cursMyDict = <MySQLdb.cursors.DictCursor object>, cursMyDict.execute = <bound method DictCursor.execute of <MySQLdb.cursors.DictCursor object>>, select_sql = ' SELECT gbr_afkorting\n FROM trr_gebruike...ERE gbr_id = None\n AND gbr_actief = 1\n '

/home/hansbrinkman/.local/lib/python2.7/site-packages/MySQLdb/cursors.py in execute(self=<MySQLdb.cursors.DictCursor object>, query=' SELECT gbr_afkorting\n FROM trr_gebruike...ERE gbr_id = None\n AND gbr_actief = 1\n ', args=None)

207

208 assert isinstance(query, (bytes, bytearray))

=> 209 res = self._query(query)

210 return res

211

res undefined, self = <MySQLdb.cursors.DictCursor object>, self._query = <bound method DictCursor._query of <MySQLdb.cursors.DictCursor object>>, query = ' SELECT gbr_afkorting\n FROM trr_gebruike...ERE gbr_id = None\n AND gbr_actief = 1\n '

/home/hansbrinkman/.local/lib/python2.7/site-packages/MySQLdb/cursors.py in _query(self=<MySQLdb.cursors.DictCursor object>, q=' SELECT gbr_afkorting\n FROM trr_gebruike...ERE gbr_id = None\n AND gbr_actief = 1\n ')

313 db = self._get_db()

314 self._result = None

=> 315 db.query(q)

316 self._do_get_result(db)

317 self._post_get_result()

db = <_mysql.connection open to 'toetsrooster.contactverloren.dreamhosters.com'>, db.query = <bound method Connection.query of <_mysql.connec...'toetsrooster.contactverloren.dreamhosters.com'>>, q = ' SELECT gbr_afkorting\n FROM trr_gebruike...ERE gbr_id = None\n AND gbr_actief = 1\n '

/home/hansbrinkman/.local/lib/python2.7/site-packages/MySQLdb/connections.py in query(self=<_mysql.connection open to 'toetsrooster.contactverloren.dreamhosters.com'>, query=' SELECT gbr_afkorting\n FROM trr_gebruike...ERE gbr_id = None\n AND gbr_actief = 1\n ')

237 if isinstance(query, bytearray):

238 query = bytes(query)

=> 239 _mysql.connection.query(self, query)

240

241 def _bytes_literal(self, bs):

global _mysql = <module 'MySQLdb._mysql' from '/home/hansbrinkma...l/lib/python2.7/site-packages/MySQLdb/_mysql.so'>, _mysql.connection = <type '_mysql.connection'>, _mysql.connection.query = <method 'query' of '_mysql.connection' objects>, self = <_mysql.connection open to 'toetsrooster.contactverloren.dreamhosters.com'>, query = ' SELECT gbr_afkorting\n FROM trr_gebruike...ERE gbr_id = None\n AND gbr_actief = 1\n '

<class 'MySQLdb._exceptions.OperationalError'>: (1054, "Unknown column 'None' in 'where clause'")
args = (1054, "Unknown column 'None' in 'where clause'")
message = ''

/home/hansbrinkman/contactverloren.dreamhosters.com/toetsrooster/logdir/tmpuoId76.html contains the description of this error.