Error with Phoca Dowload file
Posted: 19 Nov 2015, 10:48
Why when i enable Phoca Dowload file to show latest files obtain this error:
==============================================
1054 - Unknown column 'c.c.date' in 'order clause' SQL=SELECT c.*, cc.id AS categoryid, cc.title AS categorytitle, cc.alias AS categoryalias, cc.access as cataccess, cc.accessuserid as cataccessuserid FROM pada_phocadownload AS c LEFT JOIN pada_phocadownload_categories AS cc ON cc.id = c.catid WHERE c.catid IN ( 384,386,394,396,397,398,399,387,400,401,402,403,422,404,405,423,424,425,426,406,427,428,429,430,475,476,431,432,434,407,408,409,410,411,412,435,436,413,414,437,438,439,415,416,417,418,419,420,421,388,440,477,441,389,395,442,443,390,460,391,444,474,392,433,446,447,454,455,456,457,448,449,450,451,452,458,453,459,393,445 ) AND c.catid= cc.id AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 AND c.access IN (1,1,6) ) ) AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 AND cc.access IN (1,1,6) ) ) AND c.published = 1 AND c.approved = 1 AND cc.published = 1 AND c.textonly = 0 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2015-11-19 08:35:44' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2015-11-19 08:35:44' ) AND ( ( TO_DAYS('2015-11-19 08:35:44') - TO_DAYS( c.date ) ) <= '1') ORDER BY c.c.date ASC LIMIT 0, 5
==============================================
The site is padalino.gov.it
Thanks
Fjodor
==============================================
1054 - Unknown column 'c.c.date' in 'order clause' SQL=SELECT c.*, cc.id AS categoryid, cc.title AS categorytitle, cc.alias AS categoryalias, cc.access as cataccess, cc.accessuserid as cataccessuserid FROM pada_phocadownload AS c LEFT JOIN pada_phocadownload_categories AS cc ON cc.id = c.catid WHERE c.catid IN ( 384,386,394,396,397,398,399,387,400,401,402,403,422,404,405,423,424,425,426,406,427,428,429,430,475,476,431,432,434,407,408,409,410,411,412,435,436,413,414,437,438,439,415,416,417,418,419,420,421,388,440,477,441,389,395,442,443,390,460,391,444,474,392,433,446,447,454,455,456,457,448,449,450,451,452,458,453,459,393,445 ) AND c.catid= cc.id AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 AND c.access IN (1,1,6) ) ) AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 AND cc.access IN (1,1,6) ) ) AND c.published = 1 AND c.approved = 1 AND cc.published = 1 AND c.textonly = 0 AND ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2015-11-19 08:35:44' ) AND ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2015-11-19 08:35:44' ) AND ( ( TO_DAYS('2015-11-19 08:35:44') - TO_DAYS( c.date ) ) <= '1') ORDER BY c.c.date ASC LIMIT 0, 5
==============================================
The site is padalino.gov.it
Thanks
Fjodor