menalto2piwigo's People
menalto2piwigo's Issues
Import from G3 fails when importing comments
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
avoid tag duplicates
If the photo in Piwigo already has a tag, no need to create a new tag from Menalto.
inconsistent relation in G2 causes warning on conversion to Piwigo
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
compatibility Piwigo 12
Is this extension going to be made compatible?
Unable to run script
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
Author of comments
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.
Out of range value for column 'rank'
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
undefined variable comment_inserts and image_tag_inserts
When we don't find any comment or tag, we must not try to insert in Piwigo database.
missing $parentId crashes SQL query
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.
less SQL queries and more reliable matching algorithm
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.
get undefined variable errors
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
Fresh install gives "invalid section token [menalto2piwigo]"
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
import tags from Menalto Gallery 2
For now, menalto2piwigo only imports tags from Gallery 3, let's import Gallery 2 "keywords" into Piwigo tags.
imported picures id map table (future request)
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.
missing table g2_Comment
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...
Migrate Users, Groups and Permissions
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 ;-)
Small suggestion
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).
Import from MS Sql over to MY Sql.
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.
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.