|
<html><body><h1>Chyba nahlasena z: . works/show_by_user/443 (file: 374, line: 374)</h1><p>FreenetIS verze: 1.0.4</p><p>PHP verze: 5.3.3-7+squeeze14</p><p>Nahlasil: Petr Kolar</p><p>Popis: Kliknul jsem na odkaz "Moje prace".</p><h2>Kohana_Database_Exception</h2><p></p><p class="message">Chyba v SQL dotazu - Subquery returns more than 1 row</p><p class="detail">Chyba se vyskytla na <strong>radku 374</strong> souboru <strong>system/libraries/drivers/Database/Mysql.php</strong>.</p><div><ul class="backtrace"><li><strong>system/libraries/drivers/Database/Mysql.php [99]:</strong><pre>Mysql_Result->__construct( )</pre></li>
|
|
<li><strong>system/libraries/Database.php [187]:</strong><pre>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 )</pre></li>
|
|
<li><strong>application/models/job.php [474]:</strong><pre>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
|
|
)
|
|
)</pre></li>
|
|
<li><strong>application/controllers/works.php [684]:</strong><pre>Job_Model->get_all_rejected_works_by_user( 443 )</pre></li>
|
|
<li><strong>system/core/Kohana.php [330]:</strong><pre>Works_Controller->show_by_user( 443 )</pre></li>
|
|
<li><pre>Kohana::instance( )</pre></li>
|
|
<li><strong>system/core/Event.php [217]:</strong><pre>call_user_func( Array
|
|
(
|
|
[0] => Kohana
|
|
[1] => instance
|
|
)
|
|
)</pre></li>
|
|
<li><strong>system/core/Bootstrap.php [55]:</strong><pre>Event::run( system.execute )</pre></li>
|
|
<li><strong>index.php [86]:</strong><pre>require( system/core/Bootstrap.php )</pre></li></ul></div></body></html>
|