Error 500 Internal Server Error

POST https://iacp.ie/members-area/edit-personal-data

Forwarded to ErrorController (42e187)

Query Metrics

28 Database Queries
19 Different statements
26.91 ms Query time
4 Invalid entities
288 Managed entities

Grouped Statements

Show all queries

Time Count Info
4.23 ms
(15.73%)
3
SELECT d0_.id AS id_0, d0_.updated_at AS updated_at_1, d0_.deletedAt AS deletedAt_2, d0_.name AS name_3, d0_.field0 AS field0_4, d0_.field1 AS field1_5, d0_.field2 AS field2_6, d0_.field3 AS field3_7, d0_.field4 AS field4_8, d0_.field5 AS field5_9, d0_.field6 AS field6_10, d0_.field7 AS field7_11, d0_.field8 AS field8_12, d0_.field9 AS field9_13, d0_.field10 AS field10_14, d0_.field11 AS field11_15, d0_.file1_name AS file1_name_16, d0_.file2_name AS file2_name_17, d0_.type_key AS type_key_18, d0_.visible AS visible_19, d0_.list_order AS list_order_20 FROM dictionary d0_ WHERE (d0_.type_key = ?) AND (d0_.deletedAt IS NULL) ORDER BY d0_.name ASC
Parameters:
[
  "therapist_category"
]
3.20 ms
(11.89%)
2
SELECT TABLE_NAME
FROM information_schema.TABLES
WHERE TABLE_SCHEMA = ?
  AND TABLE_TYPE = 'BASE TABLE'
ORDER BY TABLE_NAME
Parameters:
[
  "iacpclrwww"
]
2.64 ms
(9.79%)
1
SELECT       c.COLUMN_NAME        AS field,
       c.COLUMN_TYPE       AS type,
       c.IS_NULLABLE        AS `null`,
       c.COLUMN_KEY         AS `key`,
       c.COLUMN_DEFAULT     AS `default`,
       c.EXTRA,
       c.COLUMN_COMMENT     AS comment,
       c.CHARACTER_SET_NAME AS characterset,
       c.COLLATION_NAME     AS collation
FROM information_schema.COLUMNS c
    INNER JOIN information_schema.TABLES t
        ON t.TABLE_NAME = c.TABLE_NAME
     WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters:
[
  "iacpclrwww"
  "iacpclrwww"
  "doctrine_migration_versions"
]
2.50 ms
(9.28%)
6
SELECT DATABASE()
Parameters:
[]
2.21 ms
(8.21%)
2
SELECT t0.id AS id_1, t0.settings_key AS settings_key_2, t0.settings_val AS settings_val_3 FROM setting t0
Parameters:
[]
1.81 ms
(6.71%)
1
SELECT DISTINCT            k.CONSTRAINT_NAME,
            k.COLUMN_NAME,
            k.REFERENCED_TABLE_NAME,
            k.REFERENCED_COLUMN_NAME,
            k.ORDINAL_POSITION /*!50116,
            c.UPDATE_RULE,
            c.DELETE_RULE */
FROM information_schema.key_column_usage k /*!50116
INNER JOIN information_schema.referential_constraints c
ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME
AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'iacpclrwww' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[
  "iacpclrwww"
  "doctrine_migration_versions"
]
1.32 ms
(4.90%)
1
SELECT t.TABLE_NAME,
           t.ENGINE,
           t.AUTO_INCREMENT,
           t.TABLE_COMMENT,
           t.CREATE_OPTIONS,
           t.TABLE_COLLATION,
           ccsa.CHARACTER_SET_NAME
      FROM information_schema.TABLES t
        INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa
          ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters:
[
  "iacpclrwww"
  "doctrine_migration_versions"
]
1.19 ms
(4.42%)
1
SELECT        NON_UNIQUE  AS Non_Unique,
        INDEX_NAME  AS Key_name,
        COLUMN_NAME AS Column_Name,
        SUB_PART    AS Sub_Part,
        INDEX_TYPE  AS Index_Type
FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
Parameters:
[
  "iacpclrwww"
  "doctrine_migration_versions"
]
0.99 ms
(3.66%)
1
SELECT d0_.id AS id_0, d0_.updated_at AS updated_at_1, d0_.deletedAt AS deletedAt_2, d0_.name AS name_3, d0_.field0 AS field0_4, d0_.field1 AS field1_5, d0_.field2 AS field2_6, d0_.field3 AS field3_7, d0_.field4 AS field4_8, d0_.field5 AS field5_9, d0_.field6 AS field6_10, d0_.field7 AS field7_11, d0_.field8 AS field8_12, d0_.field9 AS field9_13, d0_.field10 AS field10_14, d0_.field11 AS field11_15, d0_.file1_name AS file1_name_16, d0_.file2_name AS file2_name_17, d0_.type_key AS type_key_18, d0_.visible AS visible_19, d0_.list_order AS list_order_20 FROM dictionary d0_ WHERE (d0_.type_key = ?) AND (d0_.deletedAt IS NULL) ORDER BY d0_.list_order ASC
Parameters:
[
  "therapist_whom"
]
0.98 ms
(3.63%)
1
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 INNER JOIN therapist_categories_relation ON t0.id = therapist_categories_relation.category_id WHERE therapist_categories_relation.therapist_id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
  8206
]
0.95 ms
(3.55%)
1
SELECT t0.id AS id_1, t0.mdauto AS mdauto_2, t0.mdsauto AS mdsauto_3, t0.firstname AS firstname_4, t0.lastname AS lastname_5, t0.address1 AS address1_6, t0.address2 AS address2_7, t0.address3 AS address3_8, t0.address4 AS address4_9, t0.postcode AS postcode_10, t0.country AS country_11, t0.mdtel AS mdtel_12, t0.private AS private_13, t0.directory AS directory_14, t0.clinical AS clinical_15, t0.counselling AS counselling_16, t0.educational AS educational_17, t0.work AS work_18, t0.overview AS overview_19, t0.bio AS bio_20, t0.map AS map_21, t0.google_map_img AS google_map_img_22, t0.img AS img_23, t0.mdemail AS mdemail_24, t0.mdwww AS mdwww_25, t0.fax AS fax_26, t0.login AS login_27, t0.passwd AS passwd_28, t0.open_mon AS open_mon_29, t0.open_tue AS open_tue_30, t0.open_wed AS open_wed_31, t0.open_thu AS open_thu_32, t0.open_fri AS open_fri_33, t0.open_sat AS open_sat_34, t0.open_sun AS open_sun_35, t0.close_mon AS close_mon_36, t0.close_tue AS close_tue_37, t0.close_wed AS close_wed_38, t0.close_thu AS close_thu_39, t0.close_fri AS close_fri_40, t0.close_sat AS close_sat_41, t0.close_sun AS close_sun_42, t0.logo AS logo_43, t0.subdomain AS subdomain_44, t0.qualifications AS qualifications_45, t0.interests AS interests_46, t0.memberships AS memberships_47, t0.salutation AS salutation_48, t0.fee AS fee_49, t0.wheelchair AS wheelchair_50, t0.fee_negotiable AS fee_negotiable_51, t0.fee_donation AS fee_donation_52, t0.fee_free AS fee_free_53, t0.whom_one AS whom_one_54, t0.whom_families AS whom_families_55, t0.whom_groups AS whom_groups_56, t0.whom_children AS whom_children_57, t0.whom_teenagers AS whom_teenagers_58, t0.whom_adults AS whom_adults_59, t0.for_whom AS for_whom_60, t0.inactive AS inactive_61, t0.keywords AS keywords_62, t0.old_location_id AS old_location_id_63, t0.online_register AS online_register_64, t0.lapsed AS lapsed_65, t0.login_token AS login_token_66, t0.sign_language AS sign_language_67, t0.hse_frontline AS hse_frontline_68, t0.pa_website_list AS pa_website_list_69, t0.additional_training AS additional_training_70, t0.custom_lang AS custom_lang_71, t0.deletedAt AS deletedAt_72, t0.image_name AS image_name_73, t0.updated_at AS updated_at_74, t0.member_id AS member_id_75, t0.location_id AS location_id_76 FROM therapist t0 WHERE t0.member_id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
  3764
]
0.82 ms
(3.06%)
1
SELECT d0_.id AS id_0, d0_.updated_at AS updated_at_1, d0_.deletedAt AS deletedAt_2, d0_.name AS name_3, d0_.field0 AS field0_4, d0_.field1 AS field1_5, d0_.field2 AS field2_6, d0_.field3 AS field3_7, d0_.field4 AS field4_8, d0_.field5 AS field5_9, d0_.field6 AS field6_10, d0_.field7 AS field7_11, d0_.field8 AS field8_12, d0_.field9 AS field9_13, d0_.field10 AS field10_14, d0_.field11 AS field11_15, d0_.file1_name AS file1_name_16, d0_.file2_name AS file2_name_17, d0_.type_key AS type_key_18, d0_.visible AS visible_19, d0_.list_order AS list_order_20 FROM dictionary d0_ WHERE (d0_.type_key = ? AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (d0_.deletedAt IS NULL) ORDER BY d0_.name ASC
Parameters:
[
  "therapist_category"
  "288"
  "256"
  "257"
  "258"
  "259"
  "281"
  "260"
  "283"
  "262"
  "263"
  "275"
  "264"
  "276"
  "266"
  "267"
  "268"
  "272"
  "273"
  "286"
  "278"
]
0.74 ms
(2.76%)
1
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.deletedAt AS deletedAt_4, t0.status AS status_5, t0.membership_number AS membership_number_6, t0.email AS email_7, t0.password AS password_8, t0.stripe_customer_id AS stripe_customer_id_9, t0.stripe_payment_method_id AS stripe_payment_method_id_10, t0.stripe_addons AS stripe_addons_11, t0.ignore_payments AS ignore_payments_12, t0.full_name AS full_name_13, t0.ta_content AS ta_content_14, t0.ta_entries_to_include_in_log AS ta_entries_to_include_in_log_15, t0.ta_last_fetch_date AS ta_last_fetch_date_16, t0.member_page_hero_image_name AS member_page_hero_image_name_17, t0.member_page_services AS member_page_services_18, t0.member_page_service_description AS member_page_service_description_19, t0.member_page_email AS member_page_email_20, t0.member_page_phone AS member_page_phone_21, t0.member_page_about AS member_page_about_22, t0.member_page_hero_line1 AS member_page_hero_line1_23, t0.member_page_hero_line2 AS member_page_hero_line2_24, t0.member_page_hero_line3 AS member_page_hero_line3_25, t0.member_page_about_image_name AS member_page_about_image_name_26, t0.member_page_for_whom_title AS member_page_for_whom_title_27, t0.member_page_for_whom_text AS member_page_for_whom_text_28, t0.member_page_section_services_title AS member_page_section_services_title_29, t0.member_page_section_about_title AS member_page_section_about_title_30, t0.member_page_address AS member_page_address_31, t0.member_page_social_facebook AS member_page_social_facebook_32, t0.member_page_social_twitter AS member_page_social_twitter_33, t0.member_page_social_linkedin AS member_page_social_linkedin_34, t0.member_page_social_instagram AS member_page_social_instagram_35, t0.member_page_www AS member_page_www_36, t0.membership_type_id AS membership_type_id_37 FROM member t0 WHERE t0.id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
  3764
]
0.69 ms
(2.58%)
1
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 INNER JOIN therapist_whom_relation ON t0.id = therapist_whom_relation.whom_id WHERE therapist_whom_relation.therapist_id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
  8206
]
0.63 ms
(2.36%)
1
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 INNER JOIN therapist_approaches_relation ON t0.id = therapist_approaches_relation.approach_id WHERE therapist_approaches_relation.therapist_id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
  8206
]
0.54 ms
(1.99%)
1
SELECT t0.id AS id_1, t0.updated_at AS updated_at_2, t0.deletedAt AS deletedAt_3, t0.name AS name_4, t0.field0 AS field0_5, t0.field1 AS field1_6, t0.field2 AS field2_7, t0.field3 AS field3_8, t0.field4 AS field4_9, t0.field5 AS field5_10, t0.field6 AS field6_11, t0.field7 AS field7_12, t0.field8 AS field8_13, t0.field9 AS field9_14, t0.field10 AS field10_15, t0.field11 AS field11_16, t0.file1_name AS file1_name_17, t0.file2_name AS file2_name_18, t0.type_key AS type_key_19, t0.visible AS visible_20, t0.list_order AS list_order_21 FROM dictionary t0 INNER JOIN therapist_languages_relation ON t0.id = therapist_languages_relation.language_id WHERE therapist_languages_relation.therapist_id = ? AND ((t0.deletedAt IS NULL))
Parameters:
[
  8206
]
0.51 ms
(1.90%)
1
SELECT d0_.id AS id_0, d0_.updated_at AS updated_at_1, d0_.deletedAt AS deletedAt_2, d0_.name AS name_3, d0_.field0 AS field0_4, d0_.field1 AS field1_5, d0_.field2 AS field2_6, d0_.field3 AS field3_7, d0_.field4 AS field4_8, d0_.field5 AS field5_9, d0_.field6 AS field6_10, d0_.field7 AS field7_11, d0_.field8 AS field8_12, d0_.field9 AS field9_13, d0_.field10 AS field10_14, d0_.field11 AS field11_15, d0_.file1_name AS file1_name_16, d0_.file2_name AS file2_name_17, d0_.type_key AS type_key_18, d0_.visible AS visible_19, d0_.list_order AS list_order_20 FROM dictionary d0_ WHERE (d0_.type_key = ? AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (d0_.deletedAt IS NULL) ORDER BY d0_.name ASC
Parameters:
[
  "therapist_approach"
  "174"
  "157"
  "176"
  "159"
  "160"
  "161"
  "153"
  "195"
  "163"
  "167"
  "172"
  "182"
]
0.50 ms
(1.86%)
1
SELECT * FROM doctrine_migration_versions
Parameters:
[]
0.46 ms
(1.72%)
1
SELECT d0_.id AS id_0, d0_.updated_at AS updated_at_1, d0_.deletedAt AS deletedAt_2, d0_.name AS name_3, d0_.field0 AS field0_4, d0_.field1 AS field1_5, d0_.field2 AS field2_6, d0_.field3 AS field3_7, d0_.field4 AS field4_8, d0_.field5 AS field5_9, d0_.field6 AS field6_10, d0_.field7 AS field7_11, d0_.field8 AS field8_12, d0_.field9 AS field9_13, d0_.field10 AS field10_14, d0_.field11 AS field11_15, d0_.file1_name AS file1_name_16, d0_.file2_name AS file2_name_17, d0_.type_key AS type_key_18, d0_.visible AS visible_19, d0_.list_order AS list_order_20 FROM dictionary d0_ WHERE (d0_.type_key = ? AND d0_.id IN (?, ?, ?, ?, ?, ?, ?, ?)) AND (d0_.deletedAt IS NULL) ORDER BY d0_.list_order ASC
Parameters:
[
  "therapist_whom"
  "353"
  "356"
  "368"
  "358"
  "354"
  "364"
  "618"
  "365"
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\Dictionary 173
App\Entity\Setting 113
App\Entity\Member 1
App\Entity\Therapist 1

Entities Mapping

Class Mapping errors
App\Entity\MemberBase No errors.
App\Entity\Member No errors.
App\Entity\Dictionary No errors.
App\Entity\Setting No errors.
App\Entity\MemberApplicationBase No errors.
App\Entity\MemberApplication
  • The field 'App\Entity\MemberApplication#confirmInformation' has the property type 'bool' that differs from the metadata field type 'string' returned by the 'text' DBAL type.
  • The field 'App\Entity\MemberApplication#confirmTerms' has the property type 'bool' that differs from the metadata field type 'string' returned by the 'text' DBAL type.
App\Entity\MemberDocument No errors.
App\Entity\MemberLog No errors.
App\Entity\Therapist
  • The field 'App\Entity\Therapist#sign_language' has the property type 'bool' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\MemberCpdLog No errors.
App\Entity\MembershipForm
  • The field 'App\Entity\MembershipForm#gardaRequired' has the property type 'bool' that differs from the metadata field type 'int' returned by the 'integer' DBAL type.
App\Entity\EventRegistration No errors.
App\Entity\ResetPasswordRequest No errors.
App\Entity\User No errors.
App\Entity\MemberForm
  • The association App\Entity\MemberForm#member refers to the inverse side field App\Entity\Member#agmForms which does not exist.
App\Entity\Page No errors.
App\Entity\Log No errors.
App\Entity\EmailForm No errors.
App\Entity\Event No errors.
Vich\UploaderBundle\Entity\File No errors.