Errors i get
Posted: 08 Apr 2014, 17:06
Hello
I have installed the phocadownload to a joomla 3.2.3 site i am constructing and when i press at the files button i get the following error
"1054 Unknown column 'approved' in 'where clause' SQL=SELECT COUNT(a.id) AS count FROM v8cv7_phocadownload AS a WHERE approved = 0 LIMIT 0, 1'
When i press the categories button i get the following error
" 1054 Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS parentcat_title, c.id AS parentcat_id,cc.countid AS countid FROM `v8cv7_phocadownload_categories` AS a LEFT JOIN `v8cv7_languages` AS l ON l.lang_code = a.language LEFT JOIN v8cv7_users AS uc ON uc.id=a.checked_out LEFT JOIN v8cv7_viewlevels AS ag ON ag.id = a.access LEFT JOIN v8cv7_phocadownload_categories AS c ON c.id = a.parent_id LEFT JOIN (SELECT cc.parent_id, count(*) AS countid FROM v8cv7_phocadownload_categories AS cc GROUP BY cc.parent_id ) AS cc ON a.parent_id = cc.parent_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc "
and when i press the licences button i get the following error
"Error
Unknown column 'a.language' in 'on clause' SQL=SELECT COUNT(*) FROM `v8cv7_phocadownload_licenses` AS a LEFT JOIN `v8cv7_languages` AS l ON l.lang_code = a.language LEFT JOIN v8cv7_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `v8cv7_phocadownload_licenses` AS a LEFT JOIN `v8cv7_languages` AS l ON l.lang_code = a.language LEFT JOIN v8cv7_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.title asc LIMIT 0, 20 Unknown column 'a.language' in 'on clause' SQL=SELECT COUNT(*) FROM `v8cv7_phocadownload_licenses` AS a LEFT JOIN `v8cv7_languages` AS l ON l.lang_code = a.language LEFT JOIN v8cv7_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1))"
Any idea what these errors mean?
Thank you in advance
I have installed the phocadownload to a joomla 3.2.3 site i am constructing and when i press at the files button i get the following error
"1054 Unknown column 'approved' in 'where clause' SQL=SELECT COUNT(a.id) AS count FROM v8cv7_phocadownload AS a WHERE approved = 0 LIMIT 0, 1'
When i press the categories button i get the following error
" 1054 Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor,ag.title AS access_level,c.title AS parentcat_title, c.id AS parentcat_id,cc.countid AS countid FROM `v8cv7_phocadownload_categories` AS a LEFT JOIN `v8cv7_languages` AS l ON l.lang_code = a.language LEFT JOIN v8cv7_users AS uc ON uc.id=a.checked_out LEFT JOIN v8cv7_viewlevels AS ag ON ag.id = a.access LEFT JOIN v8cv7_phocadownload_categories AS c ON c.id = a.parent_id LEFT JOIN (SELECT cc.parent_id, count(*) AS countid FROM v8cv7_phocadownload_categories AS cc GROUP BY cc.parent_id ) AS cc ON a.parent_id = cc.parent_id WHERE (a.published IN (0, 1)) GROUP BY a.id ORDER BY a.title asc "
and when i press the licences button i get the following error
"Error
Unknown column 'a.language' in 'on clause' SQL=SELECT COUNT(*) FROM `v8cv7_phocadownload_licenses` AS a LEFT JOIN `v8cv7_languages` AS l ON l.lang_code = a.language LEFT JOIN v8cv7_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) Unknown column 'a.language' in 'on clause' SQL=SELECT a.*,l.title AS language_title,uc.name AS editor FROM `v8cv7_phocadownload_licenses` AS a LEFT JOIN `v8cv7_languages` AS l ON l.lang_code = a.language LEFT JOIN v8cv7_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1)) ORDER BY a.title asc LIMIT 0, 20 Unknown column 'a.language' in 'on clause' SQL=SELECT COUNT(*) FROM `v8cv7_phocadownload_licenses` AS a LEFT JOIN `v8cv7_languages` AS l ON l.lang_code = a.language LEFT JOIN v8cv7_users AS uc ON uc.id=a.checked_out WHERE (a.published IN (0, 1))"
Any idea what these errors mean?
Thank you in advance