On my prototype at home, I upgraded from RC-3 to RC-4. All went well.

But now when I access most (though not all) nodes, I receive the following error message:

user warning: Out of memory; restart server and try again (needed 65528 bytes) query: SELECT c.cid as cid, c.pid, c.nid, c.subject, c.comment, c.format, c.timestamp, c.name, c.mail, c.homepage, u.uid, u.name AS registered_name, u.picture, u.data, c.score, c.users, c.thread, c.status FROM comments c INNER JOIN users u ON c.uid = u.uid WHERE c.nid = 18 GROUP BY c.cid, c.pid, c.nid, c.subject, c.comment, c.format, c.timestamp, c.name, c.mail, u.picture, c.homepage, u.uid, u.name, u.picture, u.data, c.score, c.users, c.thread, c.status LIMIT 0, 50 in C:\Program Files\xampp\htdocs\drupal-4.7.0-rc4\includes\database.mysql.inc on line 120.

Apart from the error message, the pages load normally.

Stopping and restarting MySql had no effect.

I am running Apache 2.2.0 (win-32), MySql 5.0.18, and PHP 5.1.1.

Comments

introfini’s picture

introfini commented

I'm having the same issue.

Warning: Out of memory; restart server and try again (needed 65528 bytes) query: SELECT c.cid as cid, c.pid, c.nid, c.subject, c.comment, c.format, c.timestamp, c.name, c.mail, c.homepage, u.uid, u.name AS registered_name, u.picture, u.data, c.score, c.users, c.thread, c.status FROM comments c INNER JOIN users u ON c.uid = u.uid WHERE c.nid = 122 GROUP BY c.cid, c.pid, c.nid, c.subject, c.comment, c.format, c.timestamp, c.name, c.mail, u.picture, c.homepage, u.uid, u.name, u.picture, u.data, c.score, c.users, c.thread, c.status LIMIT 0, 10 in D:\Sites\onc.pt\includes\database.mysql.inc on line 120

introfini

jchapel@wecancolorado.org’s picture

jchapel@wecancolorado.org commented
Version: 4.7.0-rc4 » 4.7.0

Getting identical results with the new Drupal 4.7.0 release
server running Apache 2.2.0 (win-32), MySql 5.0.18, and PHP 5.1.1
and a sever running Apache 2.0.55 (win-32), MySQL 5.0.15, and PHP 5.0.5

theque’s picture

theque commented

Same error on mysql 4.1.xx (win32)
Mysql 5.0.19(win32) executes this query without any errors

theque’s picture

theque commented
Status: Active » Fixed

Not a Drupal problem!
Solution:
Edit your mysql settings file my.ini / my.cnf and set sort buffer size to 128k or 256k
[quote]sort_buffer_size = 256K[/quote]

Anonymous’s picture

Anonymous (not verified) commented

Thank you, theque. That does it.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)