F
Filamentβ€’4mo ago
Sourabh

Failed to import csv

after csv import job is not executing . it is showing the status pending. I have also run php artisan queue:work but still is not process. kindly help for the same .
No description
No description
18 Replies
Sourabh
Sourabhβ€’4mo ago
why it is not working when queue connection
<?php
QUEUE_CONNECTION=database
<?php
QUEUE_CONNECTION=database
I have found the temporary solution . just change the queue connection at runtime .but why queue connection database is not working don't know ?.
<?php
public function getJobConnection(): ?string
{
return 'sync';
}
<?php
public function getJobConnection(): ?string
{
return 'sync';
}
Sandeep
Sandeepβ€’3mo ago
Hey @Sourabh I am getting the same issue on server
krekas
krekasβ€’3mo ago
have you even started the queue?
Sandeep
Sandeepβ€’3mo ago
Hey @Sourabh Please check your log, may you got cache/ folder permission issue Try with this command after clear logs sudo chmod 777 -R storage/framework/cache/data/ I have fixed my issue due to this reason. Might be it will useful to you
cybervoigt
cybervoigtβ€’3mo ago
hello, I'm facing this problem too. now, after running "./vendor/bin/sail artisan queue:work" I've got RUNNING and them FAIL (repeatedly), how/where can I find the result of this processing?
SirAlyon
SirAlyonβ€’3mo ago
Try to share the error message. You can find it in ur db in the "failed jobs" table
cybervoigt
cybervoigtβ€’3mo ago
this table "failed_jobs" is empty
SirAlyon
SirAlyonβ€’3mo ago
This is strange. A failed job is supposed to be found there Try to share more infos
cybervoigt
cybervoigtβ€’3mo ago
these are all the tables, (these are my models: clients , planners, events, event_types and guests.) Is that right? or are there anything else missing?
No description
SirAlyon
SirAlyonβ€’3mo ago
Seems ok to me. The failed_import_rows is showing the wrong import attempts?
cybervoigt
cybervoigtβ€’3mo ago
it's empty too... :-[
SirAlyon
SirAlyonβ€’3mo ago
Then we are missing something πŸ™‚ Try to share ur resources code
cybervoigt
cybervoigtβ€’3mo ago
some months ago I created a small project with an importer and it worked... but now this new project is with laravel 11, and there is another difference, the Importer is in the "detail" model, and using a "Relation manager the relation between Event 1 - N Guest and I want to let the user import a csv file with the guests for the event
cybervoigt
cybervoigtβ€’3mo ago
No description
krekas
krekasβ€’3mo ago
You say fail. What fails? When you run queue it fails?
cybervoigt
cybervoigtβ€’3mo ago
No description
cybervoigt
cybervoigtβ€’3mo ago
I dont know exactly what is the failure...
krekas
krekasβ€’3mo ago
Install maybe horizon and check using it