[Issues exporting client data]

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:

1. 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).
2. 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.

[Why would logs show all my emails as unsent - is it a cron issue?]

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

[Possible to customize invoice due period?]

On 1/8/2020 at 1:10 PM, Jono said:

This is controlled by the "Invoice Days Before Renewal" setting which can be edited under the client group or  Billing/Payment > Invoice and Charge Options settings.  This setting also determines the number of days before a service or recurring invoice renews to generate an invoice.

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

[If Blesta isn't updated could there be issues with Stripe processing payments?]

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:

Quote

What it is doing is trying to run that payment 5 times in a row when I hit pay.
So it immediately flags it as fraud.  it tried 12 times in 3 days!
4/5 times in a row each day
So going to have to find a different way to pay you because it caused a s*&t storm of failures on our business accounts. 

I can't find a Blesta setting that controls how many times the payment is retried.

[Cron job problem with Direct Admin]

On 6/13/2022 at 12:49 PM, Paul said:

Based on this information, you should use:

/usr/local/php74/bin/php /home/username/domains/domain.com/public_html/subdomain/index.php cron > /dev/null 2>&1

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.

[Cron job problem with Direct Admin]

2 hours ago, Paul said:

Based on this information, you should use:

/usr/local/php74/bin/php /home/username/domains/domain.com/public_html/subdomain/index.php cron > /dev/null 2>&1

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?

[Cron job problem with Direct Admin]

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.

[Cron job problem with Direct Admin]

19 minutes ago, Paul said:

Blesta does a generally pretty good idea of determining the command which you can see under Settings > System > Automation. Sometimes the path to PHP is wrong.

The url is the correct path to Blesta's index.php - that's what should be accessed for the cron job?

20 minutes ago, Paul said:

If your path to PHP is right, as well as the path to your cron, then your CLI PHP may be missing system requirements.

This is not an issue, it was working fine for well over a year before I deleted the cron job by mistake last week.

[Cron job problem with Direct Admin]

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:
 

Quote

 

/usr/local/php74/bin/php -q /home/username/domains/my_domain/public_html/subdomain/index.php > /dev/null 2>&1

 

 

 

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.

[Considering switching from cPanel to DirectAdmin - anything I should watch out for?]

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?

[Handling referrals with a separate site for marketing?]

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...)

[Anyone switching from cPanel due to their change in pricing?]

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

[For tickets piped to email is there anything that can be done about delivery errors?]

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?

[Are there more details somewhere about the affiliate system?]

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)?

[Is there are page or forum for people who offer Blesta services?]

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.

[Any way to add recaptcha to support tickets?]

On 11/25/2020 at 4:16 PM, Jono said:

If the files were uploaded correctly then the footer would show 4.12.3.  It is not based on the database changes.

I copied the files to the blesta install root directory. I see the changed files in /blesta folder. Is there something else I'm supposed to do besides go to /admin/upgrade?

Edit I ran this SQL query on the db: 

SELECT `value` FROM `settings` WHERE `key`='database_version';

And the value is 4.7.0-b1.

When I go to  /components/upgrades/tasks/, the last file is upgrade4_7_0_b1.php.

I have no idea what to do next.

[Any way to add recaptcha to support tickets?]

On 11/10/2020 at 4:43 PM, Jono said:

https://dev.blesta.com/browse/CORE-2903 was added in v4.12 and adds an option to require recaptcha to public support departments.  The option is labeled "Require Human Verification for unauthenticated user" and requires that you first configure your captcha under Settings > Company > General > Human Verification

Thanks - I downloaded blesta-4.12.3, overwrote the files, went to /admin/upgrade and followed the steps until it said that The upgrade completed successfully. But in the footer it says my installed version is 4.7.1 and I can't find Settings > Company > General > Human Verification.

Not sure what I did wrong ?

[Any way to add recaptcha to support tickets?]

On 11/10/2020 at 4:43 PM, Jono said:

https://dev.blesta.com/browse/CORE-2903 was added in v4.12 and adds an option to require recaptcha to public support departments.  The option is labeled "Require Human Verification for unauthenticated user" and requires that you first configure your captcha under Settings > Company > General > Human Verification

Thanks - I downloaded blesta-4.12.3, overwrote the files, went to /admin/upgrade and followed the steps until it said that The upgrade completed successfully. But in the footer it says my installed version is 4.7.1 and I can't find Settings > Company > General > Human Verification.

Not sure what I did wrong ?

[Any way to add recaptcha to support tickets?]

I've been getting a lot of ticket spam over the past week. Is there any way to prevent, or at least slow the tide? recaptcha would work. If I could get the IP addresses of the spammers I could block them too.

[Any way to get IP addresses rom ticket emails?]

I've been getting a lot of ticket spam lately but as they're sending emails I'm not seeing any related IP addresses in my server stats. Is there a way to get the IP address of a sender from a ticket?

[Possible to merge clients?]

I have a client who has two Blesta accounts, which I did not notice until now. My guess is that I had invoiced him initially for a website and then he purchased hosting later without logging in first. Both accounts use the same email address, which I thought would not have been allowed. Is there any way to merge them?

[{update_ticket_url} is blank]

4 hours ago, Jono said:

Are you speaking of the email sent to staff members when a ticket is updated?  That tag is not available in that email template.  When editing an email template, the "Available Tags" section just above the text/html input lists all tags that are available to the template.

I'm talking about both the emails sent to staff and the emails sent to customers (either for tickets received or updated).

I know that the 'available tags' are no the only usable tags because this is in my template going to staff and all of these merge fields are filled out correctly in the emails:

Ticket #: {ticket.code}
Status: {ticket.status_language}
Priority: {ticket.priority_language}
Department: {ticket.department_name}

See this email screenshot: https://nimb.ws/LQTZ6x

[Possible to customize invoice due period?]

4 hours ago, Jono said:

This is controlled by the "Invoice Days Before Renewal" setting which can be edited under the client group or  Billing/Payment > Invoice and Charge Options settings.  This setting also determines the number of days before a service or recurring invoice renews to generate an invoice.

Thanks. It's not obvious that settings controls that too, maybe it would be worth adding some help text.

[{update_ticket_url} is blank]

My ticket emails are not including the link to update the ticket, it's blank. Both the html & text versions include the merge tag

{update_ticket_url}

Why would this happen?

[Possible to customize invoice due period?]

New invoices default to being due 3 days after delivery. Is it possible to change that to 2 days?