Well...
Sorry, but the information about the code comment is wrong...
I uncomment the code block "if db(db.auth_user).isempty():" and the error
not thrown.
With or without the code block above, in the terminal server is shown the
error:
DEBUG: connect attempt 0, connection error:
Traceback (most recent call last):
File "/home/ctx/PROJECTS/WEB/web2py/gluon/dal.py", line 6853, in __init__
self._adapter = ADAPTERS[self._dbname](**kwargs)
File "/home/ctx/PROJECTS/WEB/web2py/gluon/dal.py", line 2402, in __init__
if do_connect: self.reconnect()
File "/home/ctx/PROJECTS/WEB/web2py/gluon/dal.py", line 588, in reconnect
self.cursor = cursor and self.connection.cursor()
AttributeError: 'NoneType' object has no attribute 'cursor'
On Fri, Feb 22, 2013 at 9:12 AM, __pyslan__ - Ayslan Jenken <
[email protected]> wrote:
> 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 <
> [email protected]> 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 <
>>> [email protected]> 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 [email protected].
>> 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 [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
