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: [Solved]: mysql error with lastalb function  (Read 3937 times)

0 Members and 1 Guest are viewing this topic.

pcfreak

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
[Solved]: mysql error with lastalb function
« on: June 24, 2004, 10:19:06 pm »
i get a mysql error when i use the 'lastalb' function in the config

While executing query "SELECT *,cpg130_albums.title AS title,cpg130_albums.aid AS aid  FROM cpg130_pictures,cpg130_albums WHERE cpg130_pictures.aid = cpg130_albums.aid AND approved = 'YES' AND cpg130_pictures.aid IN (1,5)  GROUP  BY cpg130_pictures.aid ORDER BY cpg130_pictures.ctime DESC  LIMIT 0 ,4" on 0

mySQL error: Can't create/write to file '--port=3306\#sql_4bc_0.MYI' (Errcode: 2)

the error comes when i have more then one album, but works fine with just one album

error in functions.inc.php line 836
« Last Edit: June 27, 2004, 11:40:42 pm by GauGau »
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: mysql error with lastalb function
« Reply #1 on: June 25, 2004, 12:34:27 am »
something's wrong with your server config imo. Do you happen to be self-hosted?

GauGau
Logged

pcfreak

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
Re: mysql error with lastalb function
« Reply #2 on: June 25, 2004, 08:08:57 pm »
yes self-hosting, but i'm running a lot of sites with mysql with no problems.

only this query gives a sql error, can you explain this query what it does ?

i don't no where i'm looking for to solve this problem
Logged

pcfreak

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
Re: mysql error with lastalb function
« Reply #3 on: June 25, 2004, 08:17:48 pm »
    LIMIT 0 ,4" on 0

gives the error, so can you help me what is going wrong
Logged

pcfreak

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
Re: mysql error with lastalb function
« Reply #4 on: June 25, 2004, 09:31:13 pm »
and found a new error ???

While executing query "SELECT COUNT(*) from cpg130_pictures WHERE approved = 'YES' AND cpg130_pictures.cpg130_pictures.aid IN (1) " on 0

mySQL error: Onbekende tabel 'cpg130_pictures.cpg130_pictures' in where clause


it is not my server, please explain the errors

ps this is the link what gives the error /coppermine/displayimage.php?album=lastalb&cat=1&pos=0
Logged

Joachim Müller

  • Dev Team member
  • Coppermine addict
  • ****
  • Offline Offline
  • Gender: Male
  • Posts: 47843
  • aka "GauGau"
    • gaugau.de
Re: mysql error with lastalb function
« Reply #5 on: June 26, 2004, 08:57:46 am »
different issues, different threads!

GauGau
Logged

pcfreak

  • Coppermine novice
  • *
  • Offline Offline
  • Posts: 31
Re: mysql error with lastalb function
« Reply #6 on: June 27, 2004, 09:13:08 pm »
Quote from: GauGau on June 25, 2004, 12:34:27 am
something's wrong with your server config imo. Do you happen to be self-hosted?

GauGau

you are right GauGau  the tmpdir is mysql was not set.

everything works fine now
Logged
Pages: [1]   Go Up
« previous next »
 

Page created in 0.029 seconds with 16 queries.