?
Referenced as Pull Request for: # 6219
avatar lmcculley
lmcculley
26 Feb 2015

Lines 152-157 of /administrator/components/com_installer/models/database.php improperly uses the set clause with an insert query.

// Add new row.
$query->clear()
    ->insert($db->quoteName('#__schemas'))
    ->set($db->quoteName('extension_id') . '= 700')
    ->set($db->quoteName('version_id') . '= ' . $db->quote($schema));
$db->setQuery($query);

And should instead be similar to the following:

$query->clear()
    ->insert($db->quoteName('#__schemas') . " (" . $db->quoteName('extension_id') . "," . $db->quoteName('version_id') . ") ")
    ->values('700, ' . $db->quote($schema));
$db->setQuery($query);
avatar lmcculley lmcculley - open - 26 Feb 2015
avatar joomla-cms-bot joomla-cms-bot - change - 26 Feb 2015
Labels Added: ?
avatar lmcculley lmcculley - reference | - 26 Feb 15
avatar lmcculley lmcculley - reference | - 26 Feb 15
avatar lmcculley lmcculley - reference | - 26 Feb 15
avatar lmcculley lmcculley - reference | - 27 Feb 15
avatar zero-24 zero-24 - change - 27 Feb 2015
Status New Closed
Closed_Date 0000-00-00 00:00:00 2015-02-27 21:03:11
Closed_By zero-24
avatar joomla-cms-bot
joomla-cms-bot - comment - 27 Feb 2015

Set to "closed" on behalf of @zero-24 by The JTracker Application at issues.joomla.org/joomla-cms/6204

avatar joomla-cms-bot joomla-cms-bot - close - 27 Feb 2015
avatar joomla-cms-bot joomla-cms-bot - close - 27 Feb 2015
avatar zero-24
zero-24 - comment - 27 Feb 2015

Closing here as we have a PR: #6219 Thanks!


This comment was created with the J!Tracker Application at issues.joomla.org/joomla-cms/6204.
avatar zero-24 zero-24 - change - 27 Feb 2015
Category SQL
avatar phproberto phproberto - reference | - 13 Mar 15

Add a Comment

Login with GitHub to post a comment