This topic is locked

Session Expired

5/22/2005 8:50:07 PM
PHPRunner General questions
roy author

I've been fighting this problem for several days now and it's getting frustrating. I'm getting abrupt "Session Expired" message along with forced logout. If I login again it goes directly to the display I would have expected had it not logged me out.
This is only happening when I am returning to the master record after displaying the detail for that record. It gets a little more complicated in that I have 2 master/detail relationships each is 1 master to 2 detail tables. One combination works perfectly and the other works well for 1 of the detail links, but will only allow 1 access of the 2nd detail link before failing.
I created a full backup of my database and installed it on the computer I have at home, and I copied the PHPRunner generated code from my apache2/htdocs/crms directory. I restored that to the apache2/htdocs/crms on my computer at home. It works flawlessly!
I'm baffled! Can anyone help?
Thanks,

Roy

Admin 5/24/2005

Hi,
could you post here an URL where I can see this problem?

roy author 5/24/2005

Hi Sergey,

Actually, I can't (or don't know how to) post a URL for you to see the problem. I'm running things during development on my laptop. I have apache2/mysql/PHP running as localhost under WinXP SP2 . I haven't addressed how I'm going to upload everything to our intranet server yet. But, there are staff here that can help me with that. ;-)
The tables in my database are all InnoDB and are as follows:

  1. Businesses, master to the following 2 detail tables: Contacts and Contracts;
  2. Markets, master to the following 2 detail tables: Publications and Rates;
  3. Users.
    The only table I'm having a problem with is the Rates table.
    I can go back and forth from the Businesses list display (vertical) to Contacts list display (horizontal with link to view) and Contracts list display (horizontal) as much as I like, using the links from the master table, with out problem.
    From the Markets list display (horizontal) I can go back and forth to the Publications list display, using the links from the master table and the Back to Master link, with no problem. But, when I link from Markets to Rates using the link on the Markets list display (horizontal), when I return from the Rates list display (horizontal), using the Back to Master link, I get the "Session Expired" message along with the forced logout. When I log back in I'm at the Markets list display, where I was trying to go when the forced logout occured.
    When I offload all the generated code and my test database to a CD and take it to my computer at home (running WinXP SP2 as well), everything works as expected.
    I hope this extra information helps. The only other thing I can offer is to zip all the generated code, a dump file of my test database, and the project file, and send that to you.

roy author 5/24/2005

A couple of additional bits of information; both computers are running Apache2/mySQL 4.1.11/PHP 5.0.4 under Windows XP Pro SP2.
Also, the "Session Expired" logout occurs the 2nd time I go "Back to Master" from the Rates table list display to the Markets table list display.
Thanks,

Roy

Admin 5/25/2005

Roy,
please zip and send to support@xlinesoft.com the whole contents of PHPRunner output folder with subfolders along with PHPRunner project file and database creation script.

I'll find what's going wrong running your pages on my box.

prleo1 6/14/2005

i am experiencing this issue. My setup is
Apache 2.0.54 w/SSL

MySQL 5

PHP 5

Win2k3 server
I have just added a documents page to my site in order for people to download our forms. As soon as I hit the edit button, I am forwarded to the login screen with "Session Expired" underneath.

roy author 6/14/2005

Hello,

I would guess you are using PHP 5.0.4. There is a bug in the .4 release that doesn't exist in earlier releases. Which is why my application worked on 1 machine and not on two others.
The solution, for me, was to set register_long_arrays = On in the php.ini file in the Windows directory. It's not recording session data properly.
I hope this solution works for you, as I wouldn't want you to have to spend 10 days fighting the problem like I did.
I have Sergey to thank for the solution. He really dug in until he was able to duplicate the problem and find the solution.
I'm now a happy PHPRunner user and my application is in the midst of being implemented live as we speak. We move our offices over this weekend and next week the app will go up on the company's intranet. Even with the 10 day delay, I would have never been able to accomplish this in such a short amount of time without PHPRunner.

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=4793&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />

Roy

prleo1 6/15/2005

Thank you, both. I have been pulling out my hair with this issue.

I have made the change on my prod server, and will test it out thoroughly today.