In aggregated without GROUP BY error - Printable Version +- CodeIgniter Forums (https://forum.codeigniter.com) +-- Forum: Using CodeIgniter (https://forum.codeigniter.com/forumdisplay.php?fid=5) +--- Forum: General Help (https://forum.codeigniter.com/forumdisplay.php?fid=24) +--- Thread: In aggregated without GROUP BY error (/showthread.php?tid=67505) |
In aggregated without GROUP BY error - doomie22 - 03-01-2017 Hi all, I have recently updated my local WAMP testing platform to version 3 (I know, bad mistake). Something that was previously working fine is now coming up with this big error and I really don't know what it means. This is what is in the controller: PHP Code: $data['this_month_uniques'] = $this->Analytics_model->get_month_page_views('0 months', true, 'unique_hits'); This is what is in the model: PHP Code: public function get_month_page_views($month_num, $total = false, $column){ This is the error that I am getting Quote:Error Number: 1140 Can anyone help please with understanding this error? Thanks, Doomie RE: In aggregated without GROUP BY error - JayAdra - 03-01-2017 I had the same issue, see the following answer for a well-put explanation: http://stackoverflow.com/a/38551525 RE: In aggregated without GROUP BY error - doomie22 - 03-02-2017 I have been looking at this post but I just cannot understand what it really means and how I can fix it |