Import process hangs with no output

[usulpt]

Attempting to import from a CSV file, after going through the wizard steps for the file type, account to create the transactions, column mapping, everything goes fine and then ...nothing. No values entered into the database, no error output, just a continuous "Please wait, import is running".
Using AMPPS (Windows) in my own machine at home.

[JC5]

OK. Anything in the log files? On the browser's console?

[usulpt]

nothing in the log files, but I hadn't tried the console and now I have. whole lot of errors there, I'll post the file here:

127.0.0.1-1538499472360.log

[JC5]

It's pretty long but I see no particular errors. It's just looping. The warning about "nothing to show for running" is OK.

Can you check the import job key from the URL to the entry in the database (table import_jobs)? Any errors or messages there?

Logs can be found in /storage/logs. Nothing there?

[usulpt]

nothing much in the logs apart from this occasional line:

#24 {main}
"}
[2018-10-02 16:58:18] production.ERROR: No application encryption key has been specified. {"exception":"[object] (RuntimeException(code: 0): No application encryption key has been specified. at C:\Program Files (x86)\Ampps\www\firefly\vendor\laravel\framework\src\Illuminate\Encryption\EncryptionServiceProvider.php:42)
[stacktrace]

in the import_jobs there's one row for the import:
key: 0ZaFFbKfDSnG
configuration: {"file-type":"csv","date-format":"Ymd","has-headers":false,"delimiter":",","apply-rules":false,"specifics":[],"import-account":1,"column-count":6,"column-roles":["date-transaction","description","amount","_ignore","_ignore","_ignore"],"column-do-mapping":[false,false,false,false,false,false]}

[JC5]

Could you show the whole stacktrace for that one? I'm curious where it's coming from.

Firefly III shouldn't even work without that key, how did you configure the application?

[usulpt]

I barely configured anything, just using it out of the box :)
here's the stacktrace:

[stacktrace]
#0 C:\Program Files (x86)\Ampps\www\firefly\vendor\laravel\framework\src\Illuminate\Container\Container.php(764): TwigBridge\ServiceProvider->TwigBridge\{closure}(Object(Illuminate\Foundation\Application), Array)
#1 C:\Program Files (x86)\Ampps\www\firefly\vendor\laravel\framework\src\Illuminate\Container\Container.php(646): Illuminate\Container\Container->build(Object(Closure))
#2 C:\Program Files (x86)\Ampps\www\firefly\vendor\laravel\framework\src\Illuminate\Container\Container.php(601): Illuminate\Container\Container->resolve('twig', Array)
#3 C:\Program Files (x86)\Ampps\www\firefly\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(734): Illuminate\Container\Container->make('twig', Array)
#4 C:\Program Files (x86)\Ampps\www\firefly\vendor\laravel\framework\src\Illuminate\Container\Container.php(1210): Illuminate\Foundation\Application->make('twig')
#5 C:\Program Files (x86)\Ampps\www\firefly\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(161): Illuminate\Container\Container->offsetGet('twig')
#6 C:\Program Files (x86)\Ampps\www\firefly\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(130): Illuminate\Support\Facades\Facade::resolveFacadeInstance('twig')
#7 C:\Program Files (x86)\Ampps\www\firefly\vendor\laravel\framework\src\Illuminate\Support\Facades\Facade.php(217): Illuminate\Support\Facades\Facade::getFacadeRoot()
#8 C:\Program Files (x86)\Ampps\www\firefly\app\Providers\FireflyServiceProvider.php(98): Illuminate\Support\Facades\Facade::__callStatic('addExtension', Array)
#9 [internal function]: FireflyIII\Providers\FireflyServiceProvider->boot()
#10 C:\Program Files (x86)\Ampps\www\firefly\vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php(29): call_user_func_array(Array, Array)
#11 C:\Program Files (x86)\Ampps\www\firefly\vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php(87): Illuminate\Container\BoundMethod::Illuminate\Container\{closure}()
#12 C:\Program Files (x86)\Ampps\www\firefly\vendor\laravel\framework\src\Illuminate\Container\BoundMethod.php(31): Illuminate\Container\BoundMethod::callBoundMethod(Object(Illuminate\Foundation\Application), Array, Object(Closure))
#13 C:\Program Files (x86)\Ampps\www\firefly\vendor\laravel\framework\src\Illuminate\Container\Container.php(564): Illuminate\Container\BoundMethod::call(Object(Illuminate\Foundation\Application), Array, Array, NULL)
#14 C:\Program Files (x86)\Ampps\www\firefly\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(794): Illuminate\Container\Container->call(Array)
#15 C:\Program Files (x86)\Ampps\www\firefly\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(777): Illuminate\Foundation\Application->bootProvider(Object(FireflyIII\Providers\FireflyServiceProvider))
#16 [internal function]: Illuminate\Foundation\Application->Illuminate\Foundation\{closure}(Object(FireflyIII\Providers\FireflyServiceProvider), 28)
#17 C:\Program Files (x86)\Ampps\www\firefly\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(778): array_walk(Array, Object(Closure))
#18 C:\Program Files (x86)\Ampps\www\firefly\vendor\laravel\framework\src\Illuminate\Foundation\Bootstrap\BootProviders.php(17): Illuminate\Foundation\Application->boot()
#19 C:\Program Files (x86)\Ampps\www\firefly\vendor\laravel\framework\src\Illuminate\Foundation\Application.php(206): Illuminate\Foundation\Bootstrap\BootProviders->bootstrap(Object(Illuminate\Foundation\Application))
#20 C:\Program Files (x86)\Ampps\www\firefly\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(162): Illuminate\Foundation\Application->bootstrapWith(Array)
#21 C:\Program Files (x86)\Ampps\www\firefly\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(146): Illuminate\Foundation\Http\Kernel->bootstrap()
#22 C:\Program Files (x86)\Ampps\www\firefly\vendor\laravel\framework\src\Illuminate\Foundation\Http\Kernel.php(116): Illuminate\Foundation\Http\Kernel->sendRequestThroughRouter(Object(Illuminate\Http\Request))
#23 C:\Program Files (x86)\Ampps\www\firefly\public\index.php(76): Illuminate\Foundation\Http\Kernel->handle(Object(Illuminate\Http\Request))
#24 {main}
"}
[2018-10-02 16:58:18] production.ERROR: No application encryption key has been specified. {"exception":"[object] (RuntimeException(code: 0): No application encryption key has been specified. at C:\Program Files (x86)\Ampps\www\firefly\vendor\laravel\framework\src\Illuminate\Encryption\EncryptionServiceProvider.php:42)

[JC5]

Oh of course AMMPS comes with the app pre-configured etc. Is there a .env file somewhere in the /firefly/ dir? Does it have a value for APP_KEY?

[usulpt]

yup, shouldn't there be one?

[JC5]

According to the error, you don't have one.

Could you open the file, turn on debug mode, clear out storage/logs and try again?

It should give you a massive debug log with lots of info. That might give us a hint.

[usulpt]

Maximum execution time of 30 seconds exceeded. this might be it. changing to 3000 in php.ini, let's see if it works!

[usulpt]

yup, it was all down to php and mysql settings. changed maximum execution time, allocated memory and those typical values (it was a big-ass import file) and it worked. many thanks for the help, gonna try the software out and see if it's on par with the good things I heard about it! :)

[JC5]

It’s brilliant stuff believe me ;).

[shobhitsinghal624]

Facing same issue. I am using the official firefly docker image. Can someone guide me to the changes needed so that I can import a large csv file. Thanks in advance!

[JC5]

Which version of FF3 are you running?

[shobhitsinghal624]

Version 4.7.7

[JC5]

That version doesn’t have a time limit on the import so I could use some logs to debug your issue.

[stale]

This issue has been automatically marked as stale because it has not had recent activity. It will be closed if no further activity occurs. Thank you for your contributions.