Announcement

#1 2014-11-17 04:21:29

wsloand
Member
2014-11-17
31

menalto2piwigo:

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

 

#2 2014-11-17 11:01:13

ElBundy
Member
2014-11-17
6

Re: menalto2piwigo:

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

 

#3 2014-11-17 12:44:53

wsloand
Member
2014-11-17
31

Re: menalto2piwigo:

Thanks very much for this pointer.  I'll post my subsequent questions into that forum topic.

Bill

Offline

 

Board footer

Powered by FluxBB

github twitter facebook google+ newsletter Donate Piwigo.org © 2002-2019 · Contact