updating the excel in the package
rylxes opened this issue · 10 comments
i just did composer require maatwebsite/excel on my application , and i got this error message
Your requirements could not be resolved to an installable set of packages.
Problem 1
- yajra/laravel-datatables-buttons v3.3.0 requires maatwebsite/excel ^2.0 -> satisfiable by maatwebsite/excel[2.1.x-dev].
- yajra/laravel-datatables-buttons v3.3.0 requires maatwebsite/excel ^2.0 -> satisfiable by maatwebsite/excel[2.1.x-dev].
- yajra/laravel-datatables-buttons v3.3.0 requires maatwebsite/excel ^2.0 -> satisfiable by maatwebsite/excel[2.1.x-dev].
- Conclusion: don't install maatwebsite/excel 2.1.x-dev
- Installation request for yajra/laravel-datatables-buttons (locked at v3.3.0, required as ^3.0) -> satisfiable by yajra/laravel-datatables-buttons[v3.3.0].
i think the excel package for this plugin is outdated :
Application Parameters :
"laravel/framework": "5.6.*",
"yajra/laravel-datatables-buttons": "^3.0",
Hey,
you need to install the ^4.0 version of "yajra/laravel-datatables-buttons to get maatwebsite/excel ^3.0 running.
#68
https://github.com/yajra/laravel-datatables-buttons/blob/4.0/CHANGELOG.md#v400---08-15-2018
Anyone else having this issue, you can update both packages at once to the newest versions composer require maatwebsite/excel yajra/laravel-datatables-buttons
Hi
I'm using next packages in my app:
"laravel/framework": "5.8.*",
"maatwebsite/excel": "^3.1",
"phpoffice/phpspreadsheet": "^1.6",
"yajra/laravel-datatables-oracle": "~9.0"
When start using yajra, I faced the problem with importing excel data. I noticed there is some conflict between excel and yajra but don't know if there is solution for that
Hi,
did you try to import some boolean values? I implemented a nova import card and had some problems with boolean values. Yajra is using maatwebsite excel and their importer is quite "buggy" in my opinion. Boolean values are difficult for them to handle. Maybe that is the case on your problem.
Do you can offer more specific information? Maybe we can help you.
HI,
thanks for the reply.
I'm importing Excel file with several sheets. They are chunked in some sizes and send to the queue as job. Everything went fine until I started to use Yajra. This is some part of a huuuuge log:
App\Http\Controllers\Import\CpImportController one week import error: Error while sending STMT_EXECUTE packet. PID=14256 (SQL: insert into
jobs(queue,attempts,reserved_at,available_at,created_at,payload) values (default, 0, ?, 1558075209, 1558075209, {"displayName":"Maatwebsite\Excel\Jobs\QueueImport","job":"Illuminate\Queue\CallQueuedHandler@call","maxTries":null,"delay":null,"timeout":null,"timeoutAt":null,"data":{"commandName":"Maatwebsite\Excel\Jobs\QueueImport","command":"O:34:"Maatwebsite\Excel\Jobs\QueueImport":6:{s:10:"connection";N;s:5:"queue";N;s:15:"chainConnection";N;s:10:"chainQueue";N;s:5:"delay";N;s:7:"chained";a:26231:{i:0;s:1593:"O:32:"Maatwebsite\Excel\Jobs\ReadChunk":14:{s:40:"\u0000Maatwebsite\Excel\Jobs\ReadChunk\u0000import";O:34:"App\Imports\MainOneWeekSalesImport":2:{s:12:"\u0000*\u0000themeType";s:9:"Wallpaper";s:7:"\u0000*\u0000year";s:4:"2019";}s:40:"\u0000Maatwebsite\Excel\Jobs\ReadChunk\u0000reader";O:36:"PhpOffice\PhpSpreadsheet\Reader\Xlsx":8:
So the main problem is to send job to the queue. I'm using with WithChunkReading and ShouldQueue concerns.
Let me know if you need some specific information about the code.
One Question to your error message:
Shouldn't the 'reserved_at' be a timestamp? You are inserting a '?'. Maybe that is the error? That would be my first suggestion.
This is default Laravel jobs table:
`
| id | int(10) UN AI PK |
|---|---|
| queue | varchar(191) |
| payload | longtext |
| attempts | tinyint(3) UN |
| reserved_at | int(10) UN |
| available_at | int(10) UN |
| created_at | int(10) UN |
`
Last three columns are integer and they store seconds as unix epoch time..
I know but you try to store an ? in an integer column:
insert into jobs (queue, attempts, reserved_at, available_at, created_at, payload) values (default, 0, ?, 1558075209, 1558075209,
The third parameter on your values is an '?' (char) instead an integer. Maybe that helps you to find the error.
Hi
I found the reason, actually I found what is the reason. Excel spreadsheet I'm trying to import has 6 sheets X ~ 3K rows. When I remove one sheet, it goes without a problem. So it suppose this is not related to Yajra but to payload for jobs table. But I must find what.
This was the reason ( I hope)
max_allowed_packet = 128M