7webcreator
Member
Hello,
One of my lists with the following code on the calc element plugins
$result = 0;
$quota_doch_id = '{calendario_2022_23a___quota_docente_raw}';
$quota_docy_id = '{calendario_2022_23a___nrlezioni_raw}';
if (!empty($quota_doch_id) && !empty($quota_docy_id)) {
$myDb = JFactory::getDbo();
$myQuery = $myDb->getQuery(true);
$myQuery->select('nbre_heure_an')->from('packages')->where('id = ' . $myDb->quote($quota_docy_id));
$myDb->setQuery($myQuery);
$quota_docy = $myDb->loadResult();
$myQuery->clear()->select('quota_docente')->from('quota_corsi')->where('id = ' . $myDb->quote($quota_doch_id));
$myDb->setQuery($myQuery);
$quota_doch = $myDb->loadResult();
$result = $quota_doch * $quota_docy;
}
return $result;
throws this error message:
0 Illegal offset type
Debug: Eval exception : quota_doc_year (id 5181):reFormatFormJoins() : $result = 0; $quota_doch_id = '5'; $quota_docy_id = '5'; if (!empty($quota_doch_id) && !empty($quota_docy_id)) { $myDb = JFactory::getDbo(); $myQuery = $myDb->getQuery(true); $myQuery->select('nbre_heure_an')->from('packages')->where('id = ' . $myDb->quote($quota_docy_id)); $myDb->setQuery($myQuery); $quota_docy = $myDb->loadResult(); $myQuery->clear()->select('quota_docente')->from('quota_corsi')->where('id = ' . $myDb->quote($quota_doch_id)); $myDb->setQuery($myQuery); $quota_doch = $myDb->loadResult(); $result = $quota_doch * $quota_docy; } return $result; : Joomla\CMS\Factory::getDbo() is deprecated. Load the database from the dependency injection container.
Any idea why?
Joomla! 4.3.4 - Fabrik Epsilon - PHP 8.1.21 - Template Cassipoeia
Thank you for your help.
One of my lists with the following code on the calc element plugins
$result = 0;
$quota_doch_id = '{calendario_2022_23a___quota_docente_raw}';
$quota_docy_id = '{calendario_2022_23a___nrlezioni_raw}';
if (!empty($quota_doch_id) && !empty($quota_docy_id)) {
$myDb = JFactory::getDbo();
$myQuery = $myDb->getQuery(true);
$myQuery->select('nbre_heure_an')->from('packages')->where('id = ' . $myDb->quote($quota_docy_id));
$myDb->setQuery($myQuery);
$quota_docy = $myDb->loadResult();
$myQuery->clear()->select('quota_docente')->from('quota_corsi')->where('id = ' . $myDb->quote($quota_doch_id));
$myDb->setQuery($myQuery);
$quota_doch = $myDb->loadResult();
$result = $quota_doch * $quota_docy;
}
return $result;
throws this error message:
0 Illegal offset type
Debug: Eval exception : quota_doc_year (id 5181):reFormatFormJoins() : $result = 0; $quota_doch_id = '5'; $quota_docy_id = '5'; if (!empty($quota_doch_id) && !empty($quota_docy_id)) { $myDb = JFactory::getDbo(); $myQuery = $myDb->getQuery(true); $myQuery->select('nbre_heure_an')->from('packages')->where('id = ' . $myDb->quote($quota_docy_id)); $myDb->setQuery($myQuery); $quota_docy = $myDb->loadResult(); $myQuery->clear()->select('quota_docente')->from('quota_corsi')->where('id = ' . $myDb->quote($quota_doch_id)); $myDb->setQuery($myQuery); $quota_doch = $myDb->loadResult(); $result = $quota_doch * $quota_docy; } return $result; : Joomla\CMS\Factory::getDbo() is deprecated. Load the database from the dependency injection container.
Any idea why?
Joomla! 4.3.4 - Fabrik Epsilon - PHP 8.1.21 - Template Cassipoeia
Thank you for your help.