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,
>>>>>>>>>>>>
>>>>>>>>>>> --
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> --
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
--
