Pass auf !So mal Ganz schnell gesehen scheint dies nur zu laufen wen nur einer Sprache drin ist mit Id 1 was alt Deutsch ist dan in neu id 2 werdet , wo English vorher ID 2 hat soll es 1 werden
Dan kan man doch kein Update machen von ID 1 AUf 2 ohne so etwas ?
ZitatUPDATE categories_description SET language_id = 999 WHERE categories_description.language_id = 2;
UPDATE categories_description SET language_id = 2 WHERE categories_description.language_id = 1;
UPDATE categories_description SET language_id = 1 WHERE categories_description.language_id = 999;
Also nicht dieser oder???
SQL für die Umstellung der Sprach-ID 1 auf 2:
SQL Alles anzeigenUPDATE categories_description SET language_id = '2'; UPDATE content_manager SET languages_id = '2'; UPDATE languages SET languages_id = '2' WHERE languages.languages_id =1; UPDATE manufacturers_info SET languages_id = '2'; UPDATE orders_status SET language_id = '2' ; UPDATE products_description SET language_id = '2' ; UPDATE products_options SET language_id = '2'; UPDATE products_options_values SET language_id = '2'; UPDATE products_vpe SET language_id = '2'; UPDATE products_xsell_grp_name SET language_id = '2'; UPDATE shipping_status SET language_id = '2'; UPDATE customers_status SET language_id = '2'; UPDATE products_parameters_description SET language_id = '2'; UPDATE products_parameters_groups_description SET language_id = '2'; UPDATE product_filter_categories SET language_id = '2'; UPDATE product_filter_items SET language_id = '2'; UPDATE blog_categories SET language_id = '2'; UPDATE blog_items SET language_id = '2'; UPDATE tag_to_product SET lID = '2'; ALTER TABLE products_images CHANGE alt_langID_1 alt_langID_2 VARCHAR( 64 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL ;Führen Sie die SQL Befehle mit Hilfe von mysqldumper oder phpmyadmin Schritt für Shritt aus!