jDownloadsownloads.com


Author Topic: Migration from Jdownloads 1.9 to 2.5 change file_id order  (Read 2030 times)

0 Members and 1 Guest are viewing this topic.

Offline rikoooo

  • Newbie
  • *
  • Posts: 9
    • Rikoooo
Hi,

I'm having a issue with the migration from Jdownloads 1.9.x to 2.5.x, indeed, after the migration I've noticed that the column file_id from the table xxx_jdownloads_files has been automatically re-ordered, if for example the values of file_id was like 2, 4, 5, 8, 10, 14 now its like 1, 2, 3, 4, 5, 6, and so on.

My problem is that I use the file_id to link a download to an URL, like for example : http://www.exemple.com/fr/downloads/download/674
http://www.exemple.com/fr/downloads/download/475
http://www.exemple.com/fr/downloads/download/686
http://www.exemple.com/fr/downloads/download/607

Since I did the migration, every link is pointing to the wrong download !

I need to get back to the exact order that I had in Jdownloads 1.9 because those links are hard coded into my softwares, I can't update them  :'( :'( . Fortunately, I have a backup of the column file_id from the jdownloads 1.9.

What I want is to make the Jdownloads 2.5 column file_id equal to the Jdownloads 1.9 column file_id. I think there is a way to do that in SQL (make a column equal to another one from another table), I have been searching for hours and nothing works out. Please I need some help here.

Thanks you,

Best Regards,

Erik
« Last Edit: 20.05.2015 00:14:19 by rikoooo »

Offline Arno

  • Administrator
  • ***
  • Posts: 12.245
    • jDownloads.com
Re: Migration from Jdownloads 1.9 to 2.5 change file_id order
« Reply #1 on: 20.05.2015 23:37:08 »
Hi Erik,
it is not useful to migrate your jD to a Joomla 2.5 version.
Also the jD 2.5 release is not longer supported from us.

Quote
after the migration I've noticed that the column file_id from the table xxx_jdownloads_files has been automatically re-ordered
- Yes, this is correct and not changable with jD version 2.5. This is not a bug.
- In the version 3.2.x remain the file id values.
- the category id must be changed in both versions

Quote
Since I did the migration, every link is pointing to the wrong download !
- use Joomla 3.x with jD 3.2.x
« Last Edit: 20.05.2015 23:38:19 by Arno »
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!