Database_Exception [ 1146 ]: Table 'idjkashdjash_EAXCYVBGCoQGXRAkcC.ZipCode' doesn't exist [ SELECT `cat_states`.state_short as short_state, `cat_states`.url_name as state_url, `cat_cities`.city_name as city, `cat_cities`.url_name as city_url, `ZipCode`.ZipCode as zip FROM `ZipCode` , `cat_cities` , `cat_states` WHERE `cat_states`.state_id = 10 AND `cat_cities`.county_id = 265 AND `cat_cities`.state_id = `cat_states`.state_id AND `ZipCode`.state = `cat_states`.state_short AND `ZipCode`.city = `cat_cities`.city_name ORDER BY `cat_cities`.city_name; ]

MODPATH/database/classes/Kohana/Database/MySQL.php [ 194 ]

189 			{
190 				// This benchmark is worthless
191 				Profiler::delete($benchmark);
192 			}
193 
194 			throw new Database_Exception(':error [ :query ]',
195 				array(':error' => mysql_error($this->_connection), ':query' => $sql),
196 				mysql_errno($this->_connection));
197 		}
198 
199 		if (isset($benchmark))

1. MODPATH/database/classes/Kohana/Database/Query.php [ 251 ] » Kohana_Database_MySQL->query(arguments)

   0	integer 1
   1	string(548) "SELECT `cat_states`.state_short as short_state, `cat_states`.url_name as state_url, `cat_cities`.city_name as city, `cat_citi …"
   2	bool FALSE
   3	array(0)

   246 				return new Database_Result_Cached($result, $sql, $as_object, $object_params);
   247 			}
   248 		}
   249 
   250 		// Execute the query
   251 		$result = $db->query($this->_type, $sql, $as_object, $object_params);
   252 
   253 		if (isset($cache_key) AND $this->_lifetime > 0)
   254 		{
   255 			// Cache the result array
   256 			Kohana::cache($cache_key, $result->as_array(), $this->_lifetime);
   

2. APPPATH/classes/Model/Workdb.php [ 15 ] » Kohana_Database_Query->execute()

   10             AND  `cat_cities`.county_id = {$county_id}
   11             AND  `cat_cities`.state_id =  `cat_states`.state_id
   12             AND  `ZipCode`.state =  `cat_states`.state_short
   13             AND  `ZipCode`.city =  `cat_cities`.city_name ORDER BY `cat_cities`.city_name;";
   14         $query = DB::query(Database::SELECT, $response)
   15         ->execute()
   16         ->as_array();
   17         if($query)
   18             return $query;
   19         else
   20             return array();   
   

3. APPPATH/classes/Controller/Welcome.php [ 555 ] » Model_Workdb->get_city_with_zip(arguments)

   0	string(2) "10"
   1	string(3) "265"

   550     }
   551     public function locations_tag()
   552     {
   553         if($this->typelocation == 'county')
   554         {
   555             $to_map = Model::factory('Workdb')->get_city_with_zip($this->location['state']['state_id'], $this->location['city']['county_id']);
   556             return $this->replace['[locations-with-zip]'] = View::factory('widgets/location_with_zip')->bind('locations', $to_map)->__toString();
   557         }
   558     }
   559 
   560     public function get_customer()
   

4. APPPATH/classes/Controller/Welcome.php [ 485 ] » Controller_Welcome->locations_tag()

   480             '[tel]' => (isset($this->customer['phone']))?$this->customer['phone']:'',
   481             '[tel2]' => (!empty($this->customer['phone2']))?$this->customer['phone2']:'',
   482             '[tel2_html]' => (!empty($this->customer['phone2']))?'<span class="number"><span class="free"><span>Local number:</span></span><a href="tel:' . $this->customer['phone2'] . '" class="phone1val">' . $this->customer['phone2'] . '</a></span>':'',
   483             '[email]' => (isset($this->customer['email']))?$this->customer['email']:'',
   484             '[adress]' => (isset($this->customer['address']))?$this->customer['address']:'',
   485             '[locations-with-zip]' => $this->locations_tag(),
   486             '[near-me-by]' => '',
   487             '[under-main]' => '',
   488             '[more-locations]'=> '',
   489             '[url_lco]' => (isset($this->location['city']['county_name']))?strtolower(str_replace(' ', '_', $this->location['city']['county_name'] . " county")):'',
   490             '[url_lci]' => (isset($this->location['city']['city_name']))?strtolower(str_replace(' ', '_', $this->location['city']['city_name'])):'',
   

5. APPPATH/classes/Controller/Welcome.php [ 653 ] » Controller_Welcome->replace_tag()

   648 
   649     public function  after() 
   650     {
   651         parent::after();
   652         $this->get_customer();
   653         $this->replace_tag();
   654         // Передаем данные в шаблон
   655         $this->template = View::factory($this->template);
   656         $this->template->title = $this->title;
   657         $this->template->keywords = $this->keywords;
   658         $this->template->description = $this->description;
   

6. SYSPATH/classes/Kohana/Controller.php [ 87 ] » Controller_Welcome->after()

   82 
   83 		// Execute the action itself
   84 		$this->{$action}();
   85 
   86 		// Execute the "after action" method
   87 		$this->after();
   88 
   89 		// Return the response
   90 		return $this->response;
   91 	}
   92 
   

7. {PHP internal call} » Kohana_Controller->execute()

8. SYSPATH/classes/Kohana/Request/Client/Internal.php [ 97 ] » ReflectionMethod->invoke(arguments)

   0

   object Controller_Welcome(14) { public template => string(4) "main" public location => array(4) ( "permission" => NULL "state" => array(6) ( "state_id" => string(2) "10" "state_name" => string(7) "Florida" "url_name" => string(2) "fl" "state_short" => string(2) "FL" "published" => string(1) "1" "area_name" => string(6) "states" ) "city" => array(7) ( "county_id" => string(3) "265" "state_id" => string(2) "10" "county_name" => string(8) "Pinellas" "url_name" => string(8) "pinellas" "published" => string(1) "1" "area_name" => string(8) "counties" "customer_id" => string(1) "0" ) "type" => string(6) "county" ) protected typelocation => string(6) "county" public auto_render => bool FALSE private title => string(56) "Locksmith Near Me [lco], [sst] - Find a Local Locksmith " private keywords => string(137) "locksmith near me [klco] [ssst],locksmith near me [klco] [klst],local locksmith [klco], local locksmith [klco] [ssst],locksmith  …" private description => string(84) "Locksmith Near Me [lco], [sst] - Local 24 hr Locksmith close to you in [lco], [lst]." private nav => string(2853) "<!-- [lco] [sst] --> <header> <div class="l1"> </div> <div class="l2"> <div id="homebanner">  …" private content => string(8220) "<div class="l4"> <div class="colum2 colum0"> </div> <div class="colum1"> < …" private footer => string(7492) " <footer id="footer"> [locations] [more-locations] <div class="l7"> <ul>  …" private replace => array(7) ( "[categories]" => string(0) "" "[cat_cat]" => string(0) "" "[side-menu]" => string(1135) " <div class="items" style="background-color: #00adee; margin:5px; padding:10px;"><img src="/public/ic …" "[near-me-by]" => string(4) "City" "[under-main]" => string(27) "Provides Locksmith Services" "[locations]" => string(3762) " <div class="l6"> <div class="loclist"> <span class="lochead">Locksmith Near Me by [near-me-by]:</span>  …" "[more-locations]" => string(1493) " <div class="row" class="select_some_loc"> <div class="col-lg-12 col-xs-12" onclick="toggle_sp('spoiler', 'arrow1')" class= …" ) private customer => array(8) ( "id" => string(1) "0" "company" => string(24) "COMPANY_NAME_IN_DATABASE" "logo" => string(8) "logo.svg" "address" => string(11) "St. Hard 12" "phone" => string(12) "786-358-5711" "phone2" => string(0) "" "email" => string(30) "locksmithfllocksmith@gmail.com" "sell_leads" => string(1) "0" ) public request => object Request(19) { protected _requested_with => NULL protected _method => string(3) "GET" protected _protocol => string(8) "HTTP/1.0" protected _secure => bool TRUE protected _referrer => NULL protected _route => object Route(5) { protected _filters => array(0) protected _uri => string(21) "<state>/<page>_<city>" protected _regex => array(2) ( "state" => string(152) "al|ak|az|ar|ca|co|ct|de|fl|ga|hi|id|il|in|ia|ks|ky|la|me|md|ma|mi|mn|ms|mo|mt|ne|nv|nh|nj|nm|ny|nc|nd|oh|ok|or|pa|ri|sc|sd|tn|tx …" "page" => string(307) "lockout-locksmith|car-locksmith|change-locks|24-hour-locksmith|services|lockout-locksmith|car-locksmith|change-locks|24-hour-loc …" ) protected _defaults => array(2) ( "controller" => string(7) "welcome" "action" => string(8) "generate" ) protected _route_regex => string(510) "#^(?P<state>al|ak|az|ar|ca|co|ct|de|fl|ga|hi|id|il|in|ia|ks|ky|la|me|md|ma|mi|mn|ms|mo|mt|ne|nv|nh|nj|nm|ny|nc|nd|oh|ok|or|pa|ri …" } protected _routes => array(0) protected _header => object HTTP_Header(0) { } protected _body => NULL protected _directory => string(0) "" protected _controller => string(7) "Welcome" protected _action => string(8) "generate" protected _uri => string(36) "fl/locksmith-near-me_pinellas_county" protected _external => bool FALSE protected _params => array(3) ( "state" => string(2) "fl" "page" => string(17) "locksmith-near-me" "city" => string(15) "pinellas_county" ) protected _get => array(0) protected _post => array(0) protected _cookies => array(0) protected _client => object Request_Client_Internal(9) { protected _previous_environment => NULL protected _cache => NULL protected _follow => bool FALSE protected _follow_headers => array(1) ( 0 => string(13) "Authorization" ) protected _strict_redirect => bool TRUE protected _header_callbacks => array(1) ( "Location" => string(34) "Request_Client::on_header_location" ) protected _max_callback_depth => integer 5 protected _callback_depth => integer 1 protected _callback_params => array(0) } } public response => object Response(5) { protected _status => integer 200 protected _header => object HTTP_Header(0) { } protected _body => string(0) "" protected _cookies => array(0) protected _protocol => string(8) "HTTP/1.0" } }

    92 
    93 			// Create a new instance of the controller
    94 			$controller = $class->newInstance($request, $response);
    95 
    96 			// Run the controller's execute() method
    97 			$response = $class->getMethod('execute')->invoke($controller);
    98 
    99 			if ( ! $response instanceof Response)
   100 			{
   101 				// Controller failed to return a Response.
   102 				throw new Kohana_Exception('Controller failed to return a Response');
   

9. SYSPATH/classes/Kohana/Request/Client.php [ 114 ] » Kohana_Request_Client_Internal->execute_request(arguments)

   0

   object Request(19) { protected _requested_with => NULL protected _method => string(3) "GET" protected _protocol => string(8) "HTTP/1.0" protected _secure => bool TRUE protected _referrer => NULL protected _route => object Route(5) { protected _filters => array(0) protected _uri => string(21) "<state>/<page>_<city>" protected _regex => array(2) ( "state" => string(152) "al|ak|az|ar|ca|co|ct|de|fl|ga|hi|id|il|in|ia|ks|ky|la|me|md|ma|mi|mn|ms|mo|mt|ne|nv|nh|nj|nm|ny|nc|nd|oh|ok|or|pa|ri|sc|sd|tn|tx …" "page" => string(307) "lockout-locksmith|car-locksmith|change-locks|24-hour-locksmith|services|lockout-locksmith|car-locksmith|change-locks|24-hour-loc …" ) protected _defaults => array(2) ( "controller" => string(7) "welcome" "action" => string(8) "generate" ) protected _route_regex => string(510) "#^(?P<state>al|ak|az|ar|ca|co|ct|de|fl|ga|hi|id|il|in|ia|ks|ky|la|me|md|ma|mi|mn|ms|mo|mt|ne|nv|nh|nj|nm|ny|nc|nd|oh|ok|or|pa|ri …" } protected _routes => array(0) protected _header => object HTTP_Header(0) { } protected _body => NULL protected _directory => string(0) "" protected _controller => string(7) "Welcome" protected _action => string(8) "generate" protected _uri => string(36) "fl/locksmith-near-me_pinellas_county" protected _external => bool FALSE protected _params => array(3) ( "state" => string(2) "fl" "page" => string(17) "locksmith-near-me" "city" => string(15) "pinellas_county" ) protected _get => array(0) protected _post => array(0) protected _cookies => array(0) protected _client => object Request_Client_Internal(9) { protected _previous_environment => NULL protected _cache => NULL protected _follow => bool FALSE protected _follow_headers => array(1) ( 0 => string(13) "Authorization" ) protected _strict_redirect => bool TRUE protected _header_callbacks => array(1) ( "Location" => string(34) "Request_Client::on_header_location" ) protected _max_callback_depth => integer 5 protected _callback_depth => integer 1 protected _callback_params => array(0) } }

   1

   object Response(5) { protected _status => integer 200 protected _header => object HTTP_Header(0) { } protected _body => string(0) "" protected _cookies => array(0) protected _protocol => string(8) "HTTP/1.0" }

   109 		$orig_response = $response = Response::factory(array('_protocol' => $request->protocol()));
   110 
   111 		if (($cache = $this->cache()) instanceof HTTP_Cache)
   112 			return $cache->execute($this, $request, $response);
   113 
   114 		$response = $this->execute_request($request, $response);
   115 
   116 		// Execute response callbacks
   117 		foreach ($this->header_callbacks() as $header => $callback)
   118 		{
   119 			if ($response->headers($header))
   

10. SYSPATH/classes/Kohana/Request.php [ 986 ] » Kohana_Request_Client->execute(arguments)

    0

    object Request(19) { protected _requested_with => NULL protected _method => string(3) "GET" protected _protocol => string(8) "HTTP/1.0" protected _secure => bool TRUE protected _referrer => NULL protected _route => object Route(5) { protected _filters => array(0) protected _uri => string(21) "<state>/<page>_<city>" protected _regex => array(2) ( "state" => string(152) "al|ak|az|ar|ca|co|ct|de|fl|ga|hi|id|il|in|ia|ks|ky|la|me|md|ma|mi|mn|ms|mo|mt|ne|nv|nh|nj|nm|ny|nc|nd|oh|ok|or|pa|ri|sc|sd|tn|tx …" "page" => string(307) "lockout-locksmith|car-locksmith|change-locks|24-hour-locksmith|services|lockout-locksmith|car-locksmith|change-locks|24-hour-loc …" ) protected _defaults => array(2) ( "controller" => string(7) "welcome" "action" => string(8) "generate" ) protected _route_regex => string(510) "#^(?P<state>al|ak|az|ar|ca|co|ct|de|fl|ga|hi|id|il|in|ia|ks|ky|la|me|md|ma|mi|mn|ms|mo|mt|ne|nv|nh|nj|nm|ny|nc|nd|oh|ok|or|pa|ri …" } protected _routes => array(0) protected _header => object HTTP_Header(0) { } protected _body => NULL protected _directory => string(0) "" protected _controller => string(7) "Welcome" protected _action => string(8) "generate" protected _uri => string(36) "fl/locksmith-near-me_pinellas_county" protected _external => bool FALSE protected _params => array(3) ( "state" => string(2) "fl" "page" => string(17) "locksmith-near-me" "city" => string(15) "pinellas_county" ) protected _get => array(0) protected _post => array(0) protected _cookies => array(0) protected _client => object Request_Client_Internal(9) { protected _previous_environment => NULL protected _cache => NULL protected _follow => bool FALSE protected _follow_headers => array(1) ( 0 => string(13) "Authorization" ) protected _strict_redirect => bool TRUE protected _header_callbacks => array(1) ( "Location" => string(34) "Request_Client::on_header_location" ) protected _max_callback_depth => integer 5 protected _callback_depth => integer 1 protected _callback_params => array(0) } }

    981 			throw new Request_Exception('Unable to execute :uri without a Kohana_Request_Client', array(
    982 				':uri' => $this->_uri,
    983 			));
    984 		}
    985 
    986 		return $this->_client->execute($this);
    987 	}
    988 
    989 	/**
    990 	 * Returns whether this request is the initial request Kohana received.
    991 	 * Can be used to test for sub requests.
    

11. DOCROOT/index.php [ 344 ] » Kohana_Request->execute()

    339 	 * If no source is specified, the URI will be automatically detected.
    340 	 */
    341 
    342 	// $request = Request::factory(TRUE, array('status'=>200), FALSE)
    343 	$request = Request::factory()
    344 		->execute();
    345 		echo $request->body();
    346 }