{"record":{"id":"4520d8b3e59c564d","repo":"sqlmapproject/sqlmap","slug":"can-t-use-column-existence-check-because-of-detect","errorCode":null,"errorMessage":"can't use column existence check because of detected invalid results (most likely caused by inability of the used injection to distinguish erroneous results)","messagePattern":"can't use column existence check because of detected invalid results \\(most likely caused by inability of the used injection to distinguish erroneous results\\)","errorType":"exception","errorClass":"SqlmapDataException","httpStatus":null,"severity":"error","filePath":"lib/utils/brute.py","lineNumber":213,"sourceCode":"        kb.choices.columnExists = readInput(message, default='N', boolean=True)\n\n        if not kb.choices.columnExists:\n            return None\n\n    if not conf.tbl:\n        errMsg = \"missing table parameter\"\n        raise SqlmapMissingMandatoryOptionException(errMsg)\n\n    if conf.db and Backend.getIdentifiedDbms() in UPPER_CASE_DBMSES:\n        conf.db = conf.db.upper()\n\n    result = inject.checkBooleanExpression(safeStringFormat(BRUTE_COLUMN_EXISTS_TEMPLATE, (randomStr(), randomStr())))\n\n    if result:\n        errMsg = \"can't use column existence check because of detected invalid results \"\n        errMsg += \"(most likely caused by inability of the used injection \"\n        errMsg += \"to distinguish erroneous results)\"\n        raise SqlmapDataException(errMsg)\n\n    message = \"which common columns (wordlist) file do you want to use?\\n\"\n    message += \"[1] default '%s' (press Enter)\\n\" % columnFile\n    message += \"[2] custom\"\n    choice = readInput(message, default='1')\n\n    if choice == '2':\n        message = \"what's the custom common columns file location?\\n\"\n        columnFile = readInput(message) or columnFile\n\n    infoMsg = \"checking column existence using items from '%s'\" % columnFile\n    logger.info(infoMsg)\n\n    columns = getFileItems(columnFile, unique=True)\n    columns.extend(_addPageTextWords())\n    columns = filterListValue(columns, regex)\n\n    for table in conf.tbl.split(','):","sourceCodeStart":195,"sourceCodeEnd":231,"githubUrl":"https://github.com/sqlmapproject/sqlmap/blob/0a35b20e3953d341be6c7ac75ccb0b3362540c8d/lib/utils/brute.py#L195-L231","documentation":"Error \"can't use column existence check because of detected invalid results (most likely caused by inability of the used injection to distinguish erroneous results)\" thrown in sqlmapproject/sqlmap.","triggerScenarios":"Thrown at lib/utils/brute.py:213 when the library encounters an invalid state.","commonSituations":"See trigger scenarios.","solutions":[],"exampleFix":null,"handlingStrategy":null,"validationCode":null,"typeGuard":null,"tryCatchPattern":null,"preventionTips":[],"tags":[],"backgroundTag":null,"analyzedSha":"0a35b20e3953d341be6c7ac75ccb0b3362540c8d","analyzedAt":"2026-08-26T23:02:52.002Z","schemaVersion":2},"datasetVersion":"2026-08-27T03:17:27.898Z"}