CB Paid Subscriptions = update error

Clicked the first link to repair the database - got the same error...
An error has occurred.

1138 Invalid use of NULL value

Recommendations on best way to recover?...
Export, reinstall, import?

Strange your entire table structure seams to be completely out of date somehow. I think the best solution is a clean install then compare the structures and update your table structure manually. I've no clue what could've done that to your database. The only issues we're had reported in the past is some problems with Akeeba Backup restores altering structure sometimes, but aside from that I'm not sure what else would mess with the tables.

ok - I've got nothing better to do today...
I may go into my backups and see when the structure changed...
Thanks for the help
Fred

I'm not seeing errors from the Plugin Check in the actual DDL...

Example: first red entry in the Check report is
Table # cbsubs_promotions Column name NULL attribute is YES instead of NO

but when I check the database, here's that same column
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

Am I reading this wrong?
Fred

Stepped through the changes to the CBSubs database structure and the only changes found were the following.

Aug 02, 2023
payment_date: varchar(255) => varchar(64)
payment_type: varchar(32) => varchar(64)

Feb 01, 2023
auction_buyer_id: removed
auction_closing_date: removed
auction_multi_item: removed
for_auction: removed
option_name1: removed
option_selection1: removed
option_name2: removed
option_selection2: removed

Aug 30, 2022
first_validity: null=true

I just don't see realistically CBSubs being the cause here. Something else must've altered the table structure somehow.

It's unfortunate this happened, but I've no clue what did it. CB can't really fix table structure issues that happened outside of our APIs limitations.

Example: first red entry in the Check report is
Table # cbsubs_promotions Column name NULL attribute is YES instead of NO

but when I check the database, here's that same column
`name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',

I wouldn't rely on the tools check. When CB fails to install a plugin its files don't transfer over so CBSubs maybe in a non-functional state right now. I suggest comparing to a clean install of CBSubs and changing the table structure to match the clean install. Then install CBSubs again and you should be good to go.