Basic Training

WordPress database error: [Unknown column 'status' in 'where clause']
SELECT COUNT(ID) FROM pirates_projectmanager_dataset WHERE `project_id` = '4' AND `status` = 'active'

WordPress database error: [Unknown column 'status' in 'where clause']
SELECT COUNT(ID) FROM pirates_projectmanager_dataset WHERE `project_id` = '4' AND `status` = 'active'

WordPress database error: [Unknown column 'status' in 'where clause']
SELECT COUNT(ID) FROM pirates_projectmanager_dataset WHERE `project_id` = '4' AND `status` = 'active'

WordPress database error: [Unknown column 'dataset.sticky' in 'field list']
SELECT dataset.`id` AS id, dataset.`name` AS name, dataset.`sticky` AS sticky, dataset.`status` AS `status`, dataset.`order` AS `order`, `cat_ids`, `user_id`, `project_id` FROM pirates_projectmanager_dataset AS dataset WHERE dataset.`project_id` = '4' AND `status` = 'active' ORDER BY sticky DESC, `order` ASC;

WordPress database error: [Unknown column 'status' in 'where clause']
SELECT COUNT(ID) FROM pirates_projectmanager_dataset WHERE `project_id` = '4' AND `status` = 'active'

WordPress database error: [Unknown column 'status' in 'where clause']
SELECT COUNT(ID) FROM pirates_projectmanager_dataset WHERE `project_id` = '4' AND `status` = 'active'

WordPress database error: [Unknown column 'mandatory' in 'field list']
SELECT `label`, `type`, `order`, `order_by`, `mandatory`, `unique`, `private`, `show_on_startpage`, `show_in_profile`, `label_type`, `width`, `newline`, `options`, `id`, `project_id` FROM pirates_projectmanager_projectmeta WHERE `project_id` = 4 AND `private` = 0 ORDER BY `order` ASC;

WordPress database error: [Unknown column 'status' in 'where clause']
SELECT COUNT(ID) FROM pirates_projectmanager_dataset WHERE `project_id` = '4' AND `status` = 'active'

WordPress database error: [Unknown column 'mandatory' in 'field list']
SELECT `label`, `type`, `order`, `order_by`, `mandatory`, `unique`, `private`, `show_on_startpage`, `show_in_profile`, `label_type`, `width`, `newline`, `options`, `id`, `project_id` FROM pirates_projectmanager_projectmeta WHERE `project_id` = 4 AND `private` = 0 ORDER BY `order` ASC;

WordPress database error: [Table 'wtfracin_pirates.pirates_projectmanager_categories' doesn't exist]
SELECT COUNT(ID) FROM pirates_projectmanager_categories WHERE `project_id` = '4'