Column not found: 1054 Unknown column 'subscription_items.subscriptions_id'

[emergingdzns]

Cashier Paddle Version

2.4

Laravel Version

11.10

PHP Version

8.3

Database Driver & Version

MySQL 8 on AWS RDS

Description

All of a sudden when I try to query any record in our subscription model (which extends CashierSubscription) it is now throwing the following error:

[previous exception] [object] (PDOException(code: 42S22): SQLSTATE[42S22]: Column not found: 1054 Unknown column 'subscription_items.subscriptions_id' in 'where clause' at /var/www/containers/web-app/vendor/laravel/framework/src/Illuminate/Database/Connection.php:407)
[stacktrace]

But there is no subscriptions_id. The plural of subscription is throwing it off.

If I remove the extending of CashierSubscription it works fine but then of course Cashier doesn't work.

I don't know what happened. We didn't change anything in the code recently.

I can't find subscriptions_id anywhere in the code, ours or the cashier vendor folder.

Steps To Reproduce

I'm honestly not sure how to duplicate this. It suddenly came up today by making a simple query to our subscription model like this:

$subscription = Subscriptions::where('receipt_id', $receipt_id)->first();

[driesvints]

If I remove the extending of CashierSubscription

Could you post your full code that extended this?

[driesvints]

Closing this issue because it's inactive, already solved, old or not relevant anymore. Feel to open up a new issue if you're still experiencing this.