There was an error while processing a database query

[Flipper01]

When I want to upload my images to a specified album I get the error:
There was an error while processing a database query

Does anyone know what my problem is and how to solve it??

[Nibbler]

That is a very general message, we need more information before we can help you. Please turn on debug mode in the config, repeat the error and post the full error message. It is also a good idea to give us a link, and also a test account with which we can duplicate the problem for ourselves. If you do this you will get a much better response and your problem will be resolved more quickly.

Thankyou.

[Flipper01]

While executing query "SELECT DISTINCT a.aid as aid, a.title as title, c.name as cname FROM cpg11d_albums as a, cpg11d_categories as c WHERE a.category = c.cid AND a.category < '10000' ORDER BY title" on 0

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


File: /home/ibn/website/fotoalbum/cpg1.2.0final/include/functions.inc.php - Line: 105

[Joachim Müller]

turn silly_safe_mode on for a start (refer to the documentation that comes with coppermine how to do this).

GauGau

[Flipper01]

I've tried a lot of things, but I keep getting an error

Only this time:

While executing query "SELECT aid, IF(user_name IS NOT NULL, CONCAT('(', user_name, ') ', title), CONCAT(' - ', title)) AS title FROM cpg11d_albums AS a LEFT JOIN cpg11d_users AS u ON category = (10000 + user_id) ORDER BY title"

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

[Joachim Müller]

"MYI" is the actual file name of your mySQL database (do not try to fiddle with the file unless you really know what you're doing).
Instead, take a look at the repair tools of mySQL, seems as if your mySQL database is broken: http://www.mysql.com/doc/search.php?q=repair&from=%2Fdoc%2Fen%2Findex.html&lang=en

GauGau

[Flipper01]

I think I found the problem... I didn't install GD on my server  :oops:

I'll ask the administrator if he can do this and then I'll trie it again..

[Flipper01]

I'm totally confused, I've tried to install coppermine several times, but it keeps getting jammed..

The last thing I tried was installing cpg1.2, I created 1 album and uploaded some pictures, no problem. Then I created a 2nd album en tried to batch upload some more pics, but then I got this error:

While executing query "SELECT DISTINCT a.aid as aid, a.title as title, c.name as cname FROM cpg11d_albums as a, cpg11d_categories as c WHERE a.category = c.cid AND a.category < '10000' ORDER BY title" on 0

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

I really hope someone can help me with this cause I've spend lots of hours to install GD, imagemagick and cpg and really want it to work with me now.

[Joachim Müller]

you asked the very same question on another thread, so I moved your new thread to the existing one.

GauGau

[hyperion]

Have you verified that MySQL is functioning correctly outside of CPG?

[Flipper01]

Have you verified that MySQL is functioning correctly outside of CPG?

I am running phpBB and that seems to work fine, I also have some other programs using MySQL on my website and they work fine to..

[Joachim Müller]

did you try the repair commands?

GauGau

[Flipper01]

did you try the repair commands?

GauGau

Yes I did. but it didn't work..