Hi Maxime... according to this... http://stackoverflow.com/questions/6585574/postgres-default-sort-by-id-worldship postgres returns a not sortet result... so the xml is scambled... :-(
how to fix export or import? We think a "sort by id" in the export functions (it seems to be a problem with all exports... rooms, user, flvs, messages... ) could do the job... Could you give us a hind where we can find the used functions? BR Peter Am 28.01.2014 16:01, schrieb Peter Dähn: > no.. unfortunately not.. the same order than the xml... > > maybe something different because we use postgres-db? > > > Am 28.01.2014 15:45, schrieb Maxim Solodovnik: >> Are your ids goes one-by-one? >> >> >> On Tue, Jan 28, 2014 at 9:25 PM, Peter Dähn <[email protected] >> <mailto:[email protected]>> wrote: >> >> i allready had a look at the dbs... the ids are different... >> >> and I also droped the db before restore om... :-( >> >> anyway... sounds not good for me... :-( >> >> >> Am 28.01.2014 15:20, schrieb Maxim Solodovnik: >>> In this case >>> all rooms should have same ids after import >>> >>> could you perform select from the database to check? >>> have you dropped your Db before import? >>> >>> >>> On Tue, Jan 28, 2014 at 9:14 PM, Peter Dähn <[email protected] >>> <mailto:[email protected]>> wrote: >>> >>> hmm... i never put my hands on the database somehow... >>> >>> Am 28.01.2014 15:02, schrieb Maxim Solodovnik: >>>> the only case it can "scramble" ids: you have manually >>>> "hard" deleted some rooms >>>> >>>> >>>> On Tue, Jan 28, 2014 at 8:57 PM, Peter Dähn <[email protected] >>>> <mailto:[email protected]>> wrote: >>>> >>>> thats what i did before... and it will scramble the >>>> roomIDs... :-( >>>> >>>> any other ideas? >>>> >>>> BR Peter >>>> >>>> Am 28.01.2014 14:49, schrieb Maxim Solodovnik: >>>>> -f option for file clean up only >>>>> >>>>> you need: "./admin.sh -i -v -file >>>>> backup_31_07_2012_12_07_51.zip --drop" >>>>> >>>>> >>>>> On Tue, Jan 28, 2014 at 8:39 PM, Peter Dähn >>>>> <[email protected] <mailto:[email protected]>> wrote: >>>>> >>>>> Hi Maxim... >>>>> >>>>> according to Admin.java 199 >>>>> >>>>> Command cmd = Command.usage; >>>>> if (cmdl.hasOption('i')) { >>>>> cmd = Command.install; >>>>> } else if (cmdl.hasOption('b')) { >>>>> cmd = Command.backup; >>>>> } else if (cmdl.hasOption('r')) { >>>>> cmd = Command.restore; >>>>> } else if (cmdl.hasOption('l')) { >>>>> cmd = Command.languages; >>>>> } else if (cmdl.hasOption('f')) { >>>>> cmd = Command.files; >>>>> } >>>>> >>>>> -f option will be ignored in case of -i... Am I right? >>>>> >>>>> BR Peter >>>>> >>>>> Am 28.01.2014 14:12, schrieb Maxim Solodovnik: >>>>>> yes >>>>>> It will not create any additional users, just >>>>>> will add the contents of backup file >>>>>> >>>>>> >>>>>> On Tue, Jan 28, 2014 at 7:59 PM, Peter Dähn >>>>>> <[email protected] <mailto:[email protected]>> wrote: >>>>>> >>>>>> Hi Maxim, >>>>>> >>>>>> thanks for your quick response. >>>>>> >>>>>> Do you mean by "install from file" the -f >>>>>> option of admin.sh? >>>>>> >>>>>> something like "./admin.sh -i -v -f -file >>>>>> backup.zip" >>>>>> >>>>>> BR >>>>>> >>>>>> Peter Dähn >>>>>> >>>>>> Am 28.01.2014 13:43, schrieb Maxim Solodovnik: >>>>>>> you can try to "install from file" >>>>>>> This is the only way I know to preserve room ids >>>>>>> >>>>>>> >>>>>>> On Tue, Jan 28, 2014 at 7:40 PM, Peter Dähn >>>>>>> <[email protected] <mailto:[email protected]>> wrote: >>>>>>> >>>>>>> >>>>>>> Hallo together, >>>>>>> >>>>>>> I faced a problem while import a backup >>>>>>> from 2.0 to 2.2. >>>>>>> >>>>>>> The roomIDs were scrambled during >>>>>>> import. This happens because the new >>>>>>> IDs will be created because of the order >>>>>>> of the rooms in room.xml. >>>>>>> >>>>>>> The problem is, that we store the >>>>>>> further roomIDs in the database of >>>>>>> our LMS and use them to launch a room >>>>>>> directly. And after the update the >>>>>>> user enter the wrong room. >>>>>>> >>>>>>> Maybe "r.setRooms_id(null);" Line 289 in >>>>>>> BackupImportController.java >>>>>>> causes the trouble. It seems there were >>>>>>> all further roomIDs discarded. >>>>>>> >>>>>>> Any Ideas how to handle it? >>>>>>> >>>>>>> BR >>>>>>> Peter Dähn >>>>>>> >>>>>>> >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> WBR >>>>>>> Maxim aka solomax >>>>>> >>>>>> >>>>>> >>>>>> >>>>>> -- >>>>>> WBR >>>>>> Maxim aka solomax >>>>> >>>>> >>>>> >>>>> >>>>> -- >>>>> WBR >>>>> Maxim aka solomax >>>> >>>> >>>> >>>> >>>> -- >>>> WBR >>>> Maxim aka solomax >>> >>> >>> >>> >>> -- >>> WBR >>> Maxim aka solomax >> >> >> >> >> -- >> WBR >> Maxim aka solomax
