Zombie Revenge maybe? only one i could find online lol.
The game im looking for is an RPG im not sure what console or year ( sorry

had so many console and hand-held games they start to meld after a while

) but the story started out as you as a kid in a cathedral city and its attacked by the evil dude of the game and you and your childhood friend (or possible sister) is separated. You end up in a village adopted by one of the villagers and over time you make friends with his grandson and one day they have a celebration where you have to put some sort of item down the river and if it gets so far your wish is granted, yours sinks so your friend gives you yours so your wish to find you friend from your childhood (although im leaning more towards sister thinking about this lol) comes true.
only part of the game i remember from later on is in another town you need to get a licence to leave to further the story.