Hey Brent,

Sorry for the delayed response.

I've tried to access your site backend but it seems credentials are no longer working.

Login denied! Your account has either been blocked or you have not activated it yet.

Please cross check it and update us.

Sorry about that, I disabled it after my first ticket. Please try it now.

Hey Brent,

Thank you for providing us with the info.
i am debugging this issue at your site , meanwhile can you let us know in your earlier forum regarding the slow access, what you change which solve the issue or recently what kind of changes done at your site.

Looking forward to your response.

I closed it by mistake earlier thinking I had it fixed, but I think I was looking at a cached response.

It has been painfully slow for a few weeks and I initially suspected something with SEF404, a search engine optimization program, however its only on this one small section when you click to purchase a membership. Everything else runs super fast and disabling SEF404 does not improve anything.

This is a live site with a lot of traffic, so please be careful. If we need to deploy a test environment, I can help with that.

Hey Brent,

Thank you for updating us on this.

This is a live site with a lot of traffic, so please be careful. If we need to deploy a test environment, I can help with that.

yes, Can you create the test environment and provide us with the backend and FTP details, so we will check it on the test site without interfering with the live site?

Looking forward to your response.

I've setup test.paulkuharsky.com with the same login information.

In lieu of FTP, I installed an old component called 'proFiles' that should give access to the site's files. Hopefully this will be sufficient to debug.

I have a pre-shared key for SSH access if you need direct access to server, but I'll need your IP(s) and a secure way to send the key if we need to go that route.

The owner of the site is very anxious to get this fixed. Please let me know if there is anything else I can do to help.

THANK YOU!

Hey Brent ,

Thank you for providing us with access.

I have a pre-shared key for SSH access if you need direct access to server, but I'll need your IP(s) and a secure way to send the key if we need to go that route.

No need for now. Till my reply do not change anything on test site.

thank you for understanding!

Hey Brent,

I am really sorry for the delayed response.

After debugging a long ago, I found out that this dummy user account "Not_Registered" has around 30k++ subscriptions (none status) which is creating this issue.

And I found that you haven't activated this "Delete Incomplete Orders" feature from the backend, so when the guest user doesn't complete their payment, this subscription (none status) will be stored in the database under this dummy user account "Not_Registered".

Go to backend Payplans >> Settings >> System and set Delete Incomplete Orders to specific period. Subscriptions that are not being used by customers from the specified period then here you can set the period. This option will delete only those records which have subscription status as ‘No-Status’.

For now i've helped you to set this period to 7 days. As you are running cron on server, when cron job run it will autodelete the dummy orders.

Also find in database , there is some entries are missing, Have you deleted anything manually from database.
Please confirm so i'll check and correct them for you on live site.

Also can you allow me to run the cron job on your live site, so i'll check make sure that all the dummy orders deleted and no missing entries will be on site.

Looking forward to your response.

Thank you. We weren't aware of the dummy orders not being removed, and I am not running any cronjobs on the live server either. What script(s) do I need to call?

Also, we have not manually deleted anything in the database. Is there anything I need to fix there?

I enabled the automatic cron with normal frequency and set delete incomplete orders after 7 days on the live site. I also updated /components/com_payplans/cron.php to include the host variable: $host = 'https://www.paulkuharsky.com';

I then tried manually triggering https://www.paulkuharsky.com/index.php?option=com_payplans&view=cron&task=trigger however it didn't seem to work.

I then ran this query to remove subscriptions for the user 'not_registered' as their userid is 2267

DELETE FROM `uoajk_payplans_subscription` WHERE `user_id` = 2267

This cleared up the speed problem and I have a backup copy of that table if we need it.

If you could help make sure my cron is setup correctly, I'd greatly appreciate it. We can go automatic or manual moving forward... I'll rely on your expertise for the best setup.

Hey Brent,

Thank you. We weren't aware of the dummy orders not being removed, and I am not running any cronjobs on the live server either. What script(s) do I need to call?

Refer below mentioned document for more details.
https://stackideas.com/docs/payplans/administrators/cronjobs/cronjobs

I enabled the automatic cron with normal frequency and set delete incomplete orders after 7 days on the live site. I also updated /components/com_payplans/cron.php to include the host variable: $host = 'https://www.paulkuharsky.com';

I've checked your site and found that cron is running fine.

I then ran this query to remove subscriptions for the user 'not_registered' as their userid is 2267

DELETE FROM `uoajk_payplans_subscription` WHERE `user_id` = 2267

This cleared up the speed problem and I have a backup copy of that table if we need it.

Never remove a subscription manually from the database. You deleted the entries from the subscription table only but the entries exist in #__payplans_invoice, #_payplans_order tables as well. so never ever delete them from the database directly.
The dummy orders will be deleted on the cron job when run and it will remove all the related entires as well.

If you could help make sure my cron is setup correctly, I'd greatly appreciate it. We can go automatic or manual moving forward... I'll rely on your expertise for the best setup.

You can decide whether you want to run automated cron or server cron. Automated cronjob is executed automatically every time a visitor visits any of PayPlan pages on the front end. and server cron will be run on particular time you decide to run.

Looking forward to your response.

How can I confirm that the cron is running? I can restore those subscriptions and allow it to run on its own, but after hitting https://www.paulkuharsky.com/index.php?option=com_payplans&view=cron&task=trigger several times it didn't seem to work.

Does it just clean up a few each time its called? Or does it trigger a process that runs in the background that takes longer to complete?

Forgive my impatience in deleting those entries... its tough being on opposite time zones.

No problem.

Yes, it will not trigger it every time when you manually access the cronjob URL frequency, at least it will try to execute one and the system will try to delete those incomplete orders and those involved with this order data in the database.

And it needs time to delete those order records because it involved a few tables when deleting 1 incomplete order. (I think you have at least 10k incomplete order record in your database)

However, you mean you already restored those subscription data on your site now?

Perhaps you can try to set up this cronjob on your server, right?

If you need help testing whether the cronjob you set up on your server is correct or not, we can assist you with this. Still, you need to provide us with your Cpanel access which can access your site cronjob configuration page and database as well because we would like to check whether the incomplete order will get deleted by trigged from cronjob?