Headline
CVE-2015-10076: Solve bug with tags (possible sql injection) · dimtion/Shaarlier@3d1d9b2
A vulnerability was found in dimtion Shaarlier up to 1.2.2. It has been declared as critical. Affected by this vulnerability is the function createTag of the file app/src/main/java/com/dimtion/shaarlier/TagsSource.java of the component Tag Handler. The manipulation leads to sql injection. Upgrading to version 1.2.3 is able to address this issue. The name of the patch is 3d1d9b239d9b3cd87e8bed45a0f02da583ad371e. It is recommended to upgrade the affected component. The identifier VDB-220453 was assigned to this vulnerability.
@@ -61,10 +61,12 @@ public Tag createTag(ShaarliAccount masterAccount, String value) {
values.put(MySQLiteHelper.TAGS_COLUMN_TAG, tag.getValue());
// If existing, do nothing :
String[] getTagArgs = {String.valueOf(tag.getMasterAccountId()), tag.getValue()};
Cursor cursor = db.query(MySQLiteHelper.TABLE_TAGS, allColumns,
MySQLiteHelper.TAGS_COLUMN_ID_ACCOUNT + " = " + tag.getMasterAccountId() + " AND " +
MySQLiteHelper.TAGS_COLUMN_TAG + " = '" + tag.getValue() + "’",
null, null, null, null);
MySQLiteHelper.TAGS_COLUMN_ID_ACCOUNT + " = ? AND " +
MySQLiteHelper.TAGS_COLUMN_TAG + " = ?",
getTagArgs, null, null, null);
try {
cursor.moveToFirst();
if (cursor.isAfterLast()) {