We build. You grow.

Get best community software here

Start a social network, a fan-site, an education project with oxwall - free opensource community software

Back Up Import not working. | Forum

Kevin
Kevin Oct 14 '13
Hello, I am attempting to import a back up file made with data exporter and I am of course using the data importer plug in. It says "Import in Progress.Please Wait". I have waited over night and even a few hours more. None of the plug ins have been imported yet they all say "wait import".


I did do what this message says:


Insert xitti_salt_SK750 into the ow_includes/config.php file to the OW_PASSWORD_SALT constant.


but it still won't work. I have heard that there is some value you have to put in but I do not know what value that is for oxwall.


if someone can help that'd be great.


PS.: I'm using the Site5 host.

Alia Team
Alia Oct 16 '13
Kevin,

1. Make sure that your CRON is up and running on your new Oxwall installation.

2. Have you increased  the 'maximum_execution_time' php directive value to at least 30 minutes ?

3. Log in your  control panel>>PhpMyAdmin>>find table "ow_dataimporter_import".
This tables contains data being imported. Do you see anything in the "Error" column?
Kevin
Kevin Oct 16 '13
I did that, here's the errors I get


I went ahead and setup a custom php.ini for  my account and increased the max_execution to 30 minutes and memory to 256M and the problem is still occurring:

satanici@satanicinternationalts.com [~]# grep max_exec|grep memory php.ini 
memory_limit = 256M ; Maximum amount of memory a script may consume (32MB) 
satanici@satanicinternationalts.com [~]# grep max_exec php.ini 
max_execution_time = 1800 ; Maximum execution time of each script, in seconds

I have checked the table ow_dataimporter_import and on the Error column I was able to find this:

0 /home/satanici/public_html/ow_plugins/data_importer/bol/import_service.php 269 
SQL import failed! SQL: INSERT INTO ow_blogs_post(`id`,`authorId`,`title`,`post`,`timestamp`,`isDraft`,`privacy`) VALUES( '1194','829','

The line 269 of /home/satanici/public_html/ow_plugins/data_importer/bol/import_service.php contains this information:

throw new LogicException('SQL import failed! SQL: ' . $query);

Skalfa LLC Partner
Skalfa LLC Oct 16 '13
Hello Kevin,

Thank you for your answer. It is one of the best answers ever in our  practice ( with all requested info included in reply) =)

Data Importer/Exporter are our plugins.

Two solutions:

1. Deactivate "Blogs" plugin on your Oxwall installation.
In this case all data except blogs will be imported.

2. Send us your back up file( file you have got after usingData Exporter). We will check it, apply fixes, you will try to import it again.


The Forum post is edited by Skalfa LLC Oct 16 '13
Kevin
Kevin Oct 17 '13
How do I send you the file?
Skalfa LLC Partner
Skalfa LLC Oct 18 '13
oxwallplugins@skalfa.com
Kieron H Leader
Kieron H Oct 19 '13
+1 to skalfa however when i imported my data i had to change the cron to run locally and then it worked 
Alia Team
Alia Oct 21 '13
Thanks for sharing Kieron.

Kevin, it is indeed worth to try and set CRON locally.
Gerardo
Gerardo Mar 29
thanks for the rosy weblog. It turned into without a doubt useful for me. i am happy i found this blog. thanks for sharing bearing in mind us,I too constantly examine some thing secondary out of your pronounce. Turkish importers
SEO HOME PAGE SERVICE
I admire what you have done here. I love the part where you say you are doing this to give back but I would assume by all the comments that is working for you as well. Do you have any more info on this? 英文補習社
anna
anna Sep 13
I like what you posted. I've read a lot of books that are similar! In contrast to other writings, yours really made an impact on me. It's great that you write thoughtful posts like this one. Please keep them coming! quordle
Post Minder
Post Minder Oct 9
Là Fuori is a reflection of the love for travel, sustainability, and the finer things in life, gathering 'nomadic creatives' to uplift and preserve the traditions of artisans worldwide. La Fuori