#5639 – Can't import JoomSEF data

Hi

Reading the doc, I understood that the imported tables have to be on the same server as the target tables, but reading some older tickets, it seems that the site has to be on the same server as the database. Is that correct?

Yes, the server has to be the same. The original data can be on a separate database but on the same database server as the one Joomla is connecting to. We can only connect to the database through Joomla, so the current site mysql server is the only one we have access to.

However, there can be several databases on that server and the JoomSEF tables can be in another database. The first option in the settings on the JoomSEF import tab is "Source database" and it will list which databases the importer can access. JoomSEF tables must be in one of those databases.

If so, that's why it is not working on my dev site since the site is not on the same server as the database.

Yes.

But I moved then on localhost (using MAMP PRO on Mac) and I have the same problem so, what should I do?

Copy the JoomSEF tables from the original server to the new ones using PHPMyadmin for instance. You do not need JoomSEF at all, just the db tables.

Best regards

Hi

It should not be there might be many additional reasons for that. I would suggest:

- set Joomla error reporting to maximum
- check your PHP log for any error that could be related to the importer plugin.

Best regards

Hi

No PHP error but the console reports an error in "bundle.min.js"

What kind of error? Exactly?

Best regards

HI

OK, the importer is a little piece of convenience software, it does not have much in terms of error reporting. Could you please provide us with superadmin credentials to your website. You can create a temporary account, and delete it afterward, but it must have superuser level.

Thanks and regards

Hi

Like I said, the message is a bit generic as the extension is just a convenience. I found that there's actually no error, simply the plugin does not find any data to import:

{"success":true,"message":null,"messages":null,"data":[{"id":"a802e0f8d74b12cd9c5ba4085418594add2afe06","next_step":"continue","data_type":"","done":{"url":0,"meta":0,"redir":0,"alias":0},"processed":{"url":0,"meta":0,"redir":0,"alias":0},"total":{"url":"6392","meta":"6392","redir":"970","alias":"0"}}]}

It says there are 6392 URLs and 970 redirections in total ("total":{"url":"6392","meta":"6392","redir":"970","alias":"0"}), but it did not process any of them ("processed":{"url":0,"meta":0,"redir":0,"alias":0})

I would need to dig further but I can't do that on a remote site. Can you export the content of the JoomSEF DB tables to a .sql file (with PHPMyadmin or similar), zip them and upload them to that [private online folder].

I can them load them on a local machine and see why no URL qualifies for import more easily.

Best regards

Hi,

The data import fines for me:



Next step is that I take an akeeba backup of the site and run the import on the actual site. You do not run many plugins that could interfere (and I tried disabling some of them) but we are now left with only 2 options:

- some extension on the site
- the server (ie php setup)

OK?

Best regards

Hi

It should not have any effect although it's always worth a try. I'll do the backup anyway.

Best regards

Hi,

So it's something on the server: the restored akeeba backup imports fine! I'm not sure what's happening to be honest, all of this is pretty simple code, there's nothing special to it.

The only difference with my local setup are:

- MariaDB version is 5.5.5 on your server while I'm using MySQL 5.6 (and on my way to upgrade to 5.7). However the version number is strange it says "5.5.5-10.0.35". So not sure exactly which version you're running. I've never used MariaDb but as far as I know, it's fully compatible with MYSQL.
WOuld be worth checking the MYSQL error log if you can access.

- PHP is the same
- If you have any firewall, security extension on the server, maybe try disabling that or at least checking the logs.

Maybe a workaround at this stage would be to copy the site onto another server and import the sh404SEF tables back. As I have done just that, I have uploaded a zipped SQL dump of those tables into the same online folder. You can download the file there and import into your database, that should do the trick for now.

Best regards

Hi

I'd appreciate if you have a successful import in sh404SEF tables that you could send me. I will do the tests later and let you know.

See my previous message:

As I have done just that, I have uploaded a zipped SQL dump of those tables into the same online folder. You can download the file there and import into your database, that should do the trick for now.

Best regards

i

You're welceom. Very strange that you have the same issue locally. I'm on windows so no MAMP for me but if ALMP settings made a difference, you would see an error in PHP logs and/or MYSQL logs. I'll try again on an online server, ie linux.

Best regards

Hi,

Tried on a linux server but did not have any issue. I will leave this ticket open in case you need to add something. It will automatically close in 2 weeks if no further comment is made.

Best regards