Query failed: 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 ') GROUP BY a.id ORDER by m.u' at line 8 SQL: SELECT distinct(a.id) as aid,m.id as id,a.title as atitle,m.description,m.datedir,m.filename,m.media_type,m.preview, m.upload_date FROM multimedia m LEFT JOIN article_multimedia am ON am.multimedia_id = m.id LEFT JOIN article a ON a.id = am.article_id LEFT JOIN section_article sa ON sa.article_id = a.id WHERE a.deleted = 0 AND a.published=1 AND m.media_type = 'video' AND sa.section_id in () GROUP BY a.id ORDER by m.upload_date desc, sa.order_index asc LIMIT 20
Array
(
[0] => Array
(
[file] => /var/www/www.realitatea.net/htdocs/libs/classes/_front.php
[line] => 1374
[function] => query
[class] => MySQL
[object] => MySQL Object
(
[dbConn] => Resource id #9
[connectError] =>
[errorMsg] => Query failed: 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 ')
GROUP BY a.id
ORDER by m.u' at line 8 SQL: SELECT distinct(a.id) as aid,m.id as id,a.title as atitle,m.description,m.datedir,m.filename,m.media_type,m.preview, m.upload_date
FROM multimedia m
LEFT JOIN article_multimedia am ON am.multimedia_id = m.id
LEFT JOIN article a ON a.id = am.article_id
LEFT JOIN section_article sa ON sa.article_id = a.id
WHERE
a.deleted = 0 AND a.published=1
AND m.media_type = 'video' AND sa.section_id in ()
GROUP BY a.id
ORDER by m.upload_date desc, sa.order_index asc LIMIT 20
)
[type] => ->
[args] => Array
(
[0] => SELECT distinct(a.id) as aid,m.id as id,a.title as atitle,m.description,m.datedir,m.filename,m.media_type,m.preview, m.upload_date
FROM multimedia m
LEFT JOIN article_multimedia am ON am.multimedia_id = m.id
LEFT JOIN article a ON a.id = am.article_id
LEFT JOIN section_article sa ON sa.article_id = a.id
WHERE
a.deleted = 0 AND a.published=1
AND m.media_type = 'video' AND sa.section_id in ()
GROUP BY a.id
ORDER by m.upload_date desc, sa.order_index asc LIMIT 20
)
)
[1] => Array
(
[file] => /var/www/www.realitatea.net/htdocs/multimedia_item.php
[line] => 58
[function] => _getOtherMedia
[class] => _front
[object] => _front Object
(
[db] => MySQL Object
(
[dbConn] => Resource id #9
[connectError] =>
[errorMsg] => Query failed: 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 ')
GROUP BY a.id
ORDER by m.u' at line 8 SQL: SELECT distinct(a.id) as aid,m.id as id,a.title as atitle,m.description,m.datedir,m.filename,m.media_type,m.preview, m.upload_date
FROM multimedia m
LEFT JOIN article_multimedia am ON am.multimedia_id = m.id
LEFT JOIN article a ON a.id = am.article_id
LEFT JOIN section_article sa ON sa.article_id = a.id
WHERE
a.deleted = 0 AND a.published=1
AND m.media_type = 'video' AND sa.section_id in ()
GROUP BY a.id
ORDER by m.upload_date desc, sa.order_index asc LIMIT 20
)
[exclude_ids] => Array
(
)
[novideos] =>
[insert_primary_key] =>
[table] =>
[id] =>
[new] =>
[debug] => 1
[fields] => Array
(
)
[children] => Array
(
)
[last_action] =>
[last_query] =>
)
[type] => ->
[args] => Array
(
[0] => 367761
[1] => LIMIT 20
[2] => video
[3] => 1293066
)
)
)