Advertisement:

Author Topic: Download System  (Read 614422 times)

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 20,128
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Download System
« Reply #2140 on: May 16, 2018, 11:12:09 AM »
action=downloads;sa=addcat
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline locutusweb

  • Semi-Newbie
  • *
  • Posts: 83
Re: Download System
« Reply #2141 on: May 17, 2018, 10:45:23 AM »
action=downloads;sa=addcat
Thanks; that worked!

Offline wintstar

  • Semi-Newbie
  • *
  • Posts: 97
  • Carpe diem!
    • SF Webdesign
Re: Download System
« Reply #2142 on: May 18, 2018, 12:45:19 PM »
Error at install of 2.1.Beta4 newest Pull Request
Version Information:
Forum Version: SMF 2.1 Beta 4
Aktuelle SMF Version: SMF 2.1 Beta 3
GD Version: bundled (2.1.0 compatible)
MySQLi System: MySQL
MySQLi Version: 5.6.39-log
PHP: 7.1.17
Server Version: Apache/2.4.33 (Unix)

.p.commenttotal' isn't in GROUP BY
Datei: /xxx/xxxx/xxx/xxx/xxxx/htdocs/xxxxx/xxxxxx/board/Sources/Downloads2.php

error log:
Type of error: Database
Database Error: '.p.commenttotal' isn't in GROUP BY
board/index.php?action=downloads
/board/Sources/Downloads2.php
(Line 5360)

My settings:

Offline wintstar

  • Semi-Newbie
  • *
  • Posts: 97
  • Carpe diem!
    • SF Webdesign
Re: Download System
« Reply #2143 on: May 18, 2018, 01:01:19 PM »
If the setting for comments and ratings are disabled you can create a category. But after clicking on "Send category" the next error message appears.


Mixing of GROUP columns (MIN(),MAX(),COUNT(),...) with no GROUP columns is illegal if there is no GROUP BY clause
File: /board/Sources/Downloads2.php
Line: 664

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 20,128
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Download System
« Reply #2144 on: May 18, 2018, 01:04:07 PM »
Your server probably has ONLY_FULL_GROUP_BY turned on. You can try to turn it off
http://dev.mysql.com/doc/refman/5.7/en/sql-mode.html#sqlmode_only_full_group_by
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline wintstar

  • Semi-Newbie
  • *
  • Posts: 97
  • Carpe diem!
    • SF Webdesign
Re: Download System
« Reply #2145 on: May 18, 2018, 01:12:24 PM »
There are no error messages on the same server in the same database with SMF 2.0.15.

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 20,128
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Download System
« Reply #2146 on: May 18, 2018, 01:16:24 PM »
It's a MYSQL server configuration issue.
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline wintstar

  • Semi-Newbie
  • *
  • Posts: 97
  • Carpe diem!
    • SF Webdesign
Re: Download System
« Reply #2147 on: May 18, 2018, 01:21:36 PM »
There are no error messages on the same server in the same database with SMF 2.0.15.
Why do I not get an error message with SMF 2.0.15 on the same server in the same database?
Why do the bugs only come with SMF 2.1.Beta*?

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 20,128
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Download System
« Reply #2148 on: May 18, 2018, 01:23:43 PM »
No idea
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline wintstar

  • Semi-Newbie
  • *
  • Posts: 97
  • Carpe diem!
    • SF Webdesign
Re: Download System
« Reply #2149 on: May 18, 2018, 04:11:08 PM »
My solution. This works.
all changes in Downloads2.php

line at 659
Code: [Select]
    // Do the order
    $dbresult = $smcFunc['db_query']('', "
    SELECT
        MAX(roworder) as cat_order
    FROM {db_prefix}down_cat
    WHERE ID_PARENT = $parent
    ORDER BY roworder DESC");
    $row = $smcFunc['db_fetch_assoc']($dbresult);
replace with
Code: [Select]
    // Do the order
    $dbresult = $smcFunc['db_query']('', "
    SELECT
        MAX(roworder) as cat_order
    FROM {db_prefix}down_cat
    WHERE ID_PARENT = $parent
    GROUP BY roworder
    ORDER BY roworder DESC");
    $row = $smcFunc['db_fetch_assoc']($dbresult);
GROUP BY roworder

line 5352
Code: [Select]
                $query = "SELECT p.ID_FILE, p.commenttotal, p.totalratings, p.rating, p.filesize, p.views, p.title, p.id_member, m.real_name, p.date, p.description,                p.totaldownloads
                    FROM {db_prefix}down_file as p
                    LEFT JOIN {db_prefix}members AS m  ON (m.id_member = p.id_member)
                    LEFT JOIN {db_prefix}down_catperm AS c ON (c.ID_GROUP IN ($groupsdata) AND c.ID_CAT = p.ID_CAT)
                    WHERE p.approved = 1 AND (c.view IS NULL || c.view =1) GROUP by p.ID_FILE ORDER BY $query_type DESC LIMIT 4";

replace with
Code: [Select]
                $queryselects = 'p.commenttotal, p.totalratings, p.rating, p.filesize, p.views, p.title, p.id_member, m.real_name, p.date, p.description, p.totaldownloads';
                $query = "SELECT p.ID_FILE, $queryselects
                    FROM {db_prefix}down_file as p
                    LEFT JOIN {db_prefix}members AS m  ON (m.id_member = p.id_member)
                    LEFT JOIN {db_prefix}down_catperm AS c ON (c.ID_GROUP IN ($groupsdata) AND c.ID_CAT = p.ID_CAT)
                    WHERE p.approved = 1 AND (c.view IS NULL || c.view =1) GROUP by p.ID_FILE, $queryselects
                    ORDER BY $query_type DESC LIMIT 4";
missing SELECT columns in GROUP

Offline rho_simafo

  • Semi-Newbie
  • *
  • Posts: 11
Re: Download System
« Reply #2150 on: June 13, 2018, 10:08:15 AM »
Hello all,

first of all, 1000 thanx for this wonderful mod.
Unfortunately I discovered a little problem: When visitors  are searching for a download, they get results of downloads which shall not be seen in the public because the set permissions shall prevent this. Finally when they click on the download link the download is prohibited, that's the good one. However, my wish is that visitors or members shall see only the download links which are dedicated o them.
Does anyone know how to prevent listing of potected download links in the search result?

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 20,128
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Download System
« Reply #2151 on: June 13, 2018, 11:05:44 AM »
What smf version are you using?
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro

Offline rho_simafo

  • Semi-Newbie
  • *
  • Posts: 11
Re: Download System
« Reply #2152 on: June 14, 2018, 07:54:53 AM »
What smf version are you using?
SMF 2.0.15
and
DownloadSystem 3.0.2

Offline SMFHacks.com Team

  • Jr. Member
  • **
  • Posts: 347
    • smfhacks on Facebook
    • @smfhacks on Twitter
    • SMFHacks.com
Re: Download System
« Reply #2153 on: June 14, 2018, 08:26:52 AM »
Update
3.0.3
!Fixed showing hidden categories in search results
Disclaimer: SMFHacks.com Team is not affiliated with the SMF Team or the SimpleMachines NPO.

http://ForumRankings.net - Get Forum Ranked!
SMFHacks.com -  Paid Modifications for SMF
Latest Mods:
Community Suite
Newsletter Pro SMF Gallery Pro SMF Classifieds SMF Store

Offline rho_simafo

  • Semi-Newbie
  • *
  • Posts: 11
Re: Download System
« Reply #2154 on: June 14, 2018, 11:25:07 AM »
Great! Now it works fine :-*

Offline vbgamer45

  • SMF Friend
  • SMF Super Hero
  • *
  • Posts: 20,128
    • smfhacks on Facebook
    • VBGAMER45 on GitHub
    • @createaforum on Twitter
    • SMF For Free
Re: Download System
« Reply #2155 on: June 14, 2018, 11:44:03 AM »
Glad to help
Community Suite for SMF - Take your forum to the next level built for SMF, Gallery,Store,Classifieds,Downloads,more!

SMFHacks.com -  Paid Modifications for SMF

Mods:
EzPortal - Portal System for SMF
SMF Gallery Pro
SMF Store SMF Classifieds Ad Seller Pro