37. Illuminate\Database\QueryException
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Connection.php631
36. BaseController getOrganizationsHtmlSelect
<#unknown>0
35. BaseController getDetailed
<#unknown>0
34. Illuminate\Routing\Router Illuminate\Routing\{closure}
<#unknown>0
33. PDOException
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Connection.php299
32. PDO prepare
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Connection.php299
31. Illuminate\Database\Connection Illuminate\Database\{closure}
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Connection.php623
30. Illuminate\Database\Connection runQueryCallback
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Connection.php587
29. Illuminate\Database\Connection run
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Connection.php304
28. Illuminate\Database\Connection select
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Query/­Builder.php1412
27. Illuminate\Database\Query\Builder runSelect
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Query/­Builder.php1397
26. Illuminate\Database\Query\Builder getFresh
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Query/­Builder.php1384
25. Illuminate\Database\Query\Builder get
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Eloquent/­Builder.php411
24. Illuminate\Database\Eloquent\Builder getModels
…/­vendor/­laravel/­framework/­src/­Illuminate/­Database/­Eloquent/­Builder.php151
23. Illuminate\Database\Eloquent\Builder get
…/­app/­controllers/­BaseController.php5102
22. BaseController select
…/­app/­controllers/­BaseController.php1865
21. BaseController getOrganizationsHtmlSelect
<#unknown>0
20. call_user_func_array
…/­vendor/­laravel/­framework/­src/­Illuminate/­Routing/­Controller.php231
19. Illuminate\Routing\Controller callAction
…/­app/­controllers/­BaseController.php4298
18. BaseController callController
…/­workbench/­erp/­blogs/­src/­controllers/­ArticleController.php310
17. Erp\Blogs\ArticleController injectDataSources
…/­app/­controllers/­BaseController.php2814
16. BaseController getDetailed
<#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.php53

Illuminate \ Database \ QueryException (42S22)

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
Illuminate\Database\QueryException thrown with message "SQLSTATE[42S22]: Column not found: 1054 Unknown column 'published' in 'where clause' (SQL: select * from `sp_blg_categories` where `organization_id` = 214 and `published` = y and `status` = 1 order by `name` asc)" Stacktrace: #37 Illuminate\Database\QueryException in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Database/Connection.php:631 #36 BaseController:getOrganizationsHtmlSelect in <#unknown>:0 #35 BaseController:getDetailed in <#unknown>:0 #34 Illuminate\Routing\Router:Illuminate\Routing\{closure} in <#unknown>:0 #33 PDOException in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Database/Connection.php:299 #32 PDO:prepare in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Database/Connection.php:299 #31 Illuminate\Database\Connection:Illuminate\Database\{closure} in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Database/Connection.php:623 #30 Illuminate\Database\Connection:runQueryCallback in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Database/Connection.php:587 #29 Illuminate\Database\Connection:run in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Database/Connection.php:304 #28 Illuminate\Database\Connection:select in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1412 #27 Illuminate\Database\Query\Builder:runSelect in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1397 #26 Illuminate\Database\Query\Builder:getFresh in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Database/Query/Builder.php:1384 #25 Illuminate\Database\Query\Builder:get in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:411 #24 Illuminate\Database\Eloquent\Builder:getModels in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Database/Eloquent/Builder.php:151 #23 Illuminate\Database\Eloquent\Builder:get in /var/www/sapamaerp/app/controllers/BaseController.php:5102 #22 BaseController:select in /var/www/sapamaerp/app/controllers/BaseController.php:1865 #21 BaseController:getOrganizationsHtmlSelect in <#unknown>:0 #20 call_user_func_array in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:231 #19 Illuminate\Routing\Controller:callAction in /var/www/sapamaerp/app/controllers/BaseController.php:4298 #18 BaseController:callController in /var/www/sapamaerp/workbench/erp/blogs/src/controllers/ArticleController.php:310 #17 Erp\Blogs\ArticleController:injectDataSources in /var/www/sapamaerp/app/controllers/BaseController.php:2814 #16 BaseController:getDetailed in <#unknown>:0 #15 call_user_func_array in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Routing/Controller.php:231 #14 Illuminate\Routing\Controller:callAction in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:93 #13 Illuminate\Routing\ControllerDispatcher:call in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:62 #12 Illuminate\Routing\ControllerDispatcher:dispatch in /var/www/sapamaerp/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/sapamaerp/vendor/laravel/framework/src/Illuminate/Routing/Route.php:109 #9 Illuminate\Routing\Route:run in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Routing/Router.php:1033 #8 Illuminate\Routing\Router:dispatchToRoute in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Routing/Router.php:1001 #7 Illuminate\Routing\Router:dispatch in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Foundation/Application.php:781 #6 Illuminate\Foundation\Application:dispatch in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Foundation/Application.php:745 #5 Illuminate\Foundation\Application:handle in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Session/Middleware.php:72 #4 Illuminate\Session\Middleware:handle in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Cookie/Queue.php:47 #3 Illuminate\Cookie\Queue:handle in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Cookie/Guard.php:51 #2 Illuminate\Cookie\Guard:handle in /var/www/sapamaerp/vendor/stack/builder/src/Stack/StackedHttpKernel.php:23 #1 Stack\StackedHttpKernel:handle in /var/www/sapamaerp/vendor/laravel/framework/src/Illuminate/Foundation/Application.php:641 #0 Illuminate\Foundation\Application:run in /var/www/sapamaerp/public/index.php:53

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'published' in 'where clause' (SQL: select * from `sp_blg_categories` where `organization_id` = 214 and `published` = y and `status` = 1 order by `name` asc)

		}
 
		// If an exception occurs when attempting to run a query, we'll format the error
		// message to include the bindings with SQL, which will make this exception a
		// lot more helpful to the developer instead of just the database's errors.
		catch (\Exception $e)
		{
			throw new QueryException(
				$query, $this->prepareBindings($bindings), $e
			);
<#unknown>
<#unknown>
<#unknown>
		return $this->run($query, $bindings, function($me, $query, $bindings) use ($useReadPdo)
		{
			if ($me->pretending()) return array();
 
			// For select statements, we'll simply execute the query and return an array
			// of the database result set. Each element in the array will be a single
			// row from the database table, and will either be an array or objects.
			$statement = $this->getPdoForSelect($useReadPdo)->prepare($query);
 
			$statement->execute($me->prepareBindings($bindings));
Exception message: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'published' in 'where clause'
		return $this->run($query, $bindings, function($me, $query, $bindings) use ($useReadPdo)
		{
			if ($me->pretending()) return array();
 
			// For select statements, we'll simply execute the query and return an array
			// of the database result set. Each element in the array will be a single
			// row from the database table, and will either be an array or objects.
			$statement = $this->getPdoForSelect($useReadPdo)->prepare($query);
 
			$statement->execute($me->prepareBindings($bindings));
	protected function runQueryCallback($query, $bindings, Closure $callback)
	{
		// To execute the statement, we'll simply call the callback, which will actually
		// run the SQL against the PDO connection. Then we can calculate the time it
		// took to execute and log the query SQL, bindings and time in our memory.
		try
		{
			$result = $callback($this, $query, $bindings);
		}
 
		$start = microtime(true);
 
		// Here we will run this query. If an exception occurs we'll determine if it was
		// caused by a connection that has been lost. If that is the cause, we'll try
		// to re-establish connection and re-run the query with a fresh connection.
		try
		{
			$result = $this->runQueryCallback($query, $bindings, $callback);
		}
		catch (QueryException $e)
			// of the database result set. Each element in the array will be a single
			// row from the database table, and will either be an array or objects.
			$statement = $this->getPdoForSelect($useReadPdo)->prepare($query);
 
			$statement->execute($me->prepareBindings($bindings));
 
			return $statement->fetchAll($me->getFetchMode());
		});
	}
 
	protected function runSelect()
	{
		if ($this->useWritePdo)
		{
			return $this->connection->select($this->toSql(), $this->getBindings(), false);
		}
 
		return $this->connection->select($this->toSql(), $this->getBindings());
	}
 
	 * @param  array  $columns
	 * @return array|static[]
	 */
	public function getFresh($columns = array('*'))
	{
		if (is_null($this->columns)) $this->columns = $columns;
 
		return $this->processor->processSelect($this, $this->runSelect());
	}
 
	 * @param  array  $columns
	 * @return array|static[]
	 */
	public function get($columns = array('*'))
	{
		if ( ! is_null($this->cacheMinutes)) return $this->getCached($columns);
 
		return $this->getFresh($columns);
	}
 
	 * @return \Illuminate\Database\Eloquent\Model[]
	 */
	public function getModels($columns = array('*'))
	{
		// First, we will simply get the raw results from the query builders which we
		// can use to populate an array with Eloquent models. We will pass columns
		// that should be selected as well, which are typically just everything.
		$results = $this->query->get($columns);
 
		$connection = $this->model->getConnectionName();
	 * Execute the query as a "select" statement.
	 *
	 * @param  array  $columns
	 * @return \Illuminate\Database\Eloquent\Collection|static[]
	 */
	public function get($columns = array('*'))
	{
		$models = $this->getModels($columns);
 
		// If we actually found models we will also eager load any relationships that
        } else {
 
            if (array_key_exists('take', $parameters)) { //Paginate
                //Get all or first model
                $selectModel = ($oneOrAll == 2) ? $selectModel->take($parameters['take'])->get($fields) : $selectModel->first($fields);
            } else {
                //Get all or first model
                $selectModel = ($oneOrAll == 2) ? $selectModel->get($fields) : $selectModel->first($fields);
            }
 
 
        // echo $cache_index;
        if ($predis->exists($cache_index)) {
 
            $model = json_decode($predis->get($cache_index), true);
        } else {
            //Select models
            $model = $this->select($fields, $where_clause, 2, $parameters);
 
            try {
<#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
     * Call another controller
     */
    public function callController($controller, $action, $parameters = array())
    {
        $app = app();
        $controller = $app->make($controller);
 
        return $controller->callAction($action, $parameters);
    }
 
     * @author Edwin Mugendi
     * Inject data source. This are mainly select
     * 
     * @param array $dataSource Data source
     */
    public function injectDataSources() {
        //Get this organization category id
        $this->view_data['dataSource']['category_id'] = $this->callController(\Util::buildNamespace('blogs', 'category', 1), 'getOrganizationsHtmlSelect', array($this->org['id'], 'id', array('name'), \Lang::get('common.select')));
 
        //Get and set published options to data source
                $this->callController(\Util::buildNamespace('accounts', 'user', 1), 'sessionUser', array($this->view_data['user'], false));
            }
            \Session::put('user', $this->view_data['user']);
        } //E# if statement
 
 
        //Inject data sources
        $this->injectDataSources();
 
        //Make controller_model an array because of buildSingleList need an array
<#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 sapamaerp.com
REDIRECT_STATUS 200
HTTPS on
SSL_TLS_SNI sapamaerp.com
HTTP_ACCEPT */*
HTTP_USER_AGENT claudebot
HTTP_HOST sapamaerp.com
PATH /usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
SERVER_SIGNATURE <address>Apache/2.4.29 (Ubuntu) Server at sapamaerp.com Port 443</address>
SERVER_SOFTWARE Apache/2.4.29 (Ubuntu)
SERVER_NAME sapamaerp.com
SERVER_ADDR 192.241.213.216
SERVER_PORT 443
REMOTE_ADDR 35.175.174.36
DOCUMENT_ROOT /var/www/sapamaerp/public
REQUEST_SCHEME https
CONTEXT_PREFIX
CONTEXT_DOCUMENT_ROOT /var/www/sapamaerp/public
SERVER_ADMIN webmaster@localhost
SCRIPT_FILENAME /var/www/sapamaerp/public/index.php
REMOTE_PORT 51198
REDIRECT_URL /blog/our-online-cyber-security-policy
GATEWAY_INTERFACE CGI/1.1
SERVER_PROTOCOL HTTP/1.1
REQUEST_METHOD GET
QUERY_STRING
REQUEST_URI /blog/our-online-cyber-security-policy
SCRIPT_NAME /index.php
PHP_SELF /index.php
REQUEST_TIME_FLOAT 1711621380.863
REQUEST_TIME 1711621380
empty
0. Whoops\Handler\PrettyPageHandler