| 2012-01-19 20:27:29 |
Alan Bell |
bug |
|
|
added bug |
| 2012-04-23 12:01:37 |
Launchpad Janitor |
pymssql (Ubuntu): status |
New |
Confirmed |
|
| 2012-05-23 07:05:55 |
Hemchand |
bug |
|
|
added subscriber Hemchand |
| 2012-06-14 09:29:04 |
Richard Ulrich |
bug |
|
|
added subscriber Richard Ulrich |
| 2012-08-08 11:26:49 |
sugree |
bug |
|
|
added subscriber sugree |
| 2012-09-24 15:46:19 |
gunny26 |
bug |
|
|
added subscriber gunny26 |
| 2013-06-20 12:53:08 |
Andy Wild |
bug |
|
|
added subscriber Andy Wild |
| 2013-08-28 11:20:08 |
Alan Bell |
bug watch added |
|
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=709210 |
|
| 2013-08-28 11:20:08 |
Alan Bell |
bug task added |
|
pymssql (Debian) |
|
| 2013-08-28 12:52:49 |
Bug Watch Updater |
pymssql (Debian): status |
Unknown |
New |
|
| 2014-03-05 18:31:14 |
Eduard Hasenleithner |
bug |
|
|
added subscriber Eduard Hasenleithner |
| 2014-07-01 14:21:42 |
Mister Tom |
bug |
|
|
added subscriber Mister Tom |
| 2016-06-05 18:42:27 |
Thomas Ward |
pymssql (Ubuntu): importance |
Undecided |
High |
|
| 2016-06-05 21:18:36 |
Thomas Ward |
summary |
returns no data from SQL server |
No data returned from MSSQL server |
|
| 2016-06-08 19:22:48 |
Thomas Ward |
nominated for series |
|
Ubuntu Yakkety |
|
| 2016-06-08 19:22:48 |
Thomas Ward |
nominated for series |
|
Ubuntu Trusty |
|
| 2016-06-08 19:22:48 |
Thomas Ward |
nominated for series |
|
Ubuntu Precise |
|
| 2016-06-08 19:22:48 |
Thomas Ward |
nominated for series |
|
Ubuntu Xenial |
|
| 2016-06-08 19:22:48 |
Thomas Ward |
nominated for series |
|
Ubuntu Wily |
|
| 2016-06-08 19:45:45 |
Thomas Ward |
description |
this works great in oneiric, but in precise it silently returns empty results from SQL server. The upstream project has relocated and provided a new release, I downloaded and built it and the same code I had started returning results.
http://code.google.com/p/pymssql/downloads/list
ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: python-pymssql 1.0.2+dfsg-1build1
ProcVersionSignature: Ubuntu 3.2.0-9.16-generic 3.2.1
Uname: Linux 3.2.0-9-generic x86_64
ApportVersion: 1.91-0ubuntu1
Architecture: amd64
Date: Thu Jan 19 20:24:31 2012
EcryptfsInUse: Yes
InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Release amd64 (20101007)
SourcePackage: pymssql
UpgradeStatus: Upgraded to precise on 2012-01-16 (2 days ago) |
[Impact]
* Due to an issue with PyMSSQL 1.0.x and the version of FreeTDX in the repositories, PyMSSQL no longer returns any information from MSSQL database queries. This means you cannot use fetchone() or fetchall() or similar methods to get data back from a database query.
[Test Case]
* Install python-pymssql to Ubuntu.
* Inside a 'python' console on the Ubuntu server, use the following python code, replacing values accordingly for your MSSQL servers. The "print" function will return 'None' in the current code base. When fixed, you will get either one value, or a tuple, depending on the results (but you will NOT get 'None'):
import pymssql
dbconn = pymssql.connect(host='FQDN_FOR_DBSERVER', user='DBUSER', password='DBPASSWORD', database='DBNAME')
dbcur = dbconn.cursor()
dbcur.execute('ANY_VALID_SQL_QUERY')
dbrs = dbcur.fetchone()
dbcur.close()
print dbrs
[Regression Potential]
* The patch in the debdiffs is from pymssql upstream. We are on a very old pymssql, but this patch was designed to fix the issue.
[Other Info]
* Test builds in https://launchpad.net/~teward/+archive/ubuntu/pymssql/+packages; these packages in that PPA are used for testing and were used to test the upstream patch.
[Original Description]
this works great in oneiric, but in precise it silently returns empty results from SQL server. The upstream project has relocated and provided a new release, I downloaded and built it and the same code I had started returning results.
http://code.google.com/p/pymssql/downloads/list
ProblemType: Bug
DistroRelease: Ubuntu 12.04
Package: python-pymssql 1.0.2+dfsg-1build1
ProcVersionSignature: Ubuntu 3.2.0-9.16-generic 3.2.1
Uname: Linux 3.2.0-9-generic x86_64
ApportVersion: 1.91-0ubuntu1
Architecture: amd64
Date: Thu Jan 19 20:24:31 2012
EcryptfsInUse: Yes
InstallationMedia: Ubuntu 10.10 "Maverick Meerkat" - Release amd64 (20101007)
SourcePackage: pymssql
UpgradeStatus: Upgraded to precise on 2012-01-16 (2 days ago) |
|
| 2016-06-08 19:45:54 |
Thomas Ward |
tags |
amd64 apport-bug precise running-unity |
amd64 apport-bug precise running-unity trusty wily xenial yakkety |
|
| 2016-06-08 20:48:58 |
C de-Avillez |
bug task added |
|
pymssql (Ubuntu Yakkety) |
|
| 2016-06-08 21:16:05 |
Thomas Ward |
attachment added |
|
Yakkety DebDiff for LP#918896 https://bugs.launchpad.net/ubuntu/+source/pymssql/+bug/918896/+attachment/4680045/+files/yakkety_debdiff_lp918896.debdiff |
|
| 2016-06-08 21:16:39 |
Thomas Ward |
bug |
|
|
added subscriber Ubuntu Sponsors Team |
| 2016-06-08 21:17:54 |
C de-Avillez |
bug task added |
|
pymssql (Ubuntu Xenial) |
|
| 2016-06-08 21:18:01 |
C de-Avillez |
bug task added |
|
pymssql (Ubuntu Wily) |
|
| 2016-06-08 21:18:14 |
C de-Avillez |
bug task added |
|
pymssql (Ubuntu Trusty) |
|
| 2016-06-08 21:18:26 |
C de-Avillez |
bug task added |
|
pymssql (Ubuntu Precise) |
|
| 2016-06-08 23:21:22 |
Thomas Ward |
attachment added |
|
Xenial DebDiff for LP#918896 https://bugs.launchpad.net/ubuntu/+source/pymssql/+bug/918896/+attachment/4680074/+files/xenial_debdiff_lp918896.debdiff |
|
| 2016-06-08 23:21:49 |
Thomas Ward |
attachment added |
|
Wily DebDiff for LP#918896 https://bugs.launchpad.net/ubuntu/+source/pymssql/+bug/918896/+attachment/4680075/+files/wily_debdiff_lp918896.debdiff |
|
| 2016-06-08 23:22:11 |
Thomas Ward |
attachment added |
|
Trusty DebDiff for LP#918896 https://bugs.launchpad.net/ubuntu/+source/pymssql/+bug/918896/+attachment/4680076/+files/trusty_debdiff_lp918896.debdiff |
|
| 2016-06-08 23:22:36 |
Thomas Ward |
attachment added |
|
Precise DebDiff for LP#918896 https://bugs.launchpad.net/ubuntu/+source/pymssql/+bug/918896/+attachment/4680077/+files/precise_debdiff_lp918896.debdiff |
|
| 2016-06-08 23:23:15 |
Thomas Ward |
pymssql (Ubuntu Precise): importance |
Undecided |
High |
|
| 2016-06-08 23:23:17 |
Thomas Ward |
pymssql (Ubuntu Trusty): importance |
Undecided |
High |
|
| 2016-06-08 23:23:19 |
Thomas Ward |
pymssql (Ubuntu Wily): importance |
Undecided |
High |
|
| 2016-06-08 23:23:21 |
Thomas Ward |
pymssql (Ubuntu Xenial): importance |
Undecided |
High |
|
| 2016-06-08 23:23:24 |
Thomas Ward |
pymssql (Ubuntu Trusty): status |
New |
Confirmed |
|
| 2016-06-08 23:23:29 |
Thomas Ward |
pymssql (Ubuntu Xenial): status |
New |
Confirmed |
|
| 2016-06-08 23:27:29 |
Thomas Ward |
pymssql (Ubuntu Precise): status |
New |
Confirmed |
|
| 2016-06-08 23:27:32 |
Thomas Ward |
pymssql (Ubuntu Wily): status |
New |
Confirmed |
|
| 2016-06-09 20:48:39 |
Bug Watch Updater |
pymssql (Debian): status |
New |
Confirmed |
|
| 2016-06-15 17:20:07 |
Thomas Ward |
attachment removed |
Precise DebDiff for LP#918896 https://bugs.launchpad.net/ubuntu/+source/pymssql/+bug/918896/+attachment/4680077/+files/precise_debdiff_lp918896.debdiff |
|
|
| 2016-06-15 17:20:13 |
Thomas Ward |
attachment removed |
Yakkety DebDiff for LP#918896 https://bugs.launchpad.net/ubuntu/+source/pymssql/+bug/918896/+attachment/4680045/+files/yakkety_debdiff_lp918896.debdiff |
|
|
| 2016-06-15 17:20:17 |
Thomas Ward |
attachment removed |
Trusty DebDiff for LP#918896 https://bugs.launchpad.net/ubuntu/+source/pymssql/+bug/918896/+attachment/4680076/+files/trusty_debdiff_lp918896.debdiff |
|
|
| 2016-06-15 17:20:21 |
Thomas Ward |
attachment removed |
Wily DebDiff for LP#918896 https://bugs.launchpad.net/ubuntu/+source/pymssql/+bug/918896/+attachment/4680075/+files/wily_debdiff_lp918896.debdiff |
|
|
| 2016-06-15 17:20:26 |
Thomas Ward |
attachment removed |
Xenial DebDiff for LP#918896 https://bugs.launchpad.net/ubuntu/+source/pymssql/+bug/918896/+attachment/4680074/+files/xenial_debdiff_lp918896.debdiff |
|
|
| 2016-06-15 17:21:15 |
Thomas Ward |
removed subscriber Ubuntu Sponsors Team |
|
|
|
| 2016-07-21 15:58:08 |
Geoffrey Thomas |
bug watch added |
|
http://bugs.debian.org/cgi-bin/bugreport.cgi?bug=648230 |
|
| 2017-05-28 23:50:58 |
Bug Watch Updater |
pymssql (Debian): status |
Confirmed |
Fix Released |
|
| 2017-05-29 00:14:20 |
Thomas Ward |
nominated for series |
|
Ubuntu Artful |
|
| 2017-05-29 00:14:20 |
Thomas Ward |
nominated for series |
|
Ubuntu Zesty |
|
| 2017-05-29 01:26:39 |
C de-Avillez |
bug task added |
|
pymssql (Ubuntu Artful) |
|
| 2017-05-29 01:26:57 |
C de-Avillez |
bug task added |
|
pymssql (Ubuntu Zesty) |
|
| 2017-05-29 03:03:38 |
Thomas Ward |
pymssql (Ubuntu Zesty): status |
New |
Confirmed |
|
| 2017-05-29 03:03:41 |
Thomas Ward |
pymssql (Ubuntu Zesty): importance |
Undecided |
High |
|
| 2017-07-20 09:06:56 |
Amr Ibrahim |
pymssql (Ubuntu Artful): status |
Confirmed |
Fix Released |
|
| 2021-10-14 05:30:21 |
Steve Langasek |
pymssql (Ubuntu Precise): status |
Confirmed |
Won't Fix |
|
