EnglishI am having problems migrating from my gallery 2.3 installation to piwigo on Windows 10. I am using xamp 8.0.30:
Includes: Apache 2.4.58, MariaDB 10.4.32, PHP 8.0.30, phpMyAdmin 5.2.1, OpenSSL 3.1.3, XAMPP Control Panel 3.2.4, Webalizer 2.23-04, Mercury Mail Transport System 4.63, FileZilla FTP Server 0.9.41, Tomcat 8.5.96 (with mod_proxy_ajp as connector), Strawberry Perl 5.32.1.1 Portable
I setup the database for the new xamp on port 3307 and left the old one running at 3306. So no conflicts there..piwigo and gallery 2 are running fine.
To do the migration I did:
- installed LocalFiles Editor, VideoJS, Menalto2Piwigo plugins
- copied my gallery pics and videos over to my menalto gallery:
gallery:
F:\web\GAlbums\albums\
\Album1
\Album2
\Album3
piwigo:
F:\web2\piwigo\galleries\
\Album1
\Album2
\Album3
- I ran a syncronization from piwigo and it added (almost) all of my pictures and videos.
- I put in the details for my gallery installation as:
database host: localhost:3306
database name: gallery2
database user: <user>
database password: <pw>
table prefix: g2_
column prefix (useless on Gallery3): g_
The first time I rean this it seem to start cranking but then the process timed out. Looking at my php.ini it seems I had a pretty small default timeout. I changed it to like 15min and tried to run again. I got an error: No Menalto tables found!
After several attempts to get another response than this I dropped the whole piwigo database and started over with the same process as above, including a fresh copy of piwigo. However now all I get is the "No Menalto tables found!" error no matter what I do. The gallery2 instance is still working.
Any idea what could cause this? Does Menalto2Piwigo create a log so I can see what it is trying to do? It does not seem to log status in the main piwigo log.
I do have spaces in some of my foldername and galleries..but I added the revised regex to config file. Same this with or without.
Any help would be appreciated.
Offline
Here are the printed database transactions during import.
[7]
SELECT *
FROM piwigo_user_infos
WHERE user_id = 2
;
(this query time : 0.000 s)
(total SQL time : 0.002 s)
(total time : 0.037 s)
(num rows : 1 )
[8]
SELECT COUNT(*)
FROM piwigo_caddie
WHERE user_id = 1
;
(this query time : 0.000 s)
(total SQL time : 0.002 s)
(total time : 0.052 s)
(num rows : 1 )
[9]
SELECT COUNT(*) FROM piwigo_images
(this query time : 0.000 s)
(total SQL time : 0.002 s)
(total time : 0.052 s)
(num rows : 1 )
[10]
INSERT INTO
piwigo_config (param, value)
VALUES('menalto2piwigo', 'a:6:{s:7:"db_host";s:9:"localhost";s:7:"db_user";s:4:"root";s:11:"db_password";s:6:"<password>";s:7:"db_name";s:8:"gallery2";s:12:"prefix_table";s:3:"g2_";s:13:"prefix_column";s:2:"g_";}')
ON DUPLICATE KEY UPDATE value = 'a:6:{s:7:"db_host";s:9:"localhost";s:7:"db_user";s:4:"root";s:11:"db_password";s:6:"<password";s:7:"db_name";s:8:"gallery2";s:12:"prefix_table";s:3:"g2_";s:13:"prefix_column";s:2:"g_";}'
;
(this query time : 0.000 s)
(total SQL time : 0.003 s)
(total time : 0.054 s)
(affected rows : 0 )
[11]
SELECT
id,
REPLACE(path, "./galleries/", "") AS filepath
FROM piwigo_images
WHERE path like "./galleries/%"
;
(this query time : 0.051 s)
(total SQL time : 0.054 s)
(total time : 0.106 s)
(num rows : 16190 )
[12]
SELECT
id,
dir,
uppercats
FROM piwigo_categories
WHERE site_id = 1
;
(this query time : 0.001 s)
(total SQL time : 0.055 s)
(total time : 0.114 s)
(num rows : 454 )
[13]
SELECT
id,
name
FROM piwigo_tags
;
(this query time : 0.000 s)
(total SQL time : 0.055 s)
(total time : 0.115 s)
(num rows : 0 )
[14]
SELECT @@SESSION.sql_mode
(this query time : 0.000 s)
(total SQL time : 0.055 s)
(total time : 2.179 s)
(num rows : 1 )
[15]
SHOW TABLES
;
(this query time : 0.003 s)
(total SQL time : 0.058 s)
(total time : 2.183 s)
[16]
SELECT @@SESSION.sql_mode
(this query time : 0.000 s)
(total SQL time : 0.059 s)
(total time : 2.211 s)
(num rows : 1 )
[17]
SELECT mail_address
FROM piwigo_users
WHERE id = 1
;
(this query time : 0.000 s)
(total SQL time : 0.059 s)
(total time : 2.220 s)
(num rows : 1 )
Offline