Help with database error after category and album setup! Help with database error after category and album setup!
 

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

Main Menu

Help with database error after category and album setup!

Started by Patak, March 01, 2006, 01:32:46 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

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.