Re: Using unsupported buffer type: XX (parameter: XX) QMYSQL3: Unable to bind value
I have been seaching google for all day. And I could not find any result.
Code:
#!/usr/bin/env python
# -*- coding: iso-8859-9 -*-
from PyQt4 import QtCore, QtGui, QtSql
class Ui_Dialog(object):
def setupUi(self, Dialog):
Dialog.setObjectName("Dialog")
Dialog.setWindowTitle("Dialog")
Dialog.resize(640, 392)
self.verticalLayout.setObjectName("vertical_layout")
self.tableView.setObjectName("table_view")
self.verticalLayout.addWidget(self.tableView)
self.buttonBox.setOrientation(QtCore.Qt.Horizontal)
self.buttonBox.setObjectName("button_box")
self.verticalLayout.addWidget(self.buttonBox)
QtCore.
QObject.
connect(self.
buttonBox, QtCore.
SIGNAL("accepted()"), self.
test) QtCore.
QObject.
connect(self.
buttonBox, QtCore.
SIGNAL("rejected()"), self.
test)
self.open_database()
self.initializeModel(self.model)
self.tableView.setModel(self.model)
#self.tableView.setItemDelegate(QtSql.QSqlRelationalDelegate(self.tableView))
#self.tableView.hideColumn(0)
def open_database(self):
self._db.setHostName("localhost")
self._db.setUserName("root")
self._db.setPassword("123456")
self._db.setDatabaseName("my_database")
self._db.open()
def initializeModel(self, model):
model.setTable('my_table')
model.select()
#model.removeColumn(0)
model.setHeaderData(0, QtCore.Qt.Horizontal, "ID")
model.setHeaderData(1, QtCore.Qt.Horizontal, "First name")
model.setHeaderData(2, QtCore.Qt.Horizontal, "Last name")
def test(self):
ok = self.model.submitAll()
print (self.model.lastError().text())
if __name__ == "__main__":
import sys
ui = Ui_Dialog()
ui.setupUi(Dialog)
Dialog.show()
sys.exit(app.exec_())
Any help would be much appreciated.
Sorry, I have forgotten the error code
This is the output;
Using unsupported buffer type: XX (parameter: XX) QMYSQL3: Unable to bind value
Re: Using unsupported buffer type: XX (parameter: XX) QMYSQL3: Unable to bind value
It is strange. Now I have tested my code on Python 3.3 32 bit and everything works perfect.
The problem was with Python 3.2 64 bit. Both Mysql db is the same. I could not figure out the problem. Not a clue. The code is working fine now.
Re: Using unsupported buffer type: XX (parameter: XX) QMYSQL3: Unable to bind value
I have solved the problem. And I am writing in case it helps someone who faces with similar problems.
The program connects a remote database. And there is another MySQL database installed on my harddrive. I have removed the installed MySQL from my harddrive. And problem solved.