SQL nach Update der Datenbank im Staging System (Abzug vom Live System)

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';

Schreibe einen Kommentar

Menü schließen