Database Error

Error: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'page' in 'where clause'

SQL Query: SELECT `Video`.`vid_id`, `Video`.`vid_title`, `Video`.`vid_category`, `Video`.`vid_path`, `Video`.`vid_desc`, `Video`.`vid_image`, `Video`.`vid_alt`, `Video`.`vid_featured`, `Video`.`vid_active`, `Video`.`vid_del`, `Video`.`vid_seotitle`, `Video`.`vid_metadesc`, `Video`.`vid_metakeyword`, `Video`.`vid_preview`, `Video`.`vid_count`, `Video`.`vid_event`, `Video`.`vid_mobilepath`, `Category`.`cat_id`, `Category`.`cat_name`, `Category`.`cat_desc`, `Category`.`cat_active`, `Category`.`cat_del`, `Category`.`cat_img`, `Category`.`cat_order` FROM `tvmedibi_medibiztv`.`video` AS `Video` LEFT JOIN `tvmedibi_medibiztv`.`category` AS `Category` ON (`Category`.`cat_id`=`Video`.`vid_category`) WHERE `Video`.`vid_id`=page LIMIT 1

Notice: If you want to customize this error message, create app/View/Errors/pdo_error.ctp

Stack Trace

• CORE/Cake/Model/Datasource/DboSource.php line 458 → PDOStatement->execute(array)

          try {
              $query = $this->_connection->prepare($sql, $prepareOptions);
              $query->setFetchMode(PDO::FETCH_LAZY);
              if (!$query->execute($params)) {
                  $this->_results = $query;

  array()

• CORE/Cake/Model/Datasource/DboSource.php line 424 → DboSource->_execute(string, array)

          $options += array('log' => $this->fullDebug);
  
          $t = microtime(true);
          $this->_result = $this->_execute($sql, $params);
  

  'SELECT `Video`.`vid_id`, `Video`.`vid_title`, `Video`.`vid_category`, `Video`.`vid_path`, `Video`.`vid_desc`, `Video`.`vid_image`, `Video`.`vid_alt`, `Video`.`vid_featured`, `Video`.`vid_active`, `Video`.`vid_del`, `Video`.`vid_seotitle`, `Video`.`vid_metadesc`, `Video`.`vid_metakeyword`, `Video`.`vid_preview`, `Video`.`vid_count`, `Video`.`vid_event`, `Video`.`vid_mobilepath`, `Category`.`cat_id`, `Category`.`cat_name`, `Category`.`cat_desc`, `Category`.`cat_active`, `Category`.`cat_del`, `Category`.`cat_img`, `Category`.`cat_order` FROM `tvmedibi_medibiztv`.`video` AS `Video` LEFT JOIN `tvmedibi_medibiztv`.`category` AS `Category` ON (`Category`.`cat_id`=`Video`.`vid_category`)  WHERE   `Video`.`vid_id`=page    LIMIT 1'
  array()

• CORE/Cake/Model/Datasource/DboSource.php line 665 → DboSource->execute(string, array, array)

          if ($cache && ($cached = $this->getQueryCache($sql, $params)) !== false) {
              return $cached;
          }
          $result = $this->execute($sql, array(), $params);
          if ($result) {

  'SELECT `Video`.`vid_id`, `Video`.`vid_title`, `Video`.`vid_category`, `Video`.`vid_path`, `Video`.`vid_desc`, `Video`.`vid_image`, `Video`.`vid_alt`, `Video`.`vid_featured`, `Video`.`vid_active`, `Video`.`vid_del`, `Video`.`vid_seotitle`, `Video`.`vid_metadesc`, `Video`.`vid_metakeyword`, `Video`.`vid_preview`, `Video`.`vid_count`, `Video`.`vid_event`, `Video`.`vid_mobilepath`, `Category`.`cat_id`, `Category`.`cat_name`, `Category`.`cat_desc`, `Category`.`cat_active`, `Category`.`cat_del`, `Category`.`cat_img`, `Category`.`cat_order` FROM `tvmedibi_medibiztv`.`video` AS `Video` LEFT JOIN `tvmedibi_medibiztv`.`category` AS `Category` ON (`Category`.`cat_id`=`Video`.`vid_category`)  WHERE   `Video`.`vid_id`=page    LIMIT 1'
  array()
  array()

• CORE/Cake/Model/Datasource/DboSource.php line 1077 → DboSource->fetchAll(string, boolean)

  
          $query = $this->generateAssociationQuery($model, null, null, null, null, $queryData, false, $null);
  
          $resultSet = $this->fetchAll($query, $model->cacheQueries);
  

  'SELECT `Video`.`vid_id`, `Video`.`vid_title`, `Video`.`vid_category`, `Video`.`vid_path`, `Video`.`vid_desc`, `Video`.`vid_image`, `Video`.`vid_alt`, `Video`.`vid_featured`, `Video`.`vid_active`, `Video`.`vid_del`, `Video`.`vid_seotitle`, `Video`.`vid_metadesc`, `Video`.`vid_metakeyword`, `Video`.`vid_preview`, `Video`.`vid_count`, `Video`.`vid_event`, `Video`.`vid_mobilepath`, `Category`.`cat_id`, `Category`.`cat_name`, `Category`.`cat_desc`, `Category`.`cat_active`, `Category`.`cat_del`, `Category`.`cat_img`, `Category`.`cat_order` FROM `tvmedibi_medibiztv`.`video` AS `Video` LEFT JOIN `tvmedibi_medibiztv`.`category` AS `Category` ON (`Category`.`cat_id`=`Video`.`vid_category`)  WHERE   `Video`.`vid_id`=page    LIMIT 1'
  false

• CORE/Cake/Model/Model.php line 2902 → DboSource->read(Video, array)

   * @return array
   */
      protected function _readDataSource($type, $query) {
          $results = $this->getDataSource()->read($this, $query);
          $this->resetAssociations();

  object(Video) {
  	name => 'Video'
  	primaryKey => 'vid_id'
  	useTable => 'video'
  	belongsTo => array(
  		[maximum depth reached]
  	)
  	useDbConfig => 'default'
  	id => false
  	data => array([maximum depth reached])
  	schemaName => 'tvmedibi_medibiztv'
  	table => 'video'
  	validate => array([maximum depth reached])
  	validationErrors => array([maximum depth reached])
  	validationDomain => null
  	tablePrefix => ''
  	plugin => null
  	alias => 'Video'
  	tableToModel => array(
  		[maximum depth reached]
  	)
  	cacheQueries => false
  	hasOne => array([maximum depth reached])
  	hasMany => array([maximum depth reached])
  	hasAndBelongsToMany => array([maximum depth reached])
  	actsAs => null
  	Behaviors => object(BehaviorCollection) {}
  	whitelist => array([maximum depth reached])
  	cacheSources => true
  	findQueryType => 'first'
  	recursive => (int) 1
  	order => null
  	virtualFields => array([maximum depth reached])
  	__backAssociation => array([maximum depth reached])
  	__backInnerAssociation => array([maximum depth reached])
  	__backOriginalAssociation => array([maximum depth reached])
  	__backContainableAssociation => array([maximum depth reached])
  	findMethods => array(
  		[maximum depth reached]
  	)
  	Category => object(Category) {}
  	[protected] _schema => null
  	[protected] _associationKeys => array(
  		[maximum depth reached]
  	)
  	[protected] _associations => array(
  		[maximum depth reached]
  	)
  	[protected] _insertID => null
  	[protected] _sourceConfigured => true
  	[protected] _eventManager => object(CakeEventManager) {}
  	[protected] _validator => null
  }
  array(
  	'conditions' => array(
  		(int) 0 => '  Video.vid_id=page'
  	),
  	'fields' => array(),
  	'joins' => array(),
  	'limit' => (int) 1,
  	'offset' => null,
  	'order' => array(
  		(int) 0 => null
  	),
  	'page' => (int) 1,
  	'group' => null,
  	'callbacks' => true
  )

• CORE/Cake/Model/Model.php line 2874 → Model->_readDataSource(string, array)

              return null;
          }
  
          return $this->_readDataSource($type, $query);
      }

  'first'
  array(
  	'conditions' => array(
  		(int) 0 => '  Video.vid_id=page'
  	),
  	'fields' => array(),
  	'joins' => array(),
  	'limit' => (int) 1,
  	'offset' => null,
  	'order' => array(
  		(int) 0 => null
  	),
  	'page' => (int) 1,
  	'group' => null,
  	'callbacks' => true
  )

• APP/Controller/ContentController.php line 513 → Model->find(string, array)

              $where_play = "  Video.vid_id=$vid";
              $arr_play = $this->Video->find('first', array('fields' => array(),
                  'conditions' => array($where_play)
              ));
  

  'first'
  array(
  	'fields' => array(),
  	'conditions' => array(
  		(int) 0 => '  Video.vid_id=page'
  	)
  )

• [internal function] → ContentController->videoarchive(string, string)

  'page'
  'Advertise'

• CORE/Cake/Controller/Controller.php line 490 → ReflectionMethod->invokeArgs(ContentController, array)

                      'action' => $request->params['action']
                  ));
              }
              return $method->invokeArgs($this, $request->params['pass']);
  

  object(ContentController) {
  	helpers => array(
  		[maximum depth reached]
  	)
  	uses => array(
  		[maximum depth reached]
  	)
  	name => 'Content'
  	request => object(CakeRequest) {}
  	response => object(CakeResponse) {}
  	viewPath => 'Content'
  	layoutPath => null
  	viewVars => array(
  		[maximum depth reached]
  	)
  	view => 'videoarchive'
  	layout => 'homeinner'
  	autoRender => true
  	autoLayout => true
  	Components => object(ComponentCollection) {}
  	components => array(
  		[maximum depth reached]
  	)
  	viewClass => 'View'
  	View => null
  	ext => '.ctp'
  	plugin => null
  	cacheAction => false
  	passedArgs => array(
  		[maximum depth reached]
  	)
  	scaffold => false
  	methods => array(
  		[maximum depth reached]
  	)
  	modelClass => 'HeadlineModel'
  	modelKey => 'content'
  	validationErrors => null
  	Session => object(SessionComponent) {}
  	HeadlineModel => object(HeadlineModel) {}
  	Category => object(Category) {}
  	Video => object(Video) {}
  	[protected] _responseClass => 'CakeResponse'
  	[protected] _mergeParent => 'AppController'
  	[protected] _eventManager => object(CakeEventManager) {}
  }
  array(
  	(int) 0 => 'page',
  	(int) 1 => 'Advertise'
  )

• CORE/Cake/Routing/Dispatcher.php line 185 → Controller->invokeAction(CakeRequest)

          $controller->startupProcess();
  
          $render = true;
          $result = $controller->invokeAction($request);
          if ($result instanceof CakeResponse) {

  object(CakeRequest) {
  	params => array(
  		[maximum depth reached]
  	)
  	data => array([maximum depth reached])
  	query => array([maximum depth reached])
  	url => 'videoarchive/sort:Video.vid_id/page/Advertise'
  	base => ''
  	webroot => '/'
  	here => '/videoarchive/sort:Video.vid_id/page/Advertise'
  	[protected] _detectors => array(
  		[maximum depth reached]
  	)
  	[protected] _input => ''
  }

• CORE/Cake/Routing/Dispatcher.php line 160 → Dispatcher->_invoke(ContentController, CakeRequest, CakeResponse)

              ));
          }
  
          $response = $this->_invoke($controller, $request, $response);
          if (isset($request->params['return'])) {

  object(ContentController) {
  	helpers => array(
  		[maximum depth reached]
  	)
  	uses => array(
  		[maximum depth reached]
  	)
  	name => 'Content'
  	request => object(CakeRequest) {}
  	response => object(CakeResponse) {}
  	viewPath => 'Content'
  	layoutPath => null
  	viewVars => array(
  		[maximum depth reached]
  	)
  	view => 'videoarchive'
  	layout => 'homeinner'
  	autoRender => true
  	autoLayout => true
  	Components => object(ComponentCollection) {}
  	components => array(
  		[maximum depth reached]
  	)
  	viewClass => 'View'
  	View => null
  	ext => '.ctp'
  	plugin => null
  	cacheAction => false
  	passedArgs => array(
  		[maximum depth reached]
  	)
  	scaffold => false
  	methods => array(
  		[maximum depth reached]
  	)
  	modelClass => 'HeadlineModel'
  	modelKey => 'content'
  	validationErrors => null
  	Session => object(SessionComponent) {}
  	HeadlineModel => object(HeadlineModel) {}
  	Category => object(Category) {}
  	Video => object(Video) {}
  	[protected] _responseClass => 'CakeResponse'
  	[protected] _mergeParent => 'AppController'
  	[protected] _eventManager => object(CakeEventManager) {}
  }
  object(CakeRequest) {
  	params => array(
  		[maximum depth reached]
  	)
  	data => array([maximum depth reached])
  	query => array([maximum depth reached])
  	url => 'videoarchive/sort:Video.vid_id/page/Advertise'
  	base => ''
  	webroot => '/'
  	here => '/videoarchive/sort:Video.vid_id/page/Advertise'
  	[protected] _detectors => array(
  		[maximum depth reached]
  	)
  	[protected] _input => ''
  }
  object(CakeResponse) {
  	[protected] _statusCodes => array(
  		[maximum depth reached]
  	)
  	[protected] _mimeTypes => array(
  		[maximum depth reached]
  	)
  	[protected] _protocol => 'HTTP/1.1'
  	[protected] _status => (int) 200
  	[protected] _contentType => 'text/html'
  	[protected] _headers => array([maximum depth reached])
  	[protected] _body => null
  	[protected] _file => null
  	[protected] _fileRange => null
  	[protected] _charset => 'UTF-8'
  	[protected] _cacheDirectives => array([maximum depth reached])
  	[protected] _cookies => array([maximum depth reached])
  }

• APP/webroot/index.php line 112 → Dispatcher->dispatch(CakeRequest, CakeResponse)

  $Dispatcher->dispatch(
  
      new CakeRequest(),
  
      new CakeResponse()
  
  );
  
  

  object(CakeRequest) {
  	params => array(
  		[maximum depth reached]
  	)
  	data => array([maximum depth reached])
  	query => array([maximum depth reached])
  	url => 'videoarchive/sort:Video.vid_id/page/Advertise'
  	base => ''
  	webroot => '/'
  	here => '/videoarchive/sort:Video.vid_id/page/Advertise'
  	[protected] _detectors => array(
  		[maximum depth reached]
  	)
  	[protected] _input => ''
  }
  object(CakeResponse) {
  	[protected] _statusCodes => array(
  		[maximum depth reached]
  	)
  	[protected] _mimeTypes => array(
  		[maximum depth reached]
  	)
  	[protected] _protocol => 'HTTP/1.1'
  	[protected] _status => (int) 200
  	[protected] _contentType => 'text/html'
  	[protected] _headers => array([maximum depth reached])
  	[protected] _body => null
  	[protected] _file => null
  	[protected] _fileRange => null
  	[protected] _charset => 'UTF-8'
  	[protected] _cacheDirectives => array([maximum depth reached])
  	[protected] _cookies => array([maximum depth reached])
  }