jDownloadsownloads.com



Author Topic: Jdownload loaded in version 2.5.27 not working  (Read 3036 times)

0 Members and 1 Guest are viewing this topic.

Offline pmandre

  • Newbie
  • *
  • Posts: 4
Jdownload loaded in version 2.5.27 not working
« on: 22.04.2015 12:45:00 »
After successful loading the upgrade version of Jdownload I have several errors under PHP 5.2.17
in the following functions of the Jdownload components


Download : error 500
500 - Une erreur s'est produite

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 `jom_jdownloads_files` AS a LEFT JOIN jom_users AS uc ON uc.id=a.checked_out LEFT JOIN `jom_jdownloads_files` AS f ON f.file_id = a.other_file_id LEFT JOIN `jom_languages` AS l ON l.lang_code = a.language LEFT JOIN jom_viewlevels AS ag ON ag.id = a.access LEFT JOIN jom_jdownloads_categories AS c ON c.id = a.cat_id LEFT JOIN jom_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 `jom_jdownloads_files` AS a LEFT JOIN jom_users AS uc ON uc.id=a.checked_out LEFT JOIN `jom_jdownloads_files` AS f ON f.file_id = a.other_file_id LEFT JOIN `jom_languages` AS l ON l.lang_code = a.language LEFT JOIN jom_viewlevels AS ag ON ag.id = a.access LEFT JOIN jom_jdownloads_categories AS c ON c.id = a.cat_id LEFT JOIN jom_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 `jom_jdownloads_files` AS a LEFT JOIN jom_users AS uc ON uc.id=a.checked_out LEFT JOIN `jom_jdownloads_files` AS f ON f.file_id = a.other_file_id LEFT JOIN `jom_languages` AS l ON l.lang_code = a.language LEFT JOIN jom_viewlevels AS ag ON ag.id = a.access LEFT JOIN jom_jdownloads_categories AS c ON c.id = a.cat_id LEFT JOIN jom_jdownloads_categories AS cc ON cc.id = c.parent_id WHERE (a.published = 0 OR a.published = 1) ORDER BY a.file_title asc

control panel : erreur Could not add download for: organigramme_reseau.pdf

add a download :
L'enregistrement a échoué avec l'erreur suivante : jdownloadsTabledownload: :store échoué
Unknown column 'password_md5' in 'field list' SQL=INSERT INTO `jom_jdownloads_files`

thanks for your help
PM Andre

Offline Arno

  • Administrator
  • ***
  • Posts: 12.234
    • jDownloads.com
Re: Jdownload loaded in version 2.5.27 not working
« Reply #1 on: 22.04.2015 13:59:58 »
Hi Andre,
Quote
After successful loading the upgrade version of Jdownload...
It seems not that it was correctly.
Have you used the update instructions from the documentation?

Please note that this can not be bugs... more wrong handling.
Also should you use better Joomla 3.x and jDownloads 3.2.x.
« Last Edit: 22.04.2015 14:01:41 by Arno »
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!

Offline pmandre

  • Newbie
  • *
  • Posts: 4
Re: Jdownload loaded in version 2.5.27 not working
« Reply #2 on: 22.04.2015 15:31:17 »
Yea I did have a message stating successful update, using the update instructions but I probably missed some. Ok should I now uninstall and then update again carefully reading the update instructions
thanks for your help
PM Andre

Offline ColinM

  • Moderator
  • *
  • Posts: 3.477
Re: Jdownload loaded in version 2.5.27 not working
« Reply #3 on: 22.04.2015 15:43:00 »
Hi
Are you migrating from jD 1.9.1.6 on Joomla! 2.5 ?  If you are then I presume you will be going shortly to Joomla! 3.x.
It is in fact slightly simpler going from the older jD series to the jD 3.2 series rather than via jd2.5 series.
Please advise you situation.

Thanks

Colin

Offline pmandre

  • Newbie
  • *
  • Posts: 4
Re: Jdownload loaded in version 2.5.27 not working
« Reply #4 on: 22.04.2015 16:04:59 »
OVH where my servers are located ask me to upgrade the  PHP to 5.3 instead of 5.2 , and the Jdownload components did not work properly , a blank page was displayed instead of a list of article.
Then I try to upgrade the Jdownload , and then I get stuck as it is the case now

I hope this helps

Offline Arno

  • Administrator
  • ***
  • Posts: 12.234
    • jDownloads.com
Re: Jdownload loaded in version 2.5.27 not working
« Reply #5 on: 23.04.2015 13:56:31 »
Please describe more detailed what you have doing exactly until now - step by step (with versions identifiers).
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!

Offline pmandre

  • Newbie
  • *
  • Posts: 4
Re: Jdownload loaded in version 2.5.27 not working
« Reply #6 on: 27.04.2015 19:10:52 »
After doing some restore of my site, very complicated and long,  under joomla I could fix the problem using Jdownload version 1.9.1.6   with Joomla 2.5.3, PHP 5.5.22
In this case I am in line with OVH my provider who request PHP 5.5.22 , and Jdownload 1.9.1.6 stable  is working fine under PHP 5.5.22
Note that the Installation under Joomla is much easier and simple using the "archive" instead of a folder.

thanks for your help and regards
PM Andre  :)