Error 500 Internal Server Error

POST https://junedev.housemaster.com/hg/report-upload-mirror

IP
52.42.29.174
Profiled on
Token
34e79a
Forwarded to ErrorController (b05cf4)

Query Metrics

1 Database Queries
1 Different statements
1549.97 ms Query time
5 Invalid entities

Grouped Statements

Show all queries

default connection

Time▼ Count Info
1549.97 ms
(100.00%) 		1 
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.firstname AS firstname_13, t0.lastname AS lastname_14, t0.address1 AS address1_15, t0.city AS city_16, t0.idToken AS idToken_17, t0.accessToken AS accessToken_18, t0.state AS state_19, t0.country AS country_20, t0.zip AS zip_21, t0.phone AS phone_22, t0.phone2 AS phone2_23, t0.phone3 AS phone3_24, t0.franchisee AS franchisee_25, t0.franchisee_number AS franchisee_number_26, t0.receivenewsletter AS receivenewsletter_27, t0.receivesms AS receivesms_28, t0.signedagreement AS signedagreement_29, t0.address2 AS address2_30, t0.facebook_id AS facebook_id_31, t0.google_id AS google_id_32, t0.twitter_id AS twitter_id_33, t0.email2 AS email2_34, t0.email3 AS email3_35, t0.home_fax AS home_fax_36, t0.work_fax AS work_fax_37, t0.companyName AS companyName_38, t0.website AS website_39, t0.photo AS photo_40, t0.updatedAt AS updatedAt_41, t0.pathandnameofphoto AS pathandnameofphoto_42, t0.timezone AS timezone_43, t0.autoRealtorReports AS autoRealtorReports_44, t0.buyerAgentViewReport AS buyerAgentViewReport_45, t0.sellerAgentViewReports AS sellerAgentViewReports_46, t0.otherAgentViewReport AS otherAgentViewReport_47, t0.shareCloudTransfers AS shareCloudTransfers_48, t0.doNotLockUnpaid AS doNotLockUnpaid_49, t0.doNotLockUnsigned AS doNotLockUnsigned_50, t0.createdAt AS createdAt_51, t0.preinspection AS preinspection_52, t0.agentDisableConcierge AS agentDisableConcierge_53, t0.newAccountNotified AS newAccountNotified_54, t0.needsPasswordReset AS needsPasswordReset_55, t0.locked AS locked_56, t57.id AS id_58, t57.address AS address_59, t57.city AS city_60, t57.state AS state_61, t57.zip AS zip_62, t57.birthday AS birthday_63, t57.hobby AS hobby_64, t57.restaurant AS restaurant_65, t57.user_id AS user_id_66, t57.contact_id AS contact_id_67, t0.isnCredentials_id AS isnCredentials_id_68, t69.id AS id_70, t69.browser AS browser_71, t69.device AS device_72, t69.accomplish AS accomplish_73, t69.useful AS useful_74, t69.confusing AS confusing_75, t69.price AS price_76, t69.stopUsing AS stopUsing_77, t69.workAsExpected AS workAsExpected_78, t69.friend AS friend_79, t69.user_id AS user_id_80, t81.id AS id_82, t81.sent AS sent_83, t81.opened AS opened_84, t81.clicked AS clicked_85, t81.bounced AS bounced_86, t81.blocked AS blocked_87, t81.notCustomerViewed AS notCustomerViewed_88, t81.notAgentViewed AS notAgentViewed_89, t81.user_id AS user_id_90, t0.officeSettings_id AS officeSettings_id_91, t92.id AS id_93, t92.apiKey AS apiKey_94, t92.apiSecretKey AS apiSecretKey_95, t92.user_id AS user_id_96 FROM User t0 LEFT JOIN SweepstakesAgentInfo t57 ON t57.user_id = t0.id LEFT JOIN BetaQuestions t69 ON t69.user_id = t0.id LEFT JOIN InspectorNotificationSettings t81 ON t81.user_id = t0.id LEFT JOIN ApiKeys t92 ON t92.user_id = t0.id WHERE t0.username = ? LIMIT 1
Parameters: 
[
  "anthony.back@housemaster.com"
]
View formatted query    View runnable query    Explain query

Database Connections

Name Service
default doctrine.dbal.default_connection
bbp doctrine.dbal.bbp_connection
housemaster doctrine.dbal.housemaster_connection

Entity Managers

Name Service
inertia doctrine.orm.inertia_entity_manager
default doctrine.orm.default_entity_manager
bbp doctrine.orm.bbp_entity_manager
housemaster doctrine.orm.housemaster_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

inertia entity manager

Class Mapping errors
FOS\UserBundle\Model\User No errors.

default entity manager

Class Mapping errors
FOS\UserBundle\Model\User No errors.
App\AppBundle\Entity\User No errors.
App\AppBundle\Entity\SweepstakesAgentInfo No errors.
App\AppBundle\Entity\SweepstakesContact No errors.
App\AppBundle\Entity\IsnCredentials No errors.
App\AppBundle\Entity\BetaQuestions No errors.
App\AppBundle\Entity\InspectorNotificationSettings No errors.
App\AppBundle\Entity\OfficeSettings No errors.
App\AppBundle\Entity\ApiKeys No errors.
App\AppBundle\Entity\ShortUrls No errors.
App\AppBundle\Entity\MailjetEmail No errors.
App\AppBundle\Entity\OfferStat
  • The association App\AppBundle\Entity\OfferStat#offer refers to the inverse side field App\AppBundle\Entity\Offer#offerStats which does not exist.
App\AppBundle\Entity\HGReport No errors.
App\AppBundle\Entity\HGReportUser No errors.
App\AppBundle\Entity\HomeGaugeFileUpload No errors.
App\AppBundle\Entity\Home No errors.
App\AppBundle\Entity\RepairWiseCardPayment No errors.
App\AppBundle\Entity\HGReportNotifications No errors.
App\AppBundle\Entity\RepairRequest No errors.
App\AppBundle\Entity\RepairWiseToken No errors.
App\AppBundle\Entity\RepairWiseReportLink No errors.
App\AppBundle\Entity\Offer No errors.
App\AppBundle\Entity\SupplementalReport No errors.
App\AppBundle\Entity\HGReportLink No errors.
App\AppBundle\Entity\HGReportRole No errors.
App\AppBundle\Entity\Appliance
  • The mappings App\AppBundle\Entity\Appliance#appliancetype and App\AppBundle\Entity\ApplianceTypes#appliances are inconsistent with each other.
App\AppBundle\Entity\Vehicle No errors.
App\AppBundle\Entity\Finish No errors.
App\AppBundle\Entity\Inventory No errors.
App\AppBundle\Entity\Maintenance No errors.
App\AppBundle\Entity\Document No errors.
App\AppBundle\Entity\Paints No errors.
App\AppBundle\Entity\Projects No errors.
App\AppBundle\Entity\Rooms No errors.
App\AppBundle\Entity\Utilities No errors.
App\AppBundle\Entity\RepairWiseCardPaymentCard No errors.
App\AppBundle\Entity\RepairRequestItem No errors.
App\AppBundle\Entity\Feeds No errors.
App\AppBundle\Entity\VehicleRecallTemp No errors.
App\AppBundle\Entity\RepairRequestItemImage No errors.
App\AppBundle\Entity\HomeWarrantyBlackList No errors.
App\AppBundle\Entity\ApplianceRecallMatch
  • The mappings App\AppBundle\Entity\ApplianceRecallMatch#recall and App\AppBundle\Entity\Recall#applianceRecallMatches are inconsistent with each other.
App\AppBundle\Entity\Recall No errors.
App\AppBundle\Entity\HazardType No errors.
App\AppBundle\Entity\LoginLog No errors.
App\AppBundle\Entity\SweepstakesWinner No errors.
App\AppBundle\Entity\UsaRecallSearchSelection No errors.
App\AppBundle\Entity\LavaSurfLocation No errors.
App\AppBundle\Entity\Remedies No errors.
App\AppBundle\Entity\ManufacturerCountries No errors.
App\AppBundle\Entity\Company No errors.
App\AppBundle\Entity\Images No errors.
App\AppBundle\Entity\SweepstakesOptOut No errors.
App\AppBundle\Entity\ApplianceTypes
  • The association App\AppBundle\Entity\ApplianceTypes#appliances refers to the owning side field App\AppBundle\Entity\Appliance#applianceType which does not exist.
App\AppBundle\Entity\CronIRGEmailQueue No errors.
App\AppBundle\Entity\TextMessage No errors.
App\AppBundle\Entity\CanRecallPanel No errors.
App\AppBundle\Entity\RepairCalculatorSuggestion No errors.
App\AppBundle\Entity\UsersManualEmail No errors.
App\AppBundle\Entity\HomeAdvisorId No errors.
App\AppBundle\Entity\CanProduct No errors.
App\AppBundle\Entity\HGReportLinkLog No errors.
App\AppBundle\Entity\Thread No errors.
App\AppBundle\Entity\CanRecallImage No errors.
App\AppBundle\Entity\UsaRecallApplianceTypes No errors.
App\AppBundle\Entity\InspectionTextQueue No errors.
App\AppBundle\Entity\CanVehicle No errors.
App\AppBundle\Entity\UsaRecallData No errors.
App\AppBundle\Entity\Injuries No errors.
App\AppBundle\Entity\MaintenanceChecklist No errors.
App\AppBundle\Entity\BBPDoNotContact No errors.
App\AppBundle\Entity\RepairEstimateReport No errors.
App\AppBundle\Entity\HGCustomerCount No errors.
App\AppBundle\Entity\Products No errors.
App\AppBundle\Entity\DefaultHomeDocument No errors.
App\AppBundle\Entity\RepairRequestItemVideo No errors.
App\AppBundle\Entity\Hazards No errors.
App\AppBundle\Entity\UsaCanadaLatestRecallList No errors.
App\AppBundle\Entity\RoomImages No errors.
App\AppBundle\Entity\CanRecall No errors.
App\AppBundle\Entity\Comment No errors.
App\AppBundle\Entity\ImageRejectionReasons No errors.
App\AppBundle\Entity\Retailers No errors.
App\AppBundle\Entity\Category No errors.
App\AppBundle\Entity\MaintenanceHistory No errors.
App\AppBundle\Entity\SweepstakesEntry No errors.
App\AppBundle\Entity\MaintenanceChecklistSublist No errors.
App\AppBundle\Entity\Rss No errors.
App\AppBundle\Entity\Post No errors.
App\AppBundle\Entity\LavaSurfRequests No errors.
App\AppBundle\Entity\HomeAdvisorInfo No errors.
App\AppBundle\Entity\RepairCalculatorReport No errors.
App\AppBundle\Entity\WeListenLinks No errors.
App\AppBundle\Entity\NewsletterMessage No errors.
App\AppBundle\Entity\Manufacturers No errors.
App\AppBundle\Entity\FurnaceFilter No errors.
App\AppBundle\Entity\CouponCodes No errors.
App\AppBundle\Entity\Inconjunctions No errors.
App\AppBundle\Entity\VehicleRecall No errors.
App\AppBundle\Entity\UsaRecallHomeAppliances No errors.
App\AppBundle\Entity\MaintenanceVideos No errors.
App\AppBundle\Entity\Vote No errors.
App\AppBundle\Entity\CanVehicleRecall No errors.
App\AppBundle\Entity\CronIrgIsnOrders No errors.
App\AppBundle\Entity\ProductUPCs No errors.
App\AppBundle\Entity\UsaRecallDataDetails No errors.
App\AppBundle\Entity\OfferCategories No errors.
App\AppBundle\Entity\Profile No errors.

bbp entity manager

No loaded entities.

housemaster entity manager

Class Mapping errors
App\Housemaster\Bundle\HousemasterBundle\Entity\UsTerritories
  • The association App\Housemaster\Bundle\HousemasterBundle\Entity\UsTerritories#account refers to the inverse side field App\Housemaster\Bundle\HousemasterBundle\Entity\Accounts#usTerritories which does not exist.
App\Housemaster\Bundle\HousemasterBundle\Entity\Accounts No errors.