Advanced search  

News:

cpg1.5.48 Security release - upgrade mandatory!
The Coppermine development team is releasing a security update for Coppermine in order to counter a recently discovered vulnerability. It is important that all users who run version cpg1.5.46 or older update to this latest version as soon as possible.
[more]

Pages: [1]   Go Down

Author Topic: sql problem  (Read 3645 times)

0 Members and 1 Guest are viewing this topic.

cluj

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 27
sql problem
« on: February 06, 2007, 08:13:27 am »
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
« Last Edit: February 06, 2007, 05:53:10 pm by Nibbler »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: sql problem
« Reply #1 on: February 06, 2007, 08:26:24 am »
Well, looks like you're out of memory ::). Ask your webhost for support. Not related to initial install, moving thread accordingly.
Logged

cluj

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 27
Re: sql problem
« Reply #2 on: February 06, 2007, 04:24:30 pm »
i am the web host, I have my own server and the site has unlimited memory so what's going on?
Logged

Nibbler

  • Guest
Re: sql problem
« Reply #3 on: February 06, 2007, 04:53:17 pm »
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.
Logged

cluj

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 27
Re: sql problem
« Reply #4 on: February 06, 2007, 05:36:36 pm »
ok so what do I have to change to increase the memory?
Logged

Nibbler

  • Guest
Re: sql problem
« Reply #5 on: February 06, 2007, 05:39:15 pm »
I have no idea. Refer to the MySQL documentation or search the web.
Logged

cluj

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 27
Re: sql problem
« Reply #6 on: February 06, 2007, 05:43:55 pm »
how do you increase yours?
Logged

cluj

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 27
Re: sql problem
« Reply #7 on: February 06, 2007, 05:47:54 pm »
i restarted the sql server and it fixed itself

thanks
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: sql problem
« Reply #8 on: February 07, 2007, 06:54:33 am »
Ah, the joys of self-hosting ::). Marking as solved.
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.024 seconds with 20 queries.