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