Evening all,

What at the permissions I need to give folders and Files?

I am getting some errors in the error log and though it might be a database issue I would like to rule out a permissions issue.

As I have said before I have moved to a new server and I did have an issue where some piwigo wouldn't work at first because the _data are was not given the correct permissions.

The error is this (all from the same IP),

[Mon Nov 05 14:58:45 2012] [error] [client IP] PHP Warning: [mysql error 126] Incorrect key file for table '/tmp/#sql_583_14.MYI'; try to repair it\nSELECT id\n FROM piwigo_images i \n INNER JOIN piwigo_image_category ic ON id=ic.image_id\n INNER JOIN piwigo_image_tag it ON id=it.image_id\n WHERE tag_id IN (441,575,576)\n GROUP BY id\n HAVING COUNT(DISTINCT tag_id)=3\nORDER BY file ASC, date_creation DESC in /var/www/vhosts/jackstringer.co.uk/subdomain/gallery/include/dblayer/functions_mysql.inc.php on line 770
[Mon Nov 05 14:58:45 2012] [error] [client IP] PHP Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/vhosts/jackstringer.co.uk/subdomain/gallery/include/dblayer/functions_mysql.inc.php on line 200
[Mon Nov 05 14:58:45 2012] [error] [client IP] PHP Warning: [mysql error 126] Incorrect key file for table '/tmp/#sql_583_12.MYI'; try to repair it\nSELECT id\n FROM piwigo_images i \n INNER JOIN piwigo_image_category ic ON id=ic.image_id\n INNER JOIN piwigo_image_tag it ON id=it.image_id\n WHERE tag_id IN (54,575,576)\n GROUP BY id\n HAVING COUNT(DISTINCT tag_id)=3\nORDER BY file ASC, date_creation DESC in /var/www/vhosts/jackstringer.co.uk/subdomain/gallery/include/dblayer/functions_mysql.inc.php on line 770
[Mon Nov 05 14:58:45 2012] [error] [client IP] PHP Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/vhosts/jackstringer.co.uk/subdomain/gallery/include/dblayer/functions_mysql.inc.php on line 200
[Mon Nov 05 14:58:45 2012] [error] [client IP] PHP Warning: [mysql error 126] Incorrect key file for table '/tmp/#sql_583_9.MYI'; try to repair it\nSELECT id\n FROM piwigo_images i \n INNER JOIN piwigo_image_category ic ON id=ic.image_id\n INNER JOIN piwigo_image_tag it ON id=it.image_id\n WHERE tag_id IN (53,55)\n GROUP BY id\n HAVING COUNT(DISTINCT tag_id)=2\nORDER BY file ASC, date_creation DESC in /var/www/vhosts/jackstringer.co.uk/subdomain/gallery/include/dblayer/functions_mysql.inc.php on line 770
[Mon Nov 05 14:58:45 2012] [error] [client IP] PHP Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/vhosts/jackstringer.co.uk/subdomain/gallery/include/dblayer/functions_mysql.inc.php on line 200
[Mon Nov 05 14:58:45 2012] [error] [client IP] PHP Warning: [mysql error 126] Incorrect key file for table '/tmp/#sql_583_7.MYI'; try to repair it\nSELECT id\n FROM piwigo_images i \n INNER JOIN piwigo_image_category ic ON id=ic.image_id\n INNER JOIN piwigo_image_tag it ON id=it.image_id\n WHERE tag_id IN (53,576)\n GROUP BY id\n HAVING COUNT(DISTINCT tag_id)=2\nORDER BY file ASC, date_creation DESC in /var/www/vhosts/jackstringer.co.uk/subdomain/gallery/include/dblayer/functions_mysql.inc.php on line 770
[Mon Nov 05 14:58:45 2012] [error] [client IP] PHP Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/vhosts/jackstringer.co.uk/subdomain/gallery/include/dblayer/functions_mysql.inc.php on line 200
[Mon Nov 05 14:58:45 2012] [error] [client IP] PHP Warning: [mysql error 126] Incorrect key file for table '/tmp/#sql_583_5.MYI'; try to repair it\nSELECT id\n FROM piwigo_images i \n INNER JOIN piwigo_image_category ic ON id=ic.image_id\n INNER JOIN piwigo_image_tag it ON id=it.image_id\n WHERE tag_id IN (53,54,446,715)\n GROUP BY id\n HAVING COUNT(DISTINCT tag_id)=4\nORDER BY file ASC, date_creation DESC in /var/www/vhosts/jackstringer.co.uk/subdomain/gallery/include/dblayer/functions_mysql.inc.php on line 770
[Mon Nov 05 14:58:45 2012] [error] [client 1IP] PHP Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/vhosts/jackstringer.co.uk/subdomain/gallery/include/dblayer/functions_mysql.inc.php on line 200
[Mon Nov 05 14:58:45 2012] [error] [client IP] PHP Warning: [mysql error 3] Error writing file '/tmp/MYhLOPID' (Errcode: 28)\n\nSELECT DISTINCT(image_id)\n FROM piwigo_image_category\n INNER JOIN piwigo_images ON id = image_id\n WHERE\n 1=1\n\n ORDER BY file ASC, date_creation DESC\n; in /var/www/vhosts/jackstringer.co.uk/subdomain/gallery/include/dblayer/functions_mysql.inc.php on line 770
[Mon Nov 05 14:58:45 2012] [error] [client IP] PHP Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/vhosts/jackstringer.co.uk/subdomain/gallery/include/dblayer/functions_mysql.inc.php on line 200
[Mon Nov 05 14:58:45 2012] [error] [client IP] PHP Warning: [mysql error 126] Incorrect key file for table '/tmp/#sql_583_11.MYI'; try to repair it\nSELECT id\n FROM piwigo_images i \n INNER JOIN piwigo_image_category ic ON id=ic.image_id\n INNER JOIN piwigo_image_tag it ON id=it.image_id\n WHERE tag_id IN (53,55,445,486)\n GROUP BY id\n HAVING COUNT(DISTINCT tag_id)=4\nORDER BY file ASC, date_creation DESC in /var/www/vhosts/jackstringer.co.uk/subdomain/gallery/include/dblayer/functions_mysql.inc.php on line 770
[Mon Nov 05 14:58:45 2012] [error] [client IP] PHP Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/vhosts/jackstringer.co.uk/subdomain/gallery/include/dblayer/functions_mysql.inc.php on line 200
[Mon Nov 05 14:58:45 2012] [error] [client IP] PHP Warning: [mysql error 3] Error writing file '/tmp/MYJiyhgR' (Errcode: 28)\nSELECT id\n FROM piwigo_images i \n INNER JOIN piwigo_image_category ic ON id=ic.image_id\n INNER JOIN piwigo_image_tag it ON id=it.image_id\n WHERE tag_id IN (6,53,55,446)\n GROUP BY id\n HAVING COUNT(DISTINCT tag_id)=4\nORDER BY file ASC, date_creation DESC in /var/www/vhosts/jackstringer.co.uk/subdomain/gallery/include/dblayer/functions_mysql.inc.php on line 770
[Mon Nov 05 14:58:45 2012] [error] [client IP] PHP Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /var/www/vhosts/jackstringer.co.uk/subdomain/gallery/include/dblayer/functions_mysql.inc.php on line 200