Announcement

#1 2012-05-30 22:00:30

Jari Warpenius
Guest

Strange error message after uploading new photo

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

 

#2 2012-05-30 22:22:39

plg
Piwigo Team
Nantes, France, Europe
2002-04-05
13487

Re: Strange error message after uploading new photo

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

 

#3 2012-05-30 22:37:15

Jari Warpenius
Guest

Re: Strange error message after uploading new photo

Hi!

We have a virtual server with  environment. No issues before this. My mysql version is 5.0.95-community.

 

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2021 · Contact