Jump to content

sunrisepro

Members
  • Posts

    201
  • Joined

  • Last visited

  • Days Won

    3

Everything posted by sunrisepro

  1. 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.
  2. Manually sending an email to a client works but I just noticed that invoices emails are all unsent.
  3. I currently have this set for 2 but all new invoices are 5, unless I edit it manually. Is this due to an update?
  4. 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.
  5. 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.
  6. 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?
  7. 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.
  8. 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.
  9. 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.
  10. 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?
  11. 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...)
  12. I've seen DirectAdmin mentioned as an alternative. How does Blesta handle existing accounts if a server is switched from WHM to DirectAdmin?
  13. 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?
  14. 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)?
  15. 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.
  16. 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.
  17. 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 ?
  18. 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 ?
  19. 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.
  20. 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?
  21. 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?
  22. 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
  23. Thanks. It's not obvious that settings controls that too, maybe it would be worth adding some help text.
  24. 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?
  25. New invoices default to being due 3 days after delivery. Is it possible to change that to 2 days?
×
×
  • Create New...