[DragonByte Tech]

Originally Posted by iask

Database error in vBulletin 4.2.0:

Invalid SQL:

INSERT INTO dbtech_downloads_categories (catname, catdesc, extgroupids, permissions)
VALUES (
'Video',
'',
'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 Error : 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
Error Number : 1064
Request Date : Monday, July 30th 2012 @ 10:19:59 AM
Error Date : Monday, July 30th 2012 @ 10:19:59 AM
Script : http://www.xxxxxxxxxxx/admincp/vbdow...step=4&mod=dl2
Referrer : http://www.xxxxxxxxxxx/admincp/vbdow...step=3&mod=dl2
IP Address : 78.23.32.76
Username : Free
Classname : vB_Database
MySQL Version : 5.1.63-log

Sorry about that. If you open dbtech/downloads/core/class_import.php
On line 165 you'll see

PHP Code:

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


replace it with

PHP Code:

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


Dylan