Subscriptions import: "Error 1048: Parent plan cannot be null"

I'm trying to import my user subscriptions from an old Joomla 3.10.12/CB 2.9.3+build.2024.10.02.18.57.11.f6795ce5a/CB Subs 4.6.1+build.2023.02.02.15.37.52.48532f2ea to a new Joomla 4.4.11-dev/2.10.0+build.2025.02.10.18.59.11.b0d14120b/4.8.0+build.2025.02.03.17.52.54.76d74952e site. I have manually recreated all my subscriptions plans (such as site registration only, 1 year, 2 year...) and created a CSV with the appropriate format to import the users' subs from the old site, such as:

1,11,A,2020-01-01 01:00:00
2,11,A,2020-01-01 01:00:00
3,11,A,2020-01-01 01:00:00
4,11,A,2020-01-01 01:00:00
7,3,A,2024-05-21 01:00:00

(ie userid, planid, status, subscription date)

When I try to import this into my new site via CB/Paid Subs/Import I get "An error has occurred - 1048 Column 'parent plan' cannot be null". What am I doing wrong?

Do you have an empty line at the beginning or end of the file? It parses line by line so be sure there are no empty lines.

I just double checked. No blank lines anywhere in the file including top and bottom. The original file was UTF-8 encoded and I tried re-saving it from Windows Notepad as ANSI but it made no difference - same error.

Try running the database fix tools in CB > Tools and applying any database fixes it recommends. Not sure why that column is erroring as the default value for it for new rows in subscription objects is 0. Will review the import code to see if there's a bug in it.

Are you trying to import a subscription to a plan that's a child of another plan? That might be the issue. You'd need to first import the parent plan then the child plan. You should be able to do that with 2 rows per user. 1 being the parent plan and 1 being the child plan.

Thanks. Checked CB database/user fields database/plugins database/users database - all are fine with no errors detected.