would i lose any data ? or what will happen to the users who is logged in
regards,
On Friday, October 12, 2012 11:14:14 PM UTC+3, Massimo Di Pierro wrote:
>
> delete all files in applications/yourapp/sessions/*
>
> On Friday, 12 October 2012 14:52:33 UTC-5, Hassan Alnatour wrote:
>>
>> What do you mean with removing the session ? and how do i do that ?
>>
>> regards,
>>
>> On Friday, October 12, 2012 10:40:09 PM UTC+3, Massimo Di Pierro wrote:
>>>
>>> Can you try remove the sessions?
>>>
>>> On Friday, 12 October 2012 10:35:02 UTC-5, Hassan Alnatour wrote:
>>>>
>>>> Dear Massimo ,
>>>>
>>>> I Removed the applications that are using the carts and still am
>>>> getting the same thing , now i noticed somthing thing , now that i when i
>>>> try to login in my website i get the error , but when i try it from my
>>>> server locally i dont get any errors
>>>>
>>>>
>>>> regards,
>>>>
>>>> On Friday, October 12, 2012 5:56:19 PM UTC+3, Hassan Alnatour wrote:
>>>>>
>>>>> Dear Massimo ,
>>>>>
>>>>> in one of my applications , that has a shopping cart in the
>>>>> controller i have :
>>>>>
>>>>>
>>>>> # Here i create a number that will never happen again ! and save it in
>>>>> the session and i use it in the database to get the cart items
>>>>> def store():
>>>>> import random
>>>>> if session.order == None :
>>>>> cart_ID = random.randint(0,999999)
>>>>> ip= (request.client).replace(".","")
>>>>> session.CartID = str(cart_ID) + str(ip)
>>>>> session.order = "True"
>>>>> cartItems = db(db.cart.OrderID ==
>>>>> session.CartID).select(db.cart.ALL)
>>>>> if request.args(0) == "Brand" :
>>>>> sup = db(db.Supplements.Brand_ID ==
>>>>> request.args(2)).select(db.Supplements.ALL)
>>>>> else:
>>>>> sup = db((db.Supplements.Category ==
>>>>> (request.args(1)).replace('_',' ')) & (db.Supplements.Users ==
>>>>> request.args(0))).select(db.Supplements.ALL)
>>>>> return locals()
>>>>>
>>>>>
>>>>>
>>>>> # Here is the add to cart where i use that session and add it to the
>>>>> database
>>>>> def AddToCart():
>>>>> if request.vars:
>>>>> # Fetching Varibles
>>>>> id = request.vars.id
>>>>> q = request.vars.quantityinput
>>>>> type = request.vars.type
>>>>>
>>>>>
>>>>> #checking If item in alrady in cart
>>>>> if int(id) in cartlist:
>>>>>
>>>>> cartitem =
>>>>> db.cart((db.cart.OrderID==session.CartID)&(db.cart.ProductID==id))
>>>>> cartitemid = db.cart[cartitem.id]
>>>>> cartitemid.update_record(quantity = int(cartitem.quantity)
>>>>> + int(q))
>>>>> session.flash = 'Already in cart'
>>>>> else:
>>>>>
>>>>> db.cart.insert(OrderID=session.CartID,ProductID=id,quantity=q,catid=type)
>>>>> session.flash = "Added"
>>>>> redirect(URL('product',args=[request.vars.one,request.vars.two]))
>>>>>
>>>>>
>>>>> May be somthing here is making that error !! , and the big question ,
>>>>> why isnt it making any problems with the old web2py !! and why cant
>>>>> insert
>>>>> session into the database ??
>>>>>
>>>>> Best Regards
>>>>> Hasan Alnatoru
>>>>>
>>>>>
>>>>> On Friday, October 12, 2012 4:45:55 PM UTC+3, Massimo Di Pierro wrote:
>>>>>>
>>>>>> Are you storing session in db?
>>>>>>
>>>>>> On Friday, 12 October 2012 01:58:24 UTC-5, Hassan Alnatour wrote:
>>>>>>>
>>>>>>> Dear Massimo ,
>>>>>>>
>>>>>>> I tried the nightly build as you said and i still get errors :
>>>>>>>
>>>>>>> TRACEBACK
>>>>>>>
>>>>>>> 1.
>>>>>>> 2.
>>>>>>> 3.
>>>>>>> 4.
>>>>>>> 5.
>>>>>>> 6.
>>>>>>> 7.
>>>>>>>
>>>>>>> 8.
>>>>>>> 9.
>>>>>>> 10.
>>>>>>> 11.
>>>>>>> 12.
>>>>>>> 13.
>>>>>>> 14.
>>>>>>> 15.
>>>>>>> 16.
>>>>>>> 17.
>>>>>>> 18.
>>>>>>> 19.
>>>>>>> 20.
>>>>>>> 21.
>>>>>>> 22.
>>>>>>> 23.
>>>>>>> 24.
>>>>>>> 25.
>>>>>>> 26.
>>>>>>> 27.
>>>>>>>
>>>>>>> Traceback (most recent call last):
>>>>>>>
>>>>>>> File "C:\web2py\gluon\main.py", line 565, in wsgibase
>>>>>>>
>>>>>>>
>>>>>>> session._try_store_on_disk(request, response)
>>>>>>>
>>>>>>>
>>>>>>> File "C:\web2py\gluon\globals.py", line 703, in _try_store_on_disk
>>>>>>>
>>>>>>>
>>>>>>> cPickle.dump(dict(self), response.session_file)
>>>>>>>
>>>>>>>
>>>>>>> File "C:\Python27\Lib\copy_reg.py", line 74, in _reduce_ex
>>>>>>>
>>>>>>>
>>>>>>> getstate = self.__getstate__
>>>>>>>
>>>>>>>
>>>>>>> File "C:\web2py\gluon\dal.py", line 7335, in __getattr__
>>>>>>>
>>>>>>>
>>>>>>> self.__allocate()
>>>>>>>
>>>>>>>
>>>>>>> File "C:\web2py\gluon\dal.py", line 7328, in __allocate
>>>>>>>
>>>>>>>
>>>>>>> self._record = self._table[int(self)]
>>>>>>>
>>>>>>>
>>>>>>> File "C:\web2py\gluon\dal.py", line 7615, in __getitem__
>>>>>>>
>>>>>>>
>>>>>>> return self._db(self._id == key).select(limitby=(0,1)).first()
>>>>>>>
>>>>>>>
>>>>>>> File "C:\web2py\gluon\dal.py", line 8768, in select
>>>>>>>
>>>>>>>
>>>>>>> return adapter.select(self.query,fields,attributes)
>>>>>>>
>>>>>>>
>>>>>>> File "C:\web2py\gluon\dal.py", line 2123, in select
>>>>>>>
>>>>>>>
>>>>>>> return super(SQLiteAdapter, self).select(query, fields, attributes)
>>>>>>>
>>>>>>>
>>>>>>> File "C:\web2py\gluon\dal.py", line 1612, in select
>>>>>>>
>>>>>>>
>>>>>>> return self._select_aux(sql,fields,attributes)
>>>>>>>
>>>>>>>
>>>>>>> File "C:\web2py\gluon\dal.py", line 1577, in _select_aux
>>>>>>>
>>>>>>>
>>>>>>> self.execute(sql)
>>>>>>>
>>>>>>>
>>>>>>> File "C:\web2py\gluon\dal.py", line 1689, in execute
>>>>>>>
>>>>>>>
>>>>>>> return self.log_execute(*a, **b)
>>>>>>>
>>>>>>>
>>>>>>> File "C:\web2py\gluon\dal.py", line 1683, in log_execute
>>>>>>>
>>>>>>>
>>>>>>> ret = self.cursor.execute(*a, **b)
>>>>>>>
>>>>>>> ProgrammingError: Cannot operate on a closed database.
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> regards,
>>>>>>>
>>>>>>>
>>>>>>> On Fri, Sep 28, 2012 at 10:04 PM, Massimo Di Pierro <
>>>>>>> [email protected]> wrote:
>>>>>>>
>>>>>>>> Many little ones. But I just want to make sure the problem has not
>>>>>>>> been fixed already and we are working off the same code.
>>>>>>>>
>>>>>>>>
>>>>>>>> On Friday, 28 September 2012 11:24:02 UTC-5, Hassan Alnatour wrote:
>>>>>>>>
>>>>>>>>> Dear Massimo ,
>>>>>>>>>
>>>>>>>>> i will try it now , but what is the difference between the
>>>>>>>>> stable version and the nightly build ?
>>>>>>>>>
>>>>>>>>> Best Regards,
>>>>>>>>> Hassan Alnatour
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> On Fri, Sep 28, 2012 at 7:10 PM, Massimo Di Pierro <
>>>>>>>>> [email protected]> wrote:
>>>>>>>>>
>>>>>>>>>> Can you try the web2py nightly build?
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> On Friday, 28 September 2012 10:12:25 UTC-5, Hassan Alnatour
>>>>>>>>>> wrote:
>>>>>>>>>>
>>>>>>>>>>> Dear Massimo ,
>>>>>>>>>>>
>>>>>>>>>>> i tested on early version of web2py and it works just fine ,
>>>>>>>>>>> can you help me with this please ?
>>>>>>>>>>>
>>>>>>>>>>> Best Regards,
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> On Friday, September 28, 2012 3:44:45 PM UTC+3, Hassan Alnatour
>>>>>>>>>>> wrote:
>>>>>>>>>>>
>>>>>>>>>>>> Dear Massimo ,
>>>>>>>>>>>>
>>>>>>>>>>>> i am getting this not in just on of my apps , and am not
>>>>>>>>>>>> storing anything in the session , the only thing using it is the
>>>>>>>>>>>> login and
>>>>>>>>>>>> i keep getting this error when the user tries to login ..
>>>>>>>>>>>>
>>>>>>>>>>>> Best Regards,
>>>>>>>>>>>> Hassan Alnatour
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> On Fri, Sep 28, 2012 at 7:39 AM, Massimo Di Pierro <
>>>>>>>>>>>> [email protected]> wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>> You are storing in session something that cannot be properly
>>>>>>>>>>>>> serialized.
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>> On Friday, 28 September 2012 05:47:52 UTC-5, Hassan Alnatour
>>>>>>>>>>>>> wrote:
>>>>>>>>>>>>>
>>>>>>>>>>>>>> Dear ALL ,
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> i am having some trouble with the new web2py , i have a
>>>>>>>>>>>>>> window server 2008 that i am using apache in to host my sites ,
>>>>>>>>>>>>>> now
>>>>>>>>>>>>>> everything was working fine but when i updated web2py , it was
>>>>>>>>>>>>>> okey but
>>>>>>>>>>>>>> every once and while the login stops , i open the server and i
>>>>>>>>>>>>>> do the same
>>>>>>>>>>>>>> thing locally and i dont get any errors and i use the error
>>>>>>>>>>>>>> trace back id
>>>>>>>>>>>>>> and i dont get anything in the trace back , and it only works
>>>>>>>>>>>>>> when i
>>>>>>>>>>>>>> restart apache ?
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> ALL the errors am getting are this :
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> TICKET ID
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> 37.44.32.9.2012-09-28.05-51-**54****.25cc4409-0578-4835-bfaa-
>>>>>>>>>>>>>> **5a51e****416766d
>>>>>>>>>>>>>> VERSION web2py™ (2, 0, 9, datetime.datetime(2012, 9, 13,
>>>>>>>>>>>>>> 23, 51, 30), 'stable') TRACEBACK
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> 1.
>>>>>>>>>>>>>> 2.
>>>>>>>>>>>>>> 3.
>>>>>>>>>>>>>> 4.
>>>>>>>>>>>>>> 5.
>>>>>>>>>>>>>> 6.
>>>>>>>>>>>>>> 7.
>>>>>>>>>>>>>> 8.
>>>>>>>>>>>>>> 9.
>>>>>>>>>>>>>> 10.
>>>>>>>>>>>>>> 11.
>>>>>>>>>>>>>> 12.
>>>>>>>>>>>>>> 13.
>>>>>>>>>>>>>> 14.
>>>>>>>>>>>>>> 15.
>>>>>>>>>>>>>> 16.
>>>>>>>>>>>>>> 17.
>>>>>>>>>>>>>> 18.
>>>>>>>>>>>>>> 19.
>>>>>>>>>>>>>> 20.
>>>>>>>>>>>>>> 21.
>>>>>>>>>>>>>> 22.
>>>>>>>>>>>>>> 23.
>>>>>>>>>>>>>> 24.
>>>>>>>>>>>>>> 25.
>>>>>>>>>>>>>> 26.
>>>>>>>>>>>>>> 27.
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Traceback (most recent call last):
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> File "C:\web2py\gluon\main.py", line 547, in wsgibase
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> session._try_store_on_disk(req******uest, response)
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> File "C:\web2py\gluon\globals.py", line 686, in
>>>>>>>>>>>>>> _try_store_on_disk
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> cPickle.dump(dict(self), response.session_file)
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> File "C:\Python27\Lib\copy_reg.py", line 74, in _reduce_ex
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> getstate = self.__getstate__
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> File "C:\web2py\gluon\dal.py", line 7344, in __getattr__
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> self.__allocate()
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> File "C:\web2py\gluon\dal.py", line 7337, in __allocate
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> self._record = self._table[int(self)]
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> File "C:\web2py\gluon\dal.py", line 7624, in __getitem__
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> return self._db(self._id ==
>>>>>>>>>>>>>> key).select(limitby=(0,1)).fir******st()
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> File "C:\web2py\gluon\dal.py", line 8766, in select
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> return adapter.select(self.query,fiel******ds,attributes)
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> File "C:\web2py\gluon\dal.py", line 2094, in select
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> return super(SQLiteAdapter, self).select(query, fields,
>>>>>>>>>>>>>> attributes)
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> File "C:\web2py\gluon\dal.py", line 1594, in select
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> return self._select_aux(sql,fields,at******tributes)
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> File "C:\web2py\gluon\dal.py", line 1559, in _select_aux
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> self.execute(sql)
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> File "C:\web2py\gluon\dal.py", line 1671, in execute
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> return self.log_execute(*a, **b)
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> File "C:\web2py\gluon\dal.py", line 1665, in log_execute
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> ret = self.cursor.execute(*a, **b)
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> ProgrammingError: Cannot operate on a closed database.
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> What do you think is the problem ? and how can i solve this ?
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Best Regards,
>>>>>>>>>>>>>>
>>>>>>>>>>>>> --
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>>
>>>>>>>>>>>>
>>>>>>>>>>>> --
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>>
--
