search

thekordy / ticketit

A simple helpdesk tickets system for Laravel 5.1+ which integrates smoothly with Laravel default users and auth system, demo is available at: http://ticketit.kordy.info/tickets
MIT License
875 stars 387 forks source link

Datatable Error Trailing Data #546

Open miguel-piste opened 4 years ago

miguel-piste commented 4 years ago

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? image

balping commented 4 years ago

Hi,

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

miguel-piste commented 4 years ago

Hi,

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

Of course, image

and this image

balping commented 4 years ago

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 commented 4 years ago

I did not understand correctly, check my server log?

balping commented 4 years ago

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

miguel-piste commented 4 years ago

Hi, I think it has to do with the date format. image Because the system recognizes that there are 3 tickets, but the table is where it does not load. image

miguel-piste commented 4 years ago

Does anyone have any ideas to solve the error? please

IamAhmedly commented 4 years ago

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

balping commented 4 years ago

@IamAhmedly Are you using SQL server as well?

miguel-piste commented 4 years ago

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

IamAhmedly commented 4 years ago

@IamAhmedly Are you using SQL server as well?

I'm using MariaDB using Wamp server

AhmedAlEssam commented 4 years ago

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 createFromFormatfunction 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 image

miguel-piste commented 4 years ago

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