Einfach folgendes SQL ausführen. Es bewirkt, dass die URLs der Staging Shops wieder korrekt gesetzt werden. Zusätzlich wird Google Analytics deaktiviert, damit keine falschen Statistiken geloggt werden.
update mag_core_config_data set value = 'http://staging-kpo.constancy.biz/' where config_id = 3;
update mag_core_config_data set value = 'https://staging-kpo.constancy.biz/' where config_id = 5;
update mag_core_config_data set value = 'http://staging-wb.constancy.biz/' where config_id = 1590;
update mag_core_config_data set value = 'https://staging-wb.constancy.biz/' where config_id = 1591;
update mag_core_config_data set value = 'http://staging-sw.constancy.biz/' where config_id = 1915;
update mag_core_config_data set value = 'https://staging-sw.constancy.biz/' where config_id = 1916;
update mag_core_config_data set value = 'http://staging-koe.constancy.biz/' where config_id = 2742;
update mag_core_config_data set value = 'https://staging-koe.constancy.biz/' where config_id = 2743;
update mag_core_config_data set value = 'http://kahlaaut.constancy.biz/' where config_id = 2332;
update mag_core_config_data set value = 'https://kahlaaut.constancy.biz/' where config_id = 2333;
update mag_core_config_data set value = 'http://staging-su.constancy.biz/' where config_id = 2641;
update mag_core_config_data set value = 'https://staging-su.constancy.biz/' where config_id = 2642;
update mag_core_config_data set value = 'http://kahlafr.constancy.biz/' where config_id = 2770;
update mag_core_config_data set value = 'https://kahlafr.constancy.biz/' where config_id = 2771;
update mag_core_config_data set value = 'http://kahlauk.constancy.biz/' where config_id = 2881;
update mag_core_config_data set value = 'https://kahlauk.constancy.biz/' where config_id = 2882;
update mag_core_config_data set value = 'http://staging-kt.constancy.biz/' where config_id = 3241;
update mag_core_config_data set value = 'https://staging-kt.constancy.biz/' where config_id = 3242;
update mag_core_config_data set value = 0 where path like '%web/secure/use_in_frontend%';
update mag_core_config_data set value = 0 where path like 'google_analytics_active';
update mag_core_config_data set value = 0 where path like 'payment_pnsofortueberweisung_active';
update mag_core_config_data set value = 0 where path like 'payment_invoice_active';
update mag_core_config_data set value = 0 where path like 'payment_ipayment_cc_active';
update mag_core_config_data set value = 0 where path like 'payment_paypal_standard_active';
update mag_core_config_data set value = 'NOINDEX,NOFOLLOW' where path like 'design_head_default_robots';
