Python 3 MySQL database insert error

[Larz60+]

creat a backup first
Change the dbinsert function to:

    def dbinsert(self, data_tuple):
        cmd = 'INSERT INTO GPS (signature, latitude, longitude, gpstime, gpsdata,
                         orientationNS, orientationEV, direction, speed, distance)  VALUES ('

        for n, element in enumerate(data_tuple):
            if n > 0:
                cmd = '{}, {}'.format(cmd, element)
            else:
                cmd = '{}{}'.format(cmd, element)
        cmd = '{})'.format(cmd)
        print(cmd)
        self.cursor.execute(sql)
        self.dbconnection.commit()

and try that