Status
Not open for further replies.

mistafro

Customer
Hi, I uploaded your latest version today and tried the downloads II importer.

When the import started I got a barrage of PHP errors and then it said it was done.

I couldn't get the errors as the screen changed to quick but from what I see, it imported the categories and less than half the files.

I went into the categories to configure them and get this error when I click save:

Database error in vBulletin 4.0.4:

Invalid SQL:

UPDATE dbtech_downloads_categories
SET
catname = 'Videos',
catdesc = 'Upload your videos here.',
extgroupids = '3',
private = '0',
password = '0',
moderation = '0',
permissions = '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;}}',
parentid = 0

WHERE catid = 5;

MySQL Error : Unknown column 'parentid' in 'field list'
Error Number : 1054
Request Date : Saturday, October 30th 2010 @ 02:22:15 PM
Error Date : Saturday, October 30th 2010 @ 02:22:15 PM
Script : mypath/vbdownloads.php?do=doeditcat
Referrer : mypath/vbdownloads.php?do=editcat&catid=5
Classname : vB_Database_MySQLi
MySQL Version : 5.1.39-log

any ideas what's up?
 
Last edited:
I uninstalled, dropped all the downloads database tables, re-installed and get the same thing, even before importing, when trying to setup the default category.
 
Same here with a fresh install, cant create category's
And at the Groupmanager i cant find the permission setting for the usergroups.
 
Last edited:
Seems parentid was missing from dbtech_downloads_categories

I added a parentid table to the database there and it worked. I still get a ton of errors flash on the screen during the downloads II import and it didn't import any of the images for the files.

Also it didn't import any comments, that would be really helpful if it could!
 
Last edited:
Installed (Upgraded) to the latest version You uploaded today at vbulletin.org and the error still exist:

Database error in vBulletin 4.0.8:

Invalid SQL:

INSERT INTO dbtech_downloads_categories (catname, catdesc, extgroupids, private, password, moderation, permissions, parentid)
VALUES (
'Members Category',
'Downloads for members',
'2,1,3',
'0',
'0',
'',
'a:3:{s:4:"view";a:6:{i:0;i:6;i:1;i:2;i:2;i:9;i:3;i:7;i:4;i:5;i:5;i:10;}s:8:"download";a:6:{i:0;i:6;i:1;i:2;i:2;i:9;i:3;i:7;i:4;i:5;i:5;i:10;}s:6:"upload";a:6:{i:0;i:6;i:1;i:2;i:2;i:9;i:3;i:7;i:4;i:5;i:5;i:10;}}',
0
);

MySQL Error : Unknown column 'parentid' in 'field list'
Error Number : 1054
Request Date : Sunday, October 31st 2010 @ 07:31:26 AM
Error Date : Sunday, October 31st 2010 @ 07:31:26 AM
Script : +++/forum/admincp/vbdownloads.php?do=doaddcategory
Referrer : +++/forum/admincp/vbdownloads.php?do=addcategory
IP Address : +++++
Username : +++++
Classname : vB_Database
MySQL Version : 5.0.51a-community
 
Installed (Upgraded) to the latest version You uploaded today at vbulletin.org and the error still exist:

Database error in vBulletin 4.0.8:

Invalid SQL:

INSERT INTO dbtech_downloads_categories (catname, catdesc, extgroupids, private, password, moderation, permissions, parentid)
VALUES (
'Members Category',
'Downloads for members',
'2,1,3',
'0',
'0',
'',
'a:3:{s:4:"view";a:6:{i:0;i:6;i:1;i:2;i:2;i:9;i:3;i:7;i:4;i:5;i:5;i:10;}s:8:"download";a:6:{i:0;i:6;i:1;i:2;i:2;i:9;i:3;i:7;i:4;i:5;i:5;i:10;}s:6:"upload";a:6:{i:0;i:6;i:1;i:2;i:2;i:9;i:3;i:7;i:4;i:5;i:5;i:10;}}',
0
);

MySQL Error : Unknown column 'parentid' in 'field list'
Error Number : 1054
Request Date : Sunday, October 31st 2010 @ 07:31:26 AM
Error Date : Sunday, October 31st 2010 @ 07:31:26 AM
Script : +++/forum/admincp/vbdownloads.php?do=doaddcategory
Referrer : +++/forum/admincp/vbdownloads.php?do=addcategory
IP Address : +++++
Username : +++++
Classname : vB_Database
MySQL Version : 5.0.51a-community
You will need to run the following query:

Code:
ALTER TABLE [COLOR="red"]{YOUR TABLE PREFIX}[/COLOR]dbtech_downloads_categories ADD COLUMN parentid INT(10) unsigned NOT NULL DEFAULT '0'
 
Last edited:
Seems parentid was missing from dbtech_downloads_categories
I added a parentid table to the database there and it worked. I still get a ton of errors flash on the screen during the downloads II import and it didn't import any of the images for the files.
Also it didn't import any comments, that would be really helpful if it could!

Hi.

Ist this fixed in V. 1.1 ?
 
Hi
The import of the database records of DownloadsII not work with vb 3.8.x. A file seems to be missing in the package.
In the install.php is: require_once (DIR '/ includes / class_dbalter.php'.)
The class_dbalter.php missing in the package. Is this intentional? This file is also missing in 1.0.0. Sorry for my bad English. I am a German. Otherwise, good script. Good work.
 
Hi
The import of the database records of DownloadsII not work with vb 3.8.x. A file seems to be missing in the package.
In the install.php is: require_once (DIR '/ includes / class_dbalter.php'.)
The class_dbalter.php missing in the package. Is this intentional? This file is also missing in 1.0.0. Sorry for my bad English. I am a German. Otherwise, good script. Good work.
Like Bravo stated, these are vBulletin default files :)
 
It should be, yes :)

Hi
Thanks for the replies. If the import function also tested in VB 3.8.x ?
The import of the database records of DownloadsII works on vb 3.8.x does not v. 1.1.0.

Edit: I use DownloadsII v. 5.1.2
 
Last edited:
Status
Not open for further replies.
Back
Top