sunrisepro

I found this query here: SELECT contacts.client_id, contacts.first_name, contacts.last_name, contacts.email, contacts.address1, contacts.city, contacts.zip, contacts.country, contact_numbers.number FROM contacts INNER JOIN contact_numbers ON contacts.client_id=contact_numbers.contact_id ORDER BY contacts.client_id; I figured that would be fine but I'm seeing some oddities: Not all clients are being exported. The export has 70 rows of clients BUT 10 clients were repeated in 2 rows so only 60 unique clients were exported. But I have a total of 77 clients (61 active, 16 inactive). Some client phone numbers are wrong. I've found 2 phone numbers that are different from that client's contact info. Some are correct, but I don't want to check every single row unless I decide to forget the export to manually check & fix the phone numbers. I also want to export the tax & Stripe IDs for clients but I'm not sure how to connect client_settings.value & accounts_cc.client_reference_id to the client without messing it up like the phone numbers.

Manually sending an email to a client works but I just noticed that invoices emails are all unsent.

I currently have this set for 2 but all new invoices are 5, unless I edit it manually. Is this due to an update?

Had a client mention she couldn't pay an invoice just now because it was asking for 'additional authorization'. My other recurring invoices all ran fine today, just not when she went to manually pay her invoice. As she put it: I can't find a Blesta setting that controls how many times the payment is retried.

This one works now, after I removed a couple of the other cron jobs that were similar. It looks like cron is running once per hour.

That exact cron job has been there since my last comment so it's been active for 6 days and cron still needs to be run manually. I'm looking into SSH access to my VPS. I'm also using Blesta 5.02 - does that affect anything?

I'm stil stuck on this and have been running cron manually once a day. This is the path Blesta is showing in the Automation screen: /usr/local/bin/php -q /home/username/domains/domain.com/public_html/subdomain/index.php cron > /dev/null 2>&1 This is what my host recommended using, including the correct path to php 7.4 (which I confirmed is the version in use): /usr/local/php74/bin/php /home/username/domains/domain.com/public_html/subdomain/index.php My host also noted that the '-q' flag is outdated and should not be used. I'm also trying these cronjobs: /usr/local/php74/bin/php /home/username/domains/domain.com/public_html/subdomain/index.php cron > /dev/null 2>&1 /usr/local/php74/bin/php /home/username/domains/domain.com/public_html/subdomain/index.php All are set for 5 minutes, none are working. I'm happy to pay someone to resolve this for me as I'm lost on what could be wrong.

The url is the correct path to Blesta's index.php - that's what should be accessed for the cron job? This is not an issue, it was working fine for well over a year before I deleted the cron job by mistake last week.

I managed to delete my cronjob by mistake, now I'm having trouble setting up a cron job that works. I know the url to php, after asking my host. My command looks like this: I set it to go off every minute, I check /admin/settings/system/automation/ after 1 minute, and it still shows that cron last ran 2 days ago when I ran it manually. I'm not sure what's wrong.

Checking the docs, I see that 'Management' & 'Config Options' are not supported but I'm unclear on what that means. What's the main differences between cPanel & DirectAdmin with regard to how they work with Blesta?

I'm wondering how to best handle affiliate referrals. I have my business website (WP), and I use Blesta for sales, payments, & tickets. I don't have any static pages on Blesta aside from order forms; all of my marketing content is on my main website. I'd like to use Blesta's referral system for a new recurring service product, rather than build out subscriptions & referrals based on Woocommerce (and thus have 2 separate billing options). Since referrals would need to land on Blesta to be counted as a referral, do I need to make static marketing pages on Blesta to receive the traffic? Or is there some miracle workaround where someone landing on WP can be counted by Blesta as an affiliate? (I realize this last question might be rather dumb...)

I've seen DirectAdmin mentioned as an alternative. How does Blesta handle existing accounts if a server is switched from WHM to DirectAdmin?

Finally got my install updated, enabled human verification, and also enabled it on the two public ticket departments. I notice that a lot of my tickets are delivery errors in response to the automatic reply that a ticket sends out. Any way to stop or mitigate these? Is it a setting within the piping?

I understand how it generally works but I have questions, like can clients sign up as affiliates or that an admin task? payment methods seem to be just a name - how do they work? The affiliate chooses a method & I manually fulfill (like adding credit to their account or mailing a check)? is the commission % strictly global or can it be customized per affiliate (ie can I give some affiliates better rates)?

I'm having trouble upgrading my install, the normal upgrade process isn't working. I wouldn't mind hiring someone to complete the upgrade for me.