{"record":{"id":"1fe0dbcfe2488f35","repo":"sqlmapproject/sqlmap","slug":"all-provided-column-name-s-are-non-existent","errorCode":null,"errorMessage":"all provided column name(s) are non-existent","messagePattern":"all provided column name\\(s\\) are non-existent","errorType":"exception","errorClass":"SqlmapNoneDataException","httpStatus":null,"severity":"error","filePath":"lib/utils/pivotdumptable.py","lineNumber":120,"sourceCode":"            query = agent.whereQuery(query)\n            value = inject.getValue(query, blind=blind, union=not blind, error=not blind, expected=EXPECTED.INT, charsetType=CHARSET_TYPE.DIGITS)\n\n            if isNumPosStrValue(value):\n                validColumnList = True\n\n                if value == count:\n                    infoMsg = \"using column '%s' as a pivot \" % column.replace((\"%s.\" % alias) if alias else \"\", \"\")\n                    infoMsg += \"for retrieving row data\"\n                    logger.info(infoMsg)\n\n                    validPivotValue = True\n                    colList.remove(column)\n                    colList.insert(0, column)\n                    break\n\n        if not validColumnList:\n            errMsg = \"all provided column name(s) are non-existent\"\n            raise SqlmapNoneDataException(errMsg)\n\n        if not validPivotValue:\n            # No single column holds all-distinct values. Fall back to a COMPOSITE pivot (a\n            # concatenation of every column) whose combined value is unique per row, so rows sharing\n            # a value in every individual column are no longer silently dropped (ref: #1545).\n            _composite = agent.concatQuery(','.join(colList))\n            query = dumpNode.count2 % (_composite, table)\n            query = agent.whereQuery(query)\n            value = inject.getValue(query, blind=blind, union=not blind, error=not blind, expected=EXPECTED.INT, charsetType=CHARSET_TYPE.DIGITS)\n\n            if isNumPosStrValue(value) and int(value) == count:\n                infoMsg = \"using a concatenation of all columns as a \"\n                infoMsg += \"composite pivot for retrieving row data\"\n                logger.info(infoMsg)\n\n                compositePivot = _composite\n                lengths[compositePivot] = 0\n                entries[compositePivot] = BigArray()","sourceCodeStart":102,"sourceCodeEnd":138,"githubUrl":"https://github.com/sqlmapproject/sqlmap/blob/0a35b20e3953d341be6c7ac75ccb0b3362540c8d/lib/utils/pivotdumptable.py#L102-L138","documentation":"Error \"all provided column name(s) are non-existent\" thrown in sqlmapproject/sqlmap.","triggerScenarios":"Thrown at lib/utils/pivotdumptable.py:120 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"}