Error Message:

Query:

SELECT am.content_asset_id, am.instructions, am.max_items, am.randomize_items, am.enable_remediation, am.enable_retake, am.max_retake_times, am.discussion_forum, ca.id AS assessment_id, ca.title, ca.version, ca.summary_description, ca.description, at.name AS assessment_type_name, art.name AS assessment_rubric_type_name, im.host_url AS assessment_image_url, im.caption AS assessment_image_caption, im.alt_text AS assessment_image_alt_text, imbg.host_url AS assessment_background_image_url, imbg.caption AS assessment_background_image_caption, imbg.alt_text AS assessment_background_image_alt_text, vi.host_url_mp4 AS assessment_video_url_mp4, vi.host_url_webm AS assessment_video_url_webm, vi.caption AS assessment_video_caption, vi.duration_minutes_seconds AS assessment_video_duration_minutes_seconds, imvi.host_url AS assessment_video_poster_url, dfc.discussion_thread_post, dfc.discussion_thread_post_audio, dfc.discussion_thread_post_document, dfc.discussion_thread_post_image, dfc.discussion_thread_post_video, dfc.discussion_reply_post, dfc.discussion_reply_post_audio, dfc.discussion_reply_post_document, dfc.discussion_reply_post_image, dfc.discussion_reply_post_video FROM assessments am LEFT JOIN content_assets ca ON am.content_asset_id = ca.id LEFT JOIN assessment_types at ON am.assessment_type_code = at.code LEFT JOIN assessment_rubric_types art ON am.assessment_rubric_type_code = art.code LEFT JOIN images im ON (am.image_id = im.content_asset_id AND im.SIZE = "Assessment" AND im.usage_size = "Medium" AND im.usage_shape = "Block" AND im.format = "JPG") LEFT JOIN images imbg ON (ca.background_image_id = imbg.content_asset_id AND imbg.SIZE = "background" AND imbg.format = "JPG") LEFT JOIN videos vi ON am.video_id = vi.content_asset_id LEFT JOIN images imvi ON (vi.image_id = imvi.content_asset_id AND imvi.SIZE = "Video" AND imvi.usage_size = "Large" AND imvi.usage_shape = "Landscape" AND imvi.format = "JPG") LEFT JOIN discussion_forum_configurations dfc ON am.content_asset_id = dfc.assessment_id WHERE am.content_asset_id = 2473 LIMIT 1

System Response:

Table 'rtsadven_production.assessment_types' doesn't exist

Next Step:

Please contact the System Administrator if you need help with this error message. Copy and paste the entire text on this page and email it to [email protected]

×