Chyba nahlasena z: . works/show_by_user/443 (file: 374, line: 374)

Mysql_Result->__construct(  )

Database_Mysql_Driver->query( 
				SELECT q.*, (agree_count - disagree_count) AS approval_state FROM (
					SELECT j.*,
					(
						SELECT COUNT(*)
						FROM votes
						WHERE vote = 1 AND votes.fk_id = j.id AND votes.type = 1
					) AS agree_count,
					(
						SELECT COUNT(*)
						FROM votes
						WHERE vote = -1 AND votes.fk_id = j.id AND votes.type = 1
					) AS disagree_count,
					(
						SELECT COUNT(*)
						FROM votes
						WHERE vote = 0 AND votes.fk_id = j.id AND votes.type = 1
					) AS abstain_count,
					(
						SELECT COUNT(*)
						FROM comments c
						WHERE j.comments_thread_id = c.comments_thread_id
					) AS comments_count,
					(
						SELECT GROUP_CONCAT(user, ' (',SUBSTRING(c.datetime,1,10),'): 
',c.text SEPARATOR ', 

') FROM
						(
							SELECT c.*, CONCAT(u.surname,' ',u.name) AS user
							FROM comments c
							LEFT JOIN users u ON c.user_id = u.id
							ORDER BY datetime DESC
						) AS c WHERE c.comments_thread_id = j.comments_thread_id GROUP BY c.user_id
					) AS comments,
					(
						SELECT GROUP_CONCAT(comment SEPARATOR ', 

') FROM
						(
							SELECT v.fk_id, v.type, CONCAT(u.surname,' ',u.name,' (',SUBSTRING(v.time,1,10),'): 
',
									IF(v.vote=1,'Souhlas',IF(v.vote=-1,'Nesouhlas','Zdrzet se')),
									IF(v.comment NOT LIKE '',' - ',''), v.comment
								) AS comment
							FROM votes v
							LEFT JOIN users u ON v.user_id = u.id
							ORDER BY v.vote DESC
						) AS v
						WHERE v.fk_id = j.id AND v.type = 1
						GROUP BY fk_id
					) AS vote_comments
				FROM jobs j
				WHERE j.state = 2 AND j.job_report_id IS NULL AND j.user_id = 443) AS q )

Database->query( 
				SELECT q.*, (agree_count - disagree_count) AS approval_state FROM (
					SELECT j.*,
					(
						SELECT COUNT(*)
						FROM votes
						WHERE vote = 1 AND votes.fk_id = j.id AND votes.type = 1
					) AS agree_count,
					(
						SELECT COUNT(*)
						FROM votes
						WHERE vote = -1 AND votes.fk_id = j.id AND votes.type = 1
					) AS disagree_count,
					(
						SELECT COUNT(*)
						FROM votes
						WHERE vote = 0 AND votes.fk_id = j.id AND votes.type = 1
					) AS abstain_count,
					(
						SELECT COUNT(*)
						FROM comments c
						WHERE j.comments_thread_id = c.comments_thread_id
					) AS comments_count,
					(
						SELECT GROUP_CONCAT(user, ' (',SUBSTRING(c.datetime,1,10),'): 
',c.text SEPARATOR ', 

') FROM
						(
							SELECT c.*, CONCAT(u.surname,' ',u.name) AS user
							FROM comments c
							LEFT JOIN users u ON c.user_id = u.id
							ORDER BY datetime DESC
						) AS c WHERE c.comments_thread_id = j.comments_thread_id GROUP BY c.user_id
					) AS comments,
					(
						SELECT GROUP_CONCAT(comment SEPARATOR ', 

') FROM
						(
							SELECT v.fk_id, v.type, CONCAT(u.surname,' ',u.name,' (',SUBSTRING(v.time,1,10),'): 
',
									IF(v.vote=1,?,IF(v.vote=-1,?,?)),
									IF(v.comment NOT LIKE '',' - ',''), v.comment
								) AS comment
							FROM votes v
							LEFT JOIN users u ON v.user_id = u.id
							ORDER BY v.vote DESC
						) AS v
						WHERE v.fk_id = j.id AND v.type = 1
						GROUP BY fk_id
					) AS vote_comments
				FROM jobs j
				WHERE j.state = 2 AND j.job_report_id IS NULL AND j.user_id = ?) AS q, Array
(
    [0] => Souhlas
    [1] => Nesouhlas
    [2] => Zdrzet se
    [3] => 443
)
 )

Job_Model->get_all_rejected_works_by_user( 443 )

Works_Controller->show_by_user( 443 )

Kohana::instance(  )

call_user_func( Array
(
    [0] => Kohana
    [1] => instance
)
 )

Event::run( system.execute )

require( system/core/Bootstrap.php )