-
I found the issue! The transaction must be committed after executing the SQL statement.
2008-04-01 03:38:31 UTC by nobody
-
conn=pdo.connect("Module=MySQLdb;User=xx;Passwd=xx;DB=test")
ex=conn.execute("insert into test.Tests(name) values('This is a Test2')")
Issue:
execute causes auto incrementing of a private key in the database table, but no row is added to the table.
PDO version 1.3.2
Mysql: 5.0.32.
2008-03-31 07:42:18 UTC by nobody
-
This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).
2007-08-23 02:20:05 UTC by sf-robot
-
Thank you for the submission, this will be in the next point release of PDO.
2007-08-08 12:09:34 UTC by brujahpriest
-
Bug Link: http://sourceforge.net/tracker/index.php?func=detail&aid=1654768&group_id=86244&atid=578926
The patch to this problem is as follows:
After line 83 in the 'connect' code, add:
# special case of b is a 'port'
if string.lower(b[0]) == 'port':
b[1] = int(b[1])
The new code will read:
.
.
.
else:
if len(b) < 2...
2007-02-08 02:48:07 UTC by gnatty
-
Since the MySQL API requires that 'port' be an integer, and pdo doesn't do string->int conversions on its connection string parameters, overriding the MySQL port results in an error.
Steps to reproduce (in an interpretor)
> import pdo
> pdo.connect("module=MySQLdb;user=user;passwd=passwd;db=db;port=3304") # notice the non-standard port specification.
Traceback (most recent call last)...
2007-02-08 02:43:16 UTC by gnatty
-
Logged In: YES
user_id=1312539
This Tracker item was closed automatically by the system. It was
previously set to a Pending status, and the original submitter
did not respond within 14 days (the time period specified by
the administrator of this Tracker).
2006-09-28 02:20:09 UTC by sf-robot
-
For the first release in over a year we have added two user submitted patches to PDO. One patch adds Reset functionality inside the Resultset object. The other corrects a connection issue with MySQLdb "passwd" variable.
PDO is a community driven project. Ideas, comments, questions and even code is welcome. Drop by the forums or join the mailing list and give us your comments.
2006-09-13 19:15:03 UTC by brujahpriest
-
Logged In: YES
user_id=613048
Added as of PDO 1.3.2.
2006-09-13 19:11:09 UTC by brujahpriest
-
Logged In: YES
user_id=613048
This is in as of PDO 1.3.2. Thank you for the submission.
2006-09-13 19:10:17 UTC by brujahpriest
