Support Request Supportlooking for help with

Support Section
Previous topicNext topic
User avatar

Topic Author
regchan
Users
Users
    Windows 10 Chrome
Magic user status: Offline
Posts: 3
Joined: Nov 22nd, '20, 17:14

looking for help with

Post by regchan »

Your phpBB Version: 3.3.2
Your phpBB Type: Standard phpBB
Extensions installed: Yes
Your knowledge: Beginner

PHP Version: 7.3.24

What have you done before the problem was there?
just installed it
goes to download from main site then

General Error
SQL ERROR [ mysqli ]

also downlading files do not work cant even download it


What have you already tried to solve the problem?
tryed looking at the settings but no luck clean install

Description and Message
User avatar

Topic Author
regchan
Users
Users
    Windows 10 Chrome
Magic user status: Offline
Posts: 3
Joined: Nov 22nd, '20, 17:14

Re: looking for help with

Post by regchan »

This is in relation with the download system

i am using bitnami stacks with this install
User avatar

Topic Author
regchan
Users
Users
    Windows 10 Chrome
Magic user status: Offline
Posts: 3
Joined: Nov 22nd, '20, 17:14

Re: looking for help with

Post by regchan »

QL ERROR [ mysqli ]

Expression #17 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bitnami_phpbb . 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: 1023
CALL: trigger_error()

FILE: [ROOT]/phpbb/db/driver/mysqli.php
LINE: 195
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: 296
CALL: phpbb\db\driver\mysql_base->_sql_query_limit()

FILE: [ROOT]/phpbb/db/driver/factory.php
LINE: 337
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: [ROOT]/vendor/symfony/http-kernel/HttpKernel.php
LINE: 151
CALL: dmzx\downloadsystem\controller\download->handle_downloadsystem()

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

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