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: [Solved]: mysql error with lastalb function  (Read 3907 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.017 seconds with 19 queries.