Hi,
I got the error below when running the menalto2piwigo extension just now. The issue appears to be that menalto gallery2 identified raw files (CR2) as images while piwigo does not. I had previously updated the $conf['picture_ext'] variable to include 'CR2' and 'cr2' hoping that since ImageMagick supports CR2 (via dcraw), that would work.
Having looked a bit more, it appears that piwigo doesn't support raw files. Without diving into the raw files or not issue here, I wonder if it's possible to work around this issue I have with the conversion where gallery treats a file as an image and piwigo doesn't (so the conversion fails).
Thank you,
Bill
Notice: Undefined variable: piwig_id in /var/www/piwigo/plugins/menalto2piwigo/admin.php on line 207
Error, is not an image and Menalto says it is an image
Warning: [mysql error 1064] You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND f.g_pathComponent='IMG_2274.CR2'' at line 16
SELECT
f.g_id,
i.g_title,
i.g_summary,
i.g_description,
i.g_canContainChildren,
a.g_orderWeight,
a.g_viewCount,
FROM_UNIXTIME(e.g_creationTimestamp)
FROM g2_Item i
JOIN g2_FileSystemEntity f ON i.g_id = f.g_id
JOIN g2_ChildEntity c ON f.g_id = c.g_id
JOIN g2_ItemAttributesMap a ON i.g_id = a.g_itemId
JOIN g2_Entity e ON e.g_id = i.g_id
WHERE c.g_parentId =
AND f.g_pathComponent='IMG_2274.CR2'
; in /var/www/piwigo/include/dblayer/functions_mysqli.inc.php on line 830
Fatal error: Call to a member function fetch_row() on a non-object in /var/www/piwigo/include/dblayer/functions_mysqli.inc.php on line 216
Warning: [mysql error 1146] Table 'gallery2.piwigo_sessions' doesn't exist
REPLACE INTO piwigo_sessions
(id,data,expiration)
VALUES('[redacted]','pwg_uid|i:1;pwg_device|s:7:\"desktop\";pwg_mobile_theme|b:0;need_update|b:0;extensions_need_update|a:0:{}bulk_manager_filter|a:1:{s:9:\"prefilter\";s:11:\"last_import\";}incompatible_plugins|a:1:{s:10:\"~~expire~~\";i:1416187668;}',now())
; in /var/www/piwigo/include/dblayer/functions_mysqli.inc.php on line 830
Piwigo version: 2.7.1
PHP version: 5.5.9-1ubuntu4.5
MySQL version: 5.5.40-0ubuntu0.14.04.1
Piwigo URL: http:// (not yet public)
Last edited by wsloand (2014-11-17 04:21:51)
Offline
Had the same Problem when I start my migration last week. Searching this forum found
http://piwigo.org/forum/viewtopic.php?id=17893&p=2
Looking at comment #19 show the fix.
After I added this ticks this worked for me.
El
Offline
Thanks very much for this pointer. I'll post my subsequent questions into that forum topic.
Bill
Offline