Tweet
Hi,
wir haben in einer Installation aktuell das Verhalten, dass nach dem Leeren des prod caches das Backend Menü für einen unserer CCs verschwindet. Ein Blick ins Install Tool verrät, dass Contao hier kontinuierlich 2 Tabellen (CCs) neu erstellen will, obwohl diese bereits existieren. Wenn wir die Befehle durchführen ist das BE Menü wieder da, bis der Cache geleert wird. Das DB Update führt ausserdem zu einem Fehler, da es die Tabellen bereits gibt.
Wo könnte hier das Problem liegen?
CREATE TABLE `tl_mobile_seller` ( `id` int(10) unsigned NOT NULL auto_increment, `pid` int(10) unsigned NOT NULL default '0', `tstamp` int(10) unsigned NOT NULL default '0', `sorting` int(10) unsigned NOT NULL default '0', `ptable` varchar(64) NOT NULL default '', `fax` varchar(255) NOT NULL default '', `image_contact` binary(16) NULL, `anrede` varchar(64) NOT NULL default '', `titel` varchar(255) NOT NULL default '', `firstname` varchar(255) NOT NULL default '', `lastname` varchar(255) NOT NULL default '', `tel_durchw` varchar(255) NOT NULL default '', `tel_handy` varchar(255) NOT NULL default '', `email_direkt` varchar(255) NOT NULL default '', `published` char(1) NOT NULL default '', `alias` varchar(255) BINARY NOT NULL default '', `position` mediumtext NULL, `department` varchar(64) NOT NULL default '', PRIMARY KEY (`id`), KEY `pid` (`pid`), KEY `tstamp` (`tstamp`), KEY `sorting` (`sorting`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE TABLE `tl_mobile_ad` ( `id` int(10) unsigned NOT NULL auto_increment, `tstamp` int(10) unsigned NOT NULL default '0', `mobile_id` int(10) unsigned NOT NULL default '0', `creation` int(10) unsigned NOT NULL default '0', `modification` int(10) unsigned NOT NULL default '0', `url` varchar(255) NOT NULL default '', `class` varchar(255) NOT NULL default '', `category` varchar(255) NOT NULL default '', `make` varchar(255) NOT NULL default '', `model` varchar(255) NOT NULL default '', `model_description` varchar(255) NOT NULL default '', `damage_and_unrepaired` char(1) NOT NULL default '', `accident_damaged` char(1) NOT NULL default '', `roadworthy` char(1) NOT NULL default '', `features` blob NULL, `exterior_color` varchar(64) NOT NULL default '', `exterior_color_metalic` char(1) NOT NULL default '', `exterior_color_name` varchar(128) NOT NULL default '', `mileage` varchar(16) NOT NULL default '', `general_inspection` varchar(16) NOT NULL default '', `door_count` varchar(16) NOT NULL default '', `first_registration` varchar(16) NOT NULL default '', `emission_class` varchar(64) NOT NULL default '', `efc_envkv_compliant` char(1) NOT NULL default '', `efc_energy_efficiency_class` varchar(64) NOT NULL default '', `efc_co2_emission` varchar(32) NOT NULL default '', `efc_inner` varchar(32) NOT NULL default '', `efc_outer` varchar(32) NOT NULL default '', `efc_combined` varchar(32) NOT NULL default '', `efc_unit` varchar(32) NOT NULL default '', `efc_petrol_type` varchar(32) NOT NULL default '', `efc_combined_power_consumption` varchar(32) NOT NULL default '', `emission_sticker` varchar(64) NOT NULL default '', `fuel` varchar(128) NOT NULL default '', `wltp_consumption_fuel_combined` varchar(32) NOT NULL default '', `wltp_co2_emission_combined` varchar(32) NOT NULL default '', `wltp_consumption_power_combined` varchar(32) NOT NULL default '', `wltp_electric_range` varchar(32) NOT NULL default '', `wltp_consumption_fuel_combined_weighted` varchar(32) NOT NULL default '', `wltp_consumption_power_combined_weighted` varchar(32) NOT NULL default '', `wltp_co2_emission_combined_weighted` varchar(32) NOT NULL default '', `power` varchar(128) NOT NULL default '', `gearbox` varchar(128) NOT NULL default '', `climatisation` varchar(128) NOT NULL default '', `num_seats` varchar(8) NOT NULL default '', `cubic_capacity` varchar(128) NOT NULL default '', `condition` varchar(128) NOT NULL default '', `interior_color` varchar(128) NOT NULL default '', `interior_type` varchar(128) NOT NULL default '', `airbag` varchar(128) NOT NULL default '', `number_of_previous_owners` varchar(8) NOT NULL default '', `speed_control` varchar(128) NOT NULL default '', `radio` blob NULL, `daytime_running_lamps` varchar(128) NOT NULL default '', `headlight_type` varchar(128) NOT NULL default '', `highlights` blob NULL, `description` blob NULL, `description_enriched` blob NULL, `image` varchar(255) NOT NULL default '', `images` blob NULL, `price` varchar(16) NOT NULL default '', `price_type` varchar(32) NOT NULL default '', `currency` varchar(8) NOT NULL default '', `vatable` char(1) NOT NULL default '', `vat_rate` varchar(8) NOT NULL default '', `published` char(1) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE utf8mb4_unicode_ci;
wir haben in einer Installation aktuell das Verhalten, dass nach dem Leeren des prod caches das Backend Menü für einen unserer CCs verschwindet. Ein Blick ins Install Tool verrät, dass Contao hier kontinuierlich 2 Tabellen (CCs) neu erstellen will, obwohl diese bereits existieren. Wenn wir die Befehle durchführen ist das BE Menü wieder da, bis der Cache geleert wird. Das DB Update führt ausserdem zu einem Fehler, da es die Tabellen bereits gibt.
Wo könnte hier das Problem liegen?
CREATE TABLE `tl_mobile_seller` ( `id` int(10) unsigned NOT NULL auto_increment, `pid` int(10) unsigned NOT NULL default '0', `tstamp` int(10) unsigned NOT NULL default '0', `sorting` int(10) unsigned NOT NULL default '0', `ptable` varchar(64) NOT NULL default '', `fax` varchar(255) NOT NULL default '', `image_contact` binary(16) NULL, `anrede` varchar(64) NOT NULL default '', `titel` varchar(255) NOT NULL default '', `firstname` varchar(255) NOT NULL default '', `lastname` varchar(255) NOT NULL default '', `tel_durchw` varchar(255) NOT NULL default '', `tel_handy` varchar(255) NOT NULL default '', `email_direkt` varchar(255) NOT NULL default '', `published` char(1) NOT NULL default '', `alias` varchar(255) BINARY NOT NULL default '', `position` mediumtext NULL, `department` varchar(64) NOT NULL default '', PRIMARY KEY (`id`), KEY `pid` (`pid`), KEY `tstamp` (`tstamp`), KEY `sorting` (`sorting`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE utf8mb4_unicode_ci;
CREATE TABLE `tl_mobile_ad` ( `id` int(10) unsigned NOT NULL auto_increment, `tstamp` int(10) unsigned NOT NULL default '0', `mobile_id` int(10) unsigned NOT NULL default '0', `creation` int(10) unsigned NOT NULL default '0', `modification` int(10) unsigned NOT NULL default '0', `url` varchar(255) NOT NULL default '', `class` varchar(255) NOT NULL default '', `category` varchar(255) NOT NULL default '', `make` varchar(255) NOT NULL default '', `model` varchar(255) NOT NULL default '', `model_description` varchar(255) NOT NULL default '', `damage_and_unrepaired` char(1) NOT NULL default '', `accident_damaged` char(1) NOT NULL default '', `roadworthy` char(1) NOT NULL default '', `features` blob NULL, `exterior_color` varchar(64) NOT NULL default '', `exterior_color_metalic` char(1) NOT NULL default '', `exterior_color_name` varchar(128) NOT NULL default '', `mileage` varchar(16) NOT NULL default '', `general_inspection` varchar(16) NOT NULL default '', `door_count` varchar(16) NOT NULL default '', `first_registration` varchar(16) NOT NULL default '', `emission_class` varchar(64) NOT NULL default '', `efc_envkv_compliant` char(1) NOT NULL default '', `efc_energy_efficiency_class` varchar(64) NOT NULL default '', `efc_co2_emission` varchar(32) NOT NULL default '', `efc_inner` varchar(32) NOT NULL default '', `efc_outer` varchar(32) NOT NULL default '', `efc_combined` varchar(32) NOT NULL default '', `efc_unit` varchar(32) NOT NULL default '', `efc_petrol_type` varchar(32) NOT NULL default '', `efc_combined_power_consumption` varchar(32) NOT NULL default '', `emission_sticker` varchar(64) NOT NULL default '', `fuel` varchar(128) NOT NULL default '', `wltp_consumption_fuel_combined` varchar(32) NOT NULL default '', `wltp_co2_emission_combined` varchar(32) NOT NULL default '', `wltp_consumption_power_combined` varchar(32) NOT NULL default '', `wltp_electric_range` varchar(32) NOT NULL default '', `wltp_consumption_fuel_combined_weighted` varchar(32) NOT NULL default '', `wltp_consumption_power_combined_weighted` varchar(32) NOT NULL default '', `wltp_co2_emission_combined_weighted` varchar(32) NOT NULL default '', `power` varchar(128) NOT NULL default '', `gearbox` varchar(128) NOT NULL default '', `climatisation` varchar(128) NOT NULL default '', `num_seats` varchar(8) NOT NULL default '', `cubic_capacity` varchar(128) NOT NULL default '', `condition` varchar(128) NOT NULL default '', `interior_color` varchar(128) NOT NULL default '', `interior_type` varchar(128) NOT NULL default '', `airbag` varchar(128) NOT NULL default '', `number_of_previous_owners` varchar(8) NOT NULL default '', `speed_control` varchar(128) NOT NULL default '', `radio` blob NULL, `daytime_running_lamps` varchar(128) NOT NULL default '', `headlight_type` varchar(128) NOT NULL default '', `highlights` blob NULL, `description` blob NULL, `description_enriched` blob NULL, `image` varchar(255) NOT NULL default '', `images` blob NULL, `price` varchar(16) NOT NULL default '', `price_type` varchar(32) NOT NULL default '', `currency` varchar(8) NOT NULL default '', `vatable` char(1) NOT NULL default '', `vat_rate` varchar(8) NOT NULL default '', `published` char(1) NOT NULL default '', PRIMARY KEY (`id`) ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE utf8mb4_unicode_ci;
Kommentar