qsqlquery – Tarik Billa

How to group items from database and display them – Android

August 10, 2023 by Tarik

It looks like you are trying to get results similar to the following SQL: select sort, grade, count(grade), sum(mass), price from logs where receiptid = forwardedId group by sort, grade; You show the displayed count computed as logList.size(). Instead, if you are going to have the database group the records, you will want to get … Read more

Laravel : Syntax error or access violation: 1055 Error

November 30, 2022 by Tarik

Short answer In config\database.php –> “mysql” array Set ‘strict’ => false to disable all. …. or You can leave ‘strict’ => true and add modes to “mysql” option in ‘mysql’ => [ … …. ‘strict’ => true, ‘modes’ => [ //’ONLY_FULL_GROUP_BY’, // Disable this to allow grouping by one column ‘STRICT_TRANS_TABLES’, ‘NO_ZERO_IN_DATE’, ‘NO_ZERO_DATE’, ‘ERROR_FOR_DIVISION_BY_ZERO’, ‘NO_AUTO_CREATE_USER’, … Read more