2 hours ago, musicmaster said:Hi Chillman,
Glad to hear you like the script.
- you should NOT have adapted the language ids. The script handles adapting the language ids for all the tables that it copies. Once you start changing language ids you also need to change that in all the system tables (those not copied) and then it is easy to overlook something - as it looks you did. The only thing you should take care of is that the same active languages are present in both shops. But it doesn't matter what ids they have.
- the script overwrites the targeted tables completely. Technically it empties them (so it keeps the table structure of the new shop) and then fills them with data from the old shop. Merging data would be considerably more complicated as you would need to give products new ids and you would need to implement the new ids in all relevant tables - so that is not done.
- I am not sure how much your language adventures complicate the picture. But installing a fresh shop and giving it the right languages will take maybe half an hour - with a work load of maybe ten minutes. The script runs rather fast and updating a fresh shop shouldn't give complications and be rather fast too. The whole process of getting such a new server ready usually takes me one to two hours (and that includes complications unrelated to the script). And if there were orders in the meantime (I like to do this at quiet hours) I increase the customer and order ids in the new shop so that I can add them manually later on.
Cheers,
M
Hi again
I started from scratch again an this time I did not edit the language ID's (just made the 4 active languages in the fresh install - ID 1,2,3,4). The result is unfortunately the same for some "lang" tables - only the English text is copied into all the 4 languages. Some lang tables are correct though, so not all. Especially ps_meta_lang (pages) is quite messed up and completely different from the source.
In the Source the 4 active language IDs are 1,6,8,9. However in the database I also notice a ID 3 in some lang tables (Spanish, which was deleted years ago, but apparently still present in some tables). So maybe this is messing up the script since also ID 3.
The script say:
4 old languages: da-DK,en,no-no,sv (6,1,9,8); 4 new languages: da-DK,en,no-no,sv (1,2,4,3); Language check ok.
Doing the following language transformations: 1=>20 6=>1 1=>2 9=>4 8=>3