MySQL Problem

[Victor Subervi]

On Thu, Sep 2, 2010 at 3:02 PM, Ian <hobson42 at gmaiil.com> wrote:

>  On 02/09/2010 19:34, Victor Subervi wrote:
>
>> for some reason running the command through python *omits* this one data!!
>> The only difference is that a flag in spreadsheets (Temp) is set to 1. Why
>> on earth doesn't it work in python??
>>
> Some ideas to follow up.  (These are only guesses).
>
> 1) One of the enum type fields contains an invalid value (perhaps a value
> removed from the column definition).
>

There are no enum type fields.

>
> 2) The second id field (products.id?) appears to be very large. I wonder
> what would happen if it was larger than the auto-increment value?
>

It's not an ID field. It doesn't auto_increment.

>
> 3) A field in the one of the rows in the missing data contains bytes that
> are invalid in the character encoding you are using in python.
>

I changed the only bytes I thought might affect it. Furthermore, I
successfully added the blasted data to that field so it would show up in the
spreadsheet through another form. More on that later.

>
> 4) The python field type used for some column in the missing row, contains
> a value that cannot be held in the python variable assigned.
>

If that were so, none of the data would show up.

Please look at this comparison:

FIELD    BAD DATA   GOOD DATA
ID        609                161
Client        Lincoln_Properties        Lincoln_Properties
Multi        0                0
Item        2030572                40x48Green
Markup        0.00                99.32
Temp        1                Null
ID        343                37
Item        2030572                40x48Green
Description    Americo 20" Beige Floor Pad    Green Can Liners
UOM        5/cs                1000/cs
Cost        15.88                17.56
ID        335                37
ProductsID    343                37
CategoryID    49                23
ID        49                23
Category    Mats                Can Liners
Parent        Restaurant Paper/Pla        Bags

I have changed the value of Temp to Null and Markup to 11.11 to see if that
would somehow make a difference. It didn't. Then I used my TTW form for
adding data "regularly" to spreadsheets and it worked. The form I'm testing
enables the client to add data himself. The code is the same in both cases:

"regular"
cursor.execute('insert into spreadsheets values (Null, %s, 0, %s, 0, Null)',
(client, prod))

"special"
cursor.execute('insert into spreadsheets values (Null, %s, 0, %s, 0, Null)',
(client, product[1]))

I checked permissions and changed ownership to make the two scripts
identical. Again, the data gets entered into MySQL correctly...it just
doesn't show up with the rest of the data in the TTW form!! Why??
TIA,
beno

>
> Regards
>
> Ian
>
>
>
> --
> http://mail.python.org/mailman/listinfo/python-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20100903/aef07eb9/attachment-0001.html>