Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: sql problem  (Read 3643 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.018 seconds with 20 queries.