26. PDOException
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Connectors/­Connector.php47
25. PDO __construct
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Connectors/­Connector.php47
24. Illuminate\Database\Connectors\Connector createConnection
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Connectors/­SqlServerConnector.php29
23. Illuminate\Database\Connectors\SqlServerConnector connect
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Connectors/­ConnectionFactory.php57
22. Illuminate\Database\Connectors\ConnectionFactory createSingleConnection
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Connectors/­ConnectionFactory.php46
21. Illuminate\Database\Connectors\ConnectionFactory make
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­DatabaseManager.php176
20. Illuminate\Database\DatabaseManager makeConnection
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­DatabaseManager.php64
19. Illuminate\Database\DatabaseManager connection
…/­vendor/­laravel/­framework/­src/­Illuminate/­Support/­Facades/­Facade.php208
18. Illuminate\Support\Facades\Facade __callStatic
…/­app/­controllers/­VacanciesController.php166
17. Illuminate\Support\Facades\DB connection
…/­app/­controllers/­VacanciesController.php166
16. VacanciesController detail
<#unknown>0
15. call_user_func_array
…/­vendor/­laravel/­framework/­src/­Illuminate/­Routing/­Controller.php231
14. Illuminate\Routing\Controller callAction
…/­vendor/­laravel/­framework/­src/­Illuminate/­Routing/­ControllerDispatcher.php93
13. Illuminate\Routing\ControllerDispatcher call
…/­vendor/­laravel/­framework/­src/­Illuminate/­Routing/­ControllerDispatcher.php62
12. Illuminate\Routing\ControllerDispatcher dispatch
…/­vendor/­laravel/­framework/­src/­Illuminate/­Routing/­Router.php967
11. Illuminate\Routing\Router Illuminate\Routing\{closure}
<#unknown>0
10. call_user_func_array
…/­vendor/­laravel/­framework/­src/­Illuminate/­Routing/­Route.php109
9. Illuminate\Routing\Route run
…/­vendor/­laravel/­framework/­src/­Illuminate/­Routing/­Router.php1033
8. Illuminate\Routing\Router dispatchToRoute
…/­vendor/­laravel/­framework/­src/­Illuminate/­Routing/­Router.php1001
7. Illuminate\Routing\Router dispatch
…/­vendor/­laravel/­framework/­src/­Illuminate/­Foundation/­Application.php781
6. Illuminate\Foundation\Application dispatch
…/­vendor/­laravel/­framework/­src/­Illuminate/­Foundation/­Application.php745
5. Illuminate\Foundation\Application handle
…/­vendor/­laravel/­framework/­src/­Illuminate/­Session/­Middleware.php72
4. Illuminate\Session\Middleware handle
…/­vendor/­laravel/­framework/­src/­Illuminate/­Cookie/­Queue.php47
3. Illuminate\Cookie\Queue handle
…/­vendor/­laravel/­framework/­src/­Illuminate/­Cookie/­Guard.php51
2. Illuminate\Cookie\Guard handle
…/­vendor/­stack/­builder/­src/­Stack/­StackedHttpKernel.php23
1. Stack\StackedHttpKernel handle
…/­vendor/­laravel/­framework/­src/­Illuminate/­Foundation/­Application.php641
0. Illuminate\Foundation\Application run
…/­public/­index.php49

PDOException (1)

Callstack information; navigate with mouse or keyboard using Ctrl+↑ or Ctrl+↓
Copy-to-clipboard button
Exception message and its type
Code snippet where the error was thrown
Server state information
Application provided context information
PDOException thrown with message "SQLSTATE[HY000] unrecognized msgno (jsidblive) (severity 11)" Stacktrace: #26 PDOException in /var/www/jsi.co.id/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:47 #25 PDO:__construct in /var/www/jsi.co.id/vendor/laravel/framework/src/Illuminate/Database/Connectors/Connector.php:47 #24 Illuminate\Database\Connectors\Connector:createConnection in /var/www/jsi.co.id/vendor/laravel/framework/src/Illuminate/Database/Connectors/SqlServerConnector.php:29 #23 Illuminate\Database\Connectors\SqlServerConnector:connect in /var/www/jsi.co.id/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php:57 #22 Illuminate\Database\Connectors\ConnectionFactory:createSingleConnection in /var/www/jsi.co.id/vendor/laravel/framework/src/Illuminate/Database/Connectors/ConnectionFactory.php:46 #21 Illuminate\Database\Connectors\ConnectionFactory:make in /var/www/jsi.co.id/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php:176 #20 Illuminate\Database\DatabaseManager:makeConnection in /var/www/jsi.co.id/vendor/laravel/framework/src/Illuminate/Database/DatabaseManager.php:64 #19 Illuminate\Database\DatabaseManager:connection in /var/www/jsi.co.id/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:208 #18 Illuminate\Support\Facades\Facade:__callStatic in /var/www/jsi.co.id/app/controllers/VacanciesController.php:166 #17 Illuminate\Support\Facades\DB:connection in /var/www/jsi.co.id/app/controllers/VacanciesController.php:166 #16 VacanciesController:detail in <#unknown>:0 #15 call_user_func_array in /var/www/jsi.co.id/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:231 #14 Illuminate\Routing\Controller:callAction in /var/www/jsi.co.id/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:93 #13 Illuminate\Routing\ControllerDispatcher:call in /var/www/jsi.co.id/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:62 #12 Illuminate\Routing\ControllerDispatcher:dispatch in /var/www/jsi.co.id/vendor/laravel/framework/src/Illuminate/Routing/Router.php:967 #11 Illuminate\Routing\Router:Illuminate\Routing\{closure} in <#unknown>:0 #10 call_user_func_array in /var/www/jsi.co.id/vendor/laravel/framework/src/Illuminate/Routing/Route.php:109 #9 Illuminate\Routing\Route:run in /var/www/jsi.co.id/vendor/laravel/framework/src/Illuminate/Routing/Router.php:1033 #8 Illuminate\Routing\Router:dispatchToRoute in /var/www/jsi.co.id/vendor/laravel/framework/src/Illuminate/Routing/Router.php:1001 #7 Illuminate\Routing\Router:dispatch in /var/www/jsi.co.id/vendor/laravel/framework/src/Illuminate/Foundation/Application.php:781 #6 Illuminate\Foundation\Application:dispatch in /var/www/jsi.co.id/vendor/laravel/framework/src/Illuminate/Foundation/Application.php:745 #5 Illuminate\Foundation\Application:handle in /var/www/jsi.co.id/vendor/laravel/framework/src/Illuminate/Session/Middleware.php:72 #4 Illuminate\Session\Middleware:handle in /var/www/jsi.co.id/vendor/laravel/framework/src/Illuminate/Cookie/Queue.php:47 #3 Illuminate\Cookie\Queue:handle in /var/www/jsi.co.id/vendor/laravel/framework/src/Illuminate/Cookie/Guard.php:51 #2 Illuminate\Cookie\Guard:handle in /var/www/jsi.co.id/vendor/stack/builder/src/Stack/StackedHttpKernel.php:23 #1 Stack\StackedHttpKernel:handle in /var/www/jsi.co.id/vendor/laravel/framework/src/Illuminate/Foundation/Application.php:641 #0 Illuminate\Foundation\Application:run in /var/www/jsi.co.id/public/index.php:49

SQLSTATE[HY000] unrecognized msgno (jsidblive) (severity 11)

	 */
	public function createConnection($dsn, array $config, array $options)
	{
		$username = array_get($config, 'username');
 
		$password = array_get($config, 'password');
 
		return new PDO($dsn, $username, $password, $options);
	}
 
	 */
	public function createConnection($dsn, array $config, array $options)
	{
		$username = array_get($config, 'username');
 
		$password = array_get($config, 'password');
 
		return new PDO($dsn, $username, $password, $options);
	}
 
	 * @param  array  $config
	 * @return \PDO
	 */
	public function connect(array $config)
	{
		$options = $this->getOptions($config);
 
		return $this->createConnection($this->getDsn($config), $config, $options);
	}
 
	 * Create a single database connection instance.
	 *
	 * @param  array  $config
	 * @return \Illuminate\Database\Connection
	 */
	protected function createSingleConnection(array $config)
	{
		$pdo = $this->createConnector($config)->connect($config);
 
		return $this->createConnection($config['driver'], $pdo, $config['database'], $config['prefix'], $config);
		$config = $this->parseConfig($config, $name);
 
		if (isset($config['read']))
		{
			return $this->createReadWriteConnection($config);
		}
 
		return $this->createSingleConnection($config);
	}
 
		// and will call the Closure if so, which allows us to have a more generic
		// resolver for the drivers themselves which applies to all connections.
		if (isset($this->extensions[$driver]))
		{
			return call_user_func($this->extensions[$driver], $config, $name);
		}

		return $this->factory->make($config, $name);
	}

		list($name, $type) = $this->parseConnectionName($name);

		// If we haven't created this connection, we'll create it based on the config
		// provided in the application. Once we've created the connections we will
		// set the "fetch mode" for PDO which determines the query return types.
		if ( ! isset($this->connections[$name]))
		{
			$connection = $this->makeConnection($name);

			$this->setPdoForType($connection, $type);
 
		switch (count($args))
		{
			case 0:
				return $instance->$method();
 
			case 1:
				return $instance->$method($args[0]);
 
			case 2:
			return Redirect::back()->with('error_message', $e->getMessage())->withInput();
		}
	}
 
	public function detail($id)
	{
		//
		$model = DB::connection('sqlsrv')->table('vacancies')->
		join('IBS.dbo.HRJobTitle', 'vacancies.type', '=', 'IBS.dbo.HRJobTitle.JobTitleID')->
		where('id', $id)->
			return Redirect::back()->with('error_message', $e->getMessage())->withInput();
		}
	}
 
	public function detail($id)
	{
		//
		$model = DB::connection('sqlsrv')->table('vacancies')->
		join('IBS.dbo.HRJobTitle', 'vacancies.type', '=', 'IBS.dbo.HRJobTitle.JobTitleID')->
		where('id', $id)->
<#unknown>
	 * @param  array   $parameters
	 * @return \Symfony\Component\HttpFoundation\Response
	 */
	public function callAction($method, $parameters)
	{
		$this->setupLayout();
 
		$response = call_user_func_array(array($this, $method), $parameters);
 
		// If no response is returned from the controller action and a layout is being
	 * @param  string  $method
	 * @return mixed
	 */
	protected function call($instance, $route, $method)
	{
		$parameters = $route->parametersWithoutNulls();
 
		return $instance->callAction($method, $parameters);
	}
 
		$response = $this->before($instance, $route, $request, $method);
 
		// If no before filters returned a response we'll call the method on the controller
		// to get the response to be returned to the router. We will then return it back
		// out for processing by this router and the after filters can be called then.
		if (is_null($response))
		{
			$response = $this->call($instance, $route, $method);
		}
 
			$request = $this->getCurrentRequest();
 
			// Now we can split the controller and method out of the action string so that we
			// can call them appropriately on the class. This controller and method are in
			// in the Class@method format and we need to explode them out then use them.
			list($class, $method) = explode('@', $controller);
 
			return $d->dispatch($route, $request, $class, $method);
		};
	}
<#unknown>
	 *
	 * @return mixed
	 */
	public function run()
	{
		$parameters = array_filter($this->parameters(), function($p) { return isset($p); });

		return call_user_func_array($this->action['uses'], $parameters);
	}

		// Once we have successfully matched the incoming request to a given route we
		// can call the before filters on that route. This works similar to global
		// filters in that if a response is returned we will not call the route.
		$response = $this->callRouteBefore($route, $request);
 
		if (is_null($response))
		{
			$response = $route->run($request);
		}
 
		// If no response was returned from the before filter, we will call the proper
		// route instance to get the response. If no route is found a response will
		// still get returned based on why no routes were found for this request.
		$response = $this->callFilter('before', $request);
 
		if (is_null($response))
		{
			$response = $this->dispatchToRoute($request);
		}
 
		}
 
		if ($this->runningUnitTests() && ! $this['session']->isStarted())
		{
			$this['session']->start();
		}
 
		return $this['router']->dispatch($this->prepareRequest($request));
	}
 
	{
		try
		{
			$this->refreshRequest($request = Request::createFromBase($request));
 
			$this->boot();
 
			return $this->dispatch($request);
		}
		catch (\Exception $e)
		if ($this->sessionConfigured())
		{
			$session = $this->startSession($request);
 
			$request->setSession($session);
		}
 
		$response = $this->app->handle($request, $type, $catch);
 
		// Again, if the session has been configured we will need to close out the session
	 * @param  \Symfony\Component\HttpFoundation\Request  $request
	 * @param  int   $type
	 * @param  bool  $catch
	 * @return \Symfony\Component\HttpFoundation\Response
	 */
	public function handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true)
	{
		$response = $this->app->handle($request, $type, $catch);
 
		foreach ($this->cookies->getQueuedCookies() as $cookie)
	 * @param  \Symfony\Component\HttpFoundation\Request  $request
	 * @param  int   $type
	 * @param  bool  $catch
	 * @return \Symfony\Component\HttpFoundation\Response
	 */
	public function handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true)
	{
		return $this->encrypt($this->app->handle($this->decrypt($request), $type, $catch));
	}
 
    {
        $this->app = $app;
        $this->middlewares = $middlewares;
    }
 
    public function handle(Request $request, $type = HttpKernelInterface::MASTER_REQUEST, $catch = true)
    {
        return $this->app->handle($request, $type, $catch);
    }
 
	 * @param  \Symfony\Component\HttpFoundation\Request  $request
	 * @return void
	 */
	public function run(SymfonyRequest $request = null)
	{
		$request = $request ?: $this['request'];
 
		$response = with($stack = $this->getStackedClient())->handle($request);
 
		$response->send();
| Once we have the application, we can simply call the run method,
| which will execute the request and send the response back to
| the client's browser allowing them to enjoy the creative
| and wonderful application we have whipped up for them.
|
*/
 
$app->run();
 
empty
empty
empty
empty
empty
Key Value
REDIRECT_HTTPS on
REDIRECT_SSL_TLS_SNI jsi.co.id
REDIRECT_STATUS 200
HTTPS on
SSL_TLS_SNI jsi.co.id
SSL_SERVER_S_DN_O CloudFlare, Inc.
SSL_SERVER_S_DN_OU CloudFlare Origin CA
SSL_SERVER_S_DN_CN CloudFlare Origin Certificate
SSL_SERVER_I_DN_C US
SSL_SERVER_I_DN_O CloudFlare, Inc.
SSL_SERVER_I_DN_OU CloudFlare Origin SSL Certificate Authority
SSL_SERVER_I_DN_L San Francisco
SSL_SERVER_I_DN_ST California
SSL_SERVER_SAN_DNS_0 *.jsi.co.id
SSL_SERVER_SAN_DNS_1 jsi.co.id
SSL_VERSION_INTERFACE mod_ssl/2.4.29
SSL_VERSION_LIBRARY OpenSSL/1.1.1
SSL_PROTOCOL TLSv1.3
SSL_SECURE_RENEG false
SSL_COMPRESS_METHOD NULL
SSL_CIPHER TLS_AES_256_GCM_SHA384
SSL_CIPHER_EXPORT false
SSL_CIPHER_USEKEYSIZE 256
SSL_CIPHER_ALGKEYSIZE 256
SSL_CLIENT_VERIFY NONE
SSL_SERVER_M_VERSION 3
SSL_SERVER_M_SERIAL 5A97FAB07FF32AEB0AB268C34A32488C83F678DD
SSL_SERVER_V_START Oct 2 07:26:00 2023 GMT
SSL_SERVER_V_END Sep 28 07:26:00 2038 GMT
SSL_SERVER_S_DN CN=CloudFlare Origin Certificate,OU=CloudFlare Origin CA,O=CloudFlare\, Inc.
SSL_SERVER_I_DN ST=California,L=San Francisco,OU=CloudFlare Origin SSL Certificate Authority,O=CloudFlare\, Inc.,C=US
SSL_SERVER_A_KEY rsaEncryption
SSL_SERVER_A_SIG sha256WithRSAEncryption
SSL_SESSION_ID 936517305b8f4020865926bd9778ce63aa101115a9491b192551198e5b81e4cd
SSL_SESSION_RESUMED Initial
HTTP_HOST jsi.co.id
HTTP_CONNECTION Keep-Alive
HTTP_ACCEPT_ENCODING gzip, br
HTTP_X_FORWARDED_FOR 44.213.80.203
HTTP_CF_RAY 86b97f688af43891-IAD
HTTP_X_FORWARDED_PROTO https
HTTP_CF_VISITOR {"scheme":"https"}
HTTP_ACCEPT */*
HTTP_USER_AGENT claudebot
HTTP_CF_CONNECTING_IP 44.213.80.203
HTTP_CDN_LOOP cloudflare
HTTP_CF_IPCOUNTRY US
PATH /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin
SERVER_SIGNATURE <address>Apache/2.4.29 (Ubuntu) Server at jsi.co.id Port 443</address>
SERVER_SOFTWARE Apache/2.4.29 (Ubuntu)
SERVER_NAME jsi.co.id
SERVER_ADDR 192.168.20.14
SERVER_PORT 443
REMOTE_ADDR 172.70.39.98
DOCUMENT_ROOT /var/www/jsi.co.id/public
REQUEST_SCHEME https
CONTEXT_PREFIX
CONTEXT_DOCUMENT_ROOT /var/www/jsi.co.id/public
SERVER_ADMIN [email protected]
SCRIPT_FILENAME /var/www/jsi.co.id/public/index.php
REMOTE_PORT 24388
REDIRECT_URL /jobdesc/7
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING
REQUEST_URI /jobdesc/7
SCRIPT_NAME /index.php
PHP_SELF /index.php
REQUEST_TIME_FLOAT 1711648595.969
REQUEST_TIME 1711648595
empty
0. Whoops\Handler\PrettyPageHandler