sql problem

[cluj]

everything went fine for a few months but now I get this:

"While executing query "SELECT user_id as user_id,user_name as user_name,COUNT(DISTINCT a.aid) as alb_count,COUNT(DISTINCT pid) as pic_count,MAX(pid) as thumb_pid, MAX(galleryicon) as gallery_pid FROM cpg_albums AS a INNER JOIN `albumef_copp1`.cpg_users as u on u.user_id = a.category - 10000 INNER JOIN cpg_pictures AS p ON p.aid = a.aid WHERE ((isnull(approved) or approved='YES') AND category > 10000)  GROUP BY category ORDER BY category LIMIT 0, 12 " on 0

mySQL error: Out of memory (Needed 1048548 bytes)"

in file: /home/albumef/public_html/include/functions.inc.php - Line: 249

[Joachim Müller]

Well, looks like you're out of memory . Ask your webhost for support. Not related to initial install, moving thread accordingly.

[cluj]

i am the web host, I have my own server and the site has unlimited memory so what's going on?

[Nibbler]

It's an error from MySQL, not Coppermine. You'd need to investigate that yourself as it is a server setup issue. There is no such thing as unlimited memory.

[cluj]

ok so what do I have to change to increase the memory?

[Nibbler]

I have no idea. Refer to the MySQL documentation or search the web.

[cluj]

how do you increase yours?

[cluj]

i restarted the sql server and it fixed itself

thanks

[Joachim Müller]

Ah, the joys of self-hosting . Marking as solved.