Help with database error after category and album setup!

[Patak]

Initial install was perfect, everything works fine, category and album setup was fine... I add files no problems... but after setting up category and then an album, clicking on album properties or edit/edit file information gives me a database error.

I know I'm probably not explaning this properly but I'm new to all of this so forgive me... it just says There was an error while processing a database query...

Can you guys tell me what info I should post...

Thanx a lot

I also get this error when I click on Last Uploads or Last Comments...

Parse error: parse error, unexpected T_AS in /photogal/thumbnails.php on line 88

[Nibbler]

Enable debug mode and post the mysql error message you get when you replicate the issue.

Re-upload thumbnails.php.

[Patak]

Ok thanx for the quick reply... these are the errors I get so far... now all this is alien to me but is this perhaps not even related to coppermine? I should also say I upgraded from 135 to 144 and version check confirms the upgrade...

Error One
While executing query "SELECT DISTINCT aid, title, IF(category = 0, CONCAT('&gt; ', title), CONCAT(name,' &lt; ',title)) AS cat_title FROM cpg135_albums, cpg135_categories WHERE category < '10000' AND (category = 0 OR category = cid) ORDER BY cat_title" on 0

mySQL error: Can't create/write to file '/var/tmp/#sql_189_0.MYI' (Errcode: 13)



Error Two
While executing query "SELECT aid, CONCAT('(', user_name, ') ', a.title) AS title
                                                        FROM cpg135_albums AS a
                                                        INNER JOIN `akidman1_photogal`.cpg135_users AS u
                                                        ON category = (10000 + user_id)
                                                        ORDER BY title" on 0

mySQL error: Can't create/write to file '/var/tmp/#sql_189_0.MYI' (Errcode: 13)


Thanx again...

[Nibbler]

Yeah, that's a mysql issue unrelated to Coppermine. Contact your host.