[web2py] Re: Insert not inserting data

2018-04-28 Thread Anthony
> > >>> Just accessing the URL runs the controller. Never had to enable MySQL > logging and looking at each query to find an problem this before. Very > interesting. There really is an Rollback issued when inserting fails. I > found out when the Rollback is issued but not yet why. > > tracker

[web2py] Re: Insert not inserting data

2018-04-28 Thread Kenneth
Den torsdag 26 april 2018 kl. 17:32:56 UTC+3 skrev Anthony: > > On Thursday, April 26, 2018 at 4:07:31 AM UTC-4, Kenneth wrote: >> >> Hi, >> >> correct, no records 24031-24040. I was thinking that my variables maybe >> would have contained something not acceptable so I changed all variables,

[web2py] Re: Insert not inserting data

2018-04-26 Thread Anthony
On Thursday, April 26, 2018 at 4:07:31 AM UTC-4, Kenneth wrote: > > Hi, > > correct, no records 24031-24040. I was thinking that my variables maybe > would have contained something not acceptable so I changed all variables, > but still can't insert. > > Feels like an roolback, but why earth it

[web2py] Re: Insert not inserting data

2018-04-26 Thread Kenneth
Hi, correct, no records 24031-24040. I was thinking that my variables maybe would have contained something not acceptable so I changed all variables, but still can't insert. Feels like an roolback, but why earth it would do something like that I don't understand. There definitly aren't any

[web2py] Re: Insert not inserting data

2018-04-25 Thread Anthony
On Tuesday, April 24, 2018 at 4:20:18 PM UTC-4, Kenneth wrote: > > The function that contains this does a lot of things, but nothing else > regarding this table. And no values are not hard coded, just trying to find > out the problem so I made it as simple as possible. > > If I look at the

[web2py] Re: Insert not inserting data

2018-04-24 Thread Kenneth
The function that contains this does a lot of things, but nothing else regarding this table. And no values are not hard coded, just trying to find out the problem so I made it as simple as possible. If I look at the table in MySQL prompt is see that highest record ID is lets say 24030, I run

[web2py] Re: Insert not inserting data

2018-04-23 Thread Anthony
Can we get more context? What does the real code look like (I assume you don't really have a line at the top level of a controller file that inserts the same hard-coded record on every request to the controller)? How are you determining that no new records are inserted but the id is

[web2py] Re: Insert not inserting data

2018-04-23 Thread Kenneth
This is in an normal controller, no command line. And still it is not working. Everything around it works. And I can't understand how MySQL ID auto increment is getting higher and higher but no data is entered. Almost like data is inserted but deleted right away. I even tried putting in the

[web2py] Re: Insert not inserting data

2018-04-23 Thread Leonel Câmara
If you put it into a controller web2py automatically commits the transaction. If you're doing this from the command line you need to to db.commit() -- Resources: - http://web2py.com - http://web2py.com/book (Documentation) - http://github.com/web2py/web2py (Source code) -