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

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

<< < (2/3) > >>

sternchen8875:
not 100% accurate, my friend ;-)


--- Quote ---I see no changes in db output
--- End quote ---

s.`module` is the first entry (block#1) for this page_id in the section-table (see picture 1), but you're right, we dont use this information somewhere in the pages-list

Another solution for this case is: replace s.`module`, with GROUP_CONCAT(s.`module`),

GROUP_CONCAT(s.`module`) give a comma-separated list of all modules or sections for this page-id, but the same here: we dont use this informations somewhere in the pages-list


Picture 1 - original Select without  Only_full_group_by in sql_mode-settings




Picture 2 - select with Only_full_group_by in sql_mode-settings && GROUP_CONCAT(s.`module`) instead of s.`module`

crnogorac081:
But at the end I found another colum with entry


--- Code: ---1. wysiwyg
2. wysiwyg
3. code

--- End code ---
like sections list.

And this s.module is throwing only first section module, I cant find usefull this information.

sternchen8875:
this section list (your code) is used in the page overview for the onhover-function on the section-icon and is a result from this code in the select:

--- Code: ---  .        'GROUP_CONCAT(CAST(CONCAT(s.`section_id`, \' - \', s.`module`, \' \', s.`title`) AS CHAR) ORDER BY s.`position` SEPARATOR \'\n\') `section_list` '
--- End code ---






--- Quote ---I cant find usefull this information.
--- End quote ---

if you mean s.`module` in the select,  100% confirm   :-P


P.S.: i remember a section list like my picture in a former wb-version, but i think, it was WB 2.8.4 with a complete different code for the pages list

crnogorac081:
Lol never knew about this on hover.


Another solution for this case is: replace s.`module`, with GROUP_CONCAT(s.`module`),

So this is accepted solution rather than begging provider to chamge system settings

Luisehahne:
I have tested all the suggestions, unfortunately without success
The solution that works for me is to add to the GROUP BY all listed columns.

The sql statement looks like this for me now!

--- Code: ---
        $sql  = 'SELECT ( SELECT COUNT(*) '
              .          'FROM `'.$oDb->TablePrefix.'pages` `x` '
              .          'WHERE x.`parent`=p.`page_id`'
              .        ') `children`, '
              .        'MAX(s.`publ_start` + s.`publ_end`) published, '
              .        '(SELECT MAX(`position`) FROM `'.$oDb->TablePrefix.'pages` '
              .        'WHERE `parent`='.$parent.') max_position, '
              .        '0 min_position, '
              .        'p.`page_id`, '
              .        'p.`position`, p.`parent`, p.`link`, p.`level`, p.`language`, p.`admin_groups`, '
              .        'p.`admin_users`, p.`viewing_groups`, p.`viewing_users`, p.`visibility`, '
              .        'p.`menu_title`, p.`page_title`, p.`page_trail`, '
              .        'GROUP_CONCAT(CAST(CONCAT(s.`section_id`, \' - \', s.`module`, \' \', s.`title`) AS CHAR) ORDER BY s.`position` SEPARATOR \'\n\') `section_list` '
              . 'FROM `'.$oDb->TablePrefix.'pages` p '
              .    'INNER JOIN `'.$oDb->TablePrefix.'sections` s '
              .    'ON p.`page_id`=s.`page_id` '
              . 'WHERE `parent`='.$parent.' '
              .    (($oReg->PageTrash != 'inline') ? 'AND `visibility`!=\'deleted\' ' : '')
              . 'GROUP BY p.`page_id`,p.`position`, p.`parent`, p.`link`, p.`level`, p.`language`, p.`admin_groups`, '
              .        'p.`admin_users`, p.`viewing_groups`, p.`viewing_users`, p.`visibility`, '
              .        'p.`menu_title`, p.`page_title`, p.`page_trail` '
              . 'ORDER BY p.`position` ASC';


--- End code ---
If you like it, I will release a patch.

Dietmar

Navigation

[0] Message Index

[#] Next page

[*] Previous page