ERROR - 2024-11-23 10:31:04 --> Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'schoolofdigitalv_dragrolife.order.order_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
CRITICAL - 2024-11-23 10:31:04 --> Call to a member function getResult() on bool
#0 /home/schoolofdigitalv/dragrolife.com/app/Controllers/Admin/Admin.php(29): App\Models\OrderModel->full_year_sales_data()
#1 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/CodeIgniter.php(832): App\Controllers\Admin\Admin->index()
#2 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/CodeIgniter.php(419): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Admin\Admin))
#3 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/CodeIgniter.php(326): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#4 /home/schoolofdigitalv/dragrolife.com/public/index.php(44): CodeIgniter\CodeIgniter->run()
#5 {main}
ERROR - 2024-11-23 10:33:43 --> Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'schoolofdigitalv_dragrolife.order.order_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
CRITICAL - 2024-11-23 10:33:43 --> Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'schoolofdigitalv_dragrolife.order.order_date' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
#0 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(292): mysqli->query('SELECT `order_d...', 0)
#1 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/Database/BaseConnection.php(670): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `order_d...')
#2 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/Database/BaseConnection.php(598): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `order_d...')
#3 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1455): CodeIgniter\Database\BaseConnection->query('SELECT `order_d...', Array, false)
#4 /home/schoolofdigitalv/dragrolife.com/app/Models/OrderModel.php(1451): CodeIgniter\Database\BaseBuilder->get()
#5 /home/schoolofdigitalv/dragrolife.com/app/Controllers/Admin/Admin.php(29): App\Models\OrderModel->full_year_sales_data()
#6 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/CodeIgniter.php(832): App\Controllers\Admin\Admin->index()
#7 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/CodeIgniter.php(419): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Admin\Admin))
#8 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/CodeIgniter.php(326): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#9 /home/schoolofdigitalv/dragrolife.com/public/index.php(44): CodeIgniter\CodeIgniter->run()
#10 {main}
ERROR - 2024-11-23 10:35:00 --> Incorrect DATE value: ''
CRITICAL - 2024-11-23 10:35:00 --> Incorrect DATE value: ''
#0 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(292): mysqli->query('SELECT `users`....', 0)
#1 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/Database/BaseConnection.php(670): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `users`....')
#2 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/Database/BaseConnection.php(598): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `users`....')
#3 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1455): CodeIgniter\Database\BaseConnection->query('SELECT `users`....', Array, false)
#4 /home/schoolofdigitalv/dragrolife.com/app/Models/OrderModel.php(137): CodeIgniter\Database\BaseBuilder->get()
#5 /home/schoolofdigitalv/dragrolife.com/app/Controllers/Admin/Order.php(41): App\Models\OrderModel->get_all_order('', '2024-11-23')
#6 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/CodeIgniter.php(832): App\Controllers\Admin\Order->all_order()
#7 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/CodeIgniter.php(419): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Admin\Order))
#8 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/CodeIgniter.php(326): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#9 /home/schoolofdigitalv/dragrolife.com/public/index.php(44): CodeIgniter\CodeIgniter->run()
#10 {main}
ERROR - 2024-11-23 10:35:25 --> Incorrect DATE value: ''
CRITICAL - 2024-11-23 10:35:25 --> Incorrect DATE value: ''
#0 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(292): mysqli->query('SELECT `users`....', 0)
#1 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/Database/BaseConnection.php(670): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `users`....')
#2 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/Database/BaseConnection.php(598): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `users`....')
#3 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1455): CodeIgniter\Database\BaseConnection->query('SELECT `users`....', Array, false)
#4 /home/schoolofdigitalv/dragrolife.com/app/Models/OrderModel.php(137): CodeIgniter\Database\BaseBuilder->get()
#5 /home/schoolofdigitalv/dragrolife.com/app/Controllers/Admin/Order.php(41): App\Models\OrderModel->get_all_order('', '2024-11-23')
#6 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/CodeIgniter.php(832): App\Controllers\Admin\Order->all_order()
#7 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/CodeIgniter.php(419): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Admin\Order))
#8 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/CodeIgniter.php(326): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#9 /home/schoolofdigitalv/dragrolife.com/public/index.php(44): CodeIgniter\CodeIgniter->run()
#10 {main}
ERROR - 2024-11-23 10:37:33 --> Incorrect DATE value: ''
CRITICAL - 2024-11-23 10:37:33 --> Incorrect DATE value: ''
#0 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/Database/MySQLi/Connection.php(292): mysqli->query('SELECT `order`....', 0)
#1 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/Database/BaseConnection.php(670): CodeIgniter\Database\MySQLi\Connection->execute('SELECT `order`....')
#2 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/Database/BaseConnection.php(598): CodeIgniter\Database\BaseConnection->simpleQuery('SELECT `order`....')
#3 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/Database/BaseBuilder.php(1455): CodeIgniter\Database\BaseConnection->query('SELECT `order`....', Array, false)
#4 /home/schoolofdigitalv/dragrolife.com/app/Models/OrderModel.php(650): CodeIgniter\Database\BaseBuilder->get()
#5 /home/schoolofdigitalv/dragrolife.com/app/Controllers/Admin/Order.php(114): App\Models\OrderModel->all_dealer_order_added_by('', '2024-11-23')
#6 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/CodeIgniter.php(832): App\Controllers\Admin\Order->all_dealer_order()
#7 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/CodeIgniter.php(419): CodeIgniter\CodeIgniter->runController(Object(App\Controllers\Admin\Order))
#8 /home/schoolofdigitalv/dragrolife.com/vendor/codeigniter4/framework/system/CodeIgniter.php(326): CodeIgniter\CodeIgniter->handleRequest(NULL, Object(Config\Cache), false)
#9 /home/schoolofdigitalv/dragrolife.com/public/index.php(44): CodeIgniter\CodeIgniter->run()
#10 {main}