And indeed, I have no table named :
- g2_Comment
- comment
- g2_sessions
- sessions

The fix you just added was put minutes after my test, so no, I had not this patch included in my test.

Now, with it, here is the result (you already answered the question of the existence of the table) :

Warning: [mysql error 1146] Table 'gal2.g2_Comment' doesn't exist

SELECT
    c.g_parentId AS id,
    t.g_subject AS subject,
    t.g_comment AS comment,
    t.g_author AS author,
    FROM_UNIXTIME(t.g_date) AS date
  FROM g2_ChildEntity c
    JOIN g2_Comment t ON t.g_id = c.g_id
  WHERE t.g_publishStatus=0
in /home/sites/lvv-pw-ssl/include/dblayer/functions_mysqli.inc.php on line 830

Fatal error: Call to a member function fetch_assoc() on a non-object in /home/sites/lvv-pw-ssl/include/dblayer/functions_mysqli.inc.php on line 211

Warning: [mysql error 1146] Table 'gal2.sessions' doesn't exist

REPLACE INTO sessions
  (id,data,expiration)
  VALUES('C0A8pcun49nj3s2hob8lb6l8o4i7n0','pwg_device|s:7:\"desktop\";pwg_mobile_theme|b:0;pwg_show_metadata|b:1;pwg_uid|i:1;pwg_multiview|a:8:{s:7:\"view_as\";s:1:\"1\";s:5:\"theme\";s:19:\"stripped_black_bloc\";s:4:\"lang\";s:5:\"fr_FR\";s:12:\"show_queries\";b:0;s:10:\"debug_l10n\";b:0;s:14:\"debug_template\";b:0;s:22:\"template_combine_files\";b:1;s:10:\"no_history\";b:0;}need_update|b:0;extensions_need_update|a:0:{}',now())
; in /home/sites/lvv-pw-ssl/include/dblayer/functions_mysqli.inc.php on line 830

Hi plg,
tested this now and still got a few error messages but no idea if they could be ignored.


Notice: Undefined variable: comment_inserts in /<path to Webspace>/piwigo/plugins/menalto2piwigo/admin.php on line 371

Warning: array_keys() [function.array-keys]: The first argument should be an array in /<path to Webspace>/piwigo/plugins/menalto2piwigo/admin.php on line 371

Notice: Undefined variable: comment_inserts in /<path to Webspace>/piwigo/plugins/menalto2piwigo/admin.php on line 373

Warning: Cannot modify header information - headers already sent by (output started at /<path to Webspace>/piwigo/plugins/menalto2piwigo/admin.php:371) in /<path to Webspace>/piwigo/include/page_header.php on line 101


---
El

I hope it is proper for me to post in this thread the SQL errors I am encountering while trying to migrate from Gallery 3 to Piwigo.  I know the FAQ is for "gallery 2", but I've also read that the Menalto2Piwigo plugin has been updated to work with Gallery 3 as well.  In addition, though the errors I am sharing seem to be related to errors others have posted, they are not exactly the same.  If I need to post elsewhere please kindly let me know.  I am looking for any assistance to try to get through this process without the errors.

Menalto2Piwigo version 2.7.a
Piwigo version 2.7.2
Gallery 3 version 3.0.9

In case it's an issue, I enabled the LocalFiles Editor plugin and added the following line to enable some special characters in my filenames.  I also removed all the apostrophes from the filenames of all photos because they caused MySQL errors during the process.  (As I'm typing this I'm wondering if doing that without somehow updating the Gallery 3 database may be the root of my problem?)

LocalFiles Editor:
$conf['sync_chars_regex'] = '/^[a-zA-Z0-9-_.&, !]+$/';

The errors I am receiving:

Notice: Undefined variable: comment_inserts in /var/apache/piwigo/plugins/menalto2piwigo/admin.php on line 579

Warning: array_keys() expects parameter 1 to be array, null given in /var/apache/piwigo/plugins/menalto2piwigo/admin.php on line 579

Notice: Undefined variable: comment_inserts in /var/apache/piwigo/plugins/menalto2piwigo/admin.php on line 581

Notice: Undefined variable: image_tag_inserts in /var/apache/piwigo/plugins/menalto2piwigo/admin.php on line 619

Warning: array_keys() expects parameter 1 to be array, null given in /var/apache/piwigo/plugins/menalto2piwigo/admin.php on line 619

Notice: Undefined variable: image_tag_inserts in /var/apache/piwigo/plugins/menalto2piwigo/admin.php on line 621

Last edited by Gork (2014-11-24 10:35:42)

You actually got the apostrophe to work in the end with a migration?!  Or do you just mean that's the hardest one to fix in the Piwigo code?

After my last post I downloaded commit 41973f0668 from GIT and ran it atop of what I had already done.  It didn't come back with any SQL errors, but the result is that I have several photos which don't show up in the Piwigo gallery; I only get the ! in a triangle.  Some of these I can click on to see the underlying photos, and others I cannot.

Should just changing the filenames of the photos to remove the apostrophes cause any problems with the migration?

I'll start from scratch again with 2.7.b when I get a chance and post the results.

Virtualize...  Yes, I am one of those Gallery people who really want to have my naming convention intact.  Reason is, if I set everything up for Piwigo and it goes the way Menalto did I'm no longer left with something I may be able to easily import into another similar gallery program.  And if I one day have to go back to static web pages of my own design, possibly losing descriptions would be bad enough, but losing descriptive filenames in descriptive directories would be the end of the organization of my photos. :(  Heck, I have a lot of old digitized photos with no EXIF data - if I lost the filenames I'd lose the dates.

Ahh, so it would appear the missing thumbnails are probably caused by non-Piwigo-standard characters then.  When I click on missing thumbnails, most of the ones I've tested so far take me to the actual photo.  But not all.

Thanks for sharing the change to the code which allowed you to use apostrophes!  I'm trying to decide if I'm going to try to incorporate that or wait until the change is available in a normal Piwigo upgrade.  If I make the changes manually would an automatic Piwigo upgrade still work properly afterwards?

I tried installing 2.7.b and running it over what I'd already done with the commit version (probably the same thing.)  No change.  But I don't think I'll be trying the process from scratch again tonight.  It doesn't sound like it will change anything but we shall see when I get a chance to try again.

EDIT:
Looks like my biggest problem with the thumbnails being generated properly is the ampersand (&) character.  I still haven't figured out what character might be causing the photos to not display on some of these bad thumbnail entries though.

Last edited by Gork (2014-11-24 12:39:34)

wsloand wrote:

I just tried the new version, and I'm getting a similar error:

Part of what you posted looks like it could be from file/folder names with apostrophes.  Do any of your file or folder names contain apostrophes?  If so, see my post above for the solution I used and @plg's post for a more eloquent solution.

The current Git is exactly the same as plugin version 2.7.b (just look at file pem_metadata.txt in your plugin).

I contact you by email.