3.2 & 3.3 Extensions Database 3.2 / 3.3 ⇒ Download System

<span class="qte-attr qte_32_33-qte">3.2.x & 3.3.x</span>
Post Reply Previous topicNext topic
User avatar

moffacostanzo
Donator
Donator
Posts: 151
Joined: 30 Oct 2015, 10:34
    Mac OS X Firefox

Re: Download System

Post by moffacostanzo »

I have this error

Code: Select all

Errore Generale
SQL ERROR [ mysqli ]

Unknown column 'announce_lock_enable' in 'field list' [1054]

SQL

UPDATE phpbb_dm_eds_config SET pagination_acp = 5, pagination_user = 3, announce_enable = 1, announce_forum = 45, announce_lock_enable = 0, pagination_downloads = 25

BACKTRACE

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

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

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

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

FILE: [ROOT]/ext/dmzx/downloadsystem/controller/admin_controller.php
LINE: 219
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/dmzx/downloadsystem/acp/downloadsystem_module.php
LINE: 39
CALL: dmzx\downloadsystem\controller\admin_controller->display_config()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: dmzx\downloadsystem\acp\downloadsystem_module->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
User avatar

Topic Author
dmzx
Founder
Founder
Posts: 6482
Joined: 13 Jan 2014, 21:45
    Windows 10 Chrome

Re: Download System

Post by dmzx »

moffacostanzo wrote: 11 Dec 2016, 20:57 i have this error

Code: Select all

Errore Generale
SQL ERROR [ mysqli ]

Unknown column 'announce_lock_enable' in 'field list' [1054]

SQL

UPDATE phpbb_dm_eds_config SET pagination_acp = 5, pagination_user = 3, announce_enable = 1, announce_forum = 45, announce_lock_enable = 0, pagination_downloads = 25

BACKTRACE

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

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

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

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

FILE: [ROOT]/ext/dmzx/downloadsystem/controller/admin_controller.php
LINE: 219
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/dmzx/downloadsystem/acp/downloadsystem_module.php
LINE: 39
CALL: dmzx\downloadsystem\controller\admin_controller->display_config()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: dmzx\downloadsystem\acp\downloadsystem_module->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
Did you correctly update the extension?
User avatar

moffacostanzo
Donator
Donator
Posts: 151
Joined: 30 Oct 2015, 10:34
    Mac OS X Firefox

Re: Download System

Post by moffacostanzo »

First i have this problem when instal ext appears this error
You do not have the required permissions to view the files attached to this post! Maybe your post count is too low.
User avatar

Topic Author
dmzx
Founder
Founder
Posts: 6482
Joined: 13 Jan 2014, 21:45
    Windows 10 Chrome

Re: Download System

Post by dmzx »

moffacostanzo wrote: 11 Dec 2016, 21:04 first i have this problem when instal ext appears this error
So are you updating from version 1.0.0?
User avatar

moffacostanzo
Donator
Donator
Posts: 151
Joined: 30 Oct 2015, 10:34
    Mac OS X Firefox

Re: Download System

Post by moffacostanzo »

No
i remove an ext
because i do't have download
and i install e new version

i used e version 1.0.2
User avatar

Topic Author
dmzx
Founder
Founder
Posts: 6482
Joined: 13 Jan 2014, 21:45
    Windows 10 Chrome

Re: Download System

Post by dmzx »

moffacostanzo wrote: 11 Dec 2016, 21:06 no
i remove an ext
because i do't have download
and i install e new version

i used e version 1.0.2
Ok check you ACP for left over download system modules and delete them manual. (disable and then delete them)
After that install v1.0.5 again.

See below where to find the module.

Image
User avatar

moffacostanzo
Donator
Donator
Posts: 151
Joined: 30 Oct 2015, 10:34
    Windows 7 Firefox

Re: Download System

Post by moffacostanzo »

Ok i reinstall en ext
i create a category but if i set anable a announce new download appears this one

Code: Select all

Errore Generale
SQL ERROR [ mysqli ]

Column 'topic_desc' cannot be null [1048]

SQL

INSERT INTO phpbb_topics (topic_poster, topic_time, topic_last_view_time, forum_id, icon_id, topic_posts_approved, topic_posts_softdeleted, topic_posts_unapproved, topic_visibility, topic_delete_user, topic_title, topic_first_poster_name, topic_first_poster_colour, topic_type, topic_time_limit, topic_attachment, topic_status, topic_desc) VALUES (2, 1481490428, 1481490428, '45', 0, 1, 0, 0, 1, 0, 'Informatica per grandi e piccoli', 'costanzo', 'FF8000', 0, 0, 0, '0', NULL)

BACKTRACE

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

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

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

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

FILE: [ROOT]/includes/functions_posting.php
LINE: 1934
CALL: phpbb\db\driver\factory->sql_query()

FILE: [ROOT]/ext/dmzx/downloadsystem/controller/admin_controller.php
LINE: 2022
CALL: submit_post()

FILE: [ROOT]/ext/dmzx/downloadsystem/controller/admin_controller.php
LINE: 873
CALL: dmzx\downloadsystem\controller\admin_controller->create_announcement()

FILE: [ROOT]/ext/dmzx/downloadsystem/acp/downloadsystem_module.php
LINE: 79
CALL: dmzx\downloadsystem\controller\admin_controller->add_new()

FILE: [ROOT]/includes/functions_module.php
LINE: 674
CALL: dmzx\downloadsystem\acp\downloadsystem_module->main()

FILE: [ROOT]/adm/index.php
LINE: 81
CALL: p_master->load_active()
Last edited by moffacostanzo on 13 Dec 2016, 17:22, edited 2 times in total.
User avatar

Unantastbar
Users
Users
Posts: 20
Joined: 18 Jul 2016, 16:58
    Windows 10 Firefox

Re: Download System

Post by Unantastbar »

Thx for the Update, it works fine on my Testforum. :thumbup:
User avatar

iorG19
Translators
Translators
Posts: 60
Joined: 10 Dec 2014, 21:50
    Windows 10 Chrome

Re: Download System

Post by iorG19 »

It's possible to have parent categories ?
Image Some [romanian] and [spanish] translations of extensions.
User avatar

Topic Author
dmzx
Founder
Founder
Posts: 6482
Joined: 13 Jan 2014, 21:45
    Windows 10 Chrome

Re: Download System

Post by dmzx »

iorG19 wrote: 19 Dec 2016, 15:34 it's possible to have parent categories ?
No at this moment not, maybe future... cannot say.
User avatar

iorG19
Translators
Translators
Posts: 60
Joined: 10 Dec 2014, 21:50
    Windows 10 Chrome

Re: Download System

Post by iorG19 »

dmzx wrote: 19 Dec 2016, 15:45
iorG19 wrote: 19 Dec 2016, 15:34 it's possible to have parent categories ?
No at this moment not, maybe future... cannot say.
and what about attachment quota (posibility to set maximum attachment file per file and global per user: in bytes, or kilobytes) and extension types (.xml, .rar, .pdf,...) :oops:
User avatar

Topic Author
dmzx
Founder
Founder
Posts: 6482
Joined: 13 Jan 2014, 21:45
    Windows 10 Chrome

Re: Download System

Post by dmzx »

iorG19 wrote: 19 Dec 2016, 15:49
dmzx wrote: 19 Dec 2016, 15:45
iorG19 wrote: 19 Dec 2016, 15:34 it's possible to have parent categories ?
No at this moment not, maybe future... cannot say.
and what about attachment quota (posibility to set maximum attachment file per file and global per user: in bytes, or kilobytes) and extension types (.xml, .rar, .pdf,...) :oops:
See here for allowed_extensions https://github.com/dmzx/Download-System ... r.php#L635 you can add them also if not listed.
Remember to do it also in edit part of same file.

Maximum attachment size depends on php upload_max_filesize settings and can only be changed there.(for all type of files so not independent)
User avatar

iorG19
Translators
Translators
Posts: 60
Joined: 10 Dec 2014, 21:50
    Windows 10 Chrome

Re: Download System

Post by iorG19 »

I wonder how to add lines for (default) topic. Let me explain; i want to change this:

From: language/en/common.php (line 109)
Find This may be a partial find and not the whole line

Code: Select all

we have a new download!

Title: [b]%1$s[/b]
Description: [b]%2$s[/b]
Category: [b]%3$s[/b]
Click [b]%4$s[/b] to go to the download page!
to this:
Replace with Replace the preceding lines with the following

Code: Select all

[color=purple][size=120][b]Title:[/b][/size][/color] %1$s
[color=purple][size=120][b]Author:[/b][/size][/color] %2$s
[color=purple][size=120][b]Description:[/b][/size][/color] %3$s
[color=purple][size=120][b]Category:[/b][/size][/color] %4$s
[color=purple][size=120][b]Requirements:[/b][/size][/color] %5$s
[color=purple][size=120][b]Click[/b][/size][/color] [i]%6$s[/i] to go to the download page!
But i don't know if it's correct; i mean if you need to add some sentences. Cheers!
User avatar

Topic Author
dmzx
Founder
Founder
Posts: 6482
Joined: 13 Jan 2014, 21:45
    Windows 10 Chrome

Re: Download System

Post by dmzx »

Yes you can do like that.
User avatar

Topic Author
dmzx
Founder
Founder
Posts: 6482
Joined: 13 Jan 2014, 21:45
    Windows 10 Chrome

Re: Download System

Post by dmzx »

First post updated
Post Reply Previous topicNext topic

Return to “Extensions Database 3.2 / 3.3”