WebsiteBaker Support (2.13.x) > General Help & Support

"There was an uncatched exception" under Pages tab after new installation

(1/3) > >>

seanie_morris:
Hi,
I have a brand new installation today of WB 2.13.4 on a new website I am doing.
The unzip process worked except for the following error message, which is under the 'Pages' tab, so I cannot add pages:
There was an uncatched exception
Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db1363538_stemdb.s. module' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
in line (828) of (/framework/class.database.php):

When searching for a fix for this, I did find this as the closest match:
https://forum.WebsiteBaker.org/index.php/topic,32203.0.html
But nothing worked.

Here lines 825 to 832 in class.database.php

public function getQuery(string $sStatement)
    {
//echo \nl2br(\sprintf("---- [%04d] %s %s \n",__LINE__,$sStatement,$_SERVER["SCRIPT_NAME"]),false);
    if (false === ($this->result = $this->oDbHandle->query($sStatement))) {
        $this->error = $this->oDbHandle->error;
    }
        return $this->result;
    }


From my hosting provider, here is what I have:
PHP 8.1
MySQL5 Databases C (Server version: 5.7.42)
Apache Website

Any help is appreciated!

Thanks,
Seanie.

Luisehahne:
Error can be found in my.ini file from mysql
sql_mode=only_full_group_by should be removed or changed with
sql_mode="STRICT_ALL_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,NO_ENGINE_SUBSTITUTION"
other solution i found on https://database.guide/6-ways-to-fix-error-1055-expression-of-select-list-is-not-in-group-by-clause-and-contains-nonaggregated-column-in-mysql/
i will be going to test and fix  it in  2.13.4 and will be publish a patch.
Sorry for the trouble 8-)

Dietmar

Luisehahne:
Best solution: Please ask your provider to drop only_full_group_by from sql_mode.

Read following blog: How do I disable ONLY_FULL_GROUP_BY in MySQL?

if you Disable Only_full_group_by from the PHPMyAdmin changes only active until mysql server is restartet

Dietmar

crnogorac081:
Or,

in /admin/pages/index.php

line 125 replace

--- Code: ---             .        's.`module`, MAX(s.`publ_start` + s.`publ_end`) published, p.`link`, '

--- End code ---
With

--- Code: ---              .        ' MAX(s.`publ_start` + s.`publ_end`) published, p.`link`, '

--- End code ---

delete s.`module`,

I see no changes in db output, nor that s.module is needed somewhere in code below

seanie_morris:
Thanks for the replies folks.

I went for the quick option:


--- Quote from: crnogorac081 on August 30, 2023, 12:12:37 PM ---Or,
in /admin/pages/index.php
line 125 replace

--- Code: ---             .        's.`module`, MAX(s.`publ_start` + s.`publ_end`) published, p.`link`, '

--- End code ---
With

--- Code: ---              .        ' MAX(s.`publ_start` + s.`publ_end`) published, p.`link`, '

--- End code ---
delete s.`module`,
--- End quote ---

This worked, and so far no other problems have surfaced. I can create new pages and everything else that goes with them.

Thank you!  8-)

Navigation

[0] Message Index

[#] Next page