2Checkout Issues still going on

Just checking in. Anything I can do to help with the testing/diagnosing?

Goosemoose wrote: Just checking in. Anything I can do to help with the testing/diagnosing?

I'm not seeing any 2checkout issues on your site. The INS notifications arrive fine and are handled fine.

Would need to see server access and error logs to maybe help on the server issue. CBSubs doesn't give such an error HTTP status reply to a request...

CBSubs 4.1.1, just released, includes now the other fixes.

Unfortunately it's definitely not recording recurring payments correctly. It shows 0 for yesterday when I have a ton and 3 the day before where there's a lot more. Are you saying it will work for new renewals for this point forward? 2Checkout's site still shows 0 successful webhook calls. Let me know what logs you need and for what day and I'll get them to you.

When I click on the number of renewals in the payment center I get a sql error:

An error has occurred.
1054 Unknown column 'a.renewals' in 'where clause' SQL=SELECT COUNT(*) FROM `#__cbsubs_payments` AS a WHERE ( a.`time_paid_date` = '2017-08-28' ) AND ( a.`renewals` = '1' )

Goosemoose wrote: Unfortunately it's definitely not recording recurring payments correctly. It shows 0 for yesterday when I have a ton and 3 the day before where there's a lot more. Are you saying it will work for new renewals for this point forward? 2Checkout's site still shows 0 successful webhook calls. Let me know what logs you need and for what day and I'll get them to you.

I see many successful notifications for auto-recurring 2checkout payments in CBSubs notifications. Also did get quickly a 200 ok status when trying to replay the one you gave me manually.

I would need webserver access (or error) log (Apache log) entries for those failed accesses and know if they are in access or error log. Your hoster can provide you or tell you where those files are (please not entire log, just the 2checkout notifications that are reported as failed at 2co).

---

When I click on the number of renewals in the payment center I get a sql error:

An error has occurred.
1054 Unknown column 'a.renewals' in 'where clause' SQL=SELECT COUNT(*) FROM `#__cbsubs_payments` AS a WHERE ( a.`time_paid_date` = '2017-08-28' ) AND ( a.`renewals` = '1' )

Thanks for reporting. This is an unrelated admin-only issue on the listing query. Noted that as low-priority tracker #6748

After the latest update (nightly a few days ago) I get that same sql error when I click Payments so I can't check for recurring payments anymore. Logging out and back in works though I know my session was good as I could edit articles, pull up other info , etc.

I'm sending you a screenshot via pm of 2CO with the first page of 20 payments for the day and CBSubs with 5.

I'll work on getting you the logs.

Checking in Beat to see if you found anything. I sent you access to all my logs.