500 Server Error for some users after working fine for a day.

[no1knows]

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]

[SKaero]

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.

[no1knows]

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.

[SKaero]

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.

[no1knows]

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 Expand

[03-Dec-2009 16:31:27 +0000]: * OK Gimap ready for requests from 78.105.63.52 i6if192184gve.16
AUTH PLAIN: Resource id #87


[SKaero]

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.

[no1knows]

I'm in on your server!!!

[SKaero]

Its a start! Hopefully it keeps working, let me know if it stops working.

[no1knows]

ok, let me know what changes you made and I'll try the same on mine?

[no1knows]

SKaero - I tried again this morning on your server and its working!

Would you mind letting me know what amends you made?

[SKaero]

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 Expand


// get cache entry ID for this key


Replace:

Code Select Expand


$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 Expand


$sql_result = '';


[no1knows]

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 Expand

[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]

[SKaero]

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.

[no1knows]

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

[SKaero]

I removed you from the database yesterday before you where able to login on my server the first time.