Hi!
Categories from our gallery home page get totally lost when I upload new photo / video to gallery. This is a totally new thing, happening just for two days. I don't know where to start fixing this so hopefully someone can help..error messages is following:
Warning: [mysql error 1] Can't create/write to file '/tmp/#sql_1c94_0.MYD' (Errcode: 17)
SELECT c.id AS cat_id, global_rank,
MAX(date_available) AS date_last, COUNT(date_available) AS nb_images
FROM piwigo_categories as c
LEFT JOIN piwigo_image_category AS ic ON ic.category_id = c.id
LEFT JOIN piwigo_images AS i
ON ic.image_id = i.id
AND i.level<=8
WHERE c.id NOT IN (1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,67)
GROUP BY c.id, c.global_rank in /home/bigwinpi/public_html/slotgallery/include/dblayer/functions_mysql.inc.php on line 767
Warning: mysql_fetch_assoc() expects parameter 1 to be resource, boolean given in /home/bigwinpi/public_html/slotgallery/include/dblayer/functions_mysql.inc.php on line 153
Warning: Cannot modify header information - headers already sent by (output started at /home/bigwinpi/public_html/slotgallery/include/dblayer/functions_mysql.inc.php:766) in /home/bigwinpi/public_html/slotgallery/include/page_header.php on line 103
Hi Jari Warpenius,
Do you have a dedicated server? or shared hosting?
What is the version of MySQL? (you can see it on Piwigo Administration Home Page)
http://bugs.mysql.com/bug.php?id=9551
Offline
Hi!
We have a virtual server with environment. No issues before this. My mysql version is 5.0.95-community.