David Spade also stars in TV comedy Just Shoot Me

In Dickie Roberts: Former Child Star, ex-Saturday Night Live comic David Spade plays a faded star who tries to reclaim his childhood 30 years on.

But in a slow weekend, it took $7m (£4.4m) in its first three days.

The previous low was set by Eye of the Beholder, starring Ashley Judd, which took $6m when it opened in early 2000.

"$7 million in this day and age is a pretty mediocre opening at best, but they can brag about being number one and it could have been a lot worse," said Brandon Gray, who runs movie tracker BoxOfficeMojo.com.

US BOX OFFICE TOP FIVE 1. Dickie Roberts: Former Child Star 2. Jeepers Creepers 2 3. Pirates of the Caribbean 4. Freaky Friday 5. Swat Source: Exhibitor Relations

Dickie Roberts fared worse than Spade's last hit, 2001's trailer trash comedy Joe Dirt, which took $8m in its opening weekend.

Spade is also a star of TV comedy Just Shoot Me and recently received a star on the Hollywood Walk of Fame.

The only other new release of this weekend was supernatural thriller The Order, which opened in sixth place with $4.3m (£2.7m).

Starring Heath Ledger and The Full Monty's Mark Addy, The Order will be released in the UK as The Sin Eater.

Horror sequel Jeepers Creepers 2 was at number two, with takings down from $18m last weekend to $6.7m.