Hi Guys
i thought id already posted this on here but i cant find it.
anyway im getting strange errors when clicking from the thumbnail page back to the main sub folder, highlighted on the attached pic. this is the full error
While executing query 'SELECT a.aid, a.title, a.description, a.thumb, a.keyword, category, visibility, filepath, filename, url_prefix, pwidth, pheight, a.owner FROM cpg15x_albums AS a LEFT JOIN cpg15x_pictures AS p ON a.thumb=p.pid WHERE a.category = 11 ORDER BY LIMIT 0,3' in index.php on line 795
mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'LIMIT 0,3' at line 1
im no programmer so dont really understand what this refers to. this has happened since i started resizing my pics prior to uploading them - currently at 800 x 600. it also happens with every theme i try. ive already removed and reuploaded the whole coppermine folder from a freshly downloaded version. the only other change is that im now running on a Linux server not 2003
ive also now lost the ability to be able to view the larger image when clicked on from an intermediate size. All these things seem to have happened at the same time ive tried GD 1, GD 2 and imagemagick (although i dont think this is supported by fasthosts)
ive enclose the two files showing what happens - the first (critical error pt 1) is what im actually clikcing on the second the result.
I hope someone can shed some light on this for me.