Datatable Error Trailing Data

[miguel-piste]

Hi guys, I just installed "Ticketit" on my server, everything works fine, except for the Ticket index, when I created the first ticket I got an error: "Exception Message: dataTrailing data", it is worth mentioning that I am using SQL Server 2012.
Can someone help me please?

[balping]

Hi,

Could you please check the network tab the developer console to see what is returned by the server?

[miguel-piste]

Hi,

Could you please check the network tab the developer console to see what is returned by the server?

Of course,

and this

[balping]

So it seems that the error message is coming from the server itself. Could you check the error log on the server too? Should be under storage/logs

[miguel-piste]

I did not understand correctly, check my server log?

[balping]

Yes please. The call stack might reveal what is causing the issue.

[miguel-piste]

Hi, I think it has to do with the date format.

Because the system recognizes that there are 3 tickets, but the table is where it does not load.

[miguel-piste]

Does anyone have any ideas to solve the error? please

[IamAhmedly]

I have the same issue and this what appears in the server log

[balping]

@IamAhmedly Are you using SQL server as well?

[miguel-piste]

I have the same error that @IamAhmedly has in the log

[IamAhmedly]

@IamAhmedly Are you using SQL server as well?

I'm using MariaDB using Wamp server

[AhmedAlEssam]

This issue occurred when I generated demo content using this command,
php artisan db:seed --class="Kordy\Ticketit\Seeds\TicketitTableSeeder"
and the tickets don't appear in its' page
according to this StackOverflow thread "Laravel Carbon Data Missing"

This error arises when Carbon's createFromFormat function receives a date string that doesn't match the passed format string. More precisely this comes from the DateTime::createFromFormat function

So I've opened the PHPMyAdmin to the tickets table and sorted the rows according to its' update_date searching for Null value, I've found about 6 rows with null value so I deleted the rows with null, and that fix the issue

this should not happen in the first place

UPDATE:
in the image the rows to be deleted ....not 6 rows ... about (24) rows open the image in new tab
i'm using laravel version 6 and i think the error caused by the lines from 81-92 in file path
\vendor\kordy\ticketit\src\Controllers\TicketsController.php

[miguel-piste]

In my case I solved it by converting the datetime fields to datetime2, I use Sql Server 2012