> [@blake](#):
>
> So far when I visit `/my/billing/subscriptions`
It pulls from that endpoint. And on this server, with some users, I get a 500 error (I should have included a screenshot, I think). I think it’s been happening for a while? They got me on board to upgrade, which I did, and then they reported this error, but it seems that they were hoping that the upgrade was going to resolve it (at least the upgrade didn’t break it?).
> [@blake](#):
>
> Any other clues on how I can repro this?
Zero. My best guess is that something happened at some point in the past and now it’s getting a `nil` from somewhere instead of an array? But I’ve looked at the code and don’t see anywhere that’s not testing for nil before accessing an array.
---
### Author:  [@blake](https://meta.discourse.org/u/blake)
#### Post date: [April 9, 2025, 4:53pm UTC](https://meta.discourse.org/t/problem-with-500-error-with-subscriptions/360808/6 "2025-04-09T16:53:46Z")
I’m assuming it’s only for this one site? You aren’t seeing this on other sites? Yes, there is a “bug” where we shouldn’t return a 500, but there is likely some “bad” data somewhere like a missing plan or something. Maybe it got removed in stripe and never got updated in the plugin db.
Can you run these rails console commands to help me debug?
```plaintext
Stripe.api_key = SiteSetting.discourse_subscriptions_secret_key
user = User.find_by(username: 'xxx')
customer = DiscourseSubscriptions::Customer.find_by(user_id: user.id)
subs = ::Stripe::Subscription.list(customer: stripe_customer_id, status: 'all')[:data]
subs.count # note how many subscriptions they have
subscription = subs.first # change this and run the below lines for each sub
price_id = subscription[:items][:data].first[:price][:id]
plans = ::Stripe::Price.list(expand: ['data.product'], limit: 100)
plan = plans[:data].find { |p| p[:id] == price_id }
plan
```
I’m thinking either plans or plan will return nil, but that will help us narrow down where the issue is. Could you let me know how many subscriptions they have and if there are any missing plans for them?
Likely a code fix I’ll make is to just not return any subscriptions for these users if there is an error, but if they actually have a subscription that isn’t really solving the issue. Maybe I’ll have it return an error that says something like a subscription has been found but there is an error loading the plan details for it, please reach out to an admin for help.
---
### Author:  [@pfaffman](https://meta.discourse.org/u/pfaffman)
#### Post date: [April 9, 2025, 6:34pm UTC](https://meta.discourse.org/t/problem-with-500-error-with-subscriptions/360808/7 "2025-04-09T18:34:55Z")
Cool. Thanks!
There was one subscription.
One fix on your code:
```plaintext
subs = ::Stripe::Subscription.list(customer: customer.stripe_customer_id, status: 'all')[:data]
```
There are 100 plans (so probably more than that)-- maybe this is the problem? (I tried with `limit: 1000` but that didn’t change anything; I guess that’s a Stripe API limit?)
So maybe if there are \>100 plans it fails? Oh, and the users for whom it’s not failing, are on plans that are in the first 100.
```plaintext
discourse(prod)> plan = plans[:data].find { |p| p[:id] == price_id }
discourse(prod)>
=> nil
```
EDIT:
Yes. If I do this:
```plaintext
# Get the last item's ID
last_price_id = plans.data.last.id
# Get the next 100
next_plans = ::Stripe::Price.list(
expand: ['data.product'],
limit: 100,
starting_after: last_price_id
)
```
then
```plaintext
discourse(prod)> next_plans[:data].find { |p| p[:id] == price_id }
```
finds what it’s looking for.
EDIT AGAIN: next\_plans.count == 8. I suggested that they delete 10 plans.
---
### Author:  [@blake](https://meta.discourse.org/u/blake)
#### Post date: [April 9, 2025, 8:11pm UTC](https://meta.discourse.org/t/problem-with-500-error-with-subscriptions/360808/8 "2025-04-09T20:11:37Z")
Thanks for all the info, this is helpful.
> [@pfaffman](#):
>
> EDIT AGAIN: next\_plans.count == 8. I suggested that they delete 10 plans.
Ya that would do the trick for a non-code fix. Sounds good if they have a lot of stale plans.
I’ll add some pagination too so that we can grab them all incase we run into this again.
---
### Author:  [@blake](https://meta.discourse.org/u/blake)
#### Post date: [April 10, 2025, 1:36pm UTC](https://meta.discourse.org/t/problem-with-500-error-with-subscriptions/360808/9 "2025-04-10T13:36:31Z")
> [@blake](#):
>
> I’ll add some pagination too so that we can grab them all incase we run into this again.
Here is the fix for that:
[https://github.com/discourse/discourse-subscriptions/pull/272](https://github.com/discourse/discourse-subscriptions/pull/272)
---
### Author:  [@blake](https://meta.discourse.org/u/blake)
#### Post date: [April 14, 2025, 2:00pm UTC](https://meta.discourse.org/t/problem-with-500-error-with-subscriptions/360808/10 "2025-04-14T14:00:48Z")
This topic was automatically closed after 4 days. New replies are no longer allowed.