i receiving fatal error (memory exhausted) on custom component after upgrading version 2.5.3 2.5.6. have isolated te problem in opinion quite particular , seems problem 'where clause'.
below find code problem located (in model):
it simple piece of code retrieve right information database table view. strange thing when remove clause, code seems work fine (except producing right result obviously).
when replace clause clause true,, code produces fatal error. same happens when hardcode query string.
any ideas?
below find code problem located (in model):
code: select all
$db = $this->getdbo();
$query = $db->getquery(true);
$query->select('a.*');
$query->from('#__foo a');
$query->where('a.id = '.$foo_id );
$db->setquery((string)$query);
if (!$db->query()) {
jerror::raiseerror(500, $db->geterrormsg());
}
$this->_item = $db->loadassoc();
return $this->_item;
it simple piece of code retrieve right information database table view. strange thing when remove clause, code seems work fine (except producing right result obviously).
when replace clause clause true,
code: select all
$query->where('1=1');
any ideas?
have tried run sql query in phpmyadmin?
enable debug on site , see sql queries generated.
enable debug on site , see sql queries generated.
Comments
Post a Comment