plegall / menalto2piwigo Goto Github PK

Hi,

When trying to import from G3, I get the following error:

Warning:  [mysql error 1048] Column 'anonymous_id' cannot be null

INSERT  INTO piwigo_comments
  (image_id,date,author,author_id,anonymous_id,email,website_url,content,validated)
  VALUES('7','2004-01-22 11:34:54','Anonymous coward','2',NULL,'[email protected]',NULL,'Steve\nNo toilet paper??','true')
  , ('7','2005-01-25 12:41:25','Anonymous coward','2',NULL,'[email protected]',NULL,'Administrator (admin)\nWhy do you think we don\'t live there anymore? ;)','true')
  , ('8779','2005-01-24 22:56:56','Anonymous coward','2',NULL,'[email protected]',NULL,'Grandpa and Grandma\nThese are my very best friends. They always feed me.','true')
  , ('8780','2005-01-24 22:57:44','Anonymous coward','2',NULL,'[email protected]',NULL,'Grandpa and Grandma\nThis young man loves to read to me. One day, mayve I will read to him!','true')
  , ('8782','2005-01-24 22:59:00','Anonymous coward','2',NULL,'[email protected]',NULL,'Grandpa and Grandma\n Here I am again with the \"gang\".   Boy, they sure are fun. ','true')
  , ('8786','2005- in /var/www/content/piwigo/include/dblayer/functions_mysqli.inc.php on line 845

If I comment out the comment section in admin.php, the rest of the import passes OK

If the photo in Piwigo already has a tag, no need to create a new tag from Menalto.

Sometimes in G2, we have an item set as highlighted picture for an album and this item does not exist in table FileSystemEntity => we get warnings like this

Notice: Undefined index: 371 in plugins/menalto2piwigo/admin.php on line 299

Is this extension going to be made compatible?

Hi,

I just wanted to run your script to import a lot of pictures from an old gallery v2 but it failed.

Warning:  [mysql error 1054] Unknown column 't.galsp_publishStatus' in 'where clause'

SELECT
    c.galsp_parentId AS id,
    t.galsp_subject AS subject,
    t.galsp_comment AS comment,
    t.galsp_author AS author,
    FROM_UNIXTIME(t.galsp_date) AS date
  FROM gal2_ChildEntity c
    JOIN gal2_Comment t ON t.galsp_id = c.galsp_id
  WHERE t.galsp_publishStatus=0
 in /www/htdocs/--installdir--/include/dblayer/functions_mysqli.inc.php on line 845


Fatal error: Call to a member function fetch_assoc() on a non-object in /www/htdocs/--installdir--/include/dblayer/functions_mysqli.inc.php on line 226

Warning:  [mysql error 1146] Table 'v036531.pxF2M_sessions' doesn't exist

REPLACE INTO pxF2M_sessions
  (id,data,expiration)
  VALUES('2E05ac9d2620ea1c4dd5efb450e8fb376ebf','pwg_device|s:7:\"desktop\";pwg_mobile_theme|b:0;community_user_permissions|a:9:{s:20:\"upload_whole_gallery\";b:1;s:20:\"create_whole_gallery\";b:1;s:10:\"user_album\";b:0;s:17:\"create_categories\";a:10:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;i:8;i:9;i:9;i:10;}s:17:\"upload_categories\";a:10:{i:0;i:1;i:1;i:2;i:2;i:3;i:3;i:4;i:4;i:5;i:5;i:6;i:6;i:7;i:7;i:8;i:8;i:9;i:9;i:10;}s:14:\"permission_ids\";a:1:{i:0;s:1:\"1\";}s:9:\"nb_photos\";i:-1;s:7:\"storage\";i:-1;s:17:\"community_enabled\";b:1;}community_cache_key|s:20:\"hxvLEcAWrFQIQ2TU2QBH\";community_user_id|s:1:\"1\";pwg_referer_image_id|s:1:\"9\";pwg_uid|i:1;pwg_multiview|a:8:{s:7:\"view_as\";s:1:\"1\";s:5:\"theme\";s:16:\"bootstrapdefault\";s:4:\"lang\";s:5:\"de_DE\";s:12:\"show_queries\";b:0;s:10:\"debug_l10n\";b:0;s:14:\"debug_template\";b:0;s:22:\"template_combine_fi in /www/htdocs/---installdir---/include/dblayer/functions_mysqli.inc.php on line 845

Some infos about the system (Apache, PHP 7.0, MySQL 5.7):

Piwigo dbname is d0254d7b
Gallery dbname is v036531

First error

Where is galsp_publishStatus located?

gal2_ChildEntity:
1 galsp_i
2 galsp_parentId

gal2_Comment:
1 galsp_id
2 galsp_commenterId
3 galsp_host
4 galsp_subject
5 galsp_comment
6 galsp_date
7 galsp_author

Second error

Seems the scripts wants all tables in one database?
v036531.pxF2M_sessions doesn't make sense...

Any hints for me?

Thanks,

Ralf

In my Gallery2 installation the column g_author is always empty and so it is migrated to an empty author column in Piwigo. The authors names (and emails) can be fetched from the g2_User table using the g_commenterId column from the comments. Maybe this can be integrated in the plugin for a smoother migration.

When running the script I get a MySQL error 1264 about the rank being out of bounds.
I can see that the rank is supposed to fit in a unsigned smallint and that it's coming from the orderWeight in the menalto database. The problem is that I have 2576 items in the database with an orderweight above 65535, with the highest reaching 416000.

How do I solve this? Scaling the values to fit in a smallint or maybe just limiting the orderWeight to 65535, but that will lead to multiple items with the same rank in the piwigo database.

I'll try these things out and report back.

My error message is below in full.

Warning:  [mysql error 1264] Out of range value for column 'rank' at row 66

INSERT  INTO piwigo_categories_1522004170968049
  (id,name,comment,rank)
  VALUES('43','Argentina','Foton från de två veckorna i Argentina hösten -06','3000')
  , ('45','Estancia','Foton från enstancian El Ombu där vi tillbringade en dag','2500')
  , ('46','Iguazú','Foton från nationalparken kring Iguazú-fallen','2000')
  , ('6','Bling bling',NULL,'7000')
  , ('44','Buenos Aires','Foton från Buenos Aires','1000')
  , ('3','Mikaels och Stinas fotoalbum','Mikaels och Stinas fotoalbum','4000')
  , ('61','Helenas fotoalbum',NULL,'5000')
  , ('63','Portugal 2005','Marias och min resa till Lissabon 2005','1000')
  , ('66','Argentina 2006, estancian El Ombú de Areco',NULL,'2000')
  , ('14','iBook','Min fina, men nu lite gamla och trötta iBook. Hactar heter den.','21000')
  , ('4','Prylar',NULL,'9000')
  , ('23','Resor',NULL,'6000')
  ,  in /var/www/piwigo/include/dblayer/functions_mysqli.inc.php on line 845

When we don't find any comment or tag, we must not try to insert in Piwigo database.

On MenaltoG2 conversion (not G3), sometimes Piwigo doesn't find the appropriate parentId for an item. The SQL query then has a syntax error and crashes at execution.

The matching algorithm for Gallery2 is complicated, generates 1 SQL query for each item and error prone (due to imperfect sorting of $piwigo_paths array). It would be better to use the same kind of algorithm than for Gallery3, ie generate a big array with all Menalto items, and then loop on it to match Piwigo items.

using menalto2piwigo with piwigo 11.3 and getting undefined variables when trying to import database

Notice: Undefined variable: image_updates in /home/glasshut/public_html/products/plugins/menalto2piwigo/admin.php on line 749

Notice: Undefined variable: album_thumbs in /home/glasshut/public_html/products/plugins/menalto2piwigo/admin.php on line 767

Notice: Undefined variable: items_tags in /home/glasshut/public_html/products/plugins/menalto2piwigo/admin.php on line 804

Warning: Invalid argument supplied for foreach() in /home/glasshut/public_html/products/plugins/menalto2piwigo/admin.php on line 804

Hi,
I just installed piwigo and wanted to use the plugin menalto2piwio. The plugin installs correctly but when I try to open it from the admin panel, the error

invalid section token [menalto2piwigo]

is shown.
System is Apache, PHP 7.1, MySQL. Any other info required?

Thanks
Roman

For now, menalto2piwigo only imports tags from Gallery 3, let's import Gallery 2 "keywords" into Piwigo tags.

Please implement an picture ID map table for the import.
For example you could create a file called "menalto2piwigo.log" where to put something like this:
774 291
781 292
first number is the picture ID corresponding to menalto and the second is the picture ID corresponding to piwigo.

This kind of map will help in case we have embedded links with menalto pictures in another software (wordpress, phpbb3, etc) and you switch to piwigo gallery.
Based on that generated map we could build a tool that replace in the database the old menalto links (broken) with the new links to piwigo, corresponding to the same image.

In Gallery2, table g2_Comment is not always there (you need to activate an option). Let's make sure we don't try to query a missing table...

Hi,
currently,the migration does not include the security related options like Users, Groups and Permissions.
Is there a special (technical) reason to this (besides the all-known time issue) .
What steps do you think would be necessary to include that to the script?
I'd be happy to help where I can ;-)

First, thank you very much for writing this plug-in, it worked great but there was one piece where I screwed up. I didn't notice that you said g2data/albums and I copied everything in g2data. Totally my fault, but it seems like an easy mistake to make (I am not a newbie).

So, the suggestion is to catch if they have copied the albums directory instead of its contents and give an error. What happens now is that your script throws a half-dozen errors, none of which helped me to figure out what I had done, and made a mess in the Piwigo database. In the end I scrapped the whole migration and did it again realizing what had gone wrong.

Also, strangely, I got some strange (virtual) albums created that I could not get rid of (I had to go into the database to delete them). I think they were all called "model" or something (I forgot what they were called and they're completely gone now).

Thanks again for writing this. It saved my bacon. As a future idea, if you want to write another plug-in, it seems like Piwigo really needs a plug-in to physically move albums. I don't really understand why they don't support this. I may take a shot at writing this myself, but I'm sure you would be faster (or could tell me why it's so difficult).

This is not a bug but something I hope can be done. I currently have a G2 site that is v2.3 but is on a MS Sql DB. I want to get it moved over to Piwigo which is on a MY Sql DB. It seems that the plugin does not communicate with the MS Sql even those the connection strings are correct.

Any chance to provide or assist with this matter if at all possible?

Thank you.