@booalban said:
GET /discover return a total_pages > 500 but can't load after 500
Hi, I have a problem with the GET /discover.
I'm actually using this request for my student project
https://api.themoviedb.org/3/discover/movie?api_key=API_KEY&language=en-US&sort_by=popularity.desc&include_adult=false&include_video=True&page=1
before this request returned a total_pages of 500 but now I get 33225 but I can't load after page 500 and I don't know why so my pagination doesn't work anymore :/

Probably the mistake is to show this quantity result

total_pages 33228
total_results 664541

I'm not really sure but I think this is the total non-adult movies in the Database.
In 2021-05-11 there were 653075 non-adult or "adult":false and "video":false Movies.
Your API Request is with video:true.

The limit of results available in a query remains the same.

The number/quantity of Items per Page and the number/quantity of Pages
cannot be changed, configured, specified, restricted, or anything like that.
There will always be up to 20 items per page.
And a maximum of 500 pages.
Therefore, at most 10,000 items.

Of course, depending on the parameters used in your API Request
this number/quantity can be much smaller.
Eventually zero.

In a Trending API Request, the quantities are greater.
A maximum of 1,000 pages
Therefore a maximum of 20,000 items

did I make a mistake with the format of my request? because I still don't understand why overnight the answer went from 500 pages to 33225 with the same request

@booalban said:
did I make a mistake with the format of my request?

You didn't make a mistake. As I said in my previous comment:

Probably the mistake is to show this quantity result

total_pages 33228
total_results 664541

TMDb made the mistake of changing the 500 page quantity information to 33228 quantity.
It's not your mistake. The error is ours.
But even so, even showing the total number of pages, approximately 33,300,
you will only be able to access up to page 500.

because I still don't understand why overnight the answer went from 500 pages to 33225 with the same request

You don't understand and I don't understand either.
It is certainly a BUG, an error that occurred I don't know where.
This normally occurs in code programming.
Started showing total pages of Movie Database, approximately 33,300 .
But keep in mind the limit of 500 pages available to the user. It remains valid.

I made a change to reflect the accurate total number of results, but continue to restrict the result set to the first 10,000 items.

So if any one wants more than 10,000 movies we have to contact support right? and go for commericial lincese or something?

cc: @travisbell ^

Hi @itsmegodaj, we do not provide any way to go past page 500 right now.

What you can do though, is add filters to shrink your query. For example, something like requesting 1 year at a time:

/3/discover/movie?api_key=API_KEY&primary_release_date.gte=2020-01-01&primary_release_date.lte=2020-12-31&page=1
/3/discover/movie?api_key=API_KEY&primary_release_date.gte=2020-01-01&primary_release_date.lte=2020-12-31&page=2
…

/3/discover/movie?api_key=API_KEY&primary_release_date.gte=2021-01-01&primary_release_date.lte=2021-12-31&page=1
/3/discover/movie?api_key=API_KEY&primary_release_date.gte=2021-01-01&primary_release_date.lte=2021-12-31&page=2
…

Doing it by year is just one idea, it’s possible there’s other filters that better matches your specific needs.