Jump to content

Jason Ryan

Members
 View Profile  See their activity

  • Posts

    147

  • Joined

  • Last visited

  • Days Won

    7

 Content Type 

Posts posted by Jason Ryan

  1. Upgrade Bug

    in Bugs

    Posted

    On 3/10/2024 at 11:18 PM, exception0x876 said:

    I have upgraded to 5.9.3 today and discovered a bug in the upgrade step components/upgrades/tasks/upgrade5_8_1.php

    The query that fails there is ALTER TABLE `contact_permissions` CHANGE `client_id` `client_id` INT UNSIGNED NOT NULL

    It fails with the following error 

    general.ERROR: PDOException: SQLSTATE[01000]: Warning: 1265 Data truncated for column
 'client_id' at row 8 in ..../vendors/minphp/db/src/PdoConnection.php:196 Stack trace: #0 ..../vendors/minphp/db/src/PdoConnection.php(196): PDOStatement->execute(Array) #1 ..../components/upgrades/tasks/upgrade5_8_1.php(87): Minphp\Db\PdoConnection->query('ALTER TABLE `co...
') #2 ..../components/upgrades/tasks/upgrade5_8_1.php(54): Upgrade5_8_1->setContactPermissio
nClientId() #3 ..../components/upgrades/upgrades.php(294): Upgrade5_8_1->process('setContact
Permi...') #4 .../components/upgrades/upgrades.php(103): Upgrades->processObject(Object(Upg
rade5_8_1), NULL) #5 ..../app/controllers/admin_upgrade.php(109): Upgrades->start('5.8.0-b1'
, '5.9.3') #6 ..../vendors/minphp/bridge/src/Lib/Dispatcher.php(142): AdminUpgrade->process(
) #7 ..../index.php(21): Dispatcher::dispatch('/admin/upgrade/...') #8 {main}

    I have fixed this error by running the following query manually

    delete cp.* from contact_permissions cp left join contacts c on cp.contact_id=c.id where c.id is null

    I am experiencing the same issue, when did you run the query you posted, prior to upgrading or after?

  3. Upgrading Blesta 5.8.2 -> 5.8.3 error : SourceGuardian error

    in Support

    Posted

    I just upgraded our PHP version to 8.1 and getting the same error message on 5.4.0 after applying the hotfix - blank white screen prior to installing hotfix: 

    PHP script '/home/xxxx/xxxx/public_html/app/app_model.php' is protected by SourceGuardian and requires a SourceGuardian loader 'ixed.8.1.lin' to be installed.

1) Click here to download the required 'ixed.8.1.lin' loader from the SourceGuardian site
2) Install the loader to /usr/lib/php/20210902
3) Edit /etc/php/8.1/fpm/php.ini and add 'extension=ixed.8.1.lin' directive
4) Restart the web server

    Looks like I will have to downgrade... ugh

  5. Convert Existing Contact to Primary

    in Feature Requests

    Posted

    We currently have a case where the Primary Contact on the account is leaving the company and an existing Contact on the account is assuming the position. Would be nice if there was a way to just reassign the Primary Contact role to the existing contact. Right now, doing this is very clunky and not easy because we're having to delete the Contact, modify the Primary, and resend new login credentials manually. Unless I am missing something?

    Thanks

  6. Send Invoice Receipts to assigned contact

    in Feature Requests

    Posted

    Just a quick suggestion, a big pain point for us is that there is typically someone in an Accounts Receivables or Accounting department that handles the invoices for the company, while we can designate them to receive the initial invoices for payment, it would be nice if they were able to receive the "Paid" invoices as well and maybe just BCC the Primary Owner on the account. Often times the Primary Contact is complaining that they are receiving these and asking them to be sent to the assigned contact.

    Thanks

  9. Blesta Not Downloading Tickets from Mail Server

    in Support

    Posted

    For anyone else who may come across this issue, it wound up being that it was due to Error Reporting being on and Debug was set to "true". It is unclear as to why this would only cause the downloading of emails to fail and nothing else, seems counter intuitive to me, especially using debug in Wordpress is generally used to find issues, not cause them.

    It is fixed now and back to normal.

  10. Blesta Not Downloading Tickets from Mail Server

    in Support

    Posted

    14 minutes ago, Paul said:

    If it marks it as read but doesn't import it, it is probably failing. Try disabling your cron job, and running it manually under Settings > System > Automation by clicking the button, after a 5-min wait with an email ready to be imported. At the same time, tail your logs via SSH.

    tail -f /path/to/logs_blesta/*.log

    Note any output and whether the email is imported when running the cron manually that way.

     

    Been working with our host support on this. I have disabled Cron, emailed our support channel, waited 5 minutes, ran cron manually and no import of the responses and nothing showing in logs.

    I've now moved the cron job to our app panel at the host instead of EasyCron, it still runs as normal and the polling tickets task is running with no errors.

    I only posted this here to see if anyone else out in the community ever came across this, didn't want to confuse things by cross-posting. Sorry @Paul

     

  11. Blesta Not Downloading Tickets from Mail Server

    in Support

    Posted

    1 minute ago, Paul said:

    How are you importing tickets, using POP, IMAP, or piping? Are you saying that a new email to the department opens a ticket, but replying to the email sent to the client from a staff reply does not get imported? It's unusual that an email would be imported for a new ticket but not for a reply unless the reply is missing the required information in the subject line.

    I would check that mailparse and php-imap are installed. When changing PHP versions, this is most commonly overlooked.

    The errors you've included do not appear to be related.

    @Paul

    We are using IMAP and yes, double checked our installed extensions and all required extensions are installed and are the correct versions.

     

    On 1/22/2022 at 5:39 PM, Jason Ryan said:

    3. Client responds to the Ticket via Email - this is where it breaks down. The task is run as normal, the Email is marked as "Read" on the mail server, but the response is never downloaded and attached to the Ticket.

    This is the only part that is failing. When cron runs it marks the email as "Read" on the server but it is not updating the tickets with the response.

  12. Blesta Not Downloading Tickets from Mail Server

    in Support

    Posted

    Update:

    The following error is now showing in our Blesta Logs:

    [2022-01-24T16:20:14.757751+01:00] general.ERROR: Exception: Plugins is not a valid controller in /home/xxxx/xxxx/public_html/vendors/minphp/bridge/src/Lib/Dispatcher.php:113 Stack trace: #0 /home/xxxx/xxxx/public_html/index.php(21): Dispatcher::dispatch('/plugins/suppor...') #1 {main}
     
    [2022-01-24T16:20:16.092067+01:00] general.ERROR: Exception: Plugins is not a valid controller in /home/xxxx/xxxx/public_html/vendors/minphp/bridge/src/Lib/Dispatcher.php:113 Stack trace: #0 /home/xxxx/xxxx/public_html/index.php(21): Dispatcher::dispatch('/plugins/suppor...') #1 {main}  

  13. Blesta Not Downloading Tickets from Mail Server

    in Support

    Posted

    Hello all -

    Recently we upgraded to PHP7.4 and quickly found out that their was a compatibility issue with the bundled Stripe-PHP library and have since downgraded back to PHP7.3. Upon doing so, we reinstalled the required PHP extensions for PHP7.3 but now were are having issues with Blesta downloading emails and attaching them to tickets. There are no errors and the Task is running fine.

    What works:

    1. Client sending 1st email to create a ticket - Ticket is created and the auto-response is delivered and received by client

    2. Ticket is visible in Blesta, staff and respond to the ticket and the Staff response is sent and received by the Client

    3. Client responds to the Ticket via Email - this is where it breaks down. The task is run as normal, the Email is marked as "Read" on the mail server, but the response is never downloaded and attached to the Ticket.

    Like I said, there are no errors showing anywhere and we can figure out what may be causing the issue here. All emails being "sent" by Blesta work fine. We are on Blesta version 5.2

    If anyone has any insight it would be greatly appreciated.

    Thanks

  15. ClientX Blesta Client Area Theme

    in The Marketplace

    Posted

    We tried to use this theme on 5.2 but there were several errors upon switching to the theme. Decided to just use the Default client theme packaged with Blesta but copied over our own copy and make some tweaks to it ourselves until we find a solution that works for us. They attempted to help but there is such a language barrier there that we just don't have the time right now to troubleshoot something we hoped would just work out of the box.

  19. ClientX Blesta Client Area Theme

    in The Marketplace

    Posted

    1 hour ago, WHMCSGlobalServices said:

    Thanks for addressing the css issue can you please post here or send it in ticket we will take care them. Current demo is running with latest blesta version. Yeah we wanted to make this theme productive and we will constantly update.

    Great to hear! Clicked on the link to purchase but I am not seeing where to add the promo code? Thanks

  20. ClientX Blesta Client Area Theme

    in The Marketplace

    Posted

    35 minutes ago, WHMCSGlobalServices said:

    We have restored the demo. Please try now. We are offering 20% off on clientX theme here is the coupon code " BLESTA20"

    Thanks, there are some minor CSS issues throughout the UI that could use some tweaking but may be manageable. This compatible with the latest release and is there intentions to continue supporting the theme? Like I said, don't want to buy another theme and the development on it stops. Thanks.

  23. Error: Too Many Redirects

    in Support

    Posted

    Hello -

    I just migrated my install over to a new host and switched over the DNS and I am getting a "Too Many Redirects" error. The only difference is that before I was on WHM/Cpanel and the install was installed in a subdirectory, and now it was moved to Cloudways/Digital Ocean and set up as a separate application in a root directory. I don't remember if I had to change something in a config file somewhere in order for it to work in a subdirectory or not. Of maybe missing something stupid. Never had this issue before when I moved it the last time.

    Anyone have any ideas what could be causing this error?

    Thanks

    ** EDIT **

    Got it working by commenting out:

      

    # Force HTTPS
RewriteCond %{HTTPS} !=on
RewriteRule ^ https://%{HTTP_HOST}%{REQUEST_URI} [R=307,NE,L]

    in the htaccess file. 

  25. [Components] Html Invoice

    in The Marketplace

    Posted

    Just FYI -

    I had originally purchased this add-on some time ago as an individual add-on, then when it had to be included in a "subscription", I paid the $10 again just so I can use the add-on. Then, I performed an update to Blesta which rendered the add-on useless and was no longer compatible. This happened over a year ago and we're just now getting a "working" version? No thanks, even if it is $10 it's not worth the hassle IMO.

    Sorry, but if you are going to make add-ons for a piece of software that you can't keep up with to ensure compatibility, then maybe you need to scale back and focus on what you're compatible of handling to ensure a good project. Even having a "paid" subscription and submitting multiple tickets trying to get an update and not hearing anything for several months is unacceptable. Don't mean to sound harsh, but others need to know what they're getting into.

×
×
  • Create New...