It happens when i put it on my remote linux server and use mysql on there not on my mac. I think I found out why it creates a new session on every page load though.
I looked at the records it was creating, and all the client_ip fields were filled with 127.0.0.1. My ip is not 127.0.0.1 as the website is hosted on webfaction. If you can try on a server you will defiantly be able to recreate what I'm getting. This is a serious issue for anyone wanting to have a production site running on a server using mysql to hold the sessions. Many thanks, On Oct 20, 12:36 pm, mdipierro <[EMAIL PROTECTED]> wrote: > Hi Ceej, > > I installed MySQL on my Mac (which was a pain) but I cannot reproduce > the problem. I remember when you first raised the issue there was a > problem with the file size. It was fixed then. It you possible your > 'sessions' table did not migrate. I suggest manually remove the table > and the associated .table files. > > I did have one problem with mysql on mac. Because of a MySQL bug that > was supposedly fixed (not on the version I have) this statement issues > by web2py "SET sql_mode='NO_BACKSLASH_ESCAPES';" results in an > OperationalError. In order to test the issue you raised I had to > comment that line in sql.py > > Massimo > > On Oct 17, 2:11 pm, ceej <[EMAIL PROTECTED]> wrote: > > > Hi there, > > > If i use session.connect(request,response,tablename='sessions',db=db) > > on my production server which uses MySQL It resets the sessions on > > every page load, it works fine in my development server that uses > > sqlite. I know i mentioned this before, did you get a chance to have a > > look at it? > > > Many thanks --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "web2py Web Framework" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://groups.google.com/group/web2py?hl=en -~----------~----~----~----~------~----~------~--~---
