I thought you meant the old "Miner's Guild Representative" ect for some reason. meh.
My mayors so far all were miners, asked for "Miner's Guild" jobs to be completed, and became happy when some dwarf mined out a few squares. What jobs does your mayor have? I think it'll be one of those.
I don't know the other guilds yet; is yours the Craftsdwarves' Guild or something? (I'd suggest you just order a few items to be made, something that your mayor could make - and then let us know if it worked.) :)
It's just good info for the future ;)