Bug Fatal Error by Downloads II Importer

[SpiderFive]

Datenbankfehler in vBulletin 4.2.0:

Invalid SQL:

INSERT INTO dbtech_downloads_categories (catname, catdesc, extgroupids, permissions)
VALUES (
'Siedler 4 ',
'S4',
'2',
'a:3:{s:4:\"view\";a:1:{i:0;i:6;}s:8:\"download\";a:1:{i:0;i:6;}s:6:\"upload\";a:1:{i:0;i:6;}}',
);

MySQL-Fehler : 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 ')' at line 7
Fehler-Nr. : 1064
Fehler-Zeit : Friday, 06.07.2012 @ 14:47:49
Datum : Friday, 06.07.2012 @ 14:47:49
Skript : ..../vbdownloads.php?do=import&step=4&mod=dl2
Referrer :..../admincp/vbdownloads.php?do=import&step=3&mod=dl2
IP-Adresse : ......
Benutzername :..........
Klassenname : vB_Database
MySQL-Version : 5.1.49-3~bpo50+1

Stack Trace:

#0 vB_Database->halt() called in [path]/includes/class_core.php on line 426
#1 vB_Database->execute_query() called in [path]/includes/class_core.php on line 444
#2 vB_Database->query_write() called in [path]/dbtech/downloads/core/class_import.php on line 167
#3 Downloads_Importer->importCategories() called in [path]/dbtech/downloads/core/class_import.php on line 97
#4 Downloads_Importer->step4() called in [path]/dbtech/downloads/actions/admin/import.php on line 65
#5 include_once([path]/dbtech/downloads/actions/admin/import.php) called in [path]/admincp/vbdownloads.php on line 74

 

[Dylan]

I did a hotfix on the files. You can either download the package again and reupload the files or manually fix it.

If you want to manually fix it.

Open dbtech/downloads/core/class_import.php

Find line

                                '" . $this->registry->db->escape_string($default_ugs) . "',

replace with

                                '" . $this->registry->db->escape_string($default_ugs) . "'

 

[SpiderFive]

thank you


I have a suggestion, the download addon should provide possibility of major categories and subcategories

 

[Dylan]

thank you


I have a suggestion, the download addon should provide possibility of major categories and subcategories

I'm not sure what you mean?