( ! ) 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.0029452704{main}( ).../banyan_stock.php:0
20.0243848544PhpOffice\PhpSpreadsheet\Worksheet\Worksheet->setTitle( $title = 'Inbound', $updateFormulaCellReferences = ???, $validate = ??? ).../banyan_stock.php:33
30.0243848544PhpOffice\PhpSpreadsheet\ReferenceHelper->updateNamedFormulas( $spreadsheet = class PhpOffice\PhpSpreadsheet\Spreadsheet { private $uniqueID = '6a5194c3e122e4.17615040'; private $properties = class PhpOffice\PhpSpreadsheet\Document\Properties { private $creator = 'Unknown Creator'; private $lastModifiedBy = 'Unknown Creator'; private $created = 1783731395; private $modified = 1783731395; 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 = 'Inbound' ).../Worksheet.php:892
40.0243848544PhpOffice\PhpSpreadsheet\Spreadsheet->getWorksheetIterator( ).../ReferenceHelper.php:937
50.0243848544Composer\Autoload\ClassLoader->loadClass( $class = 'PhpOffice\\PhpSpreadsheet\\Worksheet\\Iterator' ).../Spreadsheet.php:1099
60.0243848704Composer\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.0243849104include( '/var/www/html/plugins/sendmail/vendor/phpoffice/phpspreadsheet/src/PhpSpreadsheet/Worksheet/Iterator.php ).../ClassLoader.php:576
( ! ) Fatal error: Uncaught mysqli_sql_exception: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'freshfactory_db.reservations.created_at' 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/banyan_stock.php on line 69
( ! ) mysqli_sql_exception: Expression #3 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'freshfactory_db.reservations.created_at' 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/banyan_stock.php on line 69
Call Stack
#TimeMemoryFunctionLocation
10.0029452704{main}( ).../banyan_stock.php:0
20.0250869048query( $query = '\r\nSELECT inbound.*\r\nFROM(\r\nSELECT \r\n products.sku_number,\r\n products.name, \r\n DATE(reservations.created_at) created_at,\r\n tenants.id as tenant_id,\r\n CASE WHEN tenants.id = \'b20fc8ca-be46-49af-893b-bfcd43367048\' \r\n THEN SUM(CASE\r\n WHEN ikuses.status = \'stored\' THEN 1 ELSE 0\r\n END)\r\n ELSE 0 END as beginning_balance,\r\n \r\n CASE WHEN tenants.id = \'b20fc8ca-be46-49af-893b-bfcd43367048\' \r\n THEN SUM(CASE\r\n WHEN ikuse'... ).../banyan_stock.php:69