search

jdiazbb / rfxcmd

Automatically exported from code.google.com/p/rfxcmd
1 stars 0 forks source link

mysql warning #25

Closed GoogleCodeExporter closed 8 years ago

GoogleCodeExporter commented 8 years ago 
What steps will reproduce the problem?
1. ./rfxcmd.py -l
2. Waited and after a long while I got a warning
3.

What is the expected output? What do you see instead?
Expected: Nothing
Got this:
./rfxcmd.py:411: Warning: Data truncated for column 'seqnbr' at row 1
  cursor.execute(sql)

What version of the product are you using? On what operating system?
Latest SVN

Please provide any additional information below.

Original issue reported on code.google.com by magnus.a...@gmail.com on 18 Jun 2013 at 2:29

GoogleCodeExporter commented 8 years ago 
Please run again with the -D switch, to get debug logs

Original comment by sebastia...@gmail.com on 18 Jun 2013 at 2:34

GoogleCodeExporter commented 8 years ago 
I believe I found something in the SQL table..
My sequence number just went from 98->99 and then to 10  NOT 100
And then it keeps truncating the last character in that column..
10
10
10
10

Original comment by magnus.a...@gmail.com on 19 Jun 2013 at 5:32

GoogleCodeExporter commented 8 years ago 
The seqnbr should be inserted as hex to the database, but was converted to 
integer, which caused the problem. Now fixed and updated in SVN (file: 
rfxcmd.py).

Original comment by sebastia...@gmail.com on 19 Jun 2013 at 5:54