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
Well, looks like you're out of memory ::). Ask your webhost for support. Not related to initial install, moving thread accordingly.
i am the web host, I have my own server and the site has unlimited memory so what's going on?
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.
ok so what do I have to change to increase the memory?
I have no idea. Refer to the MySQL documentation or search the web.
how do you increase yours?
i restarted the sql server and it fixed itself
thanks
Ah, the joys of self-hosting ::). Marking as solved.