Wagons East!

Wagons East is a 1994 American Western adventure comedy film directed by Peter Markle, written by Matthew Carlson, and starring John Candy, Richard Lewis, John C. McGinley, Ellen Greene, Robert Picardo, Rodney A. Grant, and Ed Lauter. It tells the story of an alcoholic wagon master who leads a group of misfit settlers in the Wild West back to the East. The film was released in the United States on August 26, 1994. Filming took place in Sierra de Órganos National Park in the town of Sombrerete, Mexico, and in Durango, Mexico.

Synopsis from Wikipedia, CC BY-SA 4.0. Everything below written here.

Poster © the film's rights holders.