Error 500 Internal Server Error

GET https://www.rsystprojectwebsite.com/business-products/office-and-school-supplies/

Forwarded to ErrorController (19d9aa)

Query Metrics

2 Database Queries
2 Different statements
0.49 ms Query time
22 Invalid entities

Queries

Group similar statements

# Time Info
1 0.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.iso_code AS iso_code_3, t0.display_name AS display_name_4, t0.is_active AS is_active_5 FROM language t0 WHERE t0.id = ?
Parameters:
[
  "2"
]
2 0.16 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.is_main AS is_main_2, c0_.generic_value AS generic_value_3, c0_.high_value_threshold AS high_value_threshold_4, c0_.is_updated AS is_updated_5, c0_.is_active AS is_active_6, c0_.can_have_cp AS can_have_cp_7, c0_.slug AS slug_8, c0_.is_public AS is_public_9, c0_.generic_high_value AS generic_high_value_10, c0_.newsletter_default_footer_image AS newsletter_default_footer_image_11, c0_.newsletter_default_footer_image_price_drop AS newsletter_default_footer_image_price_drop_12, c0_.google_id AS google_id_13, c0_.max_quantity_same_lot_item AS max_quantity_same_lot_item_14, c0_.parent_id AS parent_id_15, c0_.scan_category_group_id AS scan_category_group_id_16 FROM category c0_ INNER JOIN category_lang c1_ ON c0_.id = c1_.category_id AND (c1_.language_id = ?) WHERE c1_.slug = ? AND c0_.is_active = 1 AND c0_.is_public = 1 HAVING c0_.parent_id IS NOT NULL
Parameters:
[
  2
  "office-and-school-supplies"
]

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.

Entities Mapping

Class Mapping errors
App\Entity\Language No errors.
App\Entity\Front\CountryLang No errors.
App\Entity\Front\Cart No errors.
App\Entity\Front\Order
  • The mappings App\Entity\Front\Order#billingAddress and App\Entity\Front\Address#orders are inconsistent with each other.
App\Entity\Information\ProductConditionLang No errors.
App\Entity\Front\Customer
  • The association App\Entity\Front\Customer#orderHistories refers to the owning side field App\Entity\Front\OrderHistory#customer which does not exist.
App\Entity\CategoryLang No errors.
App\Entity\SupplierLang No errors.
App\Entity\Front\WebsitePageLang No errors.
App\Entity\Front\HomepageAlertLang No errors.
App\Entity\Category
  • The field 'App\Entity\Category#isUpdated' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\Category#isActive' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The association App\Entity\Category#mappingCategories refers to the owning side field App\Entity\MappingCategory#mainCategory which does not exist.
  • The mappings App\Entity\Category#lots and App\Entity\Lot#category are inconsistent with each other.
App\Entity\ScanCategoryGroup
  • The association App\Entity\ScanCategoryGroup#reportPerformanceEntryGroups refers to the owning side field App\Entity\ReportPerformanceEntryGroup#ScanCategoryGroup which does not exist.
App\Entity\Product
  • The mappings App\Entity\Product#analyzedBy and App\Entity\User#analysedProducts are inconsistent with each other.
  • The mappings App\Entity\Product#internalSkus and App\Entity\InternalSku#product are inconsistent with each other.
App\Entity\ProductConditionDiscount No errors.
App\Entity\MappingCategory
  • The field 'App\Entity\MappingCategory#isUnmapped' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\CategoryAction No errors.
App\Entity\Lot
  • The field 'App\Entity\Lot#isHighValue' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\Lot#isCp' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The association App\Entity\Lot#po refers to the inverse side field App\Entity\Po#numbers which does not exist.
  • The association App\Entity\Lot#category refers to the inverse side field App\Entity\Category#isHighValue which does not exist.
  • The field App\Entity\Lot#triageScans is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\TriageScan#lot does not contain the required 'inversedBy="triageScans"' attribute.
App\Entity\SupplierProductConditionDiscount No errors.
App\Entity\SupplierCategoryValue No errors.
App\Entity\Front\FrontProduct No errors.
App\Entity\Newsletter No errors.
App\Entity\ReportStockRotationEntry No errors.
App\Entity\Front\OrderCategoryDiscount No errors.
App\Entity\Front\Country No errors.
App\Entity\Front\CartProduct No errors.
App\Entity\Front\ShippingMode
  • The association App\Entity\Front\ShippingMode#taxRuleGroup refers to the inverse side field App\Entity\Front\TaxRuleGroup#shippingModes which does not exist.
App\Entity\Front\Address
  • The field App\Entity\Front\Address#orders is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Front\Order#shippingAddress does not contain the required 'inversedBy="orders"' attribute.
App\Entity\Front\State No errors.
App\Entity\Front\CartShippingMode No errors.
App\Entity\Front\CartDiscount No errors.
App\Entity\Front\OrderFrontProduct No errors.
App\Entity\Front\OrderShippingTax No errors.
App\Entity\Front\OrderStatus
  • The field 'App\Entity\Front\OrderStatus#invoice' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\Front\OrderStatus#sendEmail' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\Front\OrderStatus#isLogable' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\Front\OrderStatus#isDeleted' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Front\OrderHistory No errors.
App\Entity\Front\OrderPaymentIntent No errors.
App\Entity\Front\OrderPayment No errors.
App\Entity\Front\OrderDiscount No errors.
App\Entity\Front\OrderDiscountTax No errors.
App\Entity\Warehouse
  • The mappings App\Entity\Warehouse#users and App\Entity\User#warehouse are inconsistent with each other.
App\Entity\Front\TaxRuleGroup
  • The field 'App\Entity\Front\TaxRuleGroup#isActive' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\Front\TaxRuleGroup#isDeleted' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Front\OrderFrontProductTax No errors.
App\Entity\Front\OrderRefund No errors.
App\Entity\StockUpdate No errors.
App\Entity\Information\ProductCondition
  • The field 'App\Entity\Information\ProductCondition#isActive' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Front\CustomerGroup No errors.
App\Entity\Front\WhishListItem No errors.
App\Entity\Truckload No errors.
App\Entity\Supplier
  • The field 'App\Entity\Supplier#hasActions' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\Supplier#hasValidation' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\Supplier#hasHighValue' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\Supplier#isActive' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\Supplier#isDeleted' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Front\WebsitePage No errors.
App\Entity\Front\HomepageAlert No errors.
App\Entity\TriageScan No errors.
App\Entity\ScanSession No errors.
App\Entity\ReportScanGroup No errors.
App\Entity\ReportPerformanceEntryGroup
  • The mappings App\Entity\ReportPerformanceEntryGroup#scanCategoryGroup and App\Entity\ScanCategoryGroup#reportPerformanceEntryGroups are inconsistent with each other.
App\Entity\User
  • The mappings App\Entity\User#assignedScanManifests and App\Entity\ScanManifestUser#user are inconsistent with each other.
  • The association App\Entity\User#analysedProducts refers to the owning side field App\Entity\Product#analysedBy which does not exist.
  • The association App\Entity\User#analyzedManifestItems refers to the owning side field App\Entity\ManifestItem#analysedBy which does not exist.
  • The association App\Entity\User#warehouse refers to the inverse side field App\Entity\Warehouse#userss which does not exist.
  • The mappings App\Entity\User#userMainTableSettings and App\Entity\UserMainTableSetting#user are inconsistent with each other.
App\Entity\ProductAction No errors.
App\Entity\MerchantSku No errors.
App\Entity\ManifestItem
  • The association App\Entity\ManifestItem#po refers to the inverse side field App\Entity\Po#ManifestItems which does not exist.
  • The mappings App\Entity\ManifestItem#analyzedBy and App\Entity\User#analyzedManifestItems are inconsistent with each other.
  • The mappings App\Entity\ManifestItem#internalSkus and App\Entity\InternalSku#manifestItem are inconsistent with each other.
App\Entity\LotItem No errors.
App\Entity\PreparationLot
  • The field 'App\Entity\PreparationLot#isEmpty' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
  • The field 'App\Entity\PreparationLot#isAction' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Analysis\UpcItemDb No errors.
App\Entity\ProductUpdateLog No errors.
App\Entity\ProductCpPhoto No errors.
App\Entity\MarketingPhoto No errors.
App\Entity\Analysis\Synccentric No errors.
App\Entity\InternalSku
  • The association App\Entity\InternalSku#manifestItem refers to the inverse side field App\Entity\ManifestItem#uniqueIds which does not exist.
  • The association App\Entity\InternalSku#product refers to the inverse side field App\Entity\Product#uniqueIds which does not exist.
App\Entity\Information\Action
  • The field 'App\Entity\Information\Action#isAvailableAnalysisChoice' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\Po
  • The mappings App\Entity\Po#lots and App\Entity\Lot#po are inconsistent with each other.
  • The mappings App\Entity\Po#manifestItems and App\Entity\ManifestItem#po are inconsistent with each other.
App\Entity\TruckloadLot
  • The field 'App\Entity\TruckloadLot#isCp' has the property type 'int' that differs from the metadata field type 'bool' returned by the 'boolean' DBAL type.
App\Entity\LotPhoto No errors.
App\Entity\StockLocationUpdate No errors.
App\Entity\CombinedManifestLot No errors.
App\Entity\Front\FrontProductImage No errors.
App\Entity\TruckloadFrontProduct No errors.
App\Entity\Front\FrontProductListingProgress No errors.
App\Entity\StockLocation No errors.
App\Entity\TruckloadIncludedFrontProduct No errors.
App\Entity\ReportStockRotation No errors.