Any clues as to why these errors are occurring would be much appreciated.
When viewing the profile list of microsites:
Quote: Data
Array
(
[error] => Query Error: Unknown column 'a._profile_id' in 'where clause'
[_post] => Array
(
[_uri] => /steve/microsite
[module_url] => steve
[module] =>
[option] => microsite
[_profile_id] => 1
)
[query] => /* [Steve] :/steve/microsite */ SELECT COUNT(a.`_item_id`) AS tc FROM jr_ujmicrosite_item_key a
JOIN jr_ujmicrosite_item_key b ON (b.`_item_id` = a.`_item_id` AND b.`key` = 'micro_section_type' AND b.`value` = 'header')
WHERE ((a.`key` = 'micro_category') OR (a.`key` = '_created' AND a.`_item_id` NOT IN(SELECT `_item_id` FROM jr_ujmicrosite_item_key WHERE `key` = 'micro_category')))
AND a.`_profile_id` IN(1)
GROUP BY a.`value`
)
Array
(
[error] => Query Error: Unknown column 'a._profile_id' in 'where clause'
[_post] => Array
(
[_uri] => /steve/microsite
[module_url] => steve
[module] =>
[option] => microsite
[_profile_id] => 1
)
[query] => /* [Steve] :/steve/microsite */ SELECT COUNT(a.`_item_id`) AS tc FROM jr_ujmicrosite_item_key a
JOIN jr_ujmicrosite_item_key b ON (b.`_item_id` = a.`_item_id` AND b.`key` = 'micro_section_type' AND b.`value` = 'header')
WHERE ((a.`key` = 'micro_category') OR (a.`key` = '_created' AND a.`_item_id` NOT IN(SELECT `_item_id` FROM jr_ujmicrosite_item_key WHERE `key` = 'micro_category')))
AND a.`_profile_id` IN(1)
GROUP BY a.`value`
)
When viewing a page:
Quote:
Array
(
[error] => Query Error: Unknown column 'a._profile_id' in 'where clause'
[_post] => Array
(
[_uri] => /steve/microsite/workbook-features/2/question-types
[module_url] => steve
[module] => ujMicroSite
[option] => workbook-features
[_1] => workbook-features
[_2] => 2
[_3] => question-types
[_profile_id] => 1
)
[query] => /* [Steve] :/steve/microsite/workbook-features/2/question-types */ SELECT a.`_item_id` AS _item_id FROM jr_ujmicrosite_item_key a
JOIN jr_ujmicrosite_item_key b ON (b.`_item_id` = a.`_item_id` AND b.`key` = 'micro_group_id' AND b.`value` = '2')
WHERE ((a.`key` = 'micro_section_order') OR (a.`key` = '_created' AND a.`_item_id` NOT IN(SELECT `_item_id` FROM jr_ujmicrosite_item_key WHERE `key` = 'micro_section_order')))
AND a.`_profile_id` IN(1)
ORDER BY FIELD(a.`key`, '_created', 'micro_section_order') ASC, (a.`value` + 0) ASC LIMIT 500
)
Array
(
[error] => Query Error: Unknown column 'a._profile_id' in 'where clause'
[_post] => Array
(
[_uri] => /steve/microsite/workbook-features/2/question-types
[module_url] => steve
[module] => ujMicroSite
[option] => workbook-features
[_1] => workbook-features
[_2] => 2
[_3] => question-types
[_profile_id] => 1
)
[query] => /* [Steve] :/steve/microsite/workbook-features/2/question-types */ SELECT a.`_item_id` AS _item_id FROM jr_ujmicrosite_item_key a
JOIN jr_ujmicrosite_item_key b ON (b.`_item_id` = a.`_item_id` AND b.`key` = 'micro_group_id' AND b.`value` = '2')
WHERE ((a.`key` = 'micro_section_order') OR (a.`key` = '_created' AND a.`_item_id` NOT IN(SELECT `_item_id` FROM jr_ujmicrosite_item_key WHERE `key` = 'micro_section_order')))
AND a.`_profile_id` IN(1)
ORDER BY FIELD(a.`key`, '_created', 'micro_section_order') ASC, (a.`value` + 0) ASC LIMIT 500
)
--
¯\_(ツ)_/¯ Education, learning resources, TEL, AR/VR/MR, CC licensed content, panoramas, interactive narrative, sectional modules (like jrDocs), lunch at Uni of Bristol. Get in touch if you share my current interests or can suggest better :)
updated by @ultrajam: 02/24/17 11:56:19AM
