Hello,
Please help me :-)
I want take a migration from Migration JD 1.8.2 (on j1.5) -> JD 3.2.16_beta (on j3.3.6)
I do all steps from:
http://www.jdownloads.net/documentations/item/how-to-move-jdownloads-1-8-x-from-joomla-1-5-to-joomla-2-5
http://www.jdownloads.net/documentations/item/how-to-upgrade-jdownloads-component-from-1-9-x-to-latest-3-x-version?category_id=40
I do:
Migration JD 1.8.2 (on j1.5) -> JD 1.9.2.11_beta(for j3.2 ?) (on j3.3.6) -> JD 3.2.16_beta (on j3.3.6)old Website:JD 1.8.2 (j1.5) -> Backup JD function
download download/image-data
local xampp Website:install a new JD 1.9.2.11_beta (on j3.3.6)
autolist downlodas folder - off
copy data/downloads files
import JD Data/SQL - JD 1.8.2 (wiederherstellen)
-> All ok
"Data Update"uninstall JD 1.9.2.11_beta (j3.3.6) (without del SQL & files data)
install JD 3.2.16_beta (j3.3.6)
Error:1054 Unknown column 'language' in 'field list' SQL=INSERT INTO kto6d_jdownloads_templates (template_name, template_typ, template_text, template_header_text, template_subheader_text, template_footer_text, template_active, locked, language) VALUES ('Standard Kategorien Layout v2.5', 1, '{cat_title_begin}<div> ....... .... ....{back_link}</div>', 1, 1, '*')
What i found with myphpadmin:In the Table "kto6d_jdownloads_templates" the column "language" is missing I have "jlanguage"
I rename this and try it again, come the next error ... "1054 Unknown column 'template_before_text' in 'field list'" there is no column "template_before_text" in my old SQL data ... and so on.
The "JD 3.2.16_beta (j3.3.6)" installation don't want create the new columns ?
Is this my fault or from JDownloads?
Hi,
ich vermute das im zweiten Schritt von 1.9.2 auf 3.2 etwas schiefgelaufen ist. hast du noch den Zustand nach dem ersten nupdate irgendwo gepeichert? Dann könnte ich das hier mal testen.
Hallo,
thx für die Antwort.
Nun ich habe es 3 mal probiert (immer alles gelöscht) ... immer das gleiche.
Mit Zustand meinst du...
den Export von JD 1.9.2 mit 1.8.2 data ?
Oder den SQL export von 1.9.2 mit 1.8.2 data ?
Ich werde nun noch mal von ganz vorne probieren.
EDIT: Ich habe nun mal Testweise ein migration nur mit den Beispieldaten von einer neuen JD 1.9.2 Installation zu JD 3.2.16 gemacht, dass hat problemlos funktioniert.
Ich glaube er stößt sich an der importierten JD 1.8.2 Daten.
Ps: das komische ist auch das das JD 1.9.2 sich nach dem Import von JD 1.8.2 Data auch dann als JD 1.8.2 ausgegeben hat(in der Versions info im Webinf.).
QuotePs: das komische ist auch das das JD 1.9.2 sich nach dem Import von JD 1.8.2 Data auch dann als JD 1.8.2 ausgegeben hat(in der Versions info im Webinf.).
Das könnte lediglich ein kleiner bug sein, da ja die kompletten Daten übernommen werden (auch die Versionsnummer aus der DB).
Wie groß ist deine DB? Könnte ich das hier testen?
QuoteMit Zustand meinst du...
den Export von JD 1.9.2 mit 1.8.2 data ?
Oder den SQL export von 1.9.2 mit 1.8.2 data ?
Ich meinte ein backup von der DB nach update auf 1.9.2
ja ist vermutlich nur ein Anzeigebug mit der Version.
Hat überhaupt schon mal wer die migration nach der Beschreibung von JD 1.8.2 -> JD 1.9.2 -> JD 3.2.x geschafft?
Habe leider keine blanko JD 1.8.2 daten.
Was ich mit der "_jdownloads_templates" in MyPHPAdmin die SQL DB verglichen habe:
JD 1.9.2 (inkl. JD 1.8.2 data)
--------------------------------
kto6d_jdownloads_templates
Spalte Typ Null Standard Kommentare MIME
id int(11) Nein
template_name varchar(64) Nein
template_typ tinyint(2) Nein 0
template_header_text longtext Nein
template_subheader_text longtext Nein
template_footer_text longtext Nein
template_text longtext Nein
template_active tinyint(1) Nein 0
locked tinyint(1) Nein 0
note tinytext Nein
cols tinyint(1) Nein 1
checkbox_off tinyint(1) Nein 0
symbol_off tinyint(1) Nein 0
jlanguage varchar(7) Nein
checked_out int(11) Nein 0
checked_out_time datetime Nein 0000-00-00 00:00:00
JD 1.9.2 (blank)
--------------------------------
kto6d_jdownloads_templates
Spalte Typ Null Standard Kommentare MIME
id int(11) Nein
template_name varchar(64) Nein
template_typ tinyint(2) Nein 0
template_header_text longtext Nein
template_subheader_text longtext Nein
template_footer_text longtext Nein
template_text longtext Nein
template_active tinyint(1) Nein 0
locked tinyint(1) Nein 0
note tinytext Nein
cols tinyint(1) Nein 1
checkbox_off tinyint(1) Nein 0
symbol_off tinyint(1) Nein 0
jlanguage varchar(7) Nein
checked_out int(11) Nein 0
checked_out_time datetime Nein 0000-00-00 00:00:00
JD 3.2.16 (inkl. JD 1.8.2 data)
--------------------------------
kto6d_jdownloads_templates
Spalte Typ Null Standard Kommentare MIME
id int(11) Nein
template_name varchar(64) Nein
template_typ tinyint(2) Nein 0
template_header_text longtext Nein
template_subheader_text longtext Nein
template_footer_text longtext Nein
template_text longtext Nein
template_active tinyint(1) Nein 0
locked tinyint(1) Nein 0
note tinytext Nein
cols tinyint(1) Nein 1
checkbox_off tinyint(1) Nein 0
symbol_off tinyint(1) Nein 0
jlanguage varchar(7) Nein
checked_out int(11) Nein 0
checked_out_time datetime Nein 0000-00-00 00:00:00
JD 3.2.16 (blank)
--------------------------------
kto6d_jdownloads_templates
Spalte Typ Null Standard Kommentare MIME
id int(11) Nein
template_name varchar(64) Nein
template_typ tinyint(2) Nein 0
template_header_text longtext Nein
template_subheader_text longtext Nein
template_footer_text longtext Nein
template_before_text text Nein
template_text longtext Nein
template_after_text text Nein
template_active tinyint(1) Nein 0
locked tinyint(1) Nein 0
note text Nein
cols tinyint(1) Nein 1
checkbox_off tinyint(1) Nein 0
use_to_view_subcats tinyint(1) Nein 0
symbol_off tinyint(1) Nein 0
language char(7) Nein *
checked_out int(11) Nein 0
checked_out_time datetime Nein 0000-00-00 00:00:00
Ich habe auch mal brutal probiert, einfach nach dem import der jd 1.8.2 data im jd 1.9.2 in der live SQL DB die Tabelle "kto6d_jdownloads_templates" zu leeren oder auch die komplette tabelle zu löschen und dann auf JD 3.2.16 upzudaten.
Dann ging die Installation fertig, ABER er wirft dann andauernt wo anders Fehler aus:
Übersicht (ganz verschobenes Layout):
1054 Unknown column 'password_md5' in 'field list' SQL=INSERT INTO `kto6d_jdownloads_files` (`file_id`,`file_title`,`file_alias`,`description`,`file_pic`,`language`,`size`,`date_added`,`url_download`,`cat_id`,`metakey`,`metadesc`,`ordering`,`published`,`password_md5`,`access`) VALUES ('0','mod_jdownloads_top_1.5','mod-jdownloads-top-1-5','','zip.png','*','11.95 KB','2014-11-20 16:05:11','mod_jdownloads_top_1.5.zip','3','','','422','0','','1')
Downloads:
Fehler
Unknown column 'a.other_file_id' in 'on clause' SQL=SELECT COUNT(*) FROM `kto6d_jdownloads_files` AS a LEFT JOIN kto6d_users AS uc ON uc.id=a.checked_out LEFT JOIN `kto6d_jdownloads_files` AS f ON f.file_id = a.other_file_id LEFT JOIN `kto6d_languages` AS l ON l.lang_code = a.language LEFT JOIN kto6d_viewlevels AS ag ON ag.id = a.access LEFT JOIN kto6d_jdownloads_categories AS c ON c.id = a.cat_id LEFT JOIN kto6d_jdownloads_categories AS cc ON cc.id = c.parent_id WHERE (a.published = 0 OR a.published = 1) 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 `kto6d_jdownloads_files` AS a LEFT JOIN kto6d_users AS uc ON uc.id=a.checked_out LEFT JOIN `kto6d_jdownloads_files` AS f ON f.file_id = a.other_file_id LEFT JOIN `kto6d_languages` AS l ON l.lang_code = a.language LEFT JOIN kto6d_viewlevels AS ag ON ag.id = a.access LEFT JOIN kto6d_jdownloads_categories AS c ON c.id = a.cat_id LEFT JOIN kto6d_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 'on clause' SQL=SELECT COUNT(*) FROM `kto6d_jdownloads_files` AS a LEFT JOIN kto6d_users AS uc ON uc.id=a.checked_out LEFT JOIN `kto6d_jdownloads_files` AS f ON f.file_id = a.other_file_id LEFT JOIN `kto6d_languages` AS l ON l.lang_code = a.language LEFT JOIN kto6d_viewlevels AS ag ON ag.id = a.access LEFT JOIN kto6d_jdownloads_categories AS c ON c.id = a.cat_id LEFT JOIN kto6d_jdownloads_categories AS cc ON cc.id = c.parent_id WHERE (a.published = 0 OR a.published = 1)
Ist das ein language / sprachen problem?
Und nein die DB ist nicht so groß, ich habe es passwort geschützt gezippt und dir per PM den Link zum Downloaden inkl Kennwort zugeschickt.
Bitte nicht öffentlich machen ;-)
Ich habe zwar ganz Joomla 1.5 und JD 1.8.2 modifiziert, aber denken nicht so weit das es Fehler geben dürfte.
Aber wie gesagt habe leider keine blanko Joomla 1.5 inkl JD 1.8.2. aber vielleicht probier/installier ich das noch.
Danke für deine Hilfe !!!! :)
Danke für die Daten, werden natürlich nach test sofort gelöscht.
Komme aber heute nicht mehr dazu. Im Moment weiß ich echt nicht was ich zuerst machen soll, meine Liste ist doch etwas lang geworden. :(
QuoteHat überhaupt schon mal wer die migration nach der Beschreibung von JD 1.8.2 -> JD 1.9.2 -> JD 3.2.x geschafft?
Keine Ahnung, eventuell hat Colin das aber getestet für die Dokumentation.
Danke dir, für dein Test Vorhaben.
Es hat mir nun aber keine Ruhe gelassen und ich habe mir J 1.5.26 & JD 1.8.4 auf einem xampp 1.7.3 Testweise mit den Original Beispieldaten installiert.
Und einen export /txt von JD 1.8.4 original mit Beispieldaten ohne etwas zu verändern.
Ich habe einmal abgeändert für meine DB und Original angehängt.
Und es kommt bei einer nagelneuen Installation nach den Schritten laut Doku zu genau den gleichen Fehler!
Also sind es nicht meine Daten / DB die falsch oder Fehlerhaft wären.
Die JD 3.2.16 Installation stoppt wieder mit der Meldung:
Es ist ein Fehler aufgetreten!
1054 Unknown column 'language' in 'field list' SQL=INSERT INTO kto6d_jdownloads_templates (template_name, template_typ, template_text, template_header_text, template_subheader_text, template_footer_text, template_active, locked, language) VALUES ('Standard Kategorien Layout v2.5', 1, '{cat_title_begin}<div style="background-color:#EFEFEF; padding:6px;">{subcats_title_text}</div>{cat_title_end} {cat_info_begin} <table width="100%" style="border-bottom: 1px solid #cccccc;"> <tr valign="top" border="0px"> <td width="65%" style="padding:5px;">{cat_pic}<b>{cat_title}</b></td> <td width="20%" style="padding:5px; text-align:right">{sum_subcats}</td> <td width="15%" style="padding:5px; text-align:right">{sum_files_cat}</td> </tr> <tr valign="top" border="0px"> <td colspan="3" width="100%" style="padding:5px;">{cat_description}</td> </tr> </table> {cat_info_end}', '<table class="jd_top_navi" width="100%" style="border-bottom: 1px solid #cccccc;"> <tr valign="top" border="0px"> <td style="padding:5px;">{home_link}</td> <td style="padding:5px;">{search_link}</td> <td style="padding:5px;">{upload_link}</td> <td style="padding:5px;" align="right" valign="bottom">{category_listbox}</td> </tr> </table>', '<table class="jd_cat_subheader" width="100%"> <tr> <td width="45%" valign="top"> <b>{subheader_title}</b> </td> <td width="55%" valign="top" colspan="2"> <div class="jd_page_nav" style="text-align:right">{page_navigation_pages_counter} {page_navigation}</div> </td> </tr> <tr> <td width="45%" valign="top" align="left">{count_of_sub_categories}</td> <td width="55%" valign="top" colspan="2"></td> </tr> </table>', '<table class="jd_footer" align="right" width="100%"> <tr> <td width="70%" valign="top"></td> <td width="30%" valign="top"> <div class="jd_page_nav" style="text-align:right">{page_navigation}</div> </td> </tr> </table> <div style="text-align:left" class="back_button">{back_link}</div>', 1, 1, '*')
Zurück zum Kontrollzentrum
Also der Beschrieben Weg in den beiden Dokus geht so nicht.
Oder ich habe einen Schritt übersehen? Denke aber nicht.
In der Doku http://www.jdownloads.net/documentations/item/how-to-move-jdownloads-1-8-x-from-joomla-1-5-to-joomla-2-5
wird aber von Joomla 2.5 gesprochen. Denke aber nicht das das bei den Fehler relevant ist - ob j2.5 oder j3.3.6 - oder?
[gelöscht durch Administrator]
QuoteIn der Doku http://www.jdownloads.net/documentations/item/how-to-move-jdownloads-1-8-x-from-joomla-1-5-to-joomla-2-5
wird aber von Joomla 2.5 gesprochen. Denke aber nicht das das bei den Fehler relevant ist - ob j2.5 oder j3.3.6 - oder?
Eventuell ist dies doch ein Problem. Ich kann mich leider nicht mehr erinnern, ob ich auch das damals noch einmal getestet habe, oder einfach davon ausgegangen war, dass dies so auch mit 3.x gehen sollte. :-\
Aber ich sehe schon das ich das alles noch einmal durchspielen muss... wenn mein Tag bloß 48 Stunden hätte... ::)
Wann (möglichst genau) erscheint der Fehler? Ich meine jetzt im beschriebenem Ablauf in der Doku.
Na da-renn dich nicht wegen mir ;)
Wie schon per PM geschrieben:
"Also es scheint als ob der import -im JD 1.9.2 - von den JD 1.8.2 (oder auch JD 1.8.4) Daten, etwas an der DB verändert was dem installation script von JD 3.2.16 nicht gefällt."
Der Fehler ( 1054 Unknown column 'language' in 'field list ....) kommt:
Hier die Struktur der DB nach gescheiterten Update von JD 1.9.2 (inkl JD 1.8.2 data) to JD 3.2.16:
kto6d_jdownloads_categories 1 InnoDB 96 KiB
Erstellt am: 21. Nov 2014 um 10:40
kto6d_jdownloads_cats 4 MyISAM 2.6 KiB
Erstellt am: 21. Nov 2014 um 10:40
Zuletzt aktualisiert: 21. Nov 2014 um 10:40
kto6d_jdownloads_config 459 MyISAM 51.7 KiB
Erstellt am: 21. Nov 2014 um 10:40
Zuletzt aktualisiert: 21. Nov 2014 um 10:40
kto6d_jdownloads_files 2 MyISAM 2.6 KiB
Erstellt am: 21. Nov 2014 um 10:40
Zuletzt aktualisiert: 21. Nov 2014 um 10:40
kto6d_jdownloads_groups 0 MyISAM 1 KiB
Erstellt am: 21. Nov 2014 um 10:40
Zuletzt aktualisiert: 21. Nov 2014 um 10:40
kto6d_jdownloads_license 7 MyISAM 2.5 KiB
Erstellt am: 21. Nov 2014 um 10:40
Zuletzt aktualisiert: 21. Nov 2014 um 10:40
kto6d_jdownloads_licenses 0 InnoDB 48 KiB
Erstellt am: 21. Nov 2014 um 10:40
kto6d_jdownloads_log 0 MyISAM 1 KiB
Erstellt am: 21. Nov 2014 um 10:40
Zuletzt aktualisiert: 21. Nov 2014 um 10:40
kto6d_jdownloads_logs 0 InnoDB 48 KiB
Erstellt am: 21. Nov 2014 um 10:40
kto6d_jdownloads_rating 0 MyISAM 1 KiB
Erstellt am: 21. Nov 2014 um 10:40
Zuletzt aktualisiert: 21. Nov 2014 um 10:40
kto6d_jdownloads_ratings 0 InnoDB 16 KiB
Erstellt am: 21. Nov 2014 um 10:40
kto6d_jdownloads_templates 9 MyISAM 25.7 KiB
Erstellt am: 21. Nov 2014 um 10:40
Zuletzt aktualisiert: 21. Nov 2014 um 10:40
kto6d_jdownloads_usergroups_limits 0 InnoDB 32 KiB
Erstellt am: 21. Nov 2014 um 10:40
Er scheint sich genau ab table "kto6d_jdownloads_templates" zu stoppen.
Vielleicht ist es auch der Spalten Unterschied von "jlanguage" in JD 1.9.2 zu "language" im JD 3.2.16 ?
Der Fehelr passiert ab den Dick makierten in der Quote:
Quote
How to move jDownloads 1.8.x from Joomla 1.5 to Joomla 2.5?
If you wish to move your jDownloads 1.8.x download area from Joomla 1.5 to Joomla 2.5, here is a short note on how to do this. Please note that to go to the jDownloads 2.5 or 3.2 series it is first necessary to convert to the 1.9.x series for Joomla 2.5 or Joomla 3.2 as appropriate
Old Joomla 1.5.x website
Make sure that you has installed the newest jDownloads 1.8.2 release on your old website
Reduce your stored jDownloads logs data. You can do this manually or set a lower value (1) in the identical option from the jDownloads system plugin
Now Create a backup file with the 'Backup function' from jDownloads in the control panel
Do not Delete your old Joomla installation until your new Joomla installation works perfectly with jDownloads
New Joomla 2.5.x website
Install the newest jDownloads 1.9.x release (minimum build 925)
Deactivate the auto monitoring function in the jDownloads configuration
Delete the jDownloads upload root folder (/jdownloads) on the Joomla 2.5 site with your FTP program
Copy with your FTP program the jDownloads upload root folder from the old website to the new website
Make sure that you have it copied in the same position (JoomlaROOT/jdownloads) - if you you used a different folder name from jdownloads, you must also use it here
Copy with your FTP program the jDownloads image folders (JoomlaROOT/images/jdownloads) with all sub folders to the new website in the same position
Check now with phpMyAdmin the used database table prefix and compare it with the table prefix in your backup file. To do this, you must open the backup file and search on the top a line like this:
$database->setQuery("TRUNCATE TABLE `jos_jdownloads_config`") ;$database->query(); (In this sample is: 'jos_' the used prefix)
When you use in your new Joomla Installation a other table prefix, you must replace in your backup file the wrong prefix with the new used. You can use for this a free editor with a good 'Replace' function (as example Notepad++). But make this carefully and create before you do this, a copy from your backup file. See also Backup and Restore Data in this dokumentation.
When you has compared (and changed when required) the table prefix, go to the Backup restore page in the jDownloads control panel and select the above created backup file for restoration
Check the restore result message - when it was not possible to restore it successful, you can not goes to the next step! The succesful restoration from the backup file is very important. Otherwise works jDownloads not correctly. So you must find first a solution for this. To check it more, you can activate the debug option in the Joomla configuration. It is also useful to set higher the error reporting level (TAB: Server). Sometimes (very rare) is only viewed a blank page, please use then the support forum.
When you see at the end from the restoration process a 'successful' message, you can does now the rest steps:
When you has changed the jDownloads .css file, copy also this file from components\com_jdownloads to the new website
When you has created own jDownloads user groups, you must check (correct or delete) this in your new website
Check also the format for the: Date-Time format field in the configuration. This format has changed from php strftime() format to date().
Note: You can not use modules or plugins from the jDownloads version for Joomla 1.5. Use only the new published for Joomla 1.7/2.5. The same for translations.
Hm... okay. Vermutlich ist die Backup 'Restore' Funktion von jD 1.9.2 unterschiedlich zu der in jD 1.9.2 (da ja auch für unterschiedliche Joomla Versionen).
Ich denke das hier das Problem liegt.
Eventuell müsste es aber dann klappen, wenn du wie beschrieben zuerst zur Joomla 2.5 wechselst. Aber umständlich und viel arbeit... :-\
Ich muss jetzt leider erst einmal für ein paar Stunden weg.
So habe nun folgendes getestet:
(install) Testumgebung: Xampp 1.7.3 (PHP/5.3.1):
------------------------------------------------
------------------------------------------------
- install / on Joomla 1.5.26 (inkl. Original Beispieldaten) -> OK
------------------------------------------------------------
- install Jdownloads 1.8.4 for JD1.5 -> OK
- export Jdownloads 1.8.4 Original Beispieldata -> OK
(install) Testumgebung: Xampp 3.2.1 (PHP/5.5.9):
------------------------------------------------
------------------------------------------------
- install / on Joomla 2.5.27 (inkl. Original Beispieldaten) -> OK
-----------------------------------------------------------------
- install Jdownloads 1.9.1.6 for JD2.5 -> OK
- edit Jdownloads 1.5.26 for JD1.5 data (inkl. JD 1.8.4 Original Beispieldata) : tabellennamen -> OK
- import (Restore Backup) JD 1.8.4 Original Beispieldata -> OK
- export Jdownloads 1.9.1.6 (inkl. JD 1.8.4 Original Beispieldata) -> OK
- install / on Joomla 3.3.6 -> OK
---------------------------------
- install Jdownloads 1.9.2.11 for J 3.2 -> OK
- edit Jdownloads 1.9.1.6 for JD2.5 data (inkl. JD 1.8.4 Original Beispieldata) : tabellennamen -> OK
- import Jdownloads 1.9.1.6 for JD2.5 data (inkl. JD 1.8.4 Original Beispieldata) in JD 1.9.2.11 for J 3.2 -> OK
- deinstall Jdownloads 1.9.2.11 (without del data & DB) -> OK
- install Jdownloads 3.2.16 -> OK !!! (hier kommt sonst ohne J2.5 der Fehler)
- JD 3.2.16 Berechtigungen setzen -> OK
- Meldung: ".... ältere Version von jDownloads gefunden." -> "Import Jetzt Starten" -> OK
---> Es geht alles -> Kein Fehler.
Nur leider das gleiche mit "meinen Daten" 2 mal probiert und ich bekomme den alten Fehler an gleicher Stelle..... sehr komisch:
1054 Unknown column 'language' in 'field list' SQL=INSERT INTO kto6d_jdownloads_templates (template_name, template_typ, template_text, template_header_text, template_subheader_text, template_footer_text, template_active, locked, language) VALUES ('Standard Kategorien Layout v2.5', 1, '{cat_title_begin}<div style="background-color:#EFEFEF; padding:6px;">{subcats_title_text}</div>{cat_title_end} {cat_info_begin} <table width="100%" style="border-bottom: 1px solid #cccccc;"> <tr valign="top" border="0px"> <td width="65%" style="padding:5px;">{cat_pic}<b>{cat_title}</b></td> <td width="20%" style="padding:5px; text-align:right">{sum_subcats}</td> <td width="15%" style="padding:5px; text-align:right">{sum_files_cat}</td> </tr> <tr valign="top" border="0px"> <td colspan="3" width="100%" style="padding:5px;">{cat_description}</td> </tr> </table> {cat_info_end}', '<table class="jd_top_navi" width="100%" style="border-bottom: 1px solid #cccccc;"> <tr valign="top" border="0px"> <td style="padding:5px;">{home_link}</td> <td style="padding:5px;">{search_link}</td> <td style="padding:5px;">{upload_link}</td> <td style="padding:5px;" align="right" valign="bottom">{category_listbox}</td> </tr> </table>', '<table class="jd_cat_subheader" width="100%"> <tr> <td width="45%" valign="top"> <b>{subheader_title}</b> </td> <td width="55%" valign="top" colspan="2"> <div class="jd_page_nav" style="text-align:right">{page_navigation_pages_counter} {page_navigation}</div> </td> </tr> <tr> <td width="45%" valign="top" align="left">{count_of_sub_categories}</td> <td width="55%" valign="top" colspan="2"></td> </tr> </table>', '<table class="jd_footer" align="right" width="100%"> <tr> <td width="70%" valign="top"></td> <td width="30%" valign="top"> <div class="jd_page_nav" style="text-align:right">{page_navigation}</div> </td> </tr> </table> <div style="text-align:left" class="back_button">{back_link}</div>', 1, 1, '*')
Langsam wird es Mühselig ;)
Hab keine Ahnung was an meinen daten so anders sein sollte...
Edit: Hab nun auch Probiert den
$database->setQuery("INSERT INTO kto6d_jdownloads_templates ( `id`,`template_name`,`template_typ`,`template_header_text`,`template_subheader_text`,`template_footer_text`,`template_text`,`template_active`,`locked`,`note`,`cols`,`checkbox_off`,`symbol_off`,`jlanguage`,`checked_out`,`checked_out_time` ) VALUES .....
Block von den blank data import mit dem von mein daten import zu ersetzen.. hat leider nicht gebracht ... gleicher Fehler.
Da hat es was anderes,.. nur leider geht meine PHP / SQL Kenntnis und JDownload code Kenntnis zu wenig weit. :(
Hi
If it is any help I have updated the old note on moving from 1.8 series to 1.9 series
http://www.jdownloads.net/documentations/item/updated-from-jdownloads-1-8-x-on-joomla-1-5-to-jd-1-9-series-on-joomla-2-5-or-3-x
Colin
@ Nyx:
Quote
- JD 3.2.16 Berechtigungen setzen -> OK
- Meldung: ".... ältere Version von jDownloads gefunden." -> "Import Jetzt Starten" -> OK
---> Es geht alles -> Kein Fehler.
Nur leider das gleiche mit "meinen Daten" 2 mal probiert und ich bekomme den alten Fehler an gleicher Stelle..... sehr komisch:
Ich habe dich noch gar nicht gefragt WANN/WIE überhaupt genau die Fehlermeldung kommt.
Im übrigen warte bitte, bis ich die Zeit hatte dass hier selber durchzuspielen. Ich werde den Fehler schon noch finden, hab hier schließlich mehr Möglichkeiten. Musst halt nur ein wenig Geduld haben.
Colin würde dir sicherlich auch gerne helfen, aber er versteht noch nicht so gut deutsch.
@Colin:
thanks. ;)
Nun der Fehler kommt genau bei der Installation von JD 3.2.16. wo aber die Daten und DB von JD 1.9.2 inkl. JD 1.8.3 Daten / DB bestehen bleiben..
Und ich habe eh Geduld. Ich bin nur so dahinter, weil mich die Fehlerursache interessiert. Bzw. Keine Ruhe lässt. Ich warte eh, ich will sich nicht stressen. ;)
Die Beschreibung kannte ich noch gar nicht! Die ist viel ausführlicher.
http://www.jdownloads.net/documentations/item/updated-from-jdownloads-1-8-x-on-joomla-1-5-to-jd-1-9-series-on-joomla-2-5-or-3-x
- thanks Colin ! - maybe the language is the point / error - i did't deinstall german.
Da gibt es glaub ich einen wichtigen Punkt, der in der andren Beschreibung nicht erwähnt wird und zu meinen Problem passen könnte.
Quote
There is an indication from some people that there may be problems with the language files from step to step. So the advice is top remove/uninstall all languages other than English.
.........
5. Different Language files are needed for the jD 2.5 and jD 3.2 series. So to avoid any complications Uninstall all languages except English.
Ich habe nämlich keine sprachen deinstalliert.
Vielleicht ist so eh mein Fehler.
Ich werde das noch bald testen.
so,
nun habe ich einen Joomla 1.5 1:1 clone auf Local Xampp laufen gehabt, dort alle plugins/module deinstalliert alle sprachen auf EN umgestellt und DE deinstalliert.
Dann erst den Export gemacht.
Und im Joomla 3.x ist ebenso alles auf EN.
Genau an die Anleitung gehalten.
Leider genau an der gleichen Stelle, der gleiche Fehler wie vorher.
Hm... denke nicht das es mit der Sprache zu tun hat. Die Tabelle in der DB ist einfach falsch aufgebaut.
Eventuell müsste man die mal manuell vor dem Importstart korrigieren... ?
Ich muss dich aber um Geduld bitten, habe heute noch mit dem content plugin zu tun und kann frühestens morgen das mit der db überprüfen. :-\
Möglich, da hast wohl du den bessern Überblick ;-)
Es war nur ein Punkt, der in dem anderem TUT so nicht vorgekommen ist, darum hab ichs ausprobiert.
Bezüglich Spalten umbenennen, habe ich ja mal in der Tabelle "kto6d_jdownloads_templates" gemacht oder sogar die ganze Tabelle vor dem data Update fü JD 3.x gelöscht.
Dann hängt er sich zwar an der Stelle mit dem nimmer auf und installiert fertig.
Nur dann kommen bei der Navigation im Admin Interface dann mehre Tabellen error,.. wie zb. in der kto6d_jdownloads_files Tabelle usw.
Wobei ich da sicher zu laienhaft ran gegangen bin.
Du wirst sicher mehr ausfinden, danke dir dafür, dann warte ich mal ;-)
Thx für deine Mühen, noch Mal.
EDIT: Hab auch auf J15 von JD 1.8.2 to JD 1.8.4 geupdatet, hat auch nix geändert.
Eins noch ohne dir vorgreifen zu wollen:
Zusammenfassend der Fehler:
1054 Unknown column 'language' in 'field list' SQL=INSERT INTO kto6d_jdownloads_templates (template_name, ......
Stimmt ja, die Spalte language gibt es ja nicht und andere die die bei JD 3.x vorhanden sind auch nicht.
Nur komisch, dass er es über j1.5 -> j2.5 -> j3.x dann auch ohne diese von JD1.8 -> JD1.9 -> 3.X schafft.
Bzw. selbst anlegen kann.
Ich glaub ja das der Daten import von jd1.8 (joomla 1.5) -> jd1.9 (jommla 3.x oder Joomla 2.5) die Tabellen / Spalten von 1.9 zerschießt oder was falsches reinschreibt.
Und darum geht es dann von jd1.9 -> 3.x nimmer weiter.
Ich habe Heute auch noch folgendes probiert:
Man benötigt:
Einen JD 1.9 (Blanko / frische JD DB export - von Joomla 3.x)
Einen JD 1.8 eigene DATA (von joomla 1.5)
JD 1.9 auf Joomla 3.x installiert.
Nun habe ich von JD 1.9 export alle Einträge von
$database->setQuery("INSERT INTO jos_jdownloads_cats
$database->setQuery("INSERT INTO jos_jdownloads_files
$database->setQuery("INSERT INTO jos_jdownloads_rating
gelöscht und mit denen von JD 1.8 export ersetzt.
Dies in JD 1.9 importiert -> OK
Nun JD 1.9 deinstalliert.
In SQL DB:
die Tabelle SQL _jdownloads_templates gelöscht.
in der Tabelle _jdownloads_fiels folgende Spalten erstellt:
other_file_id
notes
language
access
password_md5
Dann JD 3.x installiert....
Und es geht.
Er erkentn eine alte JD DB, bietet mir die migration an.
Und führt diese auch richtig (?) durch.
Es kommen auch keine großartige Fehler außer im Frontend:
Notice: Undefined property: JObject::$list in ....\xampp\htdocs\components\com_jdownloads\views\categories\tmpl\default.php on line 151
Notice: Use of undefined constant ordering - assumed 'ordering' in ......\xampp\htdocs\components\com_jdownloads\views\categories\tmpl\default.php on line 151
Es geht alles sonst im Backend und Fronted außer ist leider das Rating durcheinander gekommen.
Das stimmt nicht richtig überein. Ist jeweils den falschen Files zugeordnet.
Nur ist das ganze nun so und so etwas sehr russisch und vermutlich ist das keine Saubere Migration wo dann mit der Zeit wo Fehler auftauchen.
Und das Rating wäre mir wichtig,...
So nun warte ich aber auf deine Ergebnisse.
Hi
Trying to learn from your experiences so I can improve the documentation. Because of my poor German I have used Google translate, which is not very good but better than me!
My understanding is that you carried out the following steps. Would appreciate your comments and any corrections please.
- You exported all the jD databse entries from the jD1.8.4 series
- Also saved a copy of the /jDownloads folder and its sub directories and files in the 1.8.4 version
- And similarly for the /images/jDownloads directory
- After uninstalling jD1.8.4 you installed jD1.9.2.11 (or perhaps on a different Joomla installation)
- overwrote/deleted the jD tables in the 1.9.2.11 jos_jdownloads_cats, jos_jdownloads_files and jos_jdownloads_rating with the corresponding 1.8.1.4 tables.
- Deleted table jos_jdownloads_templates
- Added extra columns to table jos_jdownloads_files, specifically other_file_id, notes, language, access and password_md5
- At this stage the backend on jD1.9.2.11 appeared to work OK. Obviously the frontend would not work as that needs the templates (layouts)
- Next you saved all the jD1.9.2.11 database tables, and the /jdownloads data etc
- Then you installed jD3.2.16 , overwrote the database tables with the ones saved from jD1.9.2.11, reload data into /jdownloads.
Result was a working system but the ratings on downloads were confused.
This last is possibly because files are referenced in the ratings by id and when the files were reloaded then different ids were allocated as the files would have been accessed in a different order. I have not tried upgrading a system with rating tables so this might be a more general problem.
Why did you delete the Template files?
How did you set the entries in the other_file_id, notes, language, access and password_md5 columns?
Thanks
Colin
Edit: Was auto-monitoring on when you loaded the datafiles. If yes could you please test again with auto monitoring off.
Hi,
thanks for your reply.
i do:
You exported all the jD databse entries from the jD1.8.4 series
YES
Also saved a copy of the /jDownloads folder and its sub directories and files in the 1.8.4 version
YES
And similarly for the /images/jDownloads directory
YES
After uninstalling jD1.8.4 you installed jD1.9.2.11 (or perhaps on a different Joomla installation)
YES - in this case i install a new jd 1.9.2 on Joomla 3
overwrote/deleted the jD tables in the 1.9.2.11 jos_jdownloads_cats, jos_jdownloads_files and jos_jdownloads_rating with the corresponding 1.8.1.4 tables.
YES /NO - I overwrote the jD tables jos_jdownloads_cats, jos_jdownloads_files and jos_jdownloads_rating 1.9.2 with the from 1.8.1,4 in the EXPORT txt File from JD.
Deleted table jos_jdownloads_templates
YES - I do this with Myphpadmin in the SQL DB- But i think JD 3.2.16 will install his own new one. But this was may be false.
Added extra columns to table jos_jdownloads_files, specifically other_file_id, notes, language, access and password_md5
YES - I do this, but in the cases before when I install JD 3.2 I get the errors with this missing colums.
I do this with Myphphadmin in the SQL DB from JD 1.9.2.
At this stage the backend on jD1.9.2.11 appeared to work OK. Obviously the frontend would not work as that needs the templates (layouts)
YES
Next you saved all the jD1.9.2.11 database tables, and the /jdownloads data etc
YES
Then you installed jD3.2.16 , overwrote the database tables with the ones saved from jD1.9.2.11, reload data into /jdownloads.
YES - And no - I only install JD 3.2.16
And yes so the system work without right rating and with template error.
I take auto-monitoring in JD 1.8.4 and JD 1.9.2 off.
I hope the rating migration will work.
I have 420 Downloads and when I correct this per Hand in the SQL DB, it will take a lot of time. and i have a long Downtime with my live migration.
Thanks for comments - I have put below what I think is the correct sequence, with a little explanation.
Again I would appreciate your comments and any corrections please.
The jD1.8.4 system was working on a Joomla! 1.5.x site.
Used the jD Backup Creation facility to export all the jD database entries from the jD1.8.4 series to local PC.
Also saved a copy of the /jDownloads folder and its sub directories and files in the 1.8.4 version.
And similarly for the /images/jDownloads directory.
Installed jD1.9.2.11 on a Joomla 3.x site.
Turned off auto monitoring in jD1.9.2.11
Used the Backup Restoration facility in jD1.9.2.11 to overwrite the jD tables in with the database tables exported from jD1.8.4,
specifically tables jos_jdownloads_cats, jos_jdownloads_files and jos_jdownloads_rating with the corresponding 1.8.1.4 tables.
Deleted table jos_jdownloads_templates using phpMyAdmin.
Because jD1.8.4 does not have columns other_file_id, notes, language, access and password_md5 in table 'jos_jdownloads_files' these columns were added with phpmyAdmin. It was not necessary to populate these columns, it was sufficient that they were present.
At this stage the backend on jD1.9.2.11 appeared to work OK. Obviously the frontend would not work as that needs the templates (layouts)
Used the Backup Creation in jD1.9.2.11 to get updated copy of the database tables.
Also saved again the /jDownloads directory and contents tree, and similarly /images/jdownloads content tree.
Then you installed jD3.2.16 , overwrote the database tables with the ones saved from jD1.9.2.11, reload data into /jdownloads.
Uninstalled jD1.9.2.11 and manually deleted jD database tables using phpMyAdmin.
Deleted directory trees /jdownloads and /images/jdownloads.
Installed jD3.2.16 with no data.
Turned off auto monitoring
Used Backup Restoration in Tools to load up database from the one saved from jD1.9.2.11
Replaced directory trees /jdownloads and /images/jdownloads from saved versions.
All done -Phew!!
I have modified the final part to be consistent with other documentation. It is also where I suspect the rating tables went wrong as file ids may have changed. Also I do not think a fresh version of jDownloads will install if tables are already in place - but maybe Arno has changed since I last tried
Colin
This was the way:
1.)
The jD1.8.4 (or jD 1.8.2) system was working on a Joomla! 1.5.x site.
1.1.)
Used the jD Backup Creation facility to export all the jD database entries from the jD1.8.4 series to local PC.
1.2.)
Also saved a copy of the /jDownloads folder and its sub directories and files in the 1.8.4 version.
And similarly for the /images/jDownloads directory.
2.)
Installed jD1.9.2.11 on a Joomla 3.x site.
2.1.)
Turned off auto monitoring in jD1.9.2.11
2.2.)
Used the Backup Restoration facility in jD 1.9.2.11 and make a Backup / EXPORT TXT from the new jD 1.9.2.11
3.)
I edit the jD 1.9.2.11 Backup / EXPORT TXT with:
3.1.)
To overwrite the jD tables in with the database tables exported from jD1.8.4
specifically tables jos_jdownloads_cats, jos_jdownloads_files and jos_jdownloads_rating with the corresponding 1.8.1.4 tables.
3.2.)
Search in the jD 1.9.2.11 TXT for the jos_jdownloads_config / In this example: 'jos_' is the prefix and rename "jos_" in my case to "kto6d_".
4.)
Import the "edited jD 1.9.2.11 with jD 1.8.4 data (TXT)" in jD 1.9.2.11 with the jD Restore (Wiederherstellen) funktion.
5.)
copy the /jDownloads folder and its sub directories and files of the 1.8.4 version.
And similarly for the /images/jDownloads directory.
Over the Folders (Del the 1.9.2.11 folders first).
6.)
Test HP / JD all ok
7.)
Uninstalled jD1.9.2.11 with joomla 3.
8.)
Deleted table jos_jdownloads_templates using phpMyAdmin.
This is may be false ;-)
I will create the missing culumns (?) with phpMyAdmin in the table "__jdownloads_files" next time.
8.1.)
Because jD1.8.4 does not have columns other_file_id, notes, language, access and password_md5 in table 'jos_jdownloads_files' these columns were added with phpmyAdmin. It was not necessary to populate these columns, it was sufficient that they were present.
9.)
Then installed jD3.2.16 -> OK
9.1)
jD 3.2.16 found "a old jD installation" i use the jD Migration assistant in the Webinterface. -> OK
9.2)
Turned off auto monitoring
9.3.)
All done -Phew!!
9.4.)
But the rating is wrong -> may be false files ids.
9.5)
The Frontend work fine - but in the top a PHP errors with templates
e.g. "Notice: Undefined property: JObject::$list in ....\xampp\htdocs\components\com_jdownloads\views\categories\tmpl\default.php on line 151"
but may be, if I change this (make templates columns) in the future i have no php error.
there is already a solution for this?
What i don't understand:
Why a migration with a new JD 1.9.2 to JD 3.2 will work with out problems.
I check the Database from a live JD 1.9.2, there also no colums e.g. other_file_id, notes in the table __jdownloads_files.
The same way with JD 1.9.2 "with JD 1.8.4 data" is a Problem by the migration to JD 3.2 with the missing colums e.g. other_file_id, notes in the table __jdownloads_files.
so... i try it aign WITH Templ.
-> The same Frontend error.
Quote
1.)
The jD1.8.4 (or jD 1.8.2) system was working on a Joomla! 1.5.x site.
1.1.)
Used the jD Backup Creation facility to export all the jD database entries from the jD1.8.4 series to local PC.
1.2.)
Also saved a copy of the /jDownloads folder and its sub directories and files in the 1.8.4 version.
And similarly for the /images/jDownloads directory.
2.)
Installed jD1.9.2.11 on a Joomla 3.x site.
2.1.)
Turned off auto monitoring in jD1.9.2.11
2.2.)
Used the Backup Restoration facility in jD 1.9.2.11 and make a Backup / EXPORT TXT from the new jD 1.9.2.11
3.)
I edit the jD 1.9.2.11 Backup / EXPORT TXT with:
3.1.)
To overwrite the jD tables in with the database tables exported from jD1.8.4
specifically tables jos_jdownloads_cats, jos_jdownloads_files and jos_jdownloads_rating with the corresponding 1.8.1.4 tables.
3.2.)
Search in the jD 1.9.2.11 TXT for the jos_jdownloads_config / In this example: 'jos_' is the prefix and rename "jos_" in my case to "kto6d_".
4.)
copy the /jDownloads folder and its sub directories and files of the 1.8.4 version.
And similarly for the /images/jDownloads directory.
Over the Folders (Del the 1.9.2.11 folders first).
5.)
Import the "edited jD 1.9.2.11 with jD 1.8.4 data (TXT)" in jD 1.9.2.11 with the jD Restore (Wiederherstellen) funktion.
6.)
Test HP / JD all ok
7.)
Uninstalled jD1.9.2.11 with joomla 3.
8.)
create the missing colums with phpMyAdmin in the table "__jdownloads_templates" and "__jdownloads_files".
Because jD1.8.4 and 1.9.2 does not have columns:
kto6d_jdownloads_templates:
---------------------------
template_before_text
template_after_text
language
kto6d_jdownloads_files:
----------------------
other_file_id
notes
access
password_md5
It was not necessary to populate these columns, it was sufficient that they were present.
9.)
Then installed jD3.2.16 -> OK
9.1)
jD 3.2.16 found "a old jD installation" i use the jD Migration assistant in the Webinterface. -> OK
9.2.)
All done -Phew!!
9.3.)
But the rating is wrong -> may be false files ids.
9.4.)
The Frontend work fine (e.g.: the files data, Autor, email ,ok - also the download work) - but in the top a PHP errors:
In the "cats - Overview"(all cats):
Notice: Undefined property: JObject::$list in ...\htdocs\components\com_jdownloads\views\categories\tmpl\default.php on line 151
Notice: Use of undefined constant ordering - assumed 'ordering' in ...\htdocs\components\com_jdownloads\views\categories\tmpl\default.php on line 151
In the Single "cat - Overview":
Notice: Undefined variable: mail_encode in ...\htdocs\components\com_jdownloads\views\category\tmpl\default.php on line 1322
Notice: Undefined variable: mail_encode in ...\htdocs\components\com_jdownloads\views\category\tmpl\default.php on line 1322
Notice: Undefined variable: mail_encode in ...\htdocs\components\com_jdownloads\views\category\tmpl\default.php on line 1322
In the Single "file - Overview":
Notice: Undefined property: JObject::$list in ...\components\com_jdownloads\views\download\tmpl\default.php on line 193
Notice: Use of undefined constant ordering - assumed 'ordering' in ...\htdocs\components\com_jdownloads\views\download\tmpl\default.php on line 193
Hi Nyx,
i will try later again here self an update like yours.
Please wait on my results.
Ok, thank you :)
Hi,
i work in this moment on the tests.
Maybe i have found the problem.
First results:
- i can restore without problems the backup file from jD 1.8.x in 1.9.2.x (Joomla 3.2.6).
After this seems all be okay, but we have a wrong version stored in configuration table. See pic.
The update process checked this value later and need here a value like 1.9.2.x.
... will test the rest now...
[gelöscht durch Administrator]
Okay. i have doing now the last part:
- we must change manually the wrong version stored in the _jdownloads_config table:
- open your phpmyadmin and go to the _jdownloads_config table
- search in this the field jd.version
- change it to: 1.9.2.11
- install then the newest 3.2.x version and follow the description from the update instructions
So the only problem was the wrong version.
;D ;) :)
[gelöscht durch Administrator]
Arno
Very good detective work! ;D
I will document the sequence, so to be sure I understand that after restoring the 1.8.4 database to the 1.9 series then one manually changes the version in field jd.version of <prefix>_jdownloads_config. That is in sequence given by Nyx it is step 5A).
I also believe that step 8 as below is NOT required
Quote8.)
create the missing colums with phpMyAdmin in the table "__jdownloads_templates" and "__jdownloads_files".
Because jD1.8.4 and 1.9.2 does not have columns:
kto6d_jdownloads_templates:
---------------------------
template_before_text
template_after_text
language
kto6d_jdownloads_files:
----------------------
other_file_id
notes
access
password_md5
It was not necessary to populate these columns, it was sufficient that they were present.
Could you please confirm both points
Thanks
Colin
Colin,
Point 8 is not required because all tables are now correctly. ;)
And yes, between 5 and 6 must be added the manually version correction.
Quote9.3.)
But the rating is wrong -> may be false files ids.
Hm... maybe should we correct this in a later version. ::)
QuoteIn the "cats - Overview"(all cats):
Notice: Undefined property: JObject::$list in ...\htdocs\components\com_jdownloads\views\categories\tmpl\default.php on line 151
Notice: Use of undefined constant ordering - assumed 'ordering' in ...\htdocs\components\com_jdownloads\views\categories\tmpl\default.php on line 151
In the Single "cat - Overview":
Notice: Undefined variable: mail_encode in ...\htdocs\components\com_jdownloads\views\category\tmpl\default.php on line 1322
Notice: Undefined variable: mail_encode in ...\htdocs\components\com_jdownloads\views\category\tmpl\default.php on line 1322
Notice: Undefined variable: mail_encode in ...\htdocs\components\com_jdownloads\views\category\tmpl\default.php on line 1322
In the Single "file - Overview":
Notice: Undefined property: JObject::$list in ...\components\com_jdownloads\views\download\tmpl\default.php on line 193
Notice: Use of undefined constant ordering - assumed 'ordering' in ...\htdocs\components\com_jdownloads\views\download\tmpl\default.php on line 193
Some are fixed in the meantime, but all users should not use a higher error levels as 'default'.
And this are NOT errors, only notices...
hi,
Thank you for your testing and for the solution of "... lediglich ein kleiner bug..." a small bug with a big effect. ;)
I just tested it and there were no installation errors :) -> thank you!
all work fine, but the new File IDs is a big problem for:
x) the JDownloads Rating
x) the Component "Jcomments"
x) the Component "Custom Properties"
all work with the JD File IDs
So the JD Rating & jComments & Custom Properties all wrong by my migration.
So currently I have two options:
I change with phpMyAdmin
1)
all new File IDs to the old IDs -> This are 424 IDs in the moment.
or 2)
all old File IDs in the _jdownloads_rating to the new IDs -> This are 295 IDs in the moment.
all old File IDs in the _jcomments to the new IDs -> This are 49 IDs in the moment.
all old File IDs in the _custom_properties to the new IDs -> This are 424 IDs in the moment.
... a lot of work and a long downtime of my website in the migration time. I have think about it.
Ps: Arno: "Hm... maybe should we correct this in a later version."
when do you think you could solve this problem?
Hi,
Quote
all work fine, but the new File IDs is a big problem for:
x) the JDownloads Rating
x) the Component "Jcomments"
x) the Component "Custom Properties"
maybe would it be possible to expand the import function by a special routine which corrected the ratings.
For the JComments i must check at first how it is handled.
What mean you with
x) the Component "Custom Properties?
hm the import function is a good idea.
The JComments table "__jcomments"
Spalte
-------
id
parent
thread_id
path
level
[b]object_id[/b]
object_group
object_params
lang
userid
name
username
email
homepage
title
comment
ip
date
isgood
ispoor
published
deleted
subscribe
source
source_id
checked_out
checked_out_time
editor
The column "object_id" is the id from JD column file_id.
e.g.:
id parent thread_id path level [b]object_id[/b] object_group object_params lang userid name username email homepage title comment ip date isgood ispoor published deleted subscribe source source_id checked_out checked_out_time editor
1 0 0 0 0 [b]307[/b] com_jdownloads en-GB 0 test test erter@sds.com ertert ::1 2014-12-09 12:35:00.000000 0 0 1 0 0 0 0 0000-00-00 00:00:00.000000
and for the Component "Custom Properties":
this is a Joomla Tag System, with a Plugin for JD Downloads.
http://solidsystem.it/joomla-extensions/custom-properties.html
I wrote it in:
http://www.jdownloads.com/forum/index.php?topic=7271.0
about it.
this work the same way:
Spalte
------
id
ref_table
[b]content_id[/b]
field_id
value_id
e.g:
id ref_table [b]content_id[/b] field_id value_id
4 jdownloads_files [b]12[/b] 4 9
In this case the column "content_id" is the id from JD column file_id.
Thanks for the examples.
I will seen what i can do in this week.
Thank you for your tests.
I have try the "russian way"
.... Status: JD 3.x is installed with out error.
Only the files ids are wrong /new.
I did the following:
1) Edit the JD 1.9.2.11 JD/TXT Backup file with the JD 1.8.4 data:
- Del all data except for:
e.g.:
<script type="text/javascript">
/* for modal output */
function openWindow (url) {
fenster = window.open(url, "_blank", "width=550, height=480, STATUS=YES, DIRECTORIES=NO, MENUBAR=NO, SCROLLBARS=YES, RESIZABLE=NO");
fenster.focus();
}
</script>
<?php
$database->setQuery("TRUNCATE TABLE `kto6d_jdownloads_files`") ;$database->query();
$database->setQuery("INSERT INTO kto6d_jdownloads_files ( `file_id`,`file_title`,`file_alias`,`description`,`description_long`,`file_pic`,`thumbnail`,`thumbnail2`,`thumbnail3`,`price`,`release`,`language`,`system`,`license`,`url_license`,`license_agree`,`update_active`,`cat_id`,`metakey`,`metadesc`,`size`,`date_added`,`file_date`,`publish_from`,`publish_to`,`use_timeframe`,`url_download`,`extern_file`,`extern_site`,`mirror_1`,`mirror_2`,`extern_site_mirror_1`,`extern_site_mirror_2`,`url_home`,`author`,`url_author`,`created_by`,`created_mail`,`modified_by`,`modified_date`,`submitted_by`,`set_aup_points`,`downloads`,`custom_field_1`,`custom_field_2`,`custom_field_3`,`custom_field_4`,`custom_field_5`,`custom_field_6`,`custom_field_7`,`custom_field_8`,`custom_field_9`,`custom_field_10`,`custom_field_11`,`custom_field_12`,`custom_field_13`,`custom_field_14`,`ordering`,`published`,`checked_out`,`checked_out_time` ) VALUES ( '7','xxxx','xxx','TEXT.','','icon.png','img.png','','','','','1','1','8','','0','0','2','','','465.03 KB','2007-12-26 09:47:37','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0','file.pdf','','0','http://www.url.com','0','0','','autorname','','System','','uploader','2011-11-07 15:32:11','0','0','4261','0','0','0','0','0','115','','','','','0000-00-00','0000-00-00','','','422','1','0','0000-00-00 00:00:00' );"); $database->query();$i++;
..... etc. .....
?>
RENAME alle "$database" in "$db"
so the new code is:
<script type="text/javascript">
/* for modal output */
function openWindow (url) {
fenster = window.open(url, "_blank", "width=550, height=480, STATUS=YES, DIRECTORIES=NO, MENUBAR=NO, SCROLLBARS=YES, RESIZABLE=NO");
fenster.focus();
}
</script>
<?php
$db->setQuery("TRUNCATE TABLE `kto6d_jdownloads_files`") ;$db->query();
$db->setQuery("INSERT INTO kto6d_jdownloads_files ( `file_id`,`file_title`,`file_alias`,`description`,`description_long`,`file_pic`,`thumbnail`,`thumbnail2`,`thumbnail3`,`price`,`release`,`language`,`system`,`license`,`url_license`,`license_agree`,`update_active`,`cat_id`,`metakey`,`metadesc`,`size`,`date_added`,`file_date`,`publish_from`,`publish_to`,`use_timeframe`,`url_download`,`extern_file`,`extern_site`,`mirror_1`,`mirror_2`,`extern_site_mirror_1`,`extern_site_mirror_2`,`url_home`,`author`,`url_author`,`created_by`,`created_mail`,`modified_by`,`modified_date`,`submitted_by`,`set_aup_points`,`downloads`,`custom_field_1`,`custom_field_2`,`custom_field_3`,`custom_field_4`,`custom_field_5`,`custom_field_6`,`custom_field_7`,`custom_field_8`,`custom_field_9`,`custom_field_10`,`custom_field_11`,`custom_field_12`,`custom_field_13`,`custom_field_14`,`ordering`,`published`,`checked_out`,`checked_out_time` ) VALUES ( '7','xxxx','xxx','TEXT.','','icon.png','img.png','','','','','1','1','8','','0','0','2','','','465.03 KB','2007-12-26 09:47:37','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0','file.pdf','','0','http://www.url.com','0','0','','autorname','','System','','uploader','2011-11-07 15:32:11','0','0','4261','0','0','0','0','0','115','','','','','0000-00-00','0000-00-00','','','422','1','0','0000-00-00 00:00:00' );"); $db->query();$i++;
..... etc. .....
?>
So I clean the table "TRUNCATE TABLE `kto6d_jdownloads_files" and import all "INSERT INTO kto6d_jdownloads_files" data sets / downloads.
I make a Restore with the JD 3.x Restore function and this TXT file.
-> all ok
I had to give all files/downloads in JD Joomla Webinterface a new "Access" -> "Public" and give all files "Language" -> "All".
So all ratings now right. / all file id's the "old one" -> and no errors or false data.
I have forgotten something? And "should" go this way?
Hm... i understand not exactly what you will doing here:
QuoteSo I clean the table "TRUNCATE TABLE `kto6d_jdownloads_files" and import all "INSERT INTO kto6d_jdownloads_files" data sets / downloads.
I make a Restore with the JD 3.x Restore function and this TXT file.
You can not restore a backup file from 1.8.x in 3.2.x. Some database fields has changed in 3.2.
So you should use the 'normal import way' which we had debated early (and which worked fine). Only in this case is your database structure valid.
I will try in the next days to rework the import so that also ratings, comments and so on are corrected. But i need a little more time for this.
I only save this to a txt:
<script type="text/javascript">
/* for modal output */
function openWindow (url) {
fenster = window.open(url, "_blank", "width=550, height=480, STATUS=YES, DIRECTORIES=NO, MENUBAR=NO, SCROLLBARS=YES, RESIZABLE=NO");
fenster.focus();
}
</script>
<?php
$db->setQuery("TRUNCATE TABLE `kto6d_jdownloads_files`") ;$db->query();
$db->setQuery("INSERT INTO kto6d_jdownloads_files ( `file_id`,`file_title`,`file_alias`,`description`,`description_long`,`file_pic`,`thumbnail`,`thumbnail2`,`thumbnail3`,`price`,`release`,`language`,`system`,`license`,`url_license`,`license_agree`,`update_active`,`cat_id`,`metakey`,`metadesc`,`size`,`date_added`,`file_date`,`publish_from`,`publish_to`,`use_timeframe`,`url_download`,`extern_file`,`extern_site`,`mirror_1`,`mirror_2`,`extern_site_mirror_1`,`extern_site_mirror_2`,`url_home`,`author`,`url_author`,`created_by`,`created_mail`,`modified_by`,`modified_date`,`submitted_by`,`set_aup_points`,`downloads`,`custom_field_1`,`custom_field_2`,`custom_field_3`,`custom_field_4`,`custom_field_5`,`custom_field_6`,`custom_field_7`,`custom_field_8`,`custom_field_9`,`custom_field_10`,`custom_field_11`,`custom_field_12`,`custom_field_13`,`custom_field_14`,`ordering`,`published`,`checked_out`,`checked_out_time` ) VALUES ( '7','xxxx','xxx','TEXT.','','icon.png','img.png','','','','','1','1','8','','0','0','2','','','465.03 KB','2007-12-26 09:47:37','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0','file.pdf','','0','http://www.url.com','0','0','','autorname','','System','','uploader','2011-11-07 15:32:11','0','0','4261','0','0','0','0','0','115','','','','','0000-00-00','0000-00-00','','','422','1','0','0000-00-00 00:00:00' );"); $db->query();$i++;
$db->setQuery("INSERT INTO kto6d_jdownloads_files ( `file_id`,`file_title`,`file_alias`,`description`,`description_long`,`file_pic`,`thumbnail`,`thumbnail2`,`thumbnail3`,`price`,`release`,`language`,`system`,`license`,`url_license`,`license_agree`,`update_active`,`cat_id`,`metakey`,`metadesc`,`size`,`date_added`,`file_date`,`publish_from`,`publish_to`,`use_timeframe`,`url_download`,`extern_file`,`extern_site`,`mirror_1`,`mirror_2`,`extern_site_mirror_1`,`extern_site_mirror_2`,`url_home`,`author`,`url_author`,`created_by`,`created_mail`,`modified_by`,`modified_date`,`submitted_by`,`set_aup_points`,`downloads`,`custom_field_1`,`custom_field_2`,`custom_field_3`,`custom_field_4`,`custom_field_5`,`custom_field_6`,`custom_field_7`,`custom_field_8`,`custom_field_9`,`custom_field_10`,`custom_field_11`,`custom_field_12`,`custom_field_13`,`custom_field_14`,`ordering`,`published`,`checked_out`,`checked_out_time` ) VALUES ( '7','xxxx','xxx','TEXT.','','icon.png','img.png','','','','','1','1','8','','0','0','2','','','465.03 KB','2007-12-26 09:47:37','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0','file.pdf','','0','http://www.url.com','0','0','','autorname','','System','','uploader','2011-11-07 15:32:11','0','0','4261','0','0','0','0','0','115','','','','','0000-00-00','0000-00-00','','','422','1','0','0000-00-00 00:00:00' );"); $db->query();$i++;
$db->setQuery("INSERT INTO kto6d_jdownloads_files ( `file_id`,`file_title`,`file_alias`,`description`,`description_long`,`file_pic`,`thumbnail`,`thumbnail2`,`thumbnail3`,`price`,`release`,`language`,`system`,`license`,`url_license`,`license_agree`,`update_active`,`cat_id`,`metakey`,`metadesc`,`size`,`date_added`,`file_date`,`publish_from`,`publish_to`,`use_timeframe`,`url_download`,`extern_file`,`extern_site`,`mirror_1`,`mirror_2`,`extern_site_mirror_1`,`extern_site_mirror_2`,`url_home`,`author`,`url_author`,`created_by`,`created_mail`,`modified_by`,`modified_date`,`submitted_by`,`set_aup_points`,`downloads`,`custom_field_1`,`custom_field_2`,`custom_field_3`,`custom_field_4`,`custom_field_5`,`custom_field_6`,`custom_field_7`,`custom_field_8`,`custom_field_9`,`custom_field_10`,`custom_field_11`,`custom_field_12`,`custom_field_13`,`custom_field_14`,`ordering`,`published`,`checked_out`,`checked_out_time` ) VALUES ( '7','xxxx','xxx','TEXT.','','icon.png','img.png','','','','','1','1','8','','0','0','2','','','465.03 KB','2007-12-26 09:47:37','0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','0','file.pdf','','0','http://www.url.com','0','0','','autorname','','System','','uploader','2011-11-07 15:32:11','0','0','4261','0','0','0','0','0','115','','','','','0000-00-00','0000-00-00','','','422','1','0','0000-00-00 00:00:00' );"); $db->query();$i++;
..... etc. ..... -> 420 x "$db->setQuery("INSERT INTO kto6d_jdownloads_files ( ...." -> all Downloads.
?>
so i ONLY "flush" the JD 3.x table "kto6d_jdownloads_file" and import ONLY the old kto6d_jdownloads_file files / Download data.
-> https://localhost/administrator/index.php?option=com_jdownloads&view=tools (Tools)
-> "Backup Restoration" button to import the TXT
But, i will wait for your solution, thank you!
QuoteI only save this to a txt:
You can try this but you should afterwards extensive test all jD sections in frontend and backend.
I will wait for you :-)
The e.g.: the cats are wrong,...
so i have flush this to,.. and so on.
Wenn you have time i think your way will be the better way ;)
Okay.
Quote
Update 2015-01-07 Version 3.2.21 Beta published:
corrections for the import process from 1.9.x (the imported Downloads retained now the original ID). So it can now be useful for some users to renew the import process. The bug from 3.2.20 is fixed here.
Sounds very good ;D
I will try it soon.
so....
The new Version JD 3.2.21 beta work perfekt!
After the data Import from jd 1.8.4 / jd 1.9.2 -All File Ids & cats Ids are the old one (from 1.8.4 / jd 1.9.2) thank you very much :)
Also the old jcomments data is so right.
THANK YOU !
Many thanks. Finally a good message. ;D