Hi frumpel,

I confirm there is currently no migration tool to convert a Menalto Gallery into Piwigo.

As far as I know, Menalto Gallery has a remote API, so it means that Piwigo may import data from Menalto. It could be a good plugin for Piwigo! (since a few Menalto Gallery users are switching to Piwigo)

Hi DSchwen,

Yes, I'm highly interested, and I read Perl fluently :-)

The request "how can I migrate from Menalto Gallery to Piwigo?" occurs at least once a week!

on albums, you can have a name and a description and with plugin Extended Description you can set description as :

short description <!--complete--> long description

(see http://piwigo.com/blog/2011/11/24/album … ne-tuning/ )

For photos, you only have name + description.

Quick question, you have rank and global_rank columns in the db. Can I just dump arbitrary numbers into rank, or do I have to update the global_rank column accordingly?

I don't code so be gentle....

I believe that a change by PLG to the script has broken it. Referring below, gallery2 table column names have a g_ prefix thus the $opt{'menalto-prefix'} (referring to the table name prefix) substitution is wrong. I did not get things working by changing $opt{'menalto-prefix'} where it seemed appropriate (knowing appropriate is the issue:-)  but the script runs by copying back dschwen's original block o' code. There are 3 points in the script where this error exists.

-    SELECT 
-      f.g_id, i.g_title, i.g_summary, i.g_description, i.g_canContainChildren, a.g_orderWeight, a.g_viewCount 
-    FROM 
-      g2_FileSystemEntity f, g2_ChildEntity c, g2_Item i, g2_ItemAttributesMap a 
-    WHERE 
-      i.g_id = f.g_id AND 
-      f.g_id = c.g_id AND 
-      i.g_id = a.g_itemId AND
-      c.g_parentId = ".$db1->quote($parentId)." AND 
-      f.g_pathComponent=".$db1->quote($path[$level-1]).";
-    ";

+SELECT 
+    f.".$opt{'menalto-prefix'}."id,
+    i.".$opt{'menalto-prefix'}."title,
+    i.".$opt{'menalto-prefix'}."summary,
+    i.".$opt{'menalto-prefix'}."description,
+    i.".$opt{'menalto-prefix'}."canContainChildren,
+    a.".$opt{'menalto-prefix'}."orderWeight,
+    a.".$opt{'menalto-prefix'}."viewCount,
+    FROM_UNIXTIME(e.".$opt{'menalto-prefix'}."creationTimestamp)
+  FROM ".$opt{'menalto-prefix'}."Item i
+    JOIN ".$opt{'menalto-prefix'}."FileSystemEntity f ON i.".$opt{'menalto-prefix'}."id = f.".$opt{'menalto-prefix'}."id
+    JOIN ".$opt{'menalto-prefix'}."ChildEntity c ON f.".$opt{'menalto-prefix'}."id = c.".$opt{'menalto-prefix'}."id
+    JOIN ".$opt{'menalto-prefix'}."ItemAttributesMap a ON i.".$opt{'menalto-prefix'}."id = a.".$opt{'menalto-prefix'}."itemId
+    JOIN ".$opt{'menalto-prefix'}."Entity e ON e.".$opt{'menalto-prefix'}."id = i.".$opt{'menalto-prefix'}."id
+  WHERE c.".$opt{'menalto-prefix'}."parentId = ".$db1->quote($parentId)."
+    AND f.".$opt{'menalto-prefix'}."pathComponent=".$db1->quote($path[$level-1])."
+;";

Great work. Quite some effort put into this.
But the beauty of Gallery2 is: the original files and dirs are preserved, so migrating by a clean install is also very well possible. The reason why I like /piwigo/galleries/ more than the /piwigo/upload/ : you can also easily access and find your photos outside Piwigo.

So what will make Gallery2 completely obsolete?

Gallery2 URLs securing/authenticating logged in users like:

http://myhost.com/gallery2/main.php?g2_view=core.DownloadItem&g2_itemId=47392&g2_serialNumber=4

Hope to see this also in Piwigo, like:

http://myhost.com/piwigo/action.php?id=123456&part=th

or

http://myhost.com/piwigo/i.php?id=123456&part=th

with proper authentication.

So in the end Piwigo is as secure as Gallery2!

Hi,

I've been following the steps outlined in the Menalto2Piwigo plugin.  Upon executing the last Import step, it results in the following page with a bunch of warnings and errors.  Could someone take a look and let me know if you need anything else?

Notice: Undefined variable: piwig_id in /var/www/mysite.com/htdocs/piwigo/plugins/menalto2piwigo/admin.php on line 195
Error, is not an image and Menalto says it is an image
Notice: Undefined variable: piwig_id in /var/www/mysite.com/htdocs/piwigo/plugins/menalto2piwigo/admin.php on line 195
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='Image01'' 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='Image01'
; in /var/www/mysite.com/htdocs/piwigo/include/dblayer/functions_mysqli.inc.php on line 798


Fatal error: Call to a member function fetch_row() on a non-object in /var/www/mysite.com/htdocs/piwigo/include/dblayer/functions_mysqli.inc.php on line 186


Warning:  [mysql error 1146] Table 'g2-to-g3.piwigo_sessions' doesn't exist

REPLACE INTO piwigo_sessions
  (id,data,expiration)
  VALUES('AC05de2lb0q7663npo3i18vl33jjr0','pwg_device|s:7:\"desktop\";pwg_mobile_theme|b:0;pwg_uid|i:1;need_update|b:0;extensions_need_update|a:0:{}',now())
; in /var/www/mysite.com/htdocs/piwigo/include/dblayer/functions_mysqli.inc.php on line 798