*update* inzwischen erledigt.
Einige Constraints in der Datenbank haben nach Serverumzug gefehlt. Danach ließen sich alle Proxys wieder neu generieren.
Kannst du vllt sagen wie du das Problem behoben hast? habe das gleiche problem aktuell
Hallo Tammo,
mach am besten ein Backup deiner jetzigen Datenbank.
Bei mir war es so, dass beim Datenbankumzug die CONSTRAINTS schon im Export gefehlt haben.
Mit folgenden SQL-Queries konnte ich die (aus einer anderen Installation) wieder hinzufügen… Wie gesagt: vorher Backup machen.
TEIL 1:
– Constraints der exportierten Tabellen
– Constraints der Tabelle s_articles_attributes
ALTER TABLE s_articles_attributes
ADD CONSTRAINT s_articles_attributes_ibfk_1 FOREIGN KEY (articleID) REFERENCES s_articles (id) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT s_articles_attributes_ibfk_2 FOREIGN KEY (articledetailsID) REFERENCES s_articles_details (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_articles_downloads_attributes
ALTER TABLE s_articles_downloads_attributes
ADD CONSTRAINT s_articles_downloads_attributes_ibfk_1 FOREIGN KEY (downloadID) REFERENCES s_articles_downloads (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_articles_esd_attributes
ALTER TABLE s_articles_esd_attributes
ADD CONSTRAINT s_articles_esd_attributes_ibfk_1 FOREIGN KEY (esdID) REFERENCES s_articles_esd (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_articles_img_attributes
ALTER TABLE s_articles_img_attributes
ADD CONSTRAINT s_articles_img_attributes_ibfk_1 FOREIGN KEY (imageID) REFERENCES s_articles_img (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_articles_information_attributes
ALTER TABLE s_articles_information_attributes
ADD CONSTRAINT s_articles_information_attributes_ibfk_1 FOREIGN KEY (informationID) REFERENCES s_articles_information (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_articles_prices_attributes
ALTER TABLE s_articles_prices_attributes
ADD CONSTRAINT s_articles_prices_attributes_ibfk_1 FOREIGN KEY (priceID) REFERENCES s_articles_prices (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_articles_supplier_attributes
ALTER TABLE s_articles_supplier_attributes
ADD CONSTRAINT s_articles_supplier_attributes_ibfk_1 FOREIGN KEY (supplierID) REFERENCES s_articles_supplier (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_article_configurator_templates_attributes
ALTER TABLE s_article_configurator_templates_attributes
ADD CONSTRAINT s_article_configurator_templates_attributes_ibfk_1 FOREIGN KEY (template_id) REFERENCES s_article_configurator_templates (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_article_configurator_template_prices_attributes
ALTER TABLE s_article_configurator_template_prices_attributes
ADD CONSTRAINT s_article_configurator_template_prices_attributes_ibfk_1 FOREIGN KEY (template_price_id) REFERENCES s_article_configurator_template_prices (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_blog_attributes
ALTER TABLE s_blog_attributes
ADD CONSTRAINT s_blog_attributes_ibfk_1 FOREIGN KEY (blog_id) REFERENCES s_blog (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_categories
ALTER TABLE s_categories
ADD CONSTRAINT s_categories_fk_stream_id FOREIGN KEY (stream_id) REFERENCES s_product_streams (id) ON DELETE SET NULL;
– Constraints der Tabelle s_categories_attributes
ALTER TABLE s_categories_attributes
ADD CONSTRAINT s_categories_attributes_ibfk_1 FOREIGN KEY (categoryID) REFERENCES s_categories (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_cms_static_attributes
ALTER TABLE s_cms_static_attributes
ADD CONSTRAINT s_cms_static_attributes_ibfk_1 FOREIGN KEY (cmsStaticID) REFERENCES s_cms_static (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_cms_support_attributes
ALTER TABLE s_cms_support_attributes
ADD CONSTRAINT s_cms_support_attributes_ibfk_1 FOREIGN KEY (cmsSupportID) REFERENCES s_cms_support (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_core_auth_attributes
ALTER TABLE s_core_auth_attributes
ADD CONSTRAINT s_core_auth_attributes_ibfk_1 FOREIGN KEY (authID) REFERENCES s_core_auth (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_core_config_mails
ALTER TABLE s_core_config_mails
ADD CONSTRAINT s_core_config_mails_ibfk_1 FOREIGN KEY (stateId) REFERENCES s_core_states (id);
– Constraints der Tabelle s_core_config_mails_attributes
ALTER TABLE s_core_config_mails_attributes
ADD CONSTRAINT s_core_config_mails_attributes_ibfk_1 FOREIGN KEY (mailID) REFERENCES s_core_config_mails (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_core_countries_attributes
ALTER TABLE s_core_countries_attributes
ADD CONSTRAINT s_core_countries_attributes_ibfk_1 FOREIGN KEY (countryID) REFERENCES s_core_countries (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_core_countries_states_attributes
ALTER TABLE s_core_countries_states_attributes
ADD CONSTRAINT s_core_countries_states_attributes_ibfk_1 FOREIGN KEY (stateID) REFERENCES s_core_countries_states (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_core_customergroups_attributes
ALTER TABLE s_core_customergroups_attributes
ADD CONSTRAINT s_core_customergroups_attributes_ibfk_1 FOREIGN KEY (customerGroupID) REFERENCES s_core_customergroups (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_core_paymentmeans_attributes
ALTER TABLE s_core_paymentmeans_attributes
ADD CONSTRAINT s_core_paymentmeans_attributes_ibfk_1 FOREIGN KEY (paymentmeanID) REFERENCES s_core_paymentmeans (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_emarketing_banners_attributes
ALTER TABLE s_emarketing_banners_attributes
ADD CONSTRAINT s_emarketing_banners_attributes_ibfk_1 FOREIGN KEY (bannerID) REFERENCES s_emarketing_banners (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_emarketing_vouchers_attributes
ALTER TABLE s_emarketing_vouchers_attributes
ADD CONSTRAINT s_emarketing_vouchers_attributes_ibfk_1 FOREIGN KEY (voucherID) REFERENCES s_emarketing_vouchers (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_emotion_attributes
ALTER TABLE s_emotion_attributes
ADD CONSTRAINT s_emotion_attributes_ibfk_1 FOREIGN KEY (emotionID) REFERENCES s_emotion (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_export_attributes
ALTER TABLE s_export_attributes
ADD CONSTRAINT s_export_attributes_ibfk_1 FOREIGN KEY (exportID) REFERENCES s_export (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_filter_attributes
ALTER TABLE s_filter_attributes
ADD CONSTRAINT s_filter_attributes_ibfk_1 FOREIGN KEY (filterID) REFERENCES s_filter (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_filter_options_attributes
ALTER TABLE s_filter_options_attributes
ADD CONSTRAINT s_filter_options_attributes_ibfk_1 FOREIGN KEY (optionID) REFERENCES s_filter_options (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_filter_values_attributes
ALTER TABLE s_filter_values_attributes
ADD CONSTRAINT s_filter_values_attributes_ibfk_1 FOREIGN KEY (valueID) REFERENCES s_filter_values (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_import_export_expression
ALTER TABLE s_import_export_expression
ADD CONSTRAINT FK_42CE4B73CCFA12B8 FOREIGN KEY (profile_id) REFERENCES s_import_export_profile (id) ON DELETE CASCADE;
– Constraints der Tabelle s_import_export_session
ALTER TABLE s_import_export_session
ADD CONSTRAINT FK_64E921BACCFA12B8 FOREIGN KEY (profile_id) REFERENCES s_import_export_profile (id) ON DELETE CASCADE;
– Constraints der Tabelle s_media_attributes
ALTER TABLE s_media_attributes
ADD CONSTRAINT s_media_attributes_ibfk_1 FOREIGN KEY (mediaID) REFERENCES s_media (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_multi_edit_queue_articles
ALTER TABLE s_multi_edit_queue_articles
ADD CONSTRAINT s_multi_edit_queue_articles_ibfk_1 FOREIGN KEY (detail_id) REFERENCES s_articles_details (id) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT s_multi_edit_queue_articles_ibfk_2 FOREIGN KEY (queue_id) REFERENCES s_multi_edit_queue (id) ON DELETE CASCADE ON UPDATE NO ACTION;
und Teil 2:
– Constraints der Tabelle s_order_attributes
ALTER TABLE s_order_attributes
ADD CONSTRAINT s_order_attributes_ibfk_1 FOREIGN KEY (orderID) REFERENCES s_order (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_order_basket_attributes
ALTER TABLE s_order_basket_attributes
ADD CONSTRAINT s_order_basket_attributes_ibfk_2 FOREIGN KEY (basketID) REFERENCES s_order_basket (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_order_billingaddress_attributes
ALTER TABLE s_order_billingaddress_attributes
ADD CONSTRAINT s_order_billingaddress_attributes_ibfk_2 FOREIGN KEY (billingID) REFERENCES s_order_billingaddress (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_order_details_attributes
ALTER TABLE s_order_details_attributes
ADD CONSTRAINT s_order_details_attributes_ibfk_1 FOREIGN KEY (detailID) REFERENCES s_order_details (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_order_documents_attributes
ALTER TABLE s_order_documents_attributes
ADD CONSTRAINT s_order_documents_attributes_ibfk_1 FOREIGN KEY (documentID) REFERENCES s_order_documents (ID) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_order_shippingaddress_attributes
ALTER TABLE s_order_shippingaddress_attributes
ADD CONSTRAINT s_order_shippingaddress_attributes_ibfk_1 FOREIGN KEY (shippingID) REFERENCES s_order_shippingaddress (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_premium_dispatch_attributes
ALTER TABLE s_premium_dispatch_attributes
ADD CONSTRAINT s_premium_dispatch_attributes_ibfk_1 FOREIGN KEY (dispatchID) REFERENCES s_premium_dispatch (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_product_streams_articles
ALTER TABLE s_product_streams_articles
ADD CONSTRAINT s_product_streams_articles_fk_article_id FOREIGN KEY (article_id) REFERENCES s_articles (id) ON DELETE CASCADE,
ADD CONSTRAINT s_product_streams_articles_fk_stream_id FOREIGN KEY (stream_id) REFERENCES s_product_streams (id) ON DELETE CASCADE;
– Constraints der Tabelle s_product_streams_attributes
ALTER TABLE s_product_streams_attributes
ADD CONSTRAINT s_product_streams_attributes_ibfk_1 FOREIGN KEY (streamID) REFERENCES s_product_streams (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_product_streams_selection
ALTER TABLE s_product_streams_selection
ADD CONSTRAINT s_product_streams_selection_fk_article_id FOREIGN KEY (article_id) REFERENCES s_articles (id) ON DELETE CASCADE,
ADD CONSTRAINT s_product_streams_selection_fk_stream_id FOREIGN KEY (stream_id) REFERENCES s_product_streams (id) ON DELETE CASCADE;
– Constraints der Tabelle s_user_addresses
ALTER TABLE s_user_addresses
ADD CONSTRAINT s_user_addresses_ibfk_1 FOREIGN KEY (country_id) REFERENCES s_core_countries (id) ON UPDATE CASCADE,
ADD CONSTRAINT s_user_addresses_ibfk_2 FOREIGN KEY (state_id) REFERENCES s_core_countries_states (id) ON DELETE SET NULL ON UPDATE CASCADE,
ADD CONSTRAINT s_user_addresses_ibfk_3 FOREIGN KEY (user_id) REFERENCES s_user (id) ON DELETE CASCADE ON UPDATE CASCADE;
– Constraints der Tabelle s_user_addresses_attributes
ALTER TABLE s_user_addresses_attributes
ADD CONSTRAINT s_user_addresses_attributes_ibfk_1 FOREIGN KEY (address_id) REFERENCES s_user_addresses (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_user_attributes
ALTER TABLE s_user_attributes
ADD CONSTRAINT s_user_attributes_ibfk_1 FOREIGN KEY (userID) REFERENCES s_user (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_user_billingaddress_attributes
ALTER TABLE s_user_billingaddress_attributes
ADD CONSTRAINT s_user_billingaddress_attributes_ibfk_1 FOREIGN KEY (billingID) REFERENCES s_user_billingaddress (id) ON DELETE CASCADE ON UPDATE NO ACTION;
– Constraints der Tabelle s_user_shippingaddress_attributes
ALTER TABLE s_user_shippingaddress_attributes
ADD CONSTRAINT s_user_shippingaddress_attributes_ibfk_1 FOREIGN KEY (shippingID) REFERENCES s_user_shippingaddress (id) ON DELETE CASCADE ON UPDATE NO ACTION;