MySQL 5.1.41 is kind of old...
http://dev.mysql.com/doc/refman/5.1/en/news-5-1-41.html
D.1.23. Changes in MySQL 5.1.41 (05 November 2009)
Richard
2011/7/13 Kenneth Lundström <kenneth.t.lundst...@gmail.com>
> What happens if you insert a record directly to mysql, can you view it
> from web2py.
>
> In controller return db(db.person.id > 0).select()
>
>
> Kenneth
>
>
> db.define_table('person',
> Field('name','string'))
>
> On Wed, Jul 13, 2011 at 1:11 PM, Richard Vézina <
> ml.richard.vez...@gmail.com> wrote:
>
>> Would you show your model?
>>
>> Richard
>>
>>
>> On Wed, Jul 13, 2011 at 2:08 PM, Ismael Alejandro <ialejandr...@gmail.com
>> > wrote:
>>
>>> Not working :(
>>>
>>>
>>> On Wed, Jul 13, 2011 at 1:02 PM, Richard Vézina <
>>> ml.richard.vez...@gmail.com> wrote:
>>>
>>>> Maybe you forgot : db.commit()
>>>>
>>>> Richard
>>>>
>>>>
>>>> On Wed, Jul 13, 2011 at 1:59 PM, Ismael Alejandro <
>>>> ialejandr...@gmail.com> wrote:
>>>>
>>>>> well, nothing is inserted
>>>>>
>>>>>
>>>>> 2011/7/13 Kenneth Lundström <kenneth.t.lundst...@gmail.com>
>>>>>
>>>>>> > hi! I'm very confused, I'm trying to do a simple Insert, like
>>>>>> this, db.person.insert(name = 'foo'), but It doesn't work (from a
>>>>>> controller).
>>>>>>
>>>>>> What happens when you do it in a controller? Do you get an error? If
>>>>>> not how do you know it does not work?
>>>>>>
>>>>>>
>>>>>> Kenneth
>>>>>>
>>>>>>
>>>>>>
>>>>>> I tried trough appadmin in the query field (same query) and it shows
>>>>>> me an error:
>>>>>>
>>>>>> (1064, u"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
>>>>>> 'WHERE 6****' at line 1")
>>>>>>
>>>>>> ****This number is the corresponding ID of the inserted record.
>>>>>>
>>>>>> but, if I exit the page and then enter again the record is there and
>>>>>> fine!!
>>>>>>
>>>>>> I need it to work from a controller but I can't.
>>>>>>
>>>>>> I'm using MySQL 5.1.41 and web2py 1.94.5
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
>
>
