MySQLdb: ValueError Something Stupid

[Justin Ezequiel]

On Sep 7, 10:39 pm, mcl <mcl.off... at googlemail.com> wrote:
> On 7 Sep, 14:11, Carsten Haese <cars... at uniqsys.com> wrote:
>
>
>
> > On Fri, 2007-09-07 at 05:52 -0700, mcl wrote:
> > > > ValueError: invalid literal for int(): 0-
> > > >       args = ('invalid literal for int(): 0-',)
>
> > > > =========================================
> > > > Thanks Richard
>
> > > Sort of solved it.
>
> > > On that particular table it did not like * for all fields.
>
> > > Any reason why that would be the case ?
>
> > None that we can divine without more information. What's the schema for
> > the table in question, which column(s) are you excluding to make the
> > query work, and what kind of data is in the column(s) you're excluding?
>
> > --
> > Carsten Haesehttp://informixdb.sourceforge.net
>
> Thanks for replying.
>
> I did not exclude any columns and the Schema is:
>
> CREATE TABLE lstData (
>   qlCat varchar(20) NOT NULL default '',
>   qlTitle varchar(255) NOT NULL default '',
>   qlSubTitle varchar(255) default NULL,
>   qlDetails text,
>   qlPic varchar(20) default NULL,
>   qlPostCode varchar(16) default NULL,
>   qlUpd timestamp NOT NULL default '0000-00-00 00:00:00' on update
> CURRENT_TIMESTAMP,
>   KEY `idx-qlCat` (qlCat)
> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;
>
> Thanks again
>
> Richard

saw this before on earlier MySQLdb and timestamp column
try upgrading your MySQLdb

see https://bugzilla.redhat.com/show_bug.cgi?id=155341 or
http://www.ravenbrook.com/project/p4dti/master/code/replicator/mysqldb_support.py