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?
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
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.
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?
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?
i am having the same problem. works the first time, but after that i am getting a database error.