Comments (4)
Not sure why it wouldn't log a raw query. Bit we could add a check there.
from laravel-telescope-toolbar.
Update
Further digging it seems to be line 56
in the file views/collectors/queries.blade.php
. If I dump out my $entries
, one is returning an array for the sql
key.
5 => Laravel\Telescope\EntryResult {#1725 ▼
+id: "90ecd9ed-7007-40aa-88ce-b8e169f4133b"
+sequence: 913
+batchId: "90ecd9ed-80e2-4039-b2e8-48a95343bc76"
+type: "query"
+familyHash: null
+content: array:10 [▼
"connection" => "mysql_local"
"bindings" => []
"sql" => [] // <<< HERE
"time" => "3.19"
"slow" => false
"file" => "/home/vagrant/project/app/Http/Controllers/Members/MemberController.php"
"line" => 136
"hash" => "9d45694b57a16d943a4b7179ef13ef8e"
"hostname" => "project-homestead"
"user" => array:3 [▶]
]
+createdAt: Illuminate\Support\Carbon @1593469428 {#1726 ▶}
-tags: []
#avatar: null
}
Is this expected for Telescope? This is a fresh install of Telescope and Toolbar on this project.
The code on line 136
on the MemberController
file is:
$prefix = DB::getTablePrefix();
return DB::select(DB::raw('
SELECT id, body FROM '.$prefix.'messages
WHERE is_active = 1
AND (state_id = '.$stateId.' OR state_id IS NULL)
AND id NOT IN (
SELECT message_id from '.$prefix.'messages_users WHERE user_id = '.$userId.')
ORDER BY created_on'));
from laravel-telescope-toolbar.
yup, I'm gettign something similar too.
The project is L7 upgraded to L8..
{
"message": "htmlspecialchars() expects parameter 1 to be string, array given (View: /var/www/projectx/vendor/fruitcake/laravel-telescope-toolbar/resources/views/collectors/queries.blade.php)",
"exception": "Facade\\Ignition\\Exceptions\\ViewException",
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Support/helpers.php",
"line": 118,
"trace": [
{
"function": "handleError",
"class": "Illuminate\\Foundation\\Bootstrap\\HandleExceptions",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Support/helpers.php",
"line": 118,
"function": "htmlspecialchars"
},
{
"file": "/var/www/projectx/vendor/fruitcake/laravel-telescope-toolbar/src/../resources/views/collectors/queries.blade.php",
"line": 56,
"function": "e"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php",
"line": 107,
"function": "require"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php",
"line": 108,
"function": "Illuminate\\Filesystem\\{closure}",
"class": "Illuminate\\Filesystem\\Filesystem",
"type": "::"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php",
"line": 58,
"function": "getRequire",
"class": "Illuminate\\Filesystem\\Filesystem",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php",
"line": 61,
"function": "evaluatePath",
"class": "Illuminate\\View\\Engines\\PhpEngine",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/facade/ignition/src/Views/Engines/CompilerEngine.php",
"line": 37,
"function": "get",
"class": "Illuminate\\View\\Engines\\CompilerEngine",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/View/View.php",
"line": 139,
"function": "get",
"class": "Facade\\Ignition\\Views\\Engines\\CompilerEngine",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/View/View.php",
"line": 122,
"function": "getContents",
"class": "Illuminate\\View\\View",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/View/View.php",
"line": 91,
"function": "renderContents",
"class": "Illuminate\\View\\View",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/fruitcake/laravel-telescope-toolbar/src/../resources/views/toolbar.blade.php",
"line": 20,
"function": "render",
"class": "Illuminate\\View\\View",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php",
"line": 107,
"function": "require"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php",
"line": 108,
"function": "Illuminate\\Filesystem\\{closure}",
"class": "Illuminate\\Filesystem\\Filesystem",
"type": "::"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php",
"line": 58,
"function": "getRequire",
"class": "Illuminate\\Filesystem\\Filesystem",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php",
"line": 61,
"function": "evaluatePath",
"class": "Illuminate\\View\\Engines\\PhpEngine",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/facade/ignition/src/Views/Engines/CompilerEngine.php",
"line": 37,
"function": "get",
"class": "Illuminate\\View\\Engines\\CompilerEngine",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/View/View.php",
"line": 139,
"function": "get",
"class": "Facade\\Ignition\\Views\\Engines\\CompilerEngine",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/View/View.php",
"line": 122,
"function": "getContents",
"class": "Illuminate\\View\\View",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/View/View.php",
"line": 91,
"function": "renderContents",
"class": "Illuminate\\View\\View",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Http/Response.php",
"line": 62,
"function": "render",
"class": "Illuminate\\View\\View",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Http/Response.php",
"line": 34,
"function": "setContent",
"class": "Illuminate\\Http\\Response",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
"line": 765,
"function": "__construct",
"class": "Illuminate\\Http\\Response",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
"line": 737,
"function": "toResponse",
"class": "Illuminate\\Routing\\Router",
"type": "::"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
"line": 691,
"function": "prepareResponse",
"class": "Illuminate\\Routing\\Router",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 128,
"function": "Illuminate\\Routing\\{closure}",
"class": "Illuminate\\Routing\\Router",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/fruitcake/laravel-telescope-toolbar/src/Http/Controllers/ToolbarController.php",
"line": 32,
"function": "Illuminate\\Pipeline\\{closure}",
"class": "Illuminate\\Pipeline\\Pipeline",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 149,
"function": "Fruitcake\\TelescopeToolbar\\Http\\Controllers\\{closure}",
"class": "Fruitcake\\TelescopeToolbar\\Http\\Controllers\\ToolbarController",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/telescope/src/Http/Middleware/Authorize.php",
"line": 18,
"function": "Illuminate\\Pipeline\\{closure}",
"class": "Illuminate\\Pipeline\\Pipeline",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 167,
"function": "handle",
"class": "Laravel\\Telescope\\Http\\Middleware\\Authorize",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Routing/Middleware/SubstituteBindings.php",
"line": 41,
"function": "Illuminate\\Pipeline\\{closure}",
"class": "Illuminate\\Pipeline\\Pipeline",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 167,
"function": "handle",
"class": "Illuminate\\Routing\\Middleware\\SubstituteBindings",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php",
"line": 77,
"function": "Illuminate\\Pipeline\\{closure}",
"class": "Illuminate\\Pipeline\\Pipeline",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 167,
"function": "handle",
"class": "Illuminate\\Foundation\\Http\\Middleware\\VerifyCsrfToken",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php",
"line": 49,
"function": "Illuminate\\Pipeline\\{closure}",
"class": "Illuminate\\Pipeline\\Pipeline",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 167,
"function": "handle",
"class": "Illuminate\\View\\Middleware\\ShareErrorsFromSession",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php",
"line": 121,
"function": "Illuminate\\Pipeline\\{closure}",
"class": "Illuminate\\Pipeline\\Pipeline",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php",
"line": 63,
"function": "handleStatefulRequest",
"class": "Illuminate\\Session\\Middleware\\StartSession",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 167,
"function": "handle",
"class": "Illuminate\\Session\\Middleware\\StartSession",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php",
"line": 37,
"function": "Illuminate\\Pipeline\\{closure}",
"class": "Illuminate\\Pipeline\\Pipeline",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 167,
"function": "handle",
"class": "Illuminate\\Cookie\\Middleware\\AddQueuedCookiesToResponse",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php",
"line": 67,
"function": "Illuminate\\Pipeline\\{closure}",
"class": "Illuminate\\Pipeline\\Pipeline",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 167,
"function": "handle",
"class": "Illuminate\\Cookie\\Middleware\\EncryptCookies",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 103,
"function": "Illuminate\\Pipeline\\{closure}",
"class": "Illuminate\\Pipeline\\Pipeline",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
"line": 693,
"function": "then",
"class": "Illuminate\\Pipeline\\Pipeline",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
"line": 668,
"function": "runRouteWithinStack",
"class": "Illuminate\\Routing\\Router",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
"line": 634,
"function": "runRoute",
"class": "Illuminate\\Routing\\Router",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Routing/Router.php",
"line": 623,
"function": "dispatchToRoute",
"class": "Illuminate\\Routing\\Router",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php",
"line": 166,
"function": "dispatch",
"class": "Illuminate\\Routing\\Router",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 128,
"function": "Illuminate\\Foundation\\Http\\{closure}",
"class": "Illuminate\\Foundation\\Http\\Kernel",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php",
"line": 21,
"function": "Illuminate\\Pipeline\\{closure}",
"class": "Illuminate\\Pipeline\\Pipeline",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 167,
"function": "handle",
"class": "Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/TransformsRequest.php",
"line": 21,
"function": "Illuminate\\Pipeline\\{closure}",
"class": "Illuminate\\Pipeline\\Pipeline",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 167,
"function": "handle",
"class": "Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/ValidatePostSize.php",
"line": 27,
"function": "Illuminate\\Pipeline\\{closure}",
"class": "Illuminate\\Pipeline\\Pipeline",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 167,
"function": "handle",
"class": "Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/PreventRequestsDuringMaintenance.php",
"line": 87,
"function": "Illuminate\\Pipeline\\{closure}",
"class": "Illuminate\\Pipeline\\Pipeline",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 167,
"function": "handle",
"class": "Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/fruitcake/laravel-cors/src/HandleCors.php",
"line": 37,
"function": "Illuminate\\Pipeline\\{closure}",
"class": "Illuminate\\Pipeline\\Pipeline",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 167,
"function": "handle",
"class": "Fruitcake\\Cors\\HandleCors",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/fideloper/proxy/src/TrustProxies.php",
"line": 57,
"function": "Illuminate\\Pipeline\\{closure}",
"class": "Illuminate\\Pipeline\\Pipeline",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 167,
"function": "handle",
"class": "Fideloper\\Proxy\\TrustProxies",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php",
"line": 103,
"function": "Illuminate\\Pipeline\\{closure}",
"class": "Illuminate\\Pipeline\\Pipeline",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php",
"line": 141,
"function": "then",
"class": "Illuminate\\Pipeline\\Pipeline",
"type": "->"
},
{
"file": "/var/www/projectx/vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php",
"line": 110,
"function": "sendRequestThroughRouter",
"class": "Illuminate\\Foundation\\Http\\Kernel",
"type": "->"
},
{
"file": "/var/www/projectx/public/index.php",
"line": 54,
"function": "handle",
"class": "Illuminate\\Foundation\\Http\\Kernel",
"type": "->"
}
]
}
from laravel-telescope-toolbar.
Same here on latest version and Laravel 9:
local.ERROR: htmlspecialchars(): Argument #1 ($string) must be of type string, array given {"view":{"view":"/var/www/html/vendor/fruitcake/laravel-telescope-toolbar/resources/views/collectors/queries.blade.php","data":[]}
Update
This error occurred only when navigating to one specific route defined in routes/web.php
, I found the line triggering the error:
$mySqlVersion = DB::selectOne(DB::raw("select version() as v"))->v;
Although this is valid PHP, removing this line fixes the issue.
Maybe the raw db query?
from laravel-telescope-toolbar.
Related Issues (20)
- Some deprecations during installation
- When returning back() it redirects to toolbar assets HOT 2
- Why do i have only one item in debug bar? HOT 2
- 500 error if a livewire component class has a mount method
- Error when using with Telescope on a dev-only env HOT 6
- APP_DEBUG vs DEBUGBAR_ENABLED HOT 1
- [Bug] Should not inject toolbar when response is expected to be application/json HOT 2
- [FR] Laravel Query Detector Integration? HOT 2
- Assets not working HOT 2
- Toolbar doesn't work with browsersync HOT 1
- BindingResolutionException after installation
- Release for PHP 8 support HOT 2
- Continuous deprecation during installation HOT 1
- Laravel Octane support HOT 3
- [FR] Copy query to clipboard
- Config file not copied HOT 2
- Toolbar Not Show
- stripos(): Passing null to parameter #1 ($haystack) of type string is deprecated
- Postman 204 error
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from laravel-telescope-toolbar.