Warning: PDOStatement::execute(): SQLSTATE[23000]: Integrity constraint violation: 1052 Column 'whenModified' in order clause is ambiguous in /var/www/notanant/DBclasses.php on line 1064
PDO FAIL# SELECT *,
knowledge_base.view_counter,
if(kb_logo<>'',concat('%%image=',kb_logo,' ',kb_subject),kb_subject) as new_kb_subject,
replace(kb_logo,'_t55.jpg','_t105.jpg') as kb_logo_big,
(substring_index(max(concat(if(backup_id IS NOT NULL,backup_id,''),'#',if(title IS NOT NULL,title,kb_subject))),'#',-1)) as kb_subject,
(substring_index(max(concat(if(backup_id IS NOT NULL,backup_id,''),'#',if(backup_id IS NOT NULL,summary,kb_precis))),'#',-1)) as kb_precis
FROM knowledge_base
LEFT OUTER JOIN backup_header
ON (link_type='kb_id' and link_id=kb_id and language=:language)
WHERE kb_header_id=:kb_header_id
GROUP BY kb_id ORDER BY whenModified DESCArray
(
[kb_header_id] => 844
[language] => esp
)
Array
(
[0] => 23000
[1] => 1052
[2] => Column 'whenModified' in order clause is ambiguous
)