Phoca Forum

Code: Select all

{phocadownload view=filelist|id=10}

Code: Select all

1054 - Unknown column 'a.c.ordering' in 'order clause' SQL=SELECT a.id, a.title, a.alias, a.filename_play, a.filename_preview, a.link_external, a.image_filename, a.filename, c.id as catid, a.confirm_license, c.title as cattitle, c.alias as catalias, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug FROM #__phocadownload AS a LEFT JOIN #__phocadownload_categories AS c ON a.catid = c.id WHERE c.id = 10 ORDER BY a.c.ordering ASC LIMIT 0, 5

Code: Select all

            $query .= ' ORDER BY a.'.$fileOrdering;

Code: Select all

$fileOrdering 		= PhocaDownloadOrdering::getOrderingText($ordering);

Code: Select all

$query .= ' ORDER BY a.'.(explode('.',$fileOrdering)[count(explode('.',$fileOrdering))-1]);