[Solved] After Update 2.x to 3.0.0 - No Thumbnails anymore

Phoca Gallery - image gallery extension
mediaLinux
Phoca Newbie
Phoca Newbie
Posts: 8
Joined: 08 Jun 2011, 13:39

[Solved] After Update 2.x to 3.0.0 - No Thumbnails anymore

Post by mediaLinux »

HI Jan, Hi all

After updating to the latest 3.0.0 no thumbs are generated anymore. I enabled error logging and debug mode in Joomla. See below for the debug log. And - there is NO error reported in any log file whatsoever. I generated a category and uloaded two files into that categories. Thumb generation is then started without any error message. But no thumb is generated in the backend. The category is shown as a white rectangle in the frontend which is unclickable so as there is no category. If i delete the two images from the database as well as the dirctory then all is fine again and the category is shown with the standard symbol.

In other words - all my old images (before 3.0.0) are shown without problems but i cannot add any other image to the gallery.

It doesnt matter what images i upload or how i upload, i can use ftp or the built-in Flash/Java-Uploader. Its all the same.

Here is the debug output from Joomla after adding the two images:

Code: Select all

Profil zum Laufzeitverhalten
Application 0.003 seconds (+0.003); 0.60 MB (+0.60) - afterLoad
Application 0.125 seconds (+0.122); 6.99 MB (+6.39) - afterInitialise
Application 0.133 seconds (+0.008); 7.02 MB (+0.03) - afterRoute
Application 23.742 seconds (+23.609); 12.61 MB (+5.59) - afterDispatch
Application 23.896 seconds (+0.154); 14.10 MB (+1.49) - afterRender
Speichernutzung
14.13 MB (14,819,744 Bytes)
27 Queries Logged

    SELECT `data`
      FROM `jos_session`
      WHERE `session_id` = '03fmo73o714ej89oq95r8bnm9kftl90r'
    DELETE
      FROM `jos_session`
      WHERE `time` < 1309717087
    SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
    SELECT folder AS type, element AS name, params
      FROM jos_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1,2,3)
      ORDER BY ordering
    SHOW FIELDS
      FROM jos_users
    SELECT *
      FROM jos_users
      WHERE id = 42
    SELECT g.id, g.title
      FROM jos_usergroups AS g JOIN jos_user_usergroup_map AS m
      ON m.group_id = g.id
      WHERE m.user_id = 42
    SELECT id, home, template, params
      FROM jos_template_styles
      WHERE client_id = 1
    SELECT template, params
      FROM jos_template_styles
      WHERE client_id = 1
      AND id = 2
    INSERT INTO `jos_rokadminaudit` (`user_id`,`ip`,`session_id`,`option`,`task`,`page`,`referrer`,`title`)
      VALUES ('42','xx.xx.154.183','xxxxxxxxxxxxxxxxxxxx','com_phocagallery','','/administrator/index.php?option=com_phocagallery&view=phocagalleryimgs','','')
    SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_rokcandy'
    SELECT *
      FROM jos_rokcandy
      WHERE published=1
    SELECT id, home, template, params
      FROM jos_template_styles
      WHERE client_id = 0
    SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_phocagallery'
    SELECT a.*,l.title AS language_title,uc.name AS editor,uua.id AS uploaduserid, uua.username AS uploadusername, uua.name AS uploadname,c.title AS category_title, c.id AS category_id, c.owner_id AS category_owner_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,v.average AS ratingavg
      FROM `jos_phocagallery` AS a
      LEFT JOIN `jos_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jos_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jos_users AS uua
      ON uua.id=a.userid
      LEFT JOIN jos_phocagallery_categories AS c
      ON c.id = a.catid
      LEFT JOIN jos_users AS ua
      ON ua.id = c.owner_id
      LEFT JOIN jos_phocagallery_img_votes_statistics AS v
      ON v.imgid = a.id
      WHERE (a.published IN (0, 1))
      AND a.catid = 207
      GROUP BY a.id
      ORDER BY a.title asc
    SELECT a.*,l.title AS language_title,uc.name AS editor,uua.id AS uploaduserid, uua.username AS uploadusername, uua.name AS uploadname,c.title AS category_title, c.id AS category_id, c.owner_id AS category_owner_id,ua.id AS userid, ua.username AS username, ua.name AS usernameno,v.average AS ratingavg
      FROM `jos_phocagallery` AS a
      LEFT JOIN `jos_languages` AS l
      ON l.lang_code = a.language
      LEFT JOIN jos_users AS uc
      ON uc.id=a.checked_out
      LEFT JOIN jos_users AS uua
      ON uua.id=a.userid
      LEFT JOIN jos_phocagallery_categories AS c
      ON c.id = a.catid
      LEFT JOIN jos_users AS ua
      ON ua.id = c.owner_id
      LEFT JOIN jos_phocagallery_img_votes_statistics AS v
      ON v.imgid = a.id
      WHERE (a.published IN (0, 1))
      AND a.catid = 207
      GROUP BY a.id
      ORDER BY a.title asc
      LIMIT 0, 20
    SELECT a.filename
      FROM jos_phocagallery AS a
    SELECT COUNT(a.id) AS count
      FROM jos_phocagallery AS a
      WHERE approved = 0
      LIMIT 0, 1
    SELECT a.title AS text, a.id AS value, a.parent_id as parentid
      FROM jos_phocagallery_categories AS a
      WHERE a.published = 1
      ORDER BY a.ordering
    SELECT a.lang_code AS value, a.title AS text, a.title_native
      FROM jos_languages AS a
      WHERE a.published >= 0
      ORDER BY a.title
    SELECT id, title, module, position, content, showtitle, params, mm.menuid
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2011-07-03 18:48:31')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2011-07-03 18:48:31')
      AND m.access IN (1,1,2,3)
      AND m.client_id = 1
      AND (mm.menuid = 0 OR mm.menuid <= 0)
      ORDER BY position, ordering
    SELECT COUNT(*)
      FROM jos_messages
      WHERE state = 0
      AND user_id_to = 42
    SELECT COUNT(session_id)
      FROM jos_session
      WHERE guest = 0
      AND client_id = 1
    SELECT COUNT(session_id)
      FROM jos_session
      WHERE guest = 0
      AND client_id = 0
    SELECT a.*, SUM(b.home) AS home
      FROM jos_menu_types AS a
      LEFT JOIN jos_menu AS b
      ON b.menutype = a.menutype
      WHERE (b.client_id = 0 OR b.client_id IS NULL)
      GROUP BY a.id
    SELECT m.id, m.title, m.alias, m.link, m.parent_id, m.img, e.element
      FROM jos_menu AS m
      LEFT JOIN jos_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.client_id = 1
      AND e.enabled = 1
      AND m.id > 1
      ORDER BY m.lft
I cant see any related message. SInce this is really annoying - Any idea how i can help you further to investigate ?

Is there a way to revert back to the old version without destroying my image database ? I have more than 17.000 images online by now and would not like to loose them. It was a lot of work :x

Here is an image of one of my categories incl. sub-categories:

Image

The white rectangles are unclickable - they contain uploaded images (after the update to 3.0.0)

Edit - My system:

Joomla 1.6.4
Strato root Server with OpenSuse 11.x
All the latest updates installed
Last edited by mediaLinux on 07 Jul 2011, 13:31, edited 1 time in total.
mediaLinux
Phoca Newbie
Phoca Newbie
Posts: 8
Joined: 08 Jun 2011, 13:39

Re: After Update 2.x to 3.0.0 - No Thumbnails anymore

Post by mediaLinux »

Update:

I removed all Phoca components, modules and plugins from my system except Phoca Gallery and the german language file. But it doesnt change anything. As soon as i add new images to any category this category becomes unaccessible (white rectangle) and no thumbs are shown. No error is reported. What can i do ?
User avatar
Benno
Phoca Hero
Phoca Hero
Posts: 9984
Joined: 04 Dec 2008, 11:58
Location: Germany
Contact:

Re: After Update 2.x to 3.0.0 - No Thumbnails anymore

Post by Benno »

Hi,
After Update 2.x to 3.0.0 - No Thumbnails anymore
Das Problem ist, Phoca Gallery 3.0.0 ist kein Update für Phoca Gallery 2.x.x
Das sind völlig unterschiedliche Systeme, weil joomla v1.5 und v1.6 ebenfalls völlig unterschiedlich sind....
Deshalb operiert Jan auf der PG-Downloadseite https://www.phoca.cz/download/category/1 ... -component mit den Symbolen:
Image für joomla v1.5
und
Image für joomla v1.6
Ich kann nur hoffen, das Du vor dem Update ein komplettes Backup von Datenbank und joomla 1.5 files angelegt hast. :idea:

Freundliche Grüße,
Benno
mediaLinux
Phoca Newbie
Phoca Newbie
Posts: 8
Joined: 08 Jun 2011, 13:39

Re: After Update 2.x to 3.0.0 - No Thumbnails anymore

Post by mediaLinux »

Hallo

Die Antwort kapier ich nicht. Wo habe ich den was von Joomla 1.5 gesagt ? Ich verwende ausschliesslich Joomla 1.6.4 auf allen gehosteten Websites, wie auch von mir oben erwähnt. Und PG 2.xx liess sich problemlos auf 3.0.0 updaten ! Die Software hat es ja selber erkannt und ein Update vorgenommen inkl. Datenbank. Und - alles funktioniert ja problemlos mit den alten Bildern. Ich konnte ja nur keine neuen Bilder hinzufügen.

Das Problem habe ich heute aber selber gelöst - nach der Installation von ImageMagick bzw. GraphicMagick funktionieren sowohl das Thumbnail erstellen als auch alle anderen Funktionen wieder. Wäre nur toll gewesen, wenn PG irgendeine Fehler- oder Warnmeldung dazu generiert hätte, dann hätte ich mir ein tagelanges Suchen ersparen können.

Davon abgesehen habe ich damals auch problemlos von Joomla 1.5 auf 1.6 aktualisieren können, das nur mal am Rande erwähnt. Und Backups lege ich grundsätzlich täglich sowohl vom root-Server als auch vom Joomla-System an. Wer das nicht macht, hat im Internet als Seitenbetreiber nichts zu suchen :wink:
User avatar
Jan
Phoca Hero
Phoca Hero
Posts: 49190
Joined: 10 Nov 2007, 18:23
Location: Czech Republic
Contact:

Re: [Solved] After Update 2.x to 3.0.0 - No Thumbnails anymo

Post by Jan »

Ok
If you find Phoca extensions useful, please support the project
Post Reply