Dwarf Fortress mining designation not working

Solution 1:

check the bottom right of the interface when you have "Mine" selected. Most likely you have the designation as "Designate/automine ore/gems".