( ! ) Deprecated: Return type of PhpOffice\PhpSpreadsheet\Worksheet\Iterator::valid() should either be compatible with Iterator::valid(): bool, or the #[\ReturnTypeWillChange] attribute should be used to temporarily suppress the notice in /var/www/html/plugins/sendmail/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Iterator.php on line 69
Call Stack
#TimeMemoryFunctionLocation
10.0007448576{main}( ).../little_joy.php:0
20.09231437848PhpOffice\PhpSpreadsheet\Worksheet\Worksheet->setTitle( $title = 'Stok', $updateFormulaCellReferences = ???, $validate = ??? ).../little_joy.php:35
30.09231437848PhpOffice\PhpSpreadsheet\ReferenceHelper->updateNamedFormulas( $spreadsheet = class PhpOffice\PhpSpreadsheet\Spreadsheet { private $uniqueID = '6a100ce780ee39.83823529'; private $properties = class PhpOffice\PhpSpreadsheet\Document\Properties { private $creator = 'Unknown Creator'; private $lastModifiedBy = 'Unknown Creator'; private $created = 1779436775; private $modified = 1779436775; private $title = 'Untitled Spreadsheet'; private $description = ''; private $subject = ''; private $keywords = ''; private $category = ''; private $manager = ''; private $company = ''; private $customProperties = [...] }; private $security = class PhpOffice\PhpSpreadsheet\Document\Security { private $lockRevision = FALSE; private $lockStructure = FALSE; private $lockWindows = FALSE; private $revisionsPassword = ''; private $workbookPassword = '' }; private $workSheetCollection = [0 => class PhpOffice\PhpSpreadsheet\Worksheet\Worksheet { ... }]; private $calculationEngine = class PhpOffice\PhpSpreadsheet\Calculation\Calculation { private $spreadsheet = ...; private $calculationCache = [...]; private $calculationCacheEnabled = TRUE; private $branchStoreKeyCounter = 0; private $branchPruningEnabled = TRUE; private $debugLog = class PhpOffice\PhpSpreadsheet\Calculation\Engine\Logger { ... }; public $suppressFormulaErrors = FALSE; public $formulaError = NULL; private $cyclicReferenceStack = class PhpOffice\PhpSpreadsheet\Calculation\Engine\CyclicReferenceStack { ... }; private $cellStack = [...]; private $cyclicFormulaCounter = 1; private $cyclicFormulaCell = ''; public $cyclicFormulaCount = 1; private $delta = 1.0E-14 }; private $activeSheetIndex = 0; private $definedNames = []; private $cellXfSupervisor = class PhpOffice\PhpSpreadsheet\Style\Style { protected $isSupervisor = TRUE; protected $parent = ...; protected $parentPropertyName = NULL; protected $font = class PhpOffice\PhpSpreadsheet\Style\Font { ... }; protected $fill = class PhpOffice\PhpSpreadsheet\Style\Fill { ... }; protected $borders = class PhpOffice\PhpSpreadsheet\Style\Borders { ... }; protected $alignment = class PhpOffice\PhpSpreadsheet\Style\Alignment { ... }; protected $numberFormat = class PhpOffice\PhpSpreadsheet\Style\NumberFormat { ... }; protected $protection = class PhpOffice\PhpSpreadsheet\Style\Protection { ... }; protected $index = NULL; protected $quotePrefix = FALSE }; private $cellXfCollection = [0 => class PhpOffice\PhpSpreadsheet\Style\Style { ... }]; private $cellStyleXfCollection = [0 => class PhpOffice\PhpSpreadsheet\Style\Style { ... }]; private $hasMacros = FALSE; private $macrosCode = NULL; private $macrosCertificate = NULL; private $ribbonXMLData = NULL; private $ribbonBinObjects = NULL; private $unparsedLoadedData = []; private $showHorizontalScroll = TRUE; private $showVerticalScroll = TRUE; private $showSheetTabs = TRUE; private $minimized = FALSE; private $autoFilterDateGrouping = TRUE; private $firstSheetIndex = 0; private $visibility = 'visible'; private $tabRatio = 600 }, $oldName = 'Worksheet', $newName = 'Stok' ).../Worksheet.php:892
40.09231437848PhpOffice\PhpSpreadsheet\Spreadsheet->getWorksheetIterator( ).../ReferenceHelper.php:937
50.09231437848Composer\Autoload\ClassLoader->loadClass( $class = 'PhpOffice\\PhpSpreadsheet\\Worksheet\\Iterator' ).../Spreadsheet.php:1099
60.09231438008Composer\Autoload\{closure:/var/www/html/plugins/sendmail/vendor/composer/ClassLoader.php:575-577}( $file = '/var/www/html/plugins/sendmail/vendor/composer/../phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Iterator.php' ).../ClassLoader.php:427
70.09251438568include( '/var/www/html/plugins/sendmail/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Iterator.php ).../ClassLoader.php:576

( ! ) Fatal error: Uncaught mysqli_sql_exception: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'freshfactory_db.i.product_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /var/www/html/plugins/sendmail/little_joy.php on line 67
( ! ) mysqli_sql_exception: Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'freshfactory_db.i.product_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by in /var/www/html/plugins/sendmail/little_joy.php on line 67
Call Stack
#TimeMemoryFunctionLocation
10.0007448576{main}( ).../little_joy.php:0
20.09321457928query( $query = '\r\nselect products.sku_number, products.name as product_name, item.expired, SUM(item.stock) as stock\r\nfrom (SELECT i.product_id, DATE(i.date_expired) as expired, COUNT(*) as stock\r\nFROM ikuses i \r\n\r\nWHERE i.status = \'stored\' and i.tenant_id = \'850f1e20-a6bb-4203-8283-152d4d2f11f9\'\r\nGROUP BY expired\r\n\r\nunion\r\n\r\nSELECT i.product_id, DATE(i.date_expired) as expired, SUM(i.boxContain) as stock\r\nFROM bkuses i \r\n\r\nWHERE i.status = \'stored\' and i.tenant_id = \'850f1e20-a6bb-4203-8283-152d4d2f11f9\'\r\nGROUP BY expired'... ).../little_joy.php:67