jDownloadsownloads.com


Author Topic: Problem with upgrade from 1.9.1.6 to 2.5.26 - [Solved - Not really a bug]  (Read 7504 times)

0 Members and 1 Guest are viewing this topic.

Offline damientrue

  • Newbie
  • *
  • Posts: 1
Hi,

I upgraded jDownloads from 1.9.1.6 to 2.5.26. On new version, in import process, got this messages:

DB table 'jdownloads_config': 110 settings imported
DB table 'jdownloads_licence': 9 licences imported
DB table 'jdownloads_templates': 10 templates imported
DB table 'jdownloads_cats': 15 categories imported
Files Result: Can not move file ID 1
Files Result: Can not move file ID 2
[...]
Files Result: Can not move file ID 47
DB table 'jdownloads_files': 47 Downloads imported

But table _jdownloads_files is empty.

When in backend I click on "Downloads" got error:
Unknown column 'a.other_file_id' in 'field list' SQL=SELECT a.file_id, a.file_title, a.file_alias, a.description, a.file_pic, a.price, a.release, a.cat_id, a.size, a.date_added, a.publish_from, a.publish_to, a.use_timeframe, a.url_download, a.other_file_id, a.extern_file, a.downloads, a.extern_site, a.notes, a.access, a.language, a.checked_out, a.checked_out_time, a.ordering, a.published, a.asset_id,uc.name AS editor,f.url_download AS other_file_name, f.file_title AS other_download_title,l.title AS language_title,ag.title AS access_level,c.title AS category_title, c.parent_id AS category_parent_id,cc.title AS category_title_parent FROM `j17_jdownloads_files` AS a LEFT JOIN j17_users AS uc ON uc.id=a.checked_out LEFT JOIN `j17_jdownloads_files` AS f ON f.file_id = a.other_file_id LEFT JOIN `j17_languages` AS l ON l.lang_code = a.language LEFT JOIN j17_viewlevels AS ag ON ag.id = a.access LEFT JOIN j17_jdownloads_categories AS c ON c.id = a.cat_id LEFT JOIN j17_jdownloads_categories AS cc ON cc.id = c.parent_id WHERE (a.published = 0 OR a.published = 1) ORDER BY a.file_title asc Unknown column 'a.other_file_id' in 'field list' SQL=SELECT a.file_id, a.file_title, a.file_alias, a.description, a.file_pic, a.price, a.release, a.cat_id, a.size, a.date_added, a.publish_from, a.publish_to, a.use_timeframe, a.url_download, a.other_file_id, a.extern_file, a.downloads, a.extern_site, a.notes, a.access, a.language, a.checked_out, a.checked_out_time, a.ordering, a.published, a.asset_id,uc.name AS editor,f.url_download AS other_file_name, f.file_title AS other_download_title,l.title AS language_title,ag.title AS access_level,c.title AS category_title, c.parent_id AS category_parent_id,cc.title AS category_title_parent FROM `j17_jdownloads_files` AS a LEFT JOIN j17_users AS uc ON uc.id=a.checked_out LEFT JOIN `j17_jdownloads_files` AS f ON f.file_id = a.other_file_id LEFT JOIN `j17_languages` AS l ON l.lang_code = a.language LEFT JOIN j17_viewlevels AS ag ON ag.id = a.access LEFT JOIN j17_jdownloads_categories AS c ON c.id = a.cat_id LEFT JOIN j17_jdownloads_categories AS cc ON cc.id = c.parent_id WHERE (a.published = 0 OR a.published = 1) ORDER BY a.file_title asc LIMIT 0, 20 Unknown column 'a.other_file_id' in 'field list' SQL=SELECT a.file_id, a.file_title, a.file_alias, a.description, a.file_pic, a.price, a.release, a.cat_id, a.size, a.date_added, a.publish_from, a.publish_to, a.use_timeframe, a.url_download, a.other_file_id, a.extern_file, a.downloads, a.extern_site, a.notes, a.access, a.language, a.checked_out, a.checked_out_time, a.ordering, a.published, a.asset_id,uc.name AS editor,f.url_download AS other_file_name, f.file_title AS other_download_title,l.title AS language_title,ag.title AS access_level,c.title AS category_title, c.parent_id AS category_parent_id,cc.title AS category_title_parent FROM `j17_jdownloads_files` AS a LEFT JOIN j17_users AS uc ON uc.id=a.checked_out LEFT JOIN `j17_jdownloads_files` AS f ON f.file_id = a.other_file_id LEFT JOIN `j17_languages` AS l ON l.lang_code = a.language LEFT JOIN j17_viewlevels AS ag ON ag.id = a.access LEFT JOIN j17_jdownloads_categories AS c ON c.id = a.cat_id LEFT JOIN j17_jdownloads_categories AS cc ON cc.id = c.parent_id WHERE (a.published = 0 OR a.published = 1) ORDER BY a.file_title asc

It's probably the same problem from topic http://www.jdownloads.com/forum/index.php?topic=7717.0
« Last Edit: 02.03.2015 13:33:52 by Arno »

Offline Arno

  • Administrator
  • ***
  • Posts: 12.244
    • jDownloads.com
Re: Problem with upgrade from 1.9.1.6 to 2.5.26
« Reply #1 on: 27.02.2015 12:27:19 »
Hi,
it seems that in your case is something not correct.
So you have not the required table format for the files.

When you can send me a backup from your old jD tables, i can do here the update process and will send you  afterwards the corret data.
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!

Offline Arno

  • Administrator
  • ***
  • Posts: 12.244
    • jDownloads.com
Re: Problem with upgrade from 1.9.1.6 to 2.5.26
« Reply #2 on: 02.03.2015 13:33:21 »
Hi,
i have your send now the imported data via e-mail.
So this issue should be solved.
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!

Offline maxser

  • Newbie
  • *
  • Posts: 4
I have the same problem after moving to the latest version for 2.5.28

Code: [Select]
500 - An error has occurred.
Unknown column 'a.other_file_id' in 'field list' SQL=SELECT a.file_id, a.file_title, a.file_alias, a.description, a.file_pic, a.price, a.release, a.cat_id, a.size, a.date_added, a.publish_from, a.publish_to, a.use_timeframe, a.url_download, a.other_file_id, a.extern_file, a.downloads, a.extern_site, a.notes, a.access, a.language, a.checked_out, a.checked_out_time, a.ordering, a.published, a.asset_id,uc.name AS editor,f.url_download AS other_file_name, f.file_title AS other_download_title,l.title AS language_title,ag.title AS access_level,c.title AS category_title, c.parent_id AS category_parent_id,cc.title AS category_title_parent FROM `j17_jdownloads_files` AS a LEFT JOIN j17_users AS uc ON uc.id=a.checked_out LEFT JOIN `j17_jdownloads_files` AS f ON f.file_id = a.other_file_id LEFT JOIN `j17_languages` AS l ON l.lang_code = a.language LEFT JOIN j17_viewlevels AS ag ON ag.id = a.access LEFT JOIN j17_jdownloads_categories AS c ON c.id = a.cat_id LEFT JOIN j17_jdownloads_categories AS cc ON cc.id = c.parent_id WHERE (a.published = 0 OR a.published = 1) ORDER BY a.file_title asc Unknown column 'a.other_file_id' in 'field list' SQL=SELECT a.file_id, a.file_title, a.file_alias, a.description, a.file_pic, a.price, a.release, a.cat_id, a.size, a.date_added, a.publish_from, a.publish_to, a.use_timeframe, a.url_download, a.other_file_id, a.extern_file, a.downloads, a.extern_site, a.notes, a.access, a.language, a.checked_out, a.checked_out_time, a.ordering, a.published, a.asset_id,uc.name AS editor,f.url_download AS other_file_name, f.file_title AS other_download_title,l.title AS language_title,ag.title AS access_level,c.title AS category_title, c.parent_id AS category_parent_id,cc.title AS category_title_parent FROM `j17_jdownloads_files` AS a LEFT JOIN j17_users AS uc ON uc.id=a.checked_out LEFT JOIN `j17_jdownloads_files` AS f ON f.file_id = a.other_file_id LEFT JOIN `j17_languages` AS l ON l.lang_code = a.language LEFT JOIN j17_viewlevels AS ag ON ag.id = a.access LEFT JOIN j17_jdownloads_categories AS c ON c.id = a.cat_id LEFT JOIN j17_jdownloads_categories AS cc ON cc.id = c.parent_id WHERE (a.published = 0 OR a.published = 1) ORDER BY a.file_title asc LIMIT 0, 20 Unknown column 'a.other_file_id' in 'field list' SQL=SELECT a.file_id, a.file_title, a.file_alias, a.description, a.file_pic, a.price, a.release, a.cat_id, a.size, a.date_added, a.publish_from, a.publish_to, a.use_timeframe, a.url_download, a.other_file_id, a.extern_file, a.downloads, a.extern_site, a.notes, a.access, a.language, a.checked_out, a.checked_out_time, a.ordering, a.published, a.asset_id,uc.name AS editor,f.url_download AS other_file_name, f.file_title AS other_download_title,l.title AS language_title,ag.title AS access_level,c.title AS category_title, c.parent_id AS category_parent_id,cc.title AS category_title_parent FROM `j17_jdownloads_files` AS a LEFT JOIN j17_users AS uc ON uc.id=a.checked_out LEFT JOIN `j17_jdownloads_files` AS f ON f.file_id = a.other_file_id LEFT JOIN `j17_languages` AS l ON l.lang_code = a.language LEFT JOIN j17_viewlevels AS ag ON ag.id = a.access LEFT JOIN j17_jdownloads_categories AS c ON c.id = a.cat_id LEFT JOIN j17_jdownloads_categories AS cc ON cc.id = c.parent_id WHERE (a.published = 0 OR a.published = 1) ORDER BY a.file_title asc

Return to Control Panel

Can you help me out with this as well?


Offline Arno

  • Administrator
  • ***
  • Posts: 12.244
    • jDownloads.com
Hi,
normally should you make an update on the jD 3.2 series, as the older 2.4 series is not more really supported from us.

But when you can send me a backup from your old jD tables, i can do here the update process and will send you afterwards the correct data.
Send me a download link via PM.

Alternate can you try to add the missing field self via phpmyadmin the jdownloads_files table. See pic.
« Last Edit: 02.06.2015 13:14:51 by Arno »
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!