YOu need to do the admincp edits. - i forgot to put the correct link in, added a fix file

Try going to your settings and saving perpage as a numerical value higher than zero. I do not get this error and cannot see another possibility as of yet. Maybe more information would help if the problem persists.

Fixed.


It works on 3.0.0 -> 3.0.8

I get this when editing user group permissions

Database error in vBulletin 3.0.7:

Invalid SQL: UPDATE usergroup SET

### UPDATE QUERY GENERATED BY fetch_query_sql() ###
title = 'Administrator',
description = '',
usertitle = 'Administrator',
opentag = '<b>',
closetag = '</b>',
passwordexpires = '0',
passwordhistory = '0',
attachlimit = '0',
avatarmaxwidth = '80',
avatarmaxheight = '80',
avatarmaxsize = '20000',
profilepicmaxwidth = '100',
profilepicmaxheight = '100',
profilepicmaxsize = '65535',
pmquota = '1000',
pmsendmax = '5',
uttstore_discount = '0',
forumpermissions = '393215',
pmpermissions = '3',
calendarpermissions = '31',
wolpermissions = '31',
adminpermissions = '3',
genericpermissions = '20971519',
genericoptions = '24',
journalpermissions = '2047',
arcadepermissions = '31',
vbarticlespermissions = '15',
vbreviewspermissions = '15',
vbtabspermissions = '15',
downloadpermissions = '1'
WHERE usergroupid=6
mysql error: Unknown column 'downloadpermissions' in 'field list'

mysql error number: 1054

I'm getting the self same error! along with missing 2 phrases and

Invalid SQL: SELECT * FROM dl_files WHERE `purgatory` = '0' AND `category` = '1' ORDER BY `pin` DESC, `date` DESC LIMIT 0,
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 1

mysql error number: 1064

its totally farked my board :s

AH FOUND IT AND FIXED IT!

go into init.php and replace.

// ###### ELITECODERS DOWNLOAD HACK ######
$_BITFIELD['usergroup']['downloadpermissions'] = array(
'canviewfiles' => 1,
'candownloadfiles' => 2,
'canratefiles' => 4,
'canuploadimages' => 8,
'canlinktofiles' => 16,
'canuploadfiles' => 32,
'canavoidpurgatory' => 64,
'canmanagepurgatory' => 128,
'caneditownfiles' => 256,
'caneditallfiles' => 512,
'canviewdisabled' => 1024
);
// ###### ELITECODERS DOWNLOAD HACK ######

// ###### ELITECODERS DOWNLOAD HACK ######
$_BITFIELD['usergroup']['ecdownloadpermissions'] = array(
'canviewfiles' => 1,
'candownloadfiles' => 2,
'canratefiles' => 4,
'canuploadimages' => 8,
'canlinktofiles' => 16,
'canuploadfiles' => 32,
'canavoidpurgatory' => 64,
'canmanagepurgatory' => 128,
'caneditownfiles' => 256,
'caneditallfiles' => 512,
'canviewdisabled' => 1024
);
// ###### ELITECODERS DOWNLOAD HACK ######

that'll fix the usergroups bug your having!

the divide by zero error piddle off after you upload your first file...

HOWEVER i've noticed something wrong when i try to upload a file with the wrong extension type it DOESNT tell me the supported extension types. Also can someone tell me what the 2 missing phrases are at the BOTTOM of the usergroup permission block, all are there but those 2! :( if someone can tell me I'll add the phrases by hand.

Fsk, yeak I reverted BACK to the old one when I added the fix :(.

ecdownloads_can_edit_all_files and ecdownloads_can_view_disabled

Question:

If I install this on 3.0.8, is there an easy upgrade available for the 3.5 version for when I do upgrade my vBulletin? Or would I be better off waiting until after I upgrade to vB3.5 to install ecD?

Thanks for the response. After editing the admincp/index.php and functions/init.php file (which fixed the other problems I was having) as noted in your fix file, I'm still having a problem with the stats page. I'll let this screen shot do the talking:

https://vborg.vbsupport.ru/

Is this normal? Or did I totally screw up LOL?

Thanks again.

I was wondering about these too. Are these permissions phrases?

Thank you.

One more LOL...

I'm getting a "403 Forbidden by Web Configuration" error when I try to download a file I upload. I can see it in my FTP but I'm unable to retrieve it by clicking the Download Here link after I upload it. I set the folders permissions at 777. Any suggestions?

Thank you.