Summarize not work with MS Sql Server . (Invalid object name 'Tsaheal.Bank') ..
I think it is BUG , because it must be 'Tsaheal.dbo.Bank'
8 Replies
I've ever seen it
https://github.com/filamentphp/filament/discussions/8433
GitHub
v3 Summaries on mssql connection · filamentphp filament · Discussio...
hi, i've used sum function and get errro, bellow: SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL s...
yes, I am sure it is BUG . I do every thing right as document.
Does this work as expected if you run the query outside filament? In tinker, let's say?
the query as filament prepered is wrong . filament call the table 'Bank' where related to 'Tsaheal' connection as 'Tsaheal.Bank' but the rigth is ''Tsaheal.dbo.Bank' . it missing the the sqlserver schema "dbo" . so the query can not run .
this is the error message
Do you have pdo sql extension on ?
Or maybe you can put .dbo in your db name ? 🤔
This seems like a db driver issue at the laravel level. Filament just uses eloquent. It doesn’t assume anything about your db connection.
yes pdo is on and every thing in project work well , only summarize not work , and I had tried to put .dbo with table name in model but the same problem
why every other filament , livewire and laravel are work good and every setting and installation in the project are normal as many project I have done . is there any more issue I must do about .dbo.
I read CanSummarizeRecords.php and CanSummarize.php and I print out the result of $query = DB::table($query->toBase(),$query->getModel()->getTable()); the $query->toBase return the name without .dbo .
any solution plz , I'm new with filament and I do well I need to enjoy with summarize