[Solved]: mysql error with lastalb function

[pcfreak]

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

[Joachim Müller]

something's wrong with your server config imo. Do you happen to be self-hosted?

GauGau

[pcfreak]

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

[pcfreak]

    LIMIT 0 ,4" on 0

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

[pcfreak]

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

[Joachim Müller]

different issues, different threads!

GauGau

[pcfreak]

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