Comment 1 for bug 299247

Random question:

what version of python are you running?

I can't recreate the problem. The main program just says "Loading..." over
and over a bunch.

On Mon, Nov 17, 2008 at 4:40 PM, Alex Stoppel <email address hidden> wrote:

> Public bug reported:
>
> File "/home/alex/CS/seniorproject/devel/backend/main.py", line 6, in main
> updateList = serv.getAvailableUpdates()
> File "/home/alex/CS/seniorproject/devel/backend/UbuntuUpdate.py", line 38,
> in getAvailableUpdates
> dbResult = self.dbConn.addPackage(package,self.machID)
> File "/home/alex/CS/seniorproject/devel/database/uusDBConnector.py", line
> 31, in addPackage
> result = self.helper.addPackage(package)
> File "/home/alex/CS/seniorproject/devel/database/uusDBHelper.py", line
> 363, in addPackage
> self.cursor.execute("insert into package %s values %s;"%(columns,
> values))
> File "/var/lib/python-support/python2.5/MySQLdb/cursors.py", line 166, in
> execute
> self.errorhandler(self, exc, value)
> File "/var/lib/python-support/python2.5/MySQLdb/connections.py", line 35,
> in defaulterrorhandler
> raise errorclass, errorvalue
> ProgrammingError: (1064, 'You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right syntax to
> use near \'Common UNIX Printing System" and "CUPS" are trademarks of Easy\n
> Software Product\' at line 1')
>
> ** Affects: luther-ubuntu-update-server
> Importance: Undecided
> Status: New
>
> --
> uusDBHelper.py crashes in line 363, SQL syntax error.
> https://bugs.launchpad.net/bugs/299247
> You received this bug notification because you are a member of Luther
> College Seniors, which is subscribed to Ubuntu Update Server.
>
> Status in Ubuntu Update Server: New
>
> Bug description:
> File "/home/alex/CS/seniorproject/devel/backend/main.py", line 6, in main
> updateList = serv.getAvailableUpdates()
> File "/home/alex/CS/seniorproject/devel/backend/UbuntuUpdate.py", line 38,
> in getAvailableUpdates
> dbResult = self.dbConn.addPackage(package,self.machID)
> File "/home/alex/CS/seniorproject/devel/database/uusDBConnector.py", line
> 31, in addPackage
> result = self.helper.addPackage(package)
> File "/home/alex/CS/seniorproject/devel/database/uusDBHelper.py", line
> 363, in addPackage
> self.cursor.execute("insert into package %s values %s;"%(columns,
> values))
> File "/var/lib/python-support/python2.5/MySQLdb/cursors.py", line 166, in
> execute
> self.errorhandler(self, exc, value)
> File "/var/lib/python-support/python2.5/MySQLdb/connections.py", line 35,
> in defaulterrorhandler
> raise errorclass, errorvalue
> ProgrammingError: (1064, 'You have an error in your SQL syntax; check the
> manual that corresponds to your MySQL server version for the right syntax to
> use near \'Common UNIX Printing System" and "CUPS" are trademarks of Easy\n
> Software Product\' at line 1')
>