This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-17. For the latest, interactive version please visit https://mariadb.com/kb/.

Python Error unhandled SystemError on execution of a SQL statement

(latest mariadb connector, Python 3.6.8, MariaDB-Server 10.3)

This is the error:

Ausnahme "unhandled SystemError"

<built-in method fetchall of mariadb.connection.cursor object at 0x000001B6066C5808> returned a result with an error set Datei: D:\PythonApps\Finanz\Finanz_SQL.py, Zeile: 98

It is caused when executing this SQL Statement after a couple of other statements in the program run are executed without problems (Note: I had to reinstall Windows 10 and set up all new. But this program ran without any problems in my old environment. Also I can run this statement in HeidiSQL sucessfully):

def readAktiveAnlagenByTypes(conn, data): cur = conn.cursor() cur.execute("SELECT anlagestamm.AnlageNo, anlagestamm.Anlagebetrag, institute.InstName, " "anlagestamm.StartDat " "FROM anlagestamm INNER JOIN institute ON anlagestamm.InstitutNo = institute.InstNo " "WHERE anlagestamm.AStatus = 1 AND anlagestamm.TypNo = ? AND anlagestamm.UnterTypNo = ? " "ORDER BY anlagestamm.TypNo, anlagestamm.UnterTypNo, institute.InstName", data) result = cur.fetchall() return result

I have not idea what could be wrong. If a mistake in the statement, I would have received another error.

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.