Database_Exception [ 1114 ]: The table '/var/tmp/#sql859a8_6484_0' is full [ select uid, u.id as id, u.first_name, u.last_name, u.address, u.photo, sum(rate) as tr from rating r inner join users u on r.uid = u.id where u.user_type = 1 group by uid order by sum(rate) DESC LIMIT 50 ]

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

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

`0`	integer 1
`1`	string(203) "select uid, u.id as id, u.first_name, u.last_name, u.address, u.photo, sum(rate) as tr from rating r inner join users u on r.uid …"
`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);

APPPATH/classes/Model/User.php [ 5639 ] » Kohana_Database_Query->execute()

5634     }
5635 
5636     public function rating_teachers($per_page, $offset)
5637     {
5638         return DB::query(Database::SELECT, "select uid, u.id as id, u.first_name, u.last_name, u.address, u.photo, sum(rate) as tr from rating r inner join users u on r.uid = u.id where u.user_type = 1 group by uid order by sum(rate) DESC LIMIT ".$per_page)
5639             ->execute()
5640             ->as_array();
5641     }
5642 
5643     public function total_rating_students()
5644     {

APPPATH/views/pages/ratings.php [ 24 ] » Model_User->rating_teachers(arguments)

`0`	integer 50
`1`	NULL

19 //                $memcache->set('total_rating_teachers', $total_items, 86400);
20 //            }
21 
22          //   $total_items = Model::factory("User")->total_rating_teachers();
23        //     $pages = Pagination::factory(array('total_items' => $total_items, 'items_per_page'    =>  50, 'view' => 'pagination/floating'));
24             $users = Model::factory("User")->rating_teachers(50, $pages->offset);
25 
26           /*  if (Cache::instance()->get('rating_teachers', FALSE)) {
27                 $users = Cache::instance()->get('rating_teachers');
28             } else {
29                 $users = Model::factory("User")->rating_teachers(50, $pages->offset);

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

`0`	string(78) "/var/www/www-root/data/www/uchportfolio.ru/application/views/pages/ratings.php"

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

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

`0`	string(79) "/var/www/www-root/data/www/uchportfolio.ru/application/views//pages/ratings.php"
`1`	array(0)

343 		{
344 			throw new View_Exception('You must set the file to use within your view before rendering');
345 		}
346 
347 		// Combine local and global data and capture the output
348 		return View::capture($this->_file, $this->_data);
349 	}
350 
351 }

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

223 	 */
224 	public function __toString()
225 	{
226 		try
227 		{
228 			return $this->render();
229 		}
230 		catch (Exception $e)
231 		{
232 			/**
233 			 * Display the exception message.

APPPATH/views/layout.php [ 399 ] » Kohana_View->__toString()

394              <?=$left_column;?>
395              <!-- Enf Of Left column  -->
396 
397              <!-- Center column  -->
398              <div class="<?=$main_center;?> portfolio_s" id="main_center">
399                  <?=$content;?>
400              </div>
401              <!-- End Of Center column  -->
402 
403              <!-- Right column  -->
404              <?php if (isset($its_start)) { ?> <div class="stick-right-column"> <?php } ?>

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

`0`	string(71) "/var/www/www-root/data/www/uchportfolio.ru/application/views/layout.php"

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

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

0

string(71) "/var/www/www-root/data/www/uchportfolio.ru/application/views/layout.php"

1

array(8) (
    "content" => object View(2) {
        protected _file => string(79) "/var/www/www-root/data/www/uchportfolio.ru/application/views//pages/ratings.php"
        protected _data => array(0) 
    }
    "styles" => string(0) ""
    "scripts" => string(0) ""
    "left_column" => string(0) ""
    "right_column" => string(0) ""
    "main_center" => string(11) "main_center"
    "curr_path" => string(13) "Ratings/index"
    "title" => string(110) "Рейтинги | Педагогическое Интернет-сообщество "УчПортфолио""
)

343 		{
344 			throw new View_Exception('You must set the file to use within your view before rendering');
345 		}
346 
347 		// Combine local and global data and capture the output
348 		return View::capture($this->_file, $this->_data);
349 	}
350 
351 }

SYSPATH/classes/Kohana/Controller/Template.php [ 44 ] » Kohana_View->render()

39 	 */
40 	public function after()
41 	{
42 		if ($this->auto_render === TRUE)
43 		{
44 			$this->response->body($this->template->render());
45 		}
46 
47 		parent::after();
48 	}
49

SYSPATH/classes/Kohana/Controller.php [ 87 ] » Kohana_Controller_Template->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

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

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

0

object Controller_Ratings(5) {
    private _salt => string(3) "Yif"
    public template => object View(2) {
        protected _file => string(71) "/var/www/www-root/data/www/uchportfolio.ru/application/views/layout.php"
        protected _data => array(8) (
            "content" => object View(2) {
                protected _file => string(79) "/var/www/www-root/data/www/uchportfolio.ru/application/views//pages/ratings.php"
                protected _data => array(0) 
            }
            "styles" => string(0) ""
            "scripts" => string(0) ""
            "left_column" => string(0) ""
            "right_column" => string(0) ""
            "main_center" => string(11) "main_center"
            "curr_path" => string(13) "Ratings/index"
            "title" => string(110) "Рейтинги | Педагогическое Интернет-сообщество "УчПортфолио""
        )
    }
    public auto_render => bool TRUE
    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(16) "ratings(/<page>)"
            protected _regex => array(0) 
            protected _defaults => array(2) (
                "controller" => string(7) "ratings"
                "action" => string(5) "index"
            )
            protected _route_regex => string(41) "#^ratings(?:/(?P<page>[^/.,;?\n]++))?$#uD"
        }
        protected _routes => array(0) 
        protected _header => object HTTP_Header(0) {
        }
        protected _body => NULL
        protected _directory => string(0) ""
        protected _controller => string(7) "Ratings"
        protected _action => string(5) "index"
        protected _uri => string(7) "ratings"
        protected _external => bool FALSE
        protected _params => array(0) 
        protected _get => array(3) (
            "page" => string(2) "72"
            "amp;amp;spage" => string(2) "17"
            "spage" => string(2) "15"
        )
        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');

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(16) "ratings(/<page>)"
        protected _regex => array(0) 
        protected _defaults => array(2) (
            "controller" => string(7) "ratings"
            "action" => string(5) "index"
        )
        protected _route_regex => string(41) "#^ratings(?:/(?P<page>[^/.,;?\n]++))?$#uD"
    }
    protected _routes => array(0) 
    protected _header => object HTTP_Header(0) {
    }
    protected _body => NULL
    protected _directory => string(0) ""
    protected _controller => string(7) "Ratings"
    protected _action => string(5) "index"
    protected _uri => string(7) "ratings"
    protected _external => bool FALSE
    protected _params => array(0) 
    protected _get => array(3) (
        "page" => string(2) "72"
        "amp;amp;spage" => string(2) "17"
        "spage" => string(2) "15"
    )
    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))

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(16) "ratings(/<page>)"
        protected _regex => array(0) 
        protected _defaults => array(2) (
            "controller" => string(7) "ratings"
            "action" => string(5) "index"
        )
        protected _route_regex => string(41) "#^ratings(?:/(?P<page>[^/.,;?\n]++))?$#uD"
    }
    protected _routes => array(0) 
    protected _header => object HTTP_Header(0) {
    }
    protected _body => NULL
    protected _directory => string(0) ""
    protected _controller => string(7) "Ratings"
    protected _action => string(5) "index"
    protected _uri => string(7) "ratings"
    protected _external => bool FALSE
    protected _params => array(0) 
    protected _get => array(3) (
        "page" => string(2) "72"
        "amp;amp;spage" => string(2) "17"
        "spage" => string(2) "15"
    )
    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.

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

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

Environment

Included files (98)

DOCROOT/index.php

APPPATH/bootstrap.php

SYSPATH/classes/Kohana/Core.php

SYSPATH/classes/Kohana.php

SYSPATH/classes/I18n.php

SYSPATH/classes/Kohana/I18n.php

SYSPATH/classes/HTTP.php

SYSPATH/classes/Kohana/HTTP.php

SYSPATH/classes/Cookie.php

SYSPATH/classes/Kohana/Cookie.php

SYSPATH/classes/Date.php

SYSPATH/classes/Kohana/Date.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/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/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/Arr.php

SYSPATH/classes/Kohana/Arr.php

SYSPATH/classes/Response.php

SYSPATH/classes/Kohana/Response.php

SYSPATH/classes/HTTP/Response.php

SYSPATH/classes/Kohana/HTTP/Response.php

APPPATH/classes/Controller/Ratings.php

APPPATH/classes/Controller/Common.php

SYSPATH/classes/Controller/Template.php

SYSPATH/classes/Kohana/Controller/Template.php

SYSPATH/classes/Controller.php

SYSPATH/classes/Kohana/Controller.php

SYSPATH/classes/View.php

SYSPATH/classes/Kohana/View.php

SYSPATH/classes/Session.php

SYSPATH/classes/Kohana/Session.php

SYSPATH/config/session.php

MODPATH/database/config/session.php

SYSPATH/classes/Config/Group.php

SYSPATH/classes/Kohana/Config/Group.php

SYSPATH/classes/Session/Native.php

SYSPATH/classes/Kohana/Session/Native.php

SYSPATH/classes/Model.php

SYSPATH/classes/Kohana/Model.php

APPPATH/classes/Model/User.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/MySQL.php

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

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

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

MODPATH/database/classes/Database/Result.php

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

APPPATH/views/layout.php

SYSPATH/classes/URL.php

SYSPATH/classes/Kohana/URL.php

SYSPATH/classes/UTF8.php

SYSPATH/classes/Kohana/UTF8.php

APPPATH/classes/Model/Site.php

APPPATH/classes/Model/vendor/autoload.php

APPPATH/classes/Model/vendor/composer/autoload_real.php

APPPATH/classes/Model/vendor/composer/platform_check.php

APPPATH/classes/Model/vendor/composer/ClassLoader.php

APPPATH/classes/Model/vendor/composer/autoload_static.php

APPPATH/views/pages/ratings.php

MODPATH/database/classes/Database/Exception.php

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

SYSPATH/classes/Kohana/Exception.php

SYSPATH/classes/Kohana/Kohana/Exception.php

APPPATH/i18n/ru/ru.php

SYSPATH/classes/Debug.php

SYSPATH/classes/Kohana/Debug.php

SYSPATH/views/kohana/error.php

Loaded extensions (51)

Core

date

ereg

libxml

openssl

pcre

sqlite3

zlib

bz2

calendar

ctype

hash

fileinfo

filter

ftp

gettext

gmp

SPL

iconv

session

standard

Reflection

Phar

shmop

SimpleXML

sockets

mbstring

tokenizer

xml

apache2handler

mysqlnd

PDO

curl

dom

gd

intl

json

exif

mcrypt

mysql

mysqli

pdo_mysql

soap

ssh2

xmlreader

xmlrpc

xmlwriter

zip

mhash

ionCube Loader

Zend OPcache

$_GET

`page`	string(2) "72"
`amp;amp;spage`	string(2) "17"
`spage`	string(2) "15"

$_SERVER

`REDIRECT_HTTPS`	string(2) "on"
`REDIRECT_UNIQUE_ID`	string(27) "ZioL7ByAczZDDD-B18GDqAAAAAY"
`REDIRECT_PERL5LIB`	string(49) "/usr/share/awstats/lib:/usr/share/awstats/plugins"
`REDIRECT_STATUS`	string(3) "200"
`HTTPS`	string(2) "on"
`UNIQUE_ID`	string(27) "ZioL7ByAczZDDD-B18GDqAAAAAY"
`PERL5LIB`	string(49) "/usr/share/awstats/lib:/usr/share/awstats/plugins"
`HTTP_HOST`	string(15) "uchportfolio.ru"
`HTTP_X_FORWARDED_PROTO`	string(5) "https"
`HTTP_X_FORWARDED_PORT`	string(3) "443"
`HTTP_CONNECTION`	string(5) "close"
`HTTP_ACCEPT`	string(3) "/"
`HTTP_USER_AGENT`	string(103) "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
`PATH`	string(49) "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin"
`SERVER_SIGNATURE`	string(0) ""
`SERVER_SOFTWARE`	string(65) "Apache/2.4.37 (centos) mpm-itk/2.4.7-04 OpenSSL/1.1.1k PHP/5.6.40"
`SERVER_NAME`	string(15) "uchportfolio.ru"
`SERVER_ADDR`	string(9) "127.0.0.1"
`SERVER_PORT`	string(2) "80"
`REMOTE_ADDR`	string(11) "3.145.108.9"
`DOCUMENT_ROOT`	string(42) "/var/www/www-root/data/www/uchportfolio.ru"
`REQUEST_SCHEME`	string(4) "http"
`CONTEXT_PREFIX`	string(0) ""
`CONTEXT_DOCUMENT_ROOT`	string(42) "/var/www/www-root/data/www/uchportfolio.ru"
`SERVER_ADMIN`	string(25) "webmaster@uchportfolio.ru"
`SCRIPT_FILENAME`	string(52) "/var/www/www-root/data/www/uchportfolio.ru/index.php"
`REMOTE_PORT`	string(5) "59362"
`REDIRECT_URL`	string(8) "/ratings"
`REDIRECT_QUERY_STRING`	string(37) "page=72&amp%3Bamp%3Bspage=17&spage=15"
`GATEWAY_INTERFACE`	string(7) "CGI/1.1"
`SERVER_PROTOCOL`	string(8) "HTTP/1.0"
`REQUEST_METHOD`	string(3) "GET"
`QUERY_STRING`	string(37) "page=72&amp%3Bamp%3Bspage=17&spage=15"
`REQUEST_URI`	string(46) "/ratings?page=72&amp%3Bamp%3Bspage=17&spage=15"
`SCRIPT_NAME`	string(10) "/index.php"
`PATH_INFO`	string(8) "/ratings"
`PATH_TRANSLATED`	string(27) "redirect:/index.php/ratings"
`PHP_SELF`	string(18) "/index.php/ratings"
`REQUEST_TIME_FLOAT`	float 1714031596.939
`REQUEST_TIME`	integer 1714031596