error while processing a database query

[stepclrk]

Hi Guys,

wonder if anyone can help me solve the following problem.

When I click on the Batch Upload I get the following error;

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

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

Now the strange thing is that the first time I did the upload to a blank database it worked fine.  And it is only when I try to add another set of files to an album that I get this message.

I am runnung PHP-Nuke 6.9, with coppermine version 1.1D

The Debug information is;

USER:
Array
(
    [ID] => 7845b3d9f4a2d15c91db9a7a0798e167
    [am] => 1
)

 
GET :
Array
(
    [name] => coppermine
    [file] => searchnew
    [startdir] => Issey
)

 
POST :
Array
(
)


Has anyone come accross this before?

[Joachim Müller]

Should be a safe mode issue imho. Try to find out wether you're on a safe_mode host (look this up with phpinfo).

GauGau

[stepclrk]

As this is being hosted locally on my machine, I have full control over this setting.

But I have had the safe_mode set to both on and off.

But with the same results.

[stepclrk]

The problem ony seems to occur when I have more than 1 Album.

If I have 1 Album listed, I can upload as many files as I want whenver I want, however as soon as I add another album this error occurs.

Any Ideas?

[ArniesAirsoft]

It's possible the table is corrupt I get errors similar to QL error: Can't create/write to file '/root/tmp/#sql_f60_0.MYI' (Errcode: 13)  if the table is damaged in some way. Have you tested the table you are trying to write to (cpg_albums) for integrity?

[nautis]

i am having the same problem. works the first time, but after that i am getting a database error.