Joomla Asked on September 5, 2021
I don’t understand the world right now. I try to make a simple query from the DB, but it fails with the message that the column is not known. I do not understand why Joomla! tries to see the value I am looking for as a column. This is my query:
$data = new stdClass();
try{
$db = JFactory::getDbo();
$query = $db->getQuery(true);
$query
->select('*')
->from($db->quoteName('#__extensions'));
$query->where($db->quoteName('element') . " = " . $db->quoteName('com_componentname'));
$db->setQuery($query);
$data->params = $db->loadObject();
}catch(Exception $e){
$data->query = $query->dump();
$data->errormsg = $e->getMessage();
}
return $data;
}else{
return false;
}
The response is:
'errormsg' => 'Unknown column 'com_componentname' in 'where clause'',
Why does Joomla! try to find the component name as a column? What I want:
Where componentname in Columns name from table extensions.
Or is there another / better way to load the parameters of a component within a module?
JDatabaseDriver::quoteName()
is for quoting SQL identifiers. Use JDatabaseDriver:quote()
to quote and escape strings.
$query->where($db->quoteName('element') . ' = ' . $db->quote('com_componentname'));
Correct answer by Sharky on September 5, 2021
1 Asked on January 6, 2022 by user3533235
1 Asked on December 30, 2021 by mano-meter
2 Asked on December 19, 2021
2 Asked on December 11, 2021
0 Asked on December 11, 2021 by sandro-antonucci
1 Asked on November 27, 2021
error handling extensions joomla 3 x server response time update
2 Asked on November 27, 2021 by lovntola
2 Asked on November 25, 2021
1 Asked on November 20, 2021
1 Asked on November 19, 2021 by matthiasdunkel
1 Asked on November 5, 2021 by fruit_alchemist
2 Asked on September 5, 2021 by user2363969
3 Asked on September 5, 2021 by jamesmandatory
0 Asked on September 5, 2021 by kaballo
1 Asked on September 5, 2021 by gart
1 Asked on September 5, 2021 by user1616338
1 Asked on September 5, 2021 by ygiorgos
2 Asked on September 5, 2021 by okisan
Get help from others!
Recent Answers
Recent Questions
© 2023 AnswerBun.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP