Caanot restore to fresh joomla with same version

[nzy182]

hallo,  before, I had wanted to move the data to the latest joomla but I get "An error has occurred."
it possible that my data is too large.
and I try to use the same version on the fresh joomla, but I still get the error

---------------
An error has occurred.

    1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'Up\\' button above to see the other download files)','','','0000-00-00'' at line 1 SQL=INSERT INTO #__jdownloads_files ( `file_id`,`file_title`,`file_alias`,`description`,`description_long`,`file_pic`,`thumbnail`,`thumbnail2`,`thumbnail3`,`images`,`price`,`release`,`file_language`,`system`,`license`,`url_license`,`license_agree`,`size`,`date_added`,`file_date`,`publish_from`,`publish_to`,`use_timeframe`,`url_download`,`preview_filename`,`other_file_id`,`md5_value`,`sha1_value`,`extern_file`,`extern_site`,`mirror_1`,`mirror_2`,`extern_site_mirror_1`,`extern_site_mirror_2`,`url_home`,`author`,`url_author`,`created_by`,`created_id`,`created_mail`,`modified_by`,`modified_id`,`modified_date`,`submitted_by`,`set_aup_points`,`downloads`,`cat_id`,`notes`,`changelog`,`password`,`password_md5`,`views`,`metakey`,`metadesc`,`robots`,`update_active`,`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`,`access`,`language`,`ordering`,`featured`,`published`,`checked_out`,`checked_out_time`,`asset_id` ) VALUES ( '532','SAMSUNG Kies,PC Sync 2.1.0.11095_121_6 for Galaxy Y GT-S5360 ','samsung-kies-pc-sync-2-1-0-11095-121-6-for-galaxy-y-gt-s5360','','','exe.jpg','','','','','','2.1.0.11095_121_6','12','5','0','','0','83.3 MB','2011-11-27 15:44:15','0000-00-00 00:00:00','2016-07-04 06:51:15','0000-00-00 00:00:00','0','','','0','','','http://downloadcenter.samsung.com/content/SW/201108/20110825092847825/Kies_2.1.0.11095_121_6.exe','1','','','0','0','','','','','62','','','0','2012-03-17 00:19:47','62','0','9971','376','','','','','0','','','','0','0','0','0','0','0','Kies 2.1.0.11095-121-6.exe','','This version maybe has been deleted or expired, please find the new version. (you can click the \\'Up\\' button above to see the other download files)','','','0000-00-00','0000-00-00','<script type=\"text/javascript\">// <![CDATA[ ch_client = \"nzyta\"; ch_width = 300; ch_height = 250; ch_type = \"mpu\"; ch_sid = \"MG DL detail - SAMSUNG Kies for galaxy y\"; ch_backfill = 1; ch_color_site_link = \"#3D4A7D\"; ch_color_title = \"#3D4A7D\"; ch_color_border = \"#FFFFFF\"; ch_color_text = \"#000000\"; ch_color_bg = \"#FFFFFF\"; ch_alternate_css_url = \"http://scripts.chitika.net/static/css/noborders.css\"; var ch_queries = new Array( \"SAMSUNG Kies\", \"galaxy y\", \"PC Sync\", \"download\", \"GT-S5360\" ); var ch_selected=Math.floor((Math.random()*ch_queries.length)); if ( ch_selected < ch_queries.length ) { ch_query = ch_queries[ch_selected]; } // ]]></script> <script src=\"http://scripts.chitika.net/eminimalls/amm.js\" type=\"text/javascript\"> </script>','','1','*','1716','0','1','0','0000-00-00 00:00:00','0' );
----------------------

version:
- joomla 3.5.1
- jdownloads 3.2.44_J32

[ColinM]

Hi
I think the problem is in updating Joomla!  Note you cannot update from 3.5.1 to 3.6.x using the Extension Manager.  It has to be done using the Joomla! Update Component.  See for example
https://docs.joomla.org/J3.x:Updating_from_an_existing_version

You might need to go through Joomla! 3.6.0 or 3.6.1
see https://www.joomla.org/announcements/release-news/5666-the-joomla-3-6-1-update.html

There are bits of advice about repairng database issues

There should be no need to update jDownloads until you get to your target Joomla!  Updating jD does not require any reloading of the Downloads

Colin
PS make Backups and test at each stage!!

[nzy182]

thanks for reply ^^ ,
I did not update my joomla but restoring data to a fresh Joomla 3.6.4 (new installation)
and I also do it to the same version with the data source
sorry if my bad english and my explanation is incomplete

i create a new backup file from:
joomla 3.5.1
jdownloads 3.2.44_j32

i restore to:
joomla 3.6.4
jdownloads 3.2.46_j32

for assure the problem of incompatibility version then I also restore data to same version:
joomla 3.5.1
jdownloads 3.2.44_j32

[Arno]

Hi nzy182,
please send me your backup file via PM. Then i will check (and try to repair) it  here.

i create a new backup file from:
joomla 3.5.1
jdownloads 3.2.44_j32

You should always first update to the newest version before you run the backup.

[nzy182]

hi arno thanks for replay, PM sent

[Arno]

I have fixed the backup files. A few data sets had double or multiple backslash characters  instead a single backslash to 'escape' single or double qoute characters.

[nzy182]

thank you very much arno. it turns out because of "double or multiple backslash characters"
It will be better if Jdownloads has auto convert or auto fix to this problem when back up/restore data or at least give more detailed error notification.
by the way, i got the data from result of backup via database from "jDownloads 1.9.1 Stable Build 931" to jdownloads 3.2.44_j32

[ColinM]

Hi
An 'auto' fix for this would be challenging as for example one wants a single \ char then it appears as two \\ chars.  This is because \ is used in the database, not jD, as an escape character.
Colin