Menu

#2 Dashboard error when no data

Current_version
open
nafisto
UI (2)
5
2007-05-15
2007-05-15
nafisto
No

Dashboard causes an error when the database is empty.

Query: SELECT `Action`.`id`, `Action`.`statusId`, `Action`.`subject`, `Action`.`description`, `Action`.`relatedCaseId`, `Action`.`assignedToUserId`, `Action`.`createdDate`, `Action`.`meetingId`, `Action`.`dueDate`, `Action`.`completedDate`, `status`.`id`, `status`.`description`, `assignedTo`.`id`, `assignedTo`.`username`, `assignedTo`.`name`, `assignedTo`.`password`, `assignedTo`.`level`, `relatedCase`.`id`, `relatedCase`.`subject`, `relatedCase`.`statusId`, `relatedCase`.`description`, `relatedCase`.`dateOpened`, `relatedCase`.`dateClosed`, `relatedCase`.`assignedToUserId`, `meeting`.`id`, `meeting`.`number`, `meeting`.`dtScheduledBegin`, `meeting`.`dtScheduledEnd`, `meeting`.`dtActualBegin`, `meeting`.`dtActualEnd`, `meeting`.`location` FROM `actions` AS `Action` LEFT JOIN `status` AS `status` ON (`Action`.`statusId` = `status`.`id`) LEFT JOIN `users` AS `assignedTo` ON (`Action`.`assignedToUserId` = `assignedTo`.`id`) LEFT JOIN `cases` AS `relatedCase` ON (`Action`.`relatedCaseId` = `relatedCase`.`id`) LEFT JOIN `meetings` AS `meeting` ON (`Action`.`meetingId` = `meeting`.`id`) WHERE `Status`.`description` IN ("New","Open","Deferred") AND `Action`.`assignedToUserId` = 1 ORDER BY `Action`.`dueDate` ASC
Warning: SQL Error: 1054: Unknown column 'Status.description' in 'where clause' in /home/nafistoc/public_html/org.miltonbahai/casetracker/cake/libs/model/datasources/dbo_source.php on line 476

Query: onError
Warning: SQL Error: 1064: 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 'onError' at line 1 in /home/nafistoc/public_html/org.miltonbahai/casetracker/cake/libs/model/datasources/dbo_source.php on line 476

Discussion


Log in to post a comment.

MongoDB Logo MongoDB