[RS_Jelle]

Originally Posted by maidos

my PHP Maximum Upload Size 350.00 MB

but i still fail to upload ?files over 20 mb
running a dedicated server with centos 5 as server os

i have created.htaccess on the same directory as download.php
and used this

php_value upload_max_filesize 30M
php_value post_max_size 30M

but i still failed to upload files over 20 mb

If it's a dedicated server, you can try changing your php.conf also
Maybe AllowOverride is set to None in your httpd.conf (Apache webserver), so .htaccess files don't work?

Originally Posted by AScherff

Hi,

i have these database error when a user try to upload a new version of the download:

Datenbankfehler in vBulletin 3.6.7:

Invalid SQL:
SELECT title, usergroup.usergroupid, username, userid
			   FROM knxusergroup, knxuser
                           WHERE ecdownloadpermissions & 1024 AND  usergroup.usergroupid = user.usergroupid;

MySQL-Fehler : Unknown table 'usergroup' in field list

The error comes because the Table-Prefix is not all set

The right SQL Statement must be:

SELECT title, knxusergroup.usergroupid, username, userid
			   FROM knxusergroup, knxuser
                           WHERE ecdownloadpermissions & 1024 AND  knxusergroup.usergroupid = knxuser.usergroupid;

so how can i fix that?

Thanks

Alfred

This is a vBulletin generated query as we don't have our own query like that. We just use the standard usergroup permissions request code and vBulletin uses this kind of code to set up the permissions.
Have you correctly updated your installation? So you have uploaded all files to your forum FTP folder and you have imported the product file (with overwrite option ON)?

Originally Posted by maidos

i would like to bring up a suggestion, please make it so ppl can upload on ftp so once its done maybe on admin cp or somewhere will tell the staff that soemone uploaded the file and let the staff put it on a category

There's already an FTP feature: you can upload files to a folder and mass import them using the DownloadsII import page in the AdminCP.
You can also use the moderation queue to let members add files.

Originally Posted by cOuNtErFiET

For some reason im getting this error when trying to delete a file, and im the GOD admin, also all my other admins are getting this too...how can i fix this?

Maybe you did a server move or something like that? Check the chmod of the downloads folder (should be 777, full permissions) and what is the chmod value of the uploaded files in the downloads folder?