v1.2.0 can't INSERT to MySQL 4.1

[igol]

Hello,

I have 3 Linux servers as follows :

Server 1 : Python 2.3.3 / MySQLdb 1.0.1-final
Server 2 : Python 2.3.5 / MySQLdb 1.2.0-final

Server 1 can INSERT, UPDATE, and SELECT to MySQL 4.1

Server 2 can only do SELECT's. INSERT's and UPDATE's don't work.

The following is the code they both execute :

=================================

import MySQLdb

conn = MySQLdb.connect (host = 'mis', user = 'agu', passwd = 'agu', db = 'springerTracking')
my_cur = conn.cursor()

sSQL2 = "INSERT INTO springerTracking.tblArticle_copy (articleID, stage, journalID, aID) VALUES " + \ "('test3', 'test2', 'test3', 'test4')"

print sSQL2
numResult2 = my_cur.execute(sSQL2)
print numResult2

================================

Any idea what could be wrong here ?

[Andy Dustman]

https://sourceforge.net/forum/forum.php?thread_id=1329039&forum_id=70461

https://sourceforge.net/forum/forum.php?thread_id=1317540&forum_id=70461

https://sourceforge.net/forum/forum.php?thread_id=1301137&forum_id=70461

Getting tired of answering questions which have been answered at least three times already.