Question: New install of latest verasion but BLANK page

New install of latest verasion but BLANK page

Hi i went through the installation process for version 1.4 step by step but i'm only getting a blank page after installation. Error log. (i have replaced my username and domain with myusern

BM

BCG Mobile

Asked

Hi i went through the installation process for version 1.4 step by step but i’m only getting a blank page after installation. Error log. (i have replaced my username and domain with myusername and mydomain.com for security reasons)

<?php defined('BASEPATH') OR exit('No direct script access allowed'); ?>

ERROR - 2019-10-26 01:52:58 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bcgmobil_solarpanelforums.tec_topics.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT `tec_topics`.*, `tec_categories`.`name` as `category`, `subcategories`.`name` as `child_category`, `tec_users`.`id` as `user_id`, `tec_users`.`username`, `tec_users`.`avatar`, `tec_users`.`gender` as `user_gender`, `tec_posts`.`body`, COUNT(tec_posts.id) as total_posts
FROM `tec_topics`
LEFT JOIN `tec_posts` ON `tec_posts`.`topic_id`=`tec_topics`.`id`
LEFT JOIN `tec_categories` ON `tec_categories`.`id`=`tec_topics`.`category_id`
LEFT JOIN `tec_categories` `subcategories` ON `subcategories`.`id`=`tec_topics`.`child_category_id`
LEFT JOIN `tec_users` ON `tec_users`.`id`=`tec_topics`.`created_by`
WHERE `tec_categories`.`active` = 1
AND `protected` = 0
AND `tec_topics`.`status` = 1
GROUP BY `tec_posts`.`topic_id`
ORDER BY `sticky` DESC, `tec_posts`.`created_at` DESC
 LIMIT 10
ERROR - 2019-10-26 01:52:58 --> Severity: error --> Exception: Call to a member function num_rows() on boolean /home/myusername/public_html/mydomain.com/forums/app/models/Forums_model.php 161
INFO - 2019-10-26 01:54:53 --> Config Class Initialized
INFO - 2019-10-26 01:54:53 --> Hooks Class Initialized
DEBUG - 2019-10-26 01:54:53 --> UTF-8 Support Enabled
INFO - 2019-10-26 01:54:53 --> Utf8 Class Initialized
INFO - 2019-10-26 01:54:53 --> URI Class Initialized
DEBUG - 2019-10-26 01:54:53 --> No URI present. Default controller set.
INFO - 2019-10-26 01:54:53 --> Router Class Initialized
INFO - 2019-10-26 01:54:53 --> Output Class Initialized
INFO - 2019-10-26 01:54:53 --> Security Class Initialized
DEBUG - 2019-10-26 01:54:53 --> Global POST, GET and COOKIE data sanitized
INFO - 2019-10-26 01:54:53 --> CSRF cookie sent
INFO - 2019-10-26 01:54:53 --> Input Class Initialized
INFO - 2019-10-26 01:54:53 --> Language Class Initialized
INFO - 2019-10-26 01:54:53 --> Loader Class Initialized
INFO - 2019-10-26 01:54:53 --> Helper loaded: url_helper
INFO - 2019-10-26 01:54:53 --> Helper loaded: form_helper
INFO - 2019-10-26 01:54:53 --> Helper loaded: cookie_helper
INFO - 2019-10-26 01:54:53 --> Helper loaded: language_helper
INFO - 2019-10-26 01:54:53 --> Helper loaded: date_helper
INFO - 2019-10-26 01:54:53 --> Database Driver Class Initialized
INFO - 2019-10-26 01:54:53 --> Session: Class initialized using 'database' driver.
INFO - 2019-10-26 01:54:53 --> Model "Settings_model" initialized
INFO - 2019-10-26 01:54:53 --> Controller Class Initialized
INFO - 2019-10-26 01:54:53 --> Language file loaded: language/english/app_lang.php
DEBUG - 2019-10-26 01:54:53 --> Config file loaded: /home/myusername/public_html/mydomain.com/forums/app/config/hybridauthlib.php
INFO - 2019-10-26 01:54:53 --> Helper loaded: smiley_helper
INFO - 2019-10-26 01:54:53 --> Form Validation Class Initialized
INFO - 2019-10-26 01:54:53 --> Model "Forums_model" initialized
INFO - 2019-10-26 01:54:53 --> Helper loaded: pagination_helper
INFO - 2019-10-26 01:54:53 --> Language file loaded: language/english/pagination_lang.php
INFO - 2019-10-26 01:54:53 --> Pagination Class Initialized
ERROR - 2019-10-26 01:54:53 --> Query error: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'myusername_solarpanelforums.tec_topics.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by - Invalid query: SELECT `tec_topics`.*, `tec_categories`.`name` as `category`, `subcategories`.`name` as `child_category`, `tec_users`.`id` as `user_id`, `tec_users`.`username`, `tec_users`.`avatar`, `tec_users`.`gender` as `user_gender`, `tec_posts`.`body`, COUNT(tec_posts.id) as total_posts
FROM `tec_topics`
LEFT JOIN `tec_posts` ON `tec_posts`.`topic_id`=`tec_topics`.`id`
LEFT JOIN `tec_categories` ON `tec_categories`.`id`=`tec_topics`.`category_id`
LEFT JOIN `tec_categories` `subcategories` ON `subcategories`.`id`=`tec_topics`.`child_category_id`
LEFT JOIN `tec_users` ON `tec_users`.`id`=`tec_topics`.`created_by`
WHERE `tec_categories`.`active` = 1
AND `protected` = 0
AND `tec_topics`.`status` = 1
GROUP BY `tec_posts`.`topic_id`
ORDER BY `sticky` DESC, `tec_posts`.`created_at` DESC
 LIMIT 10
ERROR - 2019-10-26 01:54:53 --> Severity: error --> Exception: Call to a member function num_rows() on boolean /home/myusername/public_html/mydomain.com/forums/app/models/Forums_model.php 161

  • BM

    BCG Mobile

    Answered

    Maybe it’s because only_full_group_by? I’m trying to get my hosting company to disable it to see if that works

  • MS

    Mian Saleem

    Answered

    Yes, it’s due to mysql only_full_group_by mode. Please disable it and try your site again. Thank you

  • BM

    BCG Mobile

    Answered

    Working now. After my hosting company disabled it.

  • Login to Reply