Hello, Massimo.
With this change is launched this error:
Traceback (most recent call last):
File "/ home/ctx/PROJECTS/WEB/web2py/gluon/main.py", line 632, in
wsgibase
BaseAdapter.close_all_instances ('rollback')
File "/ home/ctx/PROJECTS/WEB/web2py/gluon/dal.py", line 543, in
close_all_instances
db._adapter.close (action)
File "/ home/ctx/PROJECTS/WEB/web2py/gluon/dal.py", line 523, in close
getattr (self, action) ()
File "/ home/ctx/PROJECTS/WEB/web2py/gluon/dal.py", line 1670, in
rollback
if self.connection: return self.connection.rollback ()
ProgrammingError: (2014, "Commands out of sync, you can not run this
command now")
When this error occurs, I have to wait a while to access any other page, even
the ticket, because it generates new tickets.
This error is also thrown when I try to quickly update any other page
repeatedly. This error no longer occurs only when I comment the code:
if db (db.auth_user). isempty ()
But still happening with the execution of the stored procedure.
Thanks...
On Fri, Feb 22, 2013 at 12:22 AM, Massimo Di Pierro <
massimo.dipie...@gmail.com> wrote:
> Does it work if you replace
>
> db(db.auth_user).isempty():
>
> with
>
> len(db(db.auth_user).select(limitby=(0,1)))
> *
> *
> *This is not a solution but can help me understand.
> *
>
> On Thursday, 21 February 2013 14:07:25 UTC-6, __pyslan__ wrote:
>
>> Sorry...
>>
>> The error occur on line 3 of this file:
>>
>> https://gist.github.com/**pyslan/5007722<https://gist.github.com/pyslan/5007722>
>>
>>
>> On Thu, Feb 21, 2013 at 4:45 PM, __pyslan__ - Ayslan Jenken <
>> ayslan...@gmail.com> wrote:
>>
>>> Hello, Erevybody!
>>>
>>> I am using MySQL on a project and created two procedures to perform a
>>> recursion, because users have users parents.
>>>
>>> The extra fields in the users table:
>>> https://gist.github.com/**pyslan/5007384<https://gist.github.com/pyslan/5007384>
>>>
>>>
>>> Performing some research and testing, I came to the code as follows:
>>> https://gist.github.com/**pyslan/5007364<https://gist.github.com/pyslan/5007364>
>>>
>>> And the stored procedures [1]:
>>>
>>> https://gist.github.com/**pyslan/5007439<https://gist.github.com/pyslan/5007439>
>>>
>>> https://gist.github.com/**pyslan/5007414<https://gist.github.com/pyslan/5007414>
>>>
>>>
>>>
>>> Running the first time the page is created normally and shows the page
>>> with the data correctly. If I refresh the page, generates the following
>>> error:
>>> <type'exceptions.TypeError'> 'NoneType' object is not iterable
>>> If I upgrade again, again shows the correct page, and so on.
>>>
>>> I tried with migrate = False, and the behavior continues.
>>>
>>>
>>> Does anyone have any idea what is causing this error, or a correct way
>>> of doing this using web2py and stored procedures with MySQL?
>>>
>>>
>>> Thanks, guys!
>>> [1] - Procedures adapted from that site: http://goo.gl/l6Nc2
>>>
>>
>> --
>
> ---
> You received this message because you are subscribed to the Google Groups
> "web2py-users" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to web2py+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
--
---
You received this message because you are subscribed to the Google Groups
"web2py-users" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to web2py+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/groups/opt_out.
