jDownloadsownloads.com


Author Topic: Problem bei Upgrade von 1.9.1.6 - [Fixed in 2.5.22 !!!]  (Read 15384 times)

0 Members and 2 Guests are viewing this topic.

Offline Zoker

  • jD Tester
  • *
  • Posts: 36
  • Translator - Tester
Hallo Arno,

Habe heute versucht von Version 1.9.1.6 auf 2.5.21 upzugraden.

Wenn ich jetzt auf die Download Übersichtsseite im Backend gehe, kommt folgender Fehler:
Code: [Select]
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 `cnon_jdownloads_files` AS a LEFT JOIN cnon_users AS uc ON uc.id=a.checked_out LEFT JOIN `cnon_jdownloads_files` AS f ON f.file_id = a.other_file_id LEFT JOIN `cnon_languages` AS l ON l.lang_code = a.language LEFT JOIN cnon_viewlevels AS ag ON ag.id = a.access LEFT JOIN cnon_jdownloads_categories AS c ON c.id = a.cat_id LEFT JOIN cnon_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 `cnon_jdownloads_files` AS a LEFT JOIN cnon_users AS uc ON uc.id=a.checked_out LEFT JOIN `cnon_jdownloads_files` AS f ON f.file_id = a.other_file_id LEFT JOIN `cnon_languages` AS l ON l.lang_code = a.language LEFT JOIN cnon_viewlevels AS ag ON ag.id = a.access LEFT JOIN cnon_jdownloads_categories AS c ON c.id = a.cat_id LEFT JOIN cnon_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 `cnon_jdownloads_files` AS a LEFT JOIN cnon_users AS uc ON uc.id=a.checked_out LEFT JOIN `cnon_jdownloads_files` AS f ON f.file_id = a.other_file_id LEFT JOIN `cnon_languages` AS l ON l.lang_code = a.language LEFT JOIN cnon_viewlevels AS ag ON ag.id = a.access LEFT JOIN cnon_jdownloads_categories AS c ON c.id = a.cat_id LEFT JOIN cnon_jdownloads_categories AS cc ON cc.id = c.parent_id WHERE (a.published = 0 OR a.published = 1) ORDER BY a.file_title asc


Kannst du mir helfen?

Wenn ich die Kategorien im Frontend aufrufe kommt das hier:
Code: [Select]
500 - Unknown column 'a.images' in 'field list' SQL=SELECT a.file_id, a.file_title, a.file_alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.license_agree, a.size, a.date_added, a.file_date, a.publish_from, a.publish_to, a.use_timeframe, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a.url_home, a.author, a.url_author, a.created_id, a.created_mail, a.modified_id, a.modified_date, a.submitted_by, a.set_aup_points, a.downloads, a.cat_id, a.changelog, a.password, a.password_md5, a.views, a.metakey, a.metadesc, a.robots, a.update_active, a.custom_field_1, a.custom_field_2, a.custom_field_3, a.custom_field_4, a.custom_field_5, a.custom_field_6, a.custom_field_7, a.custom_field_8, a.custom_field_9, a.custom_field_10, a.custom_field_11, a.custom_field_12, a.custom_field_13, a.custom_field_14, a.access, a.language, a.ordering, a.published, a.checked_out, a.checked_out_time, a.modified_date as modified, a.modified_id,CASE WHEN a.publish_from = 0 THEN a.date_added ELSE a.publish_from END as publish_from,a.publish_to, a.images, a.metakey, a.metadesc, a.access, a.downloads, LENGTH(a.description_long) AS readmore,CASE WHEN badcats.id is not null THEN 0 ELSE a.published END AS state,aa.url_download AS filename_from_other_download,c.title AS category_title, c.access AS category_access, c.alias AS category_alias, c.cat_dir AS category_cat_dir, c.cat_dir_parent AS category_cat_dir_parent,u.name AS creator,u2.name AS modifier,u2.name AS modifier,l.title AS license_title, l.url AS license_url, l.description AS license_text,ROUND(r.rating_sum / r.rating_count, 0) AS rating, r.rating_count as rating_count, r.rating_sum as rating_sum,parent.title as parent_title, parent.id as parent_id, parent.alias as parent_alias,menuf.id AS menuf_itemid,c.published, CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published FROM cnon_jdownloads_files AS a LEFT JOIN cnon_jdownloads_files AS aa on aa.file_id = a.other_file_id LEFT JOIN cnon_jdownloads_categories AS c ON c.id = a.cat_id LEFT JOIN cnon_users AS ua ON ua.id = a.created_id LEFT JOIN cnon_users AS uam ON uam.id = a.modified_id LEFT JOIN cnon_users AS u on u.id = a.created_id LEFT JOIN cnon_users AS u2 on u2.id = a.modified_id LEFT JOIN cnon_jdownloads_licenses AS l on l.id = a.license LEFT JOIN cnon_jdownloads_ratings AS r on r.file_id = a.file_id LEFT JOIN cnon_jdownloads_categories as parent ON parent.id = c.parent_id LEFT JOIN cnon_menu AS menuf on menuf.link LIKE CONCAT('index.php?option=com_jdownloads&view=download&id=',a.file_id,'%') AND menuf.published = 1 AND menuf.access IN (1,1) LEFT OUTER JOIN (SELECT cat.id as id FROM cnon_jdownloads_categories AS cat JOIN cnon_jdownloads_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt AND parent.published != 1 GROUP BY cat.id ) AS badcats ON badcats.id = c.id WHERE a.access IN (1,1) AND c.access IN (1,1) AND CASE WHEN badcats.id is null THEN a.published ELSE 0 END = 1 AND a.cat_id = 2 AND (a.publish_from = '0000-00-00 00:00:00' OR a.publish_from <= '2015-01-07 12:00:30') AND (a.publish_to = '0000-00-00 00:00:00' OR a.publish_to >= '2015-01-07 12:00:30') GROUP BY a.file_id, a.file_title, a.file_alias, a.description, a.description_long, a.file_pic, a.images, a.price, a.release, a.file_language, a.system, a.license, a.url_license, a.size, a.date_added, a.file_date, a.publish_from, a.publish_to, a.use_timeframe, a.url_download, a.preview_filename, a.other_file_id, a.md5_value, a.sha1_value, a.extern_file, a.extern_site, a.mirror_1, a.mirror_2, a.extern_site_mirror_1, a.extern_site_mirror_2, a. url_home, a.author, a.url_author, a.created_by, a.created_id, a.created_mail, a.modified_id, a.modified_date, a.submitted_by, a.downloads, a.set_aup_points, a.downloads, a.cat_id, a.notes, a.changelog, a.password_md5, a.views, a.tags, a.metakey, a.metadesc, a.robots, a.update_active, a.custom_field_1, a.custom_field_2, a.custom_field_3, a.custom_field_4, a.custom_field_5, a.custom_field_6, a.custom_field_7, a.custom_field_8, a.custom_field_9, a.custom_field_10, a.custom_field_11, a.custom_field_12, a.custom_field_13, a.custom_field_14, a.access, a.language, a.ordering, a.published, a.checked_out, a.checked_out_time, a.asset_id, uam.id, uam.name, badcats.id, c.id, c.title, c.access, c.alias, c.published, c.lft, ua.name, ua.email, parent.title, parent.id, parent.alias, parent.lft ORDER BY a.ordering ASC LIMIT 0, 10


Vielen Dank
Zoker
« Last Edit: 15.01.2015 20:57:18 by Arno »

Offline Arno

  • Administrator
  • ***
  • Posts: 12.271
    • jDownloads.com
Re: Problem bei Upgrade von 1.9.1.6
« Reply #1 on: 07.01.2015 13:40:03 »
Hi,
Quote
Habe heute versucht von Version 1.9.1.6 auf 2.5.21 upzugraden.
Hast du denn dabei auch die Update Anleitung beachtet? Sieht nicht danach aus...
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!

Offline Zoker

  • jD Tester
  • *
  • Posts: 36
  • Translator - Tester
Re: Problem bei Upgrade von 1.9.1.6
« Reply #2 on: 07.01.2015 14:20:50 »
Hab mich 1:1 daran gehalten.

An was könnte es denn liegen?

Offline Arno

  • Administrator
  • ***
  • Posts: 12.271
    • jDownloads.com
Re: Problem bei Upgrade von 1.9.1.6
« Reply #3 on: 07.01.2015 15:06:03 »
Hm.... hattest du den menu link erneuert?

Quote
Unknown column 'a.other_file_id'
das deutet darauf hin, das die neuen Tabellen nicht vorhanden oder nicht komplett vorhanden sind.
Wie waren denn die Meldungen beim Installieren und Importieren?

Im Backend geht alles?  ::)
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!

Offline Zoker

  • jD Tester
  • *
  • Posts: 36
  • Translator - Tester
Re: Problem bei Upgrade von 1.9.1.6
« Reply #4 on: 07.01.2015 15:36:43 »
Menu item habe ich aktualisiert

Wie gesagt, wenn ich im Backend diese Seite (index.php?option=com_jdownloads&view=downloads) aufrufen will, kommt der erst genannte Fehler.

Auch auch folgenden Seiten gibt es einen Fehler:
  • index.php?option=com_jdownloads&view=templates&type=1 (auch type=2,3 etc)
  • index.php?option=com_jdownloads&view=groups

Log ist angehängt

[gelöscht durch Administrator]
« Last Edit: 07.01.2015 15:38:14 by Zoker »

Offline Arno

  • Administrator
  • ***
  • Posts: 12.271
    • jDownloads.com
Re: Problem bei Upgrade von 1.9.1.6
« Reply #5 on: 07.01.2015 15:48:26 »
Danke für das Logfile:
Quote
Files Result: Can not move file ID 2
Files Result: Can not move file ID 3
Files Result: Can not move file ID 4
...
Alle anderen Vorgänge meldeten keine Vorgänge (bei installation / Import) ?

Wie es aussieht sind die Datenbank Tabellen für die neue Version nicht korrekt.
Welche Version hast du für den Import verwendet? Ich hoffe die neueste von gestern Nacht? 3.2.21? 2.5.21?
Den Import habe ich jetzt schon länger nicht mehr mit der 2.5er Version getestet da man ja eigentlich direkt auf die 3.2er updaten sollte. Der Support für Joomla 2.5 wurde ja eingestellt.
« Last Edit: 07.01.2015 15:50:30 by Arno »
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!

Offline Zoker

  • jD Tester
  • *
  • Posts: 36
  • Translator - Tester
Re: Problem bei Upgrade von 1.9.1.6
« Reply #6 on: 07.01.2015 15:52:59 »
Das Logfile ist das einzige, was er mir ausgegeben hat.

Ja ich hab die neuste Version 2.5.21 genommen.
Ich habe meine Seite noch nicht auf Joomla 3.5 upgedated, da viele Komponenten nicht laufen, die ich brauche.
Deswegen habe ich die 2.5.21 genommen

Offline Arno

  • Administrator
  • ***
  • Posts: 12.271
    • jDownloads.com
Re: Problem bei Upgrade von 1.9.1.6
« Reply #7 on: 07.01.2015 15:59:13 »
Erstell mal mit jD deiner alten Version ein backup und schick mir einen Link (als PM) wo ich das dann downloaden kann.
Dann würde ich das hier mal selbst probieren und dir die neuen Importierten Daten dann schicken. Wäre wohl das einfachste.
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.271
    • jDownloads.com
Re: Problem bei Upgrade von 1.9.1.6 - [Fixed in 2.5.22 !!!]
« Reply #8 on: 15.01.2015 20:58:05 »
Hab die die importierten Daten zugesendet...
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.271
    • jDownloads.com
Re: Problem bei Upgrade von 1.9.1.6 - [Fixed in 2.5.22 !!!]
« Reply #9 on: 17.01.2015 18:06:42 »
Ich denke, dass dein Problem inzwischen ja gelöst sein sollte?
Best Regards / Gruß
Arno
Please make a Donation for jDownloads and/or write a review on the Joomla! Extensions directory!