I have an Chrono Connection containing the following Where SQL-statement:
wedstrijd_jaar = <?php
global $jaar;
$db =& JFactory::getDBO();
$query = "SELECT `lopend_jaar` FROM `gpdtest_chronoforms_data_wedstrijdjaar` WHERE 1";
$db->setQuery($query);
$jaar = $db->loadResult();
echo $jaar?>
In Joomla 2.5 / ChronoConnectivity 4.0RC3.2 this query works fine. After upgrading to Joomla 3.4/ ChronoConnectivity 4.01 however this query gives an error:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '
Strict Standards: Only variables should be assigned by reference ' at line 1 SQL=SELECT count(*) AS `Total` FROM `jos_chronoforms_data_wedstrijdinschrijvingen` WHERE wedstrijd_jaar =
Strict Standards: Only variables should be assigned by reference in /home/deb57186/domains/tvgpd.nl/public_html/test/components/com_chronoconnectivity/libraries/chronoconnection.php(1347) : eval()'d code on line 3
2015
I can't figure out what's wrong.
wedstrijd_jaar = <?php
global $jaar;
$db =& JFactory::getDBO();
$query = "SELECT `lopend_jaar` FROM `gpdtest_chronoforms_data_wedstrijdjaar` WHERE 1";
$db->setQuery($query);
$jaar = $db->loadResult();
echo $jaar?>
In Joomla 2.5 / ChronoConnectivity 4.0RC3.2 this query works fine. After upgrading to Joomla 3.4/ ChronoConnectivity 4.01 however this query gives an error:
You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near '
Strict Standards: Only variables should be assigned by reference ' at line 1 SQL=SELECT count(*) AS `Total` FROM `jos_chronoforms_data_wedstrijdinschrijvingen` WHERE wedstrijd_jaar =
Strict Standards: Only variables should be assigned by reference in /home/deb57186/domains/tvgpd.nl/public_html/test/components/com_chronoconnectivity/libraries/chronoconnection.php(1347) : eval()'d code on line 3
2015
I can't figure out what's wrong.
Hi hpeterse,
It looks to me as if the query is wrong did you miss copying some of it? The error message refers to count(*) but that isn't in the code.
Joomla! 3 shows an PHP Warning if you use $db =& JFactory - just drop the & and use $db = JFactory
Bob
It looks to me as if the query is wrong did you miss copying some of it? The error message refers to count(*) but that isn't in the code.
Joomla! 3 shows an PHP Warning if you use $db =& JFactory - just drop the & and use $db = JFactory
Bob
This topic is locked and no more replies can be posted.
