3.2 & 3.3 Extensions Database 3.2 / 3.3 ⇒ Download System

[Pulaski]

I had to uncomment #RewriteBase in the .htaccess file, everything seems to be working fine now, thanks...

[martin]

If url rewrite is on in acp and also allowed on the server then it will work you dont need to use /app.php no more.

visit the download section on the vpn site it works.

[petit79]

I have already been able to solve it thanks to your help.
Apart from activating in the server the mod rewrite, and verified that in the .htaccess I had also enabled AllowOverride on and last and it is what I was missing was in my configuration file of the add domain
<Directory "/ var / www / html">
AllowOverride All
</ Directory>

And it already works correctly. Thank you very much for your help. regards

[martin]

I have already been able to solve it thanks to your help.
Apart from activating in the server the mod rewrite, and verified that in the .htaccess I had also enabled AllowOverride on and last and it is what I was missing was in my configuration file of the add domain
<Directory "/ var / www / html">
AllowOverride All
</ Directory>

And it already works correctly. Thank you very much for your help. regards

Yes AllowOverride will tell apache to read htaccess files as by default apache wont read them and inturn this will allow mod_rewrite and that allows url_rewrite in your acp.

[volf]

Hi! Thanks for the awesome extension.

Im migrating an old pafiledb based dl system to this extension.
Links in old system are external and noticed you mentioned back in February that allowing external links is on your to do list. Got a temporary workaround but its really tedious with +2k downloads, so wondering how far has allow external link climbed on your to do list?

Also have a suggestion to make subcategories display under main categories.

Edit: Another suggestion for a possible future update is to make the extension use the styles images for icon_folder.gif and icon_subfolder.gif. Atm with a darker them i had to edit core/functions.php

[origon]

When i was updating my board onto phpbb3.2.2, i was updating the download system too, and now i got this error when i are clicking on download.

"[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/pagination.php on line 144: Division by zero
[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/pagination.php on line 292: Division by zero
[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/pagination.php on line 292: Division by zero
[phpBB Debug] PHP Warning: in file [ROOT]/phpbb/pagination.php on line 306: Division by zero"

[cisco007]

Any luck on looking into the thumbnail idea?

[Thunder]

Hi,

would it be possible to install that?

You can also upload a picture.

Many Thanks.

[dewoert]

Hello,
Thanks for this great extension.
One question :
Is it possible to change to sorting order to "Last changed time/date" or "Uploaded" ?
I tried to find it in serveral files, but can't find a place to change is (by hand)

Kind regards,
Tonny

[dmzx]

First post updated and moved to 3.2.x section

[mh254]

Hi, i can upload files, they where shown with the correct size. But when someone downloads them, they all have only a view kb :(

Any idea where the problem could be? Some server setting? I think the issue started after a server change (PHP 7.2).

[dmzx]

First post updated.

[Shadow_SHD]

Hi,

First thanks dmzx I really enjoy this extension

I'm running a PhpBB test forum hosted by a shared server, with PhpBB version 3.2.7 and PHP version 7.2.
I'm a noob regarding PhpBB and PHP coding, so excuse me if I write wrong things about the issue I have.

If I have no category at all then the expected result of Sorry, there's are currently no categories available page is displayed when browsing my forum's Downloads section.

Bu as soon as I add a new category, I get this error :

Code: Select all

General error
SQL ERROR [ mysqli ]

Expression #17 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db345746_<mydomain>.bd.download_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by [1055]

SQL

SELECT bc.*, bd.*, COUNT(bd.download_id) AS number_downloads, MAX(bd.last_changed_time) AS last_download FROM phpbb_dm_eds_cat bc LEFT JOIN phpbb_dm_eds_cat bc2 ON ( bc2.left_id < bc.right_id AND bc2.left_id > bc.left_id AND bc2.cat_id = 0 ) LEFT JOIN phpbb_dm_eds bd ON ( bd.download_cat_id = bc.cat_id OR bd.download_cat_id = bc2.cat_id	) WHERE bc.parent_id = 0 GROUP BY bc.cat_id ORDER BY bc.left_id ASC LIMIT 25

BACKTRACE

FILE: (not given by php)
LINE: (not given by php)
CALL: msg_handler()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 997
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 193
CALL: phpbb\db\driver\driver->sql_error()

FILE: [ROOT]/phpbb/db/driver/mysql_base.php
LINE: 45
CALL: phpbb\db\driver\mysqli->sql_query()

FILE: [ROOT]/phpbb/db/driver/driver.php
LINE: 270
CALL: phpbb\db\driver\mysql_base->_sql_query_limit()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 321
CALL: phpbb\db\driver\driver->sql_query_limit()

FILE: [ROOT]/ext/dmzx/downloadsystem/core/functions.php
LINE: 388
CALL: phpbb\db\driver\factory->sql_query_limit()

FILE: [ROOT]/ext/dmzx/downloadsystem/controller/download.php
LINE: 72
CALL: dmzx\downloadsystem\core\functions->generate_cat_list()

FILE: (not given by php)
LINE: (not given by php)
CALL: dmzx\downloadsystem\controller\download->handle_downloadsystem()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 135
CALL: call_user_func_array()

FILE: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 57
CALL: Symfony\Component\HttpKernel\HttpKernel->handleRaw()

FILE: [ROOT]/app.php
LINE: 35
CALL: Symfony\Component\HttpKernel\HttpKernel->handle()

From what I've read this error is generated by the only_full_group_by parameter being more restrictive since a recent version of PHP.
After Googling about this error I guessed I had to add bd.download_id in the GROUP BY lines and bingo the extension now runs flawlessly.

Lines 386 and 403 (not sure if it's really useful for line 403) in core/functions.php :

Change :

Code: Select all

GROUP BY bc.cat_id

To :

Code: Select all

GROUP BY bc.cat_id, bd.download_id

Thank you again for Download System and have a nice day

[Mickroz]

Updating to latest version gives me a 500 error, can't access anything after that, disableing it in db and deleting cache got my site accessible again.
any ideas?
Databaseserver: MySQL(i) 5.6.12
PHP-version: 5.5.20
Forumversion: 3.2.7

[martin]

How did you update ? ext uploader or ftp.