MODPATH/database/classes/Kohana/Database/MySQLi.php [ 171 ]

166 			{
167 				// This benchmark is worthless
168 				Profiler::delete($benchmark);
169 			}
170 
171 			throw new Database_Exception(':error [ :query ]', array(
172 				':error' => $this->_connection->error,
173 				':query' => $sql
174 			), $this->_connection->errno);
175 		}
176

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

`0`	integer 1
`1`	string(131) "SELECT immobili_immagini.nome FROM immobili_immagini WHERE id_immobile = AND principale <> 1 …"
`2`	bool TRUE
`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);

APPPATH/classes/Model/Immobili.php [ 278 ] » Kohana_Database_Query->execute()

273 		return DB::query(Database::SELECT, 
274 					   'SELECT immobili_immagini.nome
275 					   FROM immobili_immagini
276 					   WHERE id_immobile = '.$id.' 
277 					   AND principale <> 1
278 					   ')->as_object()->execute();
279 		
280 	}
281 	
282 	
283

APPPATH/views/scheda_immobile.php [ 123 ] » Model_Immobili->get_immagini(arguments)

0

NULL

118 									<li>
119 									<div class="slider-images" style="overflow: hidden" >
120 										<img  class="principale" src="<?PHP echo ORM::factory('Immobili')->get_foto_principale($dati_immobile->id, 'medium', 'it'); ?>" alt="">
121 										</div>
122 									</li>
123 									<?PHP $res = ORM::factory('Immobili')->get_immagini($dati_immobile->id); ?>
124 									<?PHP foreach($res as $immagine): 
125 									$data = getimagesize("https://".$_SERVER['SERVER_NAME']."/public/immobili/".$dati_immobile->id."/immagini/medium/".$immagine->nome);
126 									$width = $data[0];
127 									$height = $data[1];								
128

SYSPATH/classes/Kohana/View.php [ 62 ] » include(arguments)

`0`	string(93) "/var/www/vhosts/immobiliareplurima.it/httpdocs/application/frontend/views/scheda_immobile.php"

57 		ob_start();
58 
59 		try
60 		{
61 			// Load the view within the current scope
62 			include $kohana_view_filename;
63 		}
64 		catch (Exception $e)
65 		{
66 			// Delete the output buffer
67 			ob_end_clean();

SYSPATH/classes/Kohana/View.php [ 359 ] » Kohana_View::capture(arguments)

0

string(93) "/var/www/vhosts/immobiliareplurima.it/httpdocs/application/frontend/views/scheda_immobile.php"

1

array(4) (
    "dati_immobile" => NULL
    "box_ricerca" => object View(2) {
        protected _file => string(97) "/var/www/vhosts/immobiliareplurima.it/httpdocs/application/frontend/views/include/box_ricerca.php"
        protected _data => array(0) 
    }
    "header" => object View(2) {
        protected _file => string(92) "/var/www/vhosts/immobiliareplurima.it/httpdocs/application/frontend/views/include/header.php"
        protected _data => array(0) 
    }
    "footer" => object View(2) {
        protected _file => string(92) "/var/www/vhosts/immobiliareplurima.it/httpdocs/application/frontend/views/include/footer.php"
        protected _data => array(0) 
    }
)

354 		{
355 			throw new View_Exception('You must set the file to use within your view before rendering');
356 		}
357 
358 		// Combine local and global data and capture the output
359 		return View::capture($this->_file, $this->_data);
360 	}
361 
362 }

SYSPATH/classes/Kohana/View.php [ 236 ] » Kohana_View->render()

231 	 */
232 	public function __toString()
233 	{
234 		try
235 		{
236 			return $this->render();
237 		}
238 		catch (Exception $e)
239 		{
240 			/**
241 			 * Display the exception message.

SYSPATH/classes/Kohana/Response.php [ 160 ] » Kohana_View->__toString()

155 	public function body($content = NULL)
156 	{
157 		if ($content === NULL)
158 			return $this->_body;
159 
160 		$this->_body = (string) $content;
161 		return $this;
162 	}
163 
164 	/**
165 	 * Gets or sets the HTTP protocol. The standard protocol to use

APPPATH/classes/Controller/Home.php [ 154 ] » Kohana_Response->body(arguments)

0

object View(2) {
    protected _file => string(93) "/var/www/vhosts/immobiliareplurima.it/httpdocs/application/frontend/views/scheda_immobile.php"
    protected _data => array(4) (
        "dati_immobile" => NULL
        "box_ricerca" => object View(2) {
            protected _file => string(97) "/var/www/vhosts/immobiliareplurima.it/httpdocs/application/frontend/views/include/box_ricerca.php"
            protected _data => array(0) 
        }
        "header" => object View(2) {
            protected _file => string(92) "/var/www/vhosts/immobiliareplurima.it/httpdocs/application/frontend/views/include/header.php"
            protected _data => array(0) 
        }
        "footer" => object View(2) {
            protected _file => string(92) "/var/www/vhosts/immobiliareplurima.it/httpdocs/application/frontend/views/include/footer.php"
            protected _data => array(0) 
        }
    )
}

149 		
150 		$view->dati_immobile = $dati_immobile;
151 		$view->box_ricerca = View::factory('include/box_ricerca');
152 		$view->header = View::factory('include/header');
153 		$view->footer = View::factory('include/footer');
154 		$this->response->body($view);
155 	}	
156 			
157 			
158 	public function action_notizie_immobiliare_plurima()
159 	{

SYSPATH/classes/Kohana/Controller.php [ 84 ] » Controller_Home->action_scheda_immobile()

79 				array(':uri' => $this->request->uri())
80 			)->request($this->request);
81 		}
82 
83 		// Execute the action itself
84 		$this->{$action}();
85 
86 		// Execute the "after action" method
87 		$this->after();
88 
89 		// Return the response

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

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

0

object Controller_Home(3) {
    public request => object Request(19) {
        protected _requested_with => NULL
        protected _method => string(3) "GET"
        protected _protocol => string(8) "HTTP/1.1"
        protected _secure => bool TRUE
        protected _referrer => NULL
        protected _route => object Route(5) {
            protected _filters => array(0) 
            protected _uri => string(51) "((<lang>/)scheda_immobile(/<id>-<slug>))(.<format>)"
            protected _regex => array(4) (
                "format" => string(16) "html|xml|json|.+"
                "id" => string(6) "[0-9]+"
                "lang" => string(7) "(it|xx)"
                "slug" => string(2) ".+"
            )
            protected _defaults => array(4) (
                "controller" => string(4) "home"
                "action" => string(15) "scheda_immobile"
                "lang" => string(2) "it"
                "format" => string(0) ""
            )
            protected _route_regex => string(117) "#^(?:(?:(?P<lang>(it|xx))/)?scheda_immobile(?:/(?P<id>[0-9]+)-(?P<slug>.+))?)?(?:\.(?P<format>html|xml|json|.+))?$#uD"
        }
        protected _routes => array(0) 
        protected _header => object HTTP_Header(0) {
        }
        protected _body => NULL
        protected _directory => string(0) ""
        protected _controller => string(4) "Home"
        protected _action => string(15) "scheda_immobile"
        protected _uri => string(76) "it/scheda_immobile/87-villetta-a-schiera-su-3-livelli-località-petrosa.html"
        protected _external => bool FALSE
        protected _params => array(4) (
            "lang" => string(2) "it"
            "id" => string(2) "87"
            "slug" => string(54) "villetta-a-schiera-su-3-livelli-località-petrosa.html"
            "format" => string(0) ""
        )
        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.1"
    }
    public session => object Session_Native(5) {
        protected _name => string(12) "pronto_front"
        protected _lifetime => integer 0
        protected _encrypted => bool FALSE
        protected _data => array(0) 
        protected _destroyed => bool FALSE
    }
}

 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');

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.1"
    protected _secure => bool TRUE
    protected _referrer => NULL
    protected _route => object Route(5) {
        protected _filters => array(0) 
        protected _uri => string(51) "((<lang>/)scheda_immobile(/<id>-<slug>))(.<format>)"
        protected _regex => array(4) (
            "format" => string(16) "html|xml|json|.+"
            "id" => string(6) "[0-9]+"
            "lang" => string(7) "(it|xx)"
            "slug" => string(2) ".+"
        )
        protected _defaults => array(4) (
            "controller" => string(4) "home"
            "action" => string(15) "scheda_immobile"
            "lang" => string(2) "it"
            "format" => string(0) ""
        )
        protected _route_regex => string(117) "#^(?:(?:(?P<lang>(it|xx))/)?scheda_immobile(?:/(?P<id>[0-9]+)-(?P<slug>.+))?)?(?:\.(?P<format>html|xml|json|.+))?$#uD"
    }
    protected _routes => array(0) 
    protected _header => object HTTP_Header(0) {
    }
    protected _body => NULL
    protected _directory => string(0) ""
    protected _controller => string(4) "Home"
    protected _action => string(15) "scheda_immobile"
    protected _uri => string(76) "it/scheda_immobile/87-villetta-a-schiera-su-3-livelli-località-petrosa.html"
    protected _external => bool FALSE
    protected _params => array(4) (
        "lang" => string(2) "it"
        "id" => string(2) "87"
        "slug" => string(54) "villetta-a-schiera-su-3-livelli-località-petrosa.html"
        "format" => string(0) ""
    )
    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.1"
}

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))

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

0

object Request(19) {
    protected _requested_with => NULL
    protected _method => string(3) "GET"
    protected _protocol => string(8) "HTTP/1.1"
    protected _secure => bool TRUE
    protected _referrer => NULL
    protected _route => object Route(5) {
        protected _filters => array(0) 
        protected _uri => string(51) "((<lang>/)scheda_immobile(/<id>-<slug>))(.<format>)"
        protected _regex => array(4) (
            "format" => string(16) "html|xml|json|.+"
            "id" => string(6) "[0-9]+"
            "lang" => string(7) "(it|xx)"
            "slug" => string(2) ".+"
        )
        protected _defaults => array(4) (
            "controller" => string(4) "home"
            "action" => string(15) "scheda_immobile"
            "lang" => string(2) "it"
            "format" => string(0) ""
        )
        protected _route_regex => string(117) "#^(?:(?:(?P<lang>(it|xx))/)?scheda_immobile(?:/(?P<id>[0-9]+)-(?P<slug>.+))?)?(?:\.(?P<format>html|xml|json|.+))?$#uD"
    }
    protected _routes => array(0) 
    protected _header => object HTTP_Header(0) {
    }
    protected _body => NULL
    protected _directory => string(0) ""
    protected _controller => string(4) "Home"
    protected _action => string(15) "scheda_immobile"
    protected _uri => string(76) "it/scheda_immobile/87-villetta-a-schiera-su-3-livelli-località-petrosa.html"
    protected _external => bool FALSE
    protected _params => array(4) (
        "lang" => string(2) "it"
        "id" => string(2) "87"
        "slug" => string(54) "villetta-a-schiera-su-3-livelli-località-petrosa.html"
        "format" => string(0) ""
    )
    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) 
    }
}

988 			throw new Request_Exception('Unable to execute :uri without a Kohana_Request_Client', array(
989 				':uri' => $this->_uri,
990 			));
991 		}
992 
993 		return $this->_client->execute($this);
994 	}
995 
996 	/**
997 	 * Returns whether this request is the initial request Kohana received.
998 	 * Can be used to test for sub requests.

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

113 	/**
114 	 * Execute the main request. A source of the URI can be passed, eg: $_SERVER['PATH_INFO'].
115 	 * If no source is specified, the URI will be automatically detected.
116 	 */
117 	echo Request::factory(TRUE, array(), FALSE)
118 		->execute()
119 		->send_headers(TRUE)
120 		->body();
121 }

Included files (104)

DOCROOT/index.php

APPPATH/bootstrap.php

SYSPATH/classes/Kohana/Core.php

SYSPATH/classes/Kohana.php

APPPATH/vendor/swiftmailer/lib/swiftrequired.php

APPPATH/vendor/swiftmailer/lib/classes/Swift.php

SYSPATH/classes/I18n.php

SYSPATH/classes/Kohana/I18n.php

SYSPATH/classes/Cookie.php

SYSPATH/classes/Kohana/Cookie.php

SYSPATH/classes/Kohana/Exception.php

SYSPATH/classes/Kohana/Kohana/Exception.php

SYSPATH/classes/Log.php

SYSPATH/classes/Kohana/Log.php

SYSPATH/classes/Config.php

SYSPATH/classes/Kohana/Config.php

SYSPATH/classes/Log/File.php

SYSPATH/classes/Kohana/Log/File.php

SYSPATH/classes/Log/Writer.php

SYSPATH/classes/Kohana/Log/Writer.php

SYSPATH/classes/Config/File.php

SYSPATH/classes/Kohana/Config/File.php

SYSPATH/classes/Kohana/Config/File/Reader.php

SYSPATH/classes/Kohana/Config/Reader.php

SYSPATH/classes/Kohana/Config/Source.php

SYSPATH/classes/Arr.php

SYSPATH/classes/Kohana/Arr.php

APPPATH/config/lingua.php

SYSPATH/classes/Config/Group.php

SYSPATH/classes/Kohana/Config/Group.php

MODPATH/captcha/init.php

SYSPATH/classes/Route.php

SYSPATH/classes/Kohana/Route.php

SYSPATH/classes/Request.php

SYSPATH/classes/Kohana/Request.php

SYSPATH/classes/HTTP/Request.php

SYSPATH/classes/Kohana/HTTP/Request.php

SYSPATH/classes/HTTP/Message.php

SYSPATH/classes/Kohana/HTTP/Message.php

SYSPATH/classes/HTTP.php

SYSPATH/classes/Kohana/HTTP.php

SYSPATH/classes/HTTP/Header.php

SYSPATH/classes/Kohana/HTTP/Header.php

SYSPATH/classes/Request/Client/Internal.php

SYSPATH/classes/Kohana/Request/Client/Internal.php

SYSPATH/classes/Request/Client.php

SYSPATH/classes/Kohana/Request/Client.php

SYSPATH/classes/Response.php

SYSPATH/classes/Kohana/Response.php

SYSPATH/classes/HTTP/Response.php

SYSPATH/classes/Kohana/HTTP/Response.php

SYSPATH/classes/Profiler.php

SYSPATH/classes/Kohana/Profiler.php

APPPATH/classes/Controller/Home.php

APPPATH/classes/Controller/Website.php

SYSPATH/classes/Controller.php

SYSPATH/classes/Kohana/Controller.php

SYSPATH/classes/Session.php

SYSPATH/classes/Kohana/Session.php

SYSPATH/config/session.php

MODPATH/database/config/session.php

APPPATH/config/session.php

SYSPATH/classes/Session/Native.php

SYSPATH/classes/Kohana/Session/Native.php

SYSPATH/classes/View.php

SYSPATH/classes/Kohana/View.php

MODPATH/orm/classes/ORM.php

MODPATH/orm/classes/Kohana/ORM.php

SYSPATH/classes/Model.php

SYSPATH/classes/Kohana/Model.php

APPPATH/classes/Model/Immobili.php

MODPATH/database/classes/DB.php

MODPATH/database/classes/Kohana/DB.php

MODPATH/database/classes/Database.php

MODPATH/database/classes/Kohana/Database.php

MODPATH/database/classes/Database/Query.php

MODPATH/database/classes/Kohana/Database/Query.php

MODPATH/database/config/database.php

APPPATH/config/database.php

MODPATH/database/classes/Database/MySQLi.php

MODPATH/database/classes/Kohana/Database/MySQLi.php

MODPATH/database/classes/Database/MySQLi/Result.php

MODPATH/database/classes/Kohana/Database/MySQLi/Result.php

MODPATH/database/classes/Database/Result.php

MODPATH/database/classes/Kohana/Database/Result.php

APPPATH/views/scheda_immobile.php

MODPATH/database/classes/Database/Query/Builder/Select.php

MODPATH/database/classes/Kohana/Database/Query/Builder/Select.php

MODPATH/database/classes/Database/Query/Builder/Where.php

MODPATH/database/classes/Kohana/Database/Query/Builder/Where.php

MODPATH/database/classes/Database/Query/Builder.php

MODPATH/database/classes/Kohana/Database/Query/Builder.php

APPPATH/views/include/header.php

MODPATH/database/classes/Database/Query/Builder/Join.php

MODPATH/database/classes/Kohana/Database/Query/Builder/Join.php

MODPATH/database/classes/Database/Exception.php

MODPATH/database/classes/Kohana/Database/Exception.php

SYSPATH/classes/Debug.php

SYSPATH/classes/Kohana/Debug.php

SYSPATH/classes/Date.php

SYSPATH/classes/Kohana/Date.php

SYSPATH/views/kohana/error.php

SYSPATH/classes/UTF8.php

SYSPATH/classes/Kohana/UTF8.php

Loaded extensions (55)

Core

date

ereg

libxml

openssl

pcre

zlib

bcmath

bz2

calendar

ctype

dba

dom

hash

fileinfo

filter

ftp

gettext

SPL

iconv

json

mbstring

session

posix

Reflection

standard

shmop

SimpleXML

soap

sockets

Phar

exif

sysvmsg

sysvsem

sysvshm

tokenizer

wddx

xml

xmlreader

xmlwriter

zip

apache2handler

PDO

curl

gd

imap

mysql

mysqli

pdo_mysql

pdo_sqlite

sqlite3

xsl

imagick

mhash

ionCube Loader

$_SERVER

`REDIRECT_KOHANA_ENV`	string(10) "production"
`REDIRECT_HTTPS`	string(2) "on"
`REDIRECT_SSL_TLS_SNI`	string(25) "www.immobiliareplurima.it"
`REDIRECT_STATUS`	string(3) "200"
`KOHANA_ENV`	string(10) "production"
`HTTPS`	string(2) "on"
`SSL_TLS_SNI`	string(25) "www.immobiliareplurima.it"
`HTTP_USER_AGENT`	string(40) "CCBot/2.0 (https://commoncrawl.org/faq/)"
`HTTP_ACCEPT`	string(63) "text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8"
`HTTP_ACCEPT_LANGUAGE`	string(14) "en-US,en;q=0.5"
`HTTP_HOST`	string(25) "www.immobiliareplurima.it"
`HTTP_CONNECTION`	string(10) "Keep-Alive"
`HTTP_ACCEPT_ENCODING`	string(4) "gzip"
`PATH`	string(28) "/usr/local/bin:/usr/bin:/bin"
`SERVER_SIGNATURE`	string(71) "<address>Apache Server at www.immobiliareplurima.it Port 443</address> "
`SERVER_SOFTWARE`	string(6) "Apache"
`SERVER_NAME`	string(25) "www.immobiliareplurima.it"
`SERVER_ADDR`	string(12) "176.9.92.203"
`SERVER_PORT`	string(3) "443"
`REMOTE_ADDR`	string(13) "52.55.186.225"
`DOCUMENT_ROOT`	string(46) "/var/www/vhosts/immobiliareplurima.it/httpdocs"
`SERVER_ADMIN`	string(26) "stefano.poggioli@gmail.com"
`SCRIPT_FILENAME`	string(56) "/var/www/vhosts/immobiliareplurima.it/httpdocs/index.php"
`REMOTE_PORT`	string(5) "47172"
`REDIRECT_URL`	string(77) "/it/scheda_immobile/87-villetta-a-schiera-su-3-livelli-località-petrosa.html"
`GATEWAY_INTERFACE`	string(7) "CGI/1.1"
`SERVER_PROTOCOL`	string(8) "HTTP/1.1"
`REQUEST_METHOD`	string(3) "GET"
`QUERY_STRING`	string(0) ""
`REQUEST_URI`	string(81) "/it/scheda_immobile/87-villetta-a-schiera-su-3-livelli-localit%C3%A0-petrosa.html"
`SCRIPT_NAME`	string(10) "/index.php"
`PATH_INFO`	string(77) "/it/scheda_immobile/87-villetta-a-schiera-su-3-livelli-località-petrosa.html"
`PATH_TRANSLATED`	string(170) "redirect:/index.php/it/scheda_immobile/87-villetta-a-schiera-su-3-livelli-località-petrosa.html/scheda_immobile/87-villetta-a-sc …"
`PHP_SELF`	string(87) "/index.php/it/scheda_immobile/87-villetta-a-schiera-su-3-livelli-località-petrosa.html"
`REQUEST_TIME_FLOAT`	float 1556002575,754
`REQUEST_TIME`	integer 1556002575

Database_Exception [ 1064 ]: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND principale <> 1' at line 4 [ SELECT immobili_immagini.nome FROM immobili_immagini WHERE id_immobile = AND principale <> 1 ]

Environment

Included files (104)

Loaded extensions (55)

$_SERVER