Announcement

#1 2014-10-24 04:11:03

Murray
Member
2014-10-23
3

Menalto2Piwigo fails on import - "No Menalto tables found!" - windows

Hello,

Running the latest wampserver in windows 8.1 64, with Piwigo, and Menalto2Piwigo 2.7.a.
I am positive my credentials are correct to get into the database, but I get the error "No Menalto tables found!" in red at the top after I click Start Import.  I've double checked the database name and prefixes, and it all appears correct.  Same in IE or Chrome.
Any ideas of what to try next?

Thanks.

Piwigo version: 2.7.1
PHP version: 5.5.12
MySQL version: 5.6.17
Piwigo URL: http://

Offline

 

#2 2014-10-24 09:30:05

flop25
Piwigo Team
2006-07-06
6965

Re: Menalto2Piwigo fails on import - "No Menalto tables found!" - windows

Hello
Are your tables from menalto using a custom prefix?


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#3 2014-10-24 14:23:59

Murray
Member
2014-10-23
3

Re: Menalto2Piwigo fails on import - "No Menalto tables found!" - windows

From the input form:

database host: localhost
database name: gallery2home
database user: root
database password:  (it's a private server with no password on root in mysql)
table prefix: g2_
column prefix (useless on Gallery3): g_


From the mysql console:  You can see the proper table and column prefixes.

mysql> use gallery2home
Database changed
mysql> show tables;
+--------------------------+
| Tables_in_gallery2home   |
+--------------------------+
| g2_accessmap             |
| g2_accesssubscribermap   |
| g2_albumitem             |
| g2_animationitem         |
| g2_cachemap              |
| g2_childentity           |
| g2_comment               |
| g2_customfieldmap        |
| g2_dataitem              |
| g2_derivative            |
...

mysql>  select * from g2_accessmap;
+----------------+-----------------+--------------+
| g_accessListId | g_userOrGroupId | g_permission |
+----------------+-----------------+--------------+
|         238235 |               3 |            4 |
|         346860 |               3 |   2147483647 |
|         346860 |               4 |         4615 |
|         346860 |               6 |   2147483647 |
|         335339 |               6 |   2147483647 |
|         335339 |               4 |         4103 |
|         335339 |               3 |   2147483647 |
|         397985 |               3 |            4 |
|         331953 |               3 |   2147483647 |
|         331953 |               4 |         4103 |
+----------------+-----------------+--------------+
10 rows in set (0.00 sec)

Is there a way to turn on logging for Menalto2Piwigo?

Thanks

Offline

 

#4 2014-10-24 15:05:44

flop25
Piwigo Team
2006-07-06
6965

Re: Menalto2Piwigo fails on import - "No Menalto tables found!" - windows

author notified


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

#5 2014-10-27 23:35:10

fondy
Member
Norway
2014-10-27
15

Re: Menalto2Piwigo fails on import - "No Menalto tables found!" - windows

Hi, I got the same error as Murray on windows 2008 server

My data:

Menalto2Piwigo 2.7.a
Windows 2008 server 64-bit
Piwigo version: 2.7.1
PHP version: 5.5.15
MySQL version: 5.6.20
Piwigo URL: http://

Last edited by fondy (2014-10-29 16:54:15)

Offline

 

#6 2014-10-30 17:09:37

fondy
Member
Norway
2014-10-27
15

Re: Menalto2Piwigo fails on import - "No Menalto tables found!" - windows

Tested the import on a linux server, got same error:

No Menalto tables found!

Data:

Gallery 2 version: 2.3.2
Menalto2Piwigo 2.7.a
Piwigo version: 2.7.1
Apache version    2.4.9
PHP version    5.3.28
MySQL version    5.5.37-cll
Operating system linux

Offline

 

#7 2014-10-30 19:53:30

fondy
Member
Norway
2014-10-27
15

Re: Menalto2Piwigo fails on import - "No Menalto tables found!" - windows

I think this is about large characters and small characters in admin.php

In line 140 in admin.php:

  if (in_array($pt.'FileSystemEntity', $menalto_tables))

Change FileSystemEntity to filesystementity

In admin.php I changed all tablenames and column names to small characters

Before I changed, I got the error, see attached file error1

After I changed, the script ran but with some other errors, see attached file error2

Hope somebody can take a look, I am not a php expert :)


Uploaded Images

Offline

 

#8 2014-10-31 05:15:33

Murray
Member
2014-10-23
3

Re: Menalto2Piwigo fails on import - "No Menalto tables found!" - windows

Well, I made the one change to "filesystementity" and my import worked!

Thanks for the help.

Murray

Offline

 

#9 2014-10-31 10:37:27

fondy
Member
Norway
2014-10-27
15

Re: Menalto2Piwigo fails on import - "No Menalto tables found!" - windows

Good to hear that it worked for you.

Still problem for me :(

Offline

 

#10 2014-11-01 22:51:33

Paal
Guest

Re: Menalto2Piwigo fails on import - "No Menalto tables found!" - windows

Hi, difficult to get answers on this forum. Use several Gallery 2 and 3 today and planned to migrate to piwigo becauseaq og the migration tool. But now I am unsure because of feedback

 

#11 2015-03-23 14:38:55

edwards
Guest

Re: Menalto2Piwigo fails on import - "No Menalto tables found!" - windows

Hi,

I have the same error message:

No Menalto tables found!

I guess this is a custom prefix for tables?!

mysql> show tables;
+-----------------------+
| Tables_in_gallery3    |
+-----------------------+
| access_caches         |
| access_intents        |
| caches                |
| comments              |
| failed_auths          |
| g2_maps               |
| graphics_rules        |
| groups                |
| groups_users          |
| incoming_translations |
| items                 |
| items_tags            |
| logs                  |
| messages              |
| modules               |
| outgoing_translations |
| pending_notifications |
| permissions           |
| search_records        |
| sessions              |
| subscriptions         |
| tags                  |
| tags_gpses            |
| tasks                 |
| themes                |
| user_access_keys      |
| user_access_tokens    |
| users                 |
| vars                  |
| watermarks            |
+-----------------------+
30 rows in set (0.00 sec)

Please advise. Thank you.

 

Board footer

Powered by FluxBB

github twitter facebook google+ newsletter Donate Piwigo.org © 2002-2019 · Contact