Started to get lots of these:

user warning: Out of memory (Needed 1610496 bytes) query: SELECT DISTINCT u.uid, u.name, s.timestamp FROM users u INNER JOIN sessions s ON u.uid = s.uid WHERE s.timestamp >= 1247647491 AND s.uid > 0 ORDER BY s.timestamp DESC in /usr/local/psa/home/vhosts/xxx.org/httpdocs/sites/all/modules/im/im.module on line 712.

Tried upgrading to latest release - didn't help. Seems to have only started since setting up chatroom.

Comments

pahariwalla’s picture

Bummer... I don't see how chatroom would make any difference, but you might try to remove the chatroom and see if the error still comes. Here are a couple of interesting posts:

specially this one http://drupal.org/node/251886 - looks familiar because I'm using the same code in user.module to see who is online. I'd be interested to see what happens if you enable the stock Drupal block "Who's Online". I'm guessing that you'll get the same error.

Another similar post: http://drupal.org/node/318689

My hunch is that this has something to do with your environment, like PHP and MySQL "max memory" settings.

So, a couple pieces of information that will be handy in solving this, other than the memory limits:
1) How many users do you have?
2) Have you cleaned up the sessions table recently? This table can get pretty big, even if your registerd users are not too many because it will create a record for every session started by every unauthorized user as well as authorized users. To clean it, you can "delete from sessions where timestamp < xxxx" where xxxx is less than yesterday, or a a couple days ago. That way you won't be messing up anyone's current session.

Please make another post if you've been able to resolve the issue so others can find the answer. ;-)

Mr P’s picture

I've just cleaned everything up and am trying again. Have turned off report logging which I just switched on recently and think may be linked to problem. Only have a few trial users now.

Errors stopped - will let you know if come back.

Mr P’s picture

Seperate issue but am also getting this in ie:

Webpage error details

Message: 'console' is undefined
Line: 124
Char: 9
Code: 0
URI: http://www.xxx.org/sites/all/modules/im/im.js?6

pahariwalla’s picture

Thanks Mr P .. glad the errors stopped and would be interested if they come back

pahariwalla’s picture

Ugh ... my bad ... forgot to delete my debugging trace instructions ...

I've commit the fix but it may rake a few hours before drupal creates a new tarball ...

meanwhile, you can get the new version of im.js from http://cvs.drupal.org/viewvc.py/drupal/contributions/modules/im/im.js?vi...

call me lazy, but it's hard to test in all browsers after every change .. oops.

Mr P’s picture

And another:

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 1.1.4322; OfficeLiveConnector.1.3; OfficeLivePatch.0.0)
Timestamp: Thu, 16 Jul 2009 20:06:17 UTC

Message: Object doesn't support this property or method
Line: 228
Char: 5
Code: 0
URI: http://www.xx.org/sites/all/modules/im/im.js?s

pahariwalla’s picture

Can you tell me which version of im.js you are using. or else attach the file to this post so I can see which line is crapping out? thanks

Mr P’s picture

Latest - July 16th. Good module, by the way.

pahariwalla’s picture

hmm ... don't know what's broken where for you ... can you tell me where you see this message and what you did do get it? Did you see it in Firebug? FF Javascript Error window?

pahariwalla’s picture

Status: Active » Postponed (maintainer needs more info)
Mr P’s picture

In IE8. Error message ! bottom left of screen. Just checked after installing latest version and got this:

Webpage error details

User Agent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0; .NET CLR 2.0.50727; .NET CLR 1.1.4322; OfficeLiveConnector.1.3; OfficeLivePatch.0.0)
Timestamp: Sun, 26 Jul 2009 17:28:29 UTC

Message: Object doesn't support this property or method
Line: 240
Char: 5
Code: 0
URI: http://www.permaculturefrance.org/sites/all/modules/im/im.js?Y

pahariwalla’s picture

Issue tags: +IE

tagging