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
something's wrong with your server config imo. Do you happen to be self-hosted?
GauGau
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
LIMIT 0 ,4" on 0
gives the error, so can you help me what is going wrong
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
different issues, different threads!
GauGau
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