sqlmapproject/sqlmap · error · SqlmapNoneDataException

all provided column name(s) are non-existent

Error message

all provided column name(s) are non-existent

What it means

Error "all provided column name(s) are non-existent" thrown in sqlmapproject/sqlmap.

Source

Thrown at lib/utils/pivotdumptable.py:120

            query = agent.whereQuery(query)
            value = inject.getValue(query, blind=blind, union=not blind, error=not blind, expected=EXPECTED.INT, charsetType=CHARSET_TYPE.DIGITS)

            if isNumPosStrValue(value):
                validColumnList = True

                if value == count:
                    infoMsg = "using column '%s' as a pivot " % column.replace(("%s." % alias) if alias else "", "")
                    infoMsg += "for retrieving row data"
                    logger.info(infoMsg)

                    validPivotValue = True
                    colList.remove(column)
                    colList.insert(0, column)
                    break

        if not validColumnList:
            errMsg = "all provided column name(s) are non-existent"
            raise SqlmapNoneDataException(errMsg)

        if not validPivotValue:
            # No single column holds all-distinct values. Fall back to a COMPOSITE pivot (a
            # concatenation of every column) whose combined value is unique per row, so rows sharing
            # a value in every individual column are no longer silently dropped (ref: #1545).
            _composite = agent.concatQuery(','.join(colList))
            query = dumpNode.count2 % (_composite, table)
            query = agent.whereQuery(query)
            value = inject.getValue(query, blind=blind, union=not blind, error=not blind, expected=EXPECTED.INT, charsetType=CHARSET_TYPE.DIGITS)

            if isNumPosStrValue(value) and int(value) == count:
                infoMsg = "using a concatenation of all columns as a "
                infoMsg += "composite pivot for retrieving row data"
                logger.info(infoMsg)

                compositePivot = _composite
                lengths[compositePivot] = 0
                entries[compositePivot] = BigArray()

View on GitHub (pinned to 0a35b20e39)

When it happens

Trigger: Thrown at lib/utils/pivotdumptable.py:120 when the library encounters an invalid state.

Common situations: See trigger scenarios.

AI-assisted analysis of sqlmapproject/sqlmap@0a35b20e39 (2026-08-26). Data as JSON: /api/errors/1fe0dbcfe2488f35. Report an issue: GitHub.