tlm-unikent commented 10 years ago

Reports of failed saves of edits from users and since yesterday when hitting 'save' getting this error message:

Unhandled Exception

Message:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ari_code' in 'field list'

SQL: INSERT INTO programmes_revisions_ug (created_at, updated_at, year, programme_title_1, slug_2, award_3, awarding_institute_or_body_4, honours_type_5, administrative_school_6, additional_school_7, subject_area_1_8, subject_area_2_9, ucas_code_10, location_11, mode_of_study_12, attendance_mode_13, attendance_pattern_14, duration_15, accredited_by_16, programme_type_17, total_kent_credits_awarded_on_completion_18, total_ects_credits_awarded_on_completion_19, programme_abstract_20, programme_overview_text_21, teaching_and_assessment_22, programme_aims_23, learning_outcomes_24, careers_overview_25, professional_recognition_26, did_you_know_fact_box_27, a_level_28, cgse_29, cambridge_preu_30, international_baccalaureate_31, btec_level_5_hnd_32, btec_level_3_extended_diploma_formerly_btec_national_diploma_33, scottish_qualifications_34, irish_leaving_certificate_35, subject_leaflet_36, subject_leaflet_2_37, student_profile_38, student_profile_2_39, kiscourseid_40, kistype_41, jacs_code_subject_1_42, jacs_code_subject_2_43, pos_code_44, programme_url_45, search_keywords_46, subject_categories_47, related_courses_48, holding_message_49, new_programme_50, prorgamme_specification_url_51, subject_to_approval_52, programme_suspended_53, programme_withdrawn_54, foundation_year_55, module_disclaimer_56, year_in_industry_57, year_abroad_58, careersemployability_text_59, general_disclaimer_60, start_61, entry_profile_62, homeeu_students_intro_text_63, access_to_he_diploma_64, international_students_intro_text_65, kent_international_foundation_programme_66, english_language_requirements_67, entry_requirements_overriding_text_68, tuition_fees_69, funding_70, how_to_apply_71, enquiries_72, kis_explanatory_textarea_73, url_for_administrative_school_74, url_for_additional_school_75, student_profile_1_link_text_76, student_profile_2_link_text_77, foundation_year_78, year_in_industry_79, year_abroad_80, general_entry_requirements_link_81, intellectual_skills_learning_outcomes_82, subjectspecific_skills_learning_outcomes_83, transferable_skills_learning_outcomes_84, open_days_85, hidden, instance_id, module_session_86, parttime_mcr_code_87, fulltime_mcr_code_88, kis_institution_id_89, how_to_apply_medway_fulltime_90, how_to_apply_parttime_91, module_disclaimer_92, module_intro_93, ari_code, edits_by, status, programme_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Bindings: array ( 0 => '2014-07-29 10:07:24', 1 => '2014-07-29 10:07:24', 2 => '2015', 3 => 'Digital Arts', 4 => 'digital-arts', 5 => '27', 6 => 'University of Kent', 7 => 'Single honours', 8 => '10', 9 => '0', 10 => '29', 11 => '0', 12 => 'W283', 13 => '1', 14 => 'Full-time only', 15 => 'Campus', 16 => 'Day-time', 17 => '4 years full-time', 18 => '', 19 => '', 20 => '', 21 => '', 22 => ' Develop in-depth knowledge in areas such as interaction design, web design, digital film-making, computer animation and special effects.

', 23 => ' Our integrated Master's in Digital Arts offers you the opportunity to develop in-depth knowledge in areas such as interaction design, web design, digital film-making, computer animation and special effects.

Digital technology has had a tremendous impact on all forms of communication in the 21st century. Using computers, visual artists can manipulate all forms of artefacts, whether video, photographic images, sound clips or text, to create exciting new experiences for audiences.

This programme combines the content of our Digital Arts BA with additional modules from our MSc programmes. You have the option to specialise by choosing selected modules from the MSc in Computer Animation or Digital Visual Effects.

Our computer animation content has been developed jointly by the School and our industrial partner, Framestore CFC and is oriented towards current industrial needs, technology and practice. Our digital effects content is steered towards careers such as: Technical Director in creature development or lighting effects; Compositor; Modeller and Tracker/matchmover. In smaller environments target roles include 3D generalist/artist, effects artist or compositor. The Careers tab includes more details on graduate employment.

If you would like to take an industrial placement as part of your degree, we also offer Digital Arts with a Year in Industry MArt.

', 24 => ' Teaching in the School has been rated as excellent. The course is taught by a team of experts in communication, animation, film-making, photography and website design.

All modules contain design and project work, and are continuously assessed. The specialist project at Stage 3 is assessed by a written report, a critique and, of course, the outcome of the project itself. Both Stage 2 and 3 marks count towards your degree result.

You have 24-hour access to our extensive air-conditioned computer suites and are able to take advantage of dedicated photographic and production studios, with green-screen, motion-capture and 3D scanning facilities.

', 25 => '', 26 => '', 27 => ' This programme offers a variety of career options, dependent on the course content chosen.

Graduates from the Digital Arts BA typically find careers in areas such as: web design, film, games design, animation and internet publishing. While this is a new programme, it is designed to offer similar career pathways to our Master's programmes in Computer Animation and Digital Visual Effects.

Previous students from the Computer Animation MSc are working in animation and animation layout roles for companies like Sony Games and Framestore CFC on major titles in games, television and film. This is not easy to achieve as global competition is fierce in these areas - success depends on a much better than average concentration and constant practice to grasp the essence and modern techniques of animation.

Previous students from the Digital Visual Effects MSc are working for London and international companies in areas ranging from television graphics to architectural visualisation, although the thrust of that programme is towards high end film special effects and animation from which the standards and techniques allow you to go into numerous other areas of digital effects.

Alongside your studies on the Digital Arts MArt, you develop useful workplace skills such as planning and organisation, leadership, and effective communication.

If you are interested in setting up your own business, the Kent Enterprise Hub is there to offer help and advice.

', 28 => '', 29 => ' In the National Student Survey 2013, the School is ranked 12th for student satisfaction.

Art and Design at Kent was ranked 6th in The Guardian University Guide 2014.

', 30 => ' ABB

', 31 => ' English language at grade C

', 32 => '', 33 => ' 34 points overall or 16 at HL

', 34 => '', 35 => '', 36 => '', 37 => '', 38 => '28', 39 => '0', 40 => 'http://www.kent.ac.uk/courses/undergrad/profiles/digital_arts.html/', 41 => '', 42 => '', 43 => '', 44 => '', 45 => '', 46 => '', 47 => '', 48 => 'digital arts,mart', 49 => ',9', 50 => '', 51 => '', 52 => 'true', 53 => '', 54 => 'true', 55 => '', 56 => '', 57 => '', 58 => '', 59 => '', 60 => '', 61 => '', 62 => '', 63 => '', 64 => '', 65 => '', 66 => '', 67 => '', 68 => '', 69 => '', 70 => '', 71 => '', 72 => '', 73 => ' This programme is subject to approval and not yet open for applications.

', 74 => '', 75 => '', 76 => 'http://www.eda.kent.ac.uk/', 77 => '', 78 => 'David Horler - Digital Arts', 79 => '', 80 => '', 81 => '', 82 => '', 83 => '', 84 => '', 85 => '', 86 => '', 87 => '', 88 => '0', 89 => '876', 90 => '', 91 => '', 92 => '', 93 => '', 94 => '', 95 => ' Please contact us for information on when this programme will open for applications.

', 96 => '', 97 => ' For the first three years, you follow the course structure of the BA in Digital Arts.

Most modules consist of a mix of lectures, seminars, studio work, computer sessions and private study. The workstations in our computer suites are equipped with current industry-standard software.

In the fourth year, you take seven 15-credit modules based on our existing MSc provision, with the opportunity to specialise by taking optional modules from our Computer Animation or Digital Visual Effects MSc programmes. An additional 15-credit project module runs in the spring term.

', 98 => '', 99 => 'tlm', 100 => 'selected', 101 => '876', ) Location:

/www/app/ems/xcri/releases/20140721092714/laravel/laravel/database/connection.php on line 263 Stack Trace:

0 /www/app/ems/xcri/releases/20140721092714/laravel/laravel/database/connection.php(183): Laravel\Database\Connection->execute('INSERT INTO `pr...', Array)

1 /www/app/ems/xcri/releases/20140721092714/laravel/laravel/database/query.php(823): Laravel\Database\Connection->query('INSERT INTO `pr...', Array)

2 [internal function]: Laravel\Database\Query->insert_get_id(Array, 'id')

3 /www/app/ems/xcri/releases/20140721092714/laravel/laravel/database/eloquent/query.php(267): call_user_func_array(Array, Array)

4 /www/app/ems/xcri/releases/20140721092714/laravel/laravel/database/eloquent/model.php(402): Laravel\Database\Eloquent\Query->__call('insert_get_id', Array)

5 /www/app/ems/xcri/releases/20140721092714/laravel/laravel/database/eloquent/model.php(402): Laravel\Database\Eloquent\Query->insert_get_id(Array, 'id')

6 /www/app/ems/xcri/releases/20140721092714/application/models/revisionable.php(131): Laravel\Database\Eloquent\Model->save()

7 /www/app/ems/xcri/releases/20140721092714/application/models/revisionable.php(66): Revisionable->save_revision()

8 /www/app/ems/xcri/releases/20140721092714/application/models/programme.php(76): Revisionable->save()

9 /www/app/ems/xcri/releases/20140721092714/application/controllers/programmes.php(232): Programme->save()

10 [internal function]: Programmes_Controller->post_edit('2015', 'ug')

11 /www/app/ems/xcri/releases/20140721092714/laravel/laravel/routing/controller.php(325): call_user_func_array(Array, Array)

12 /www/app/ems/xcri/releases/20140721092714/laravel/laravel/routing/controller.php(285): Laravel\Routing\Controller->response('edit', Array)

13 /www/app/ems/xcri/releases/20140721092714/laravel/laravel/routing/controller.php(165): Laravel\Routing\Controller->execute('edit', Array)

14 /www/app/ems/xcri/releases/20140721092714/laravel/laravel/routing/route.php(153): Laravel\Routing\Controller::call('programmes@(:3)', Array)

15 /www/app/ems/xcri/releases/20140721092714/laravel/laravel/routing/route.php(124): Laravel\Routing\Route->response()

16 /www/app/ems/xcri/releases/20140721092714/laravel/laravel/laravel.php(165): Laravel\Routing\Route->call()

17 /www/app/ems/xcri/shared/public/index.php(34): require('/www/app/ems/xc...')

18 {main}

mb324-unikent commented 10 years ago

Hi!

Sorry about that. It was a bug that was introduced recently as part of the admissions project work we were doing. Fixed now.

If you get urgent issues like this again just email helpdesk@kent.ac.ukmailto:helpdesk@kent.ac.uk and we're probably more likely to jump on it quickly!

Matthew

On 29 Jul 2014, at 10:12, tlm-unikent notifications@github.com<mailto:notifications@github.com> wrote:

Reports of failed saves of edits from users and since yesterday when hitting 'save' getting this error message:

Unhandled Exception

Message:

SQLSTATE[42S22]: Column not found: 1054 Unknown column 'ari_code' in 'field list'

SQL: INSERT INTO programmes_revisions_ug (created_at, updated_at, year, programme_title_1, slug_2, award_3, awarding_institute_or_body_4, honours_type_5, administrative_school_6, additional_school_7, subject_area_1_8, subject_area_2_9, ucas_code_10, location_11, mode_of_study_12, attendance_mode_13, attendance_pattern_14, duration_15, accredited_by_16, programme_type_17, total_kent_credits_awarded_on_completion_18, total_ects_credits_awarded_on_completion_19, programme_abstract_20, programme_overview_text_21, teaching_and_assessment_22, programme_aims_23, learning_outcomes_24, careers_overview_25, profess ional_recognition_26, did_you_know_fact_box_27, a_level_28, cgse_29, cambridge_preu_30, international_baccalaureate_31, btec_level_5_hnd_32, btec_level_3_extended_diploma_formerly_btec_national_diploma_33, scottish_qualifications_34, irish_leaving_certificate_35, subject_leaflet_36, subject_leaflet_2_37, student_profile_38, student_profile_2_39, kiscourseid_40, kistype_41, jacs_code_subject_1_42, jacs_code_subject_2_43, pos_code_44, programme_url_45, search_keywords_46, subject_categories_47, related_courses_48, holding_message_49, new_programme_50, prorgamme_specification_url_51, subject_to_approval_52, programme_suspended_53, programme_withdrawn_54, foundation_year_55, module_disclaimer_56, year_in_industry_57, year_abroad_58, careersemployability_text_59, general_disclaimer_60, start_61, entry_profile_62, homeeu_students_intro_text_63, access_to_he_diploma_64, international_students_intro_text_65, kent_international_foundation_programme_66, english_language_requirements_67, entry_requirements_overriding_text_68, tuition_fees_69, funding_70, how_to_apply_71, enquiries_72, kis_explanatory_textarea_73, url_for_administrative_school_74, url_for_additional_school_75, student_profile_1_link_text_76, student_profile_2_link_text_77, foundation_year_78, year_in_industry_79, yea r_abroad_80, general_entry_requirements_link_81, intellectual_skills_learning_outcomes_82, subjectspecific_skills_learning_outcomes_83, transferable_skills_learning_outcomes_84, open_days_85, hidden, instance_id, module_session_86, parttime_mcr_code_87, fulltime_mcr_code_88, kis_institution_id_89, how_to_apply_medway_fulltime_90, how_to_apply_parttime_91, module_disclaimer_92, module_intro_93, ari_code, edits_by, status, programme_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)