Author Topic: 500 Server Error for some users after working fine for a day.  (Read 13485 times)

Offline no1knows

  • Jr. Member
  • **
  • Posts: 23
500 Server Error for some users after working fine for a day.
« Reply #15 on: December 03, 2009, 10:04:38 AM »
Nice, could be getting somewhere! I had tried, I will try again. But the problem seemed to exist even with cache disabled.

[edit]No luck with an empty cache table - should I empty the messages table to?
It seems during the timeout that the Messages table is updated with the latest emails, although no entries are made in the cache table.
[/edit]
« Last Edit: December 03, 2009, 10:09:21 AM by no1knows »

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
500 Server Error for some users after working fine for a day.
« Reply #16 on: December 03, 2009, 10:08:43 AM »
I checked my database and there were no cache for your user, looking at the query in the error there is "\n" and ? that shouldn't be there it looks like it querying the database when it shouldn't be.

Offline no1knows

  • Jr. Member
  • **
  • Posts: 23
500 Server Error for some users after working fine for a day.
« Reply #17 on: December 03, 2009, 10:22:30 AM »
Ahah... weird that it only occurs after the user is X hours old on my server...

But I am a new user on your server and its broken from the get-go.

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
500 Server Error for some users after working fine for a day.
« Reply #18 on: December 03, 2009, 11:22:53 AM »
True, but my server is still running 0.3 if you the $rcmail_config['debug_level'] to 8 in the main.inc.php does anything show up in the console.

Offline no1knows

  • Jr. Member
  • **
  • Posts: 23
500 Server Error for some users after working fine for a day.
« Reply #19 on: December 03, 2009, 11:31:55 AM »
nothing in the console, just stays blank then goes to the 500 error page.

The console file in the logs directory contains this:

Code: [Select]
[03-Dec-2009 16:31:27 +0000]: * OK Gimap ready for requests from 78.105.63.52 i6if192184gve.16
AUTH PLAIN: Resource id #87
« Last Edit: December 03, 2009, 11:34:31 AM by no1knows »

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
500 Server Error for some users after working fine for a day.
« Reply #20 on: December 03, 2009, 11:58:41 AM »
Ok no new info there, try login on on my server again I made some changes where the error code was let me know if you can get in.

Offline no1knows

  • Jr. Member
  • **
  • Posts: 23
500 Server Error for some users after working fine for a day.
« Reply #21 on: December 03, 2009, 12:08:17 PM »
I'm in on your server!!!

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
500 Server Error for some users after working fine for a day.
« Reply #22 on: December 03, 2009, 12:20:35 PM »
Its a start! Hopefully it keeps working, let me know if it stops working.

Offline no1knows

  • Jr. Member
  • **
  • Posts: 23
500 Server Error for some users after working fine for a day.
« Reply #23 on: December 03, 2009, 12:26:16 PM »
ok, let me know what changes you made and I'll try the same on mine?

Offline no1knows

  • Jr. Member
  • **
  • Posts: 23
500 Server Error for some users after working fine for a day.
« Reply #24 on: December 04, 2009, 04:19:23 AM »
SKaero - I tried again this morning on your server and its working!

Would you mind letting me know what amends you made?

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
500 Server Error for some users after working fine for a day.
« Reply #25 on: December 04, 2009, 07:01:04 AM »
Sure, remember that the one on my site is a mix of versions try at your own risk :rolleyes: I also have caching enabled. I removed the code that was causing the error forcing it not get a cache key witch seams to be where it was hanging.

Edited the [RC root]/program/include/rcube_imap.php

Fine:
Code: [Select]

// get cache entry ID for this key


Replace:
Code: [Select]

$sql_result = $this->db->query(
"SELECT cache_id
FROM ".get_table_name('cache')."
WHERE  user_id=?
AND    cache_key=?",
$_SESSION['user_id'],
'IMAP.'.$key);


With:
Code: [Select]

$sql_result = '';

Offline no1knows

  • Jr. Member
  • **
  • Posts: 23
500 Server Error for some users after working fine for a day.
« Reply #26 on: December 04, 2009, 07:30:29 AM »
ok, done that - but still timing out... :mad:

where did you get your logs from? apache error_log? I don't get any entries.

This is incredibly frustrating! Hopefully if I can find some logs we can find the culprit in the SVN!

[edit] found this in the error_log:

Code: [Select]
[Fri Dec 04 12:42:49 2009] [error] [client 80.254.146.52] PHP Fatal error:  Call to a member function fetchRow() on a non-object in /var/www/html/webmail/program/include/rcube_mdb2.php on line 386, referer: http://ldn.no1knows.com/webmail/

This is as a result of the above amend I believe... [/edit]
« Last Edit: December 04, 2009, 07:34:32 AM by no1knows »

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
500 Server Error for some users after working fine for a day.
« Reply #27 on: December 04, 2009, 07:45:10 AM »
I forgot to say I did remove you from the database when I made the changes. I had that log entry one as well, but everything else still works.

Offline no1knows

  • Jr. Member
  • **
  • Posts: 23
500 Server Error for some users after working fine for a day.
« Reply #28 on: December 04, 2009, 07:57:37 AM »
Ah, so you removed me from the database today? that explains why its working then... if you leave me there then tomorrow it will timeout...

Offline SKaero

  • Administrator
  • Hero Member
  • *****
  • Posts: 5,876
    • SKaero - Custom Roundcube development
500 Server Error for some users after working fine for a day.
« Reply #29 on: December 04, 2009, 08:30:49 AM »
I removed you from the database yesterday before you where able to login on my server the first time.