Okay
  Public Ticket #2131618
Notifications problem since amelia update
Closed

Comments

  •  4
    Gregory started the conversation

    Since 2.1 update, Delete notifications for employees have no data for predefined fields.

    For this employee delete notification config : 

    Annulation de séance !
    %customer_full_name% (1ère séance : %custom_field_3%)
    %customer_phone% ; %customer_email%
    %appointment_date% à %appointment_start_time%
    %appointment_price%

    Sujet de la séance :
    %custom_field_6%


    I recieve this mail :

    Annulation de séance !
    (1ère séance : Oui)
    ;
    3 septembre 2019 à 15 h 00 min
    60 €

    Sujet de la séance :
    le sujet de la séance 

    Approved and reported mails are ok. But this mails with empty fields appeared with 2.1 Amelia Plugin.

    Thanks and regards,
    Greg

  •  2,572
    Aleksandar replied

    Hello Greg.

    That sounds really strange - we haven't had anyone report this until now.

    We have released version 2.1.1 with some bug fixes, so can you please update the plugin and try again?

    If it still fails to work correctly, then please provide me a temporary WP-admin login for your site where this happens, so we could log in and take a look ‘from the inside’ as that’s the most efficient way to see and resolve the issue. We do not interfere with any data or anything else except for the plugin (in case that’s a production version of the site), and of course we do not provide login data to third party. You can write credentials here just check Private Reply so nobody can see them except us.

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  4
    Gregory replied

    Hi Aleksandar,

    Thank you for your reply.

    I want to test on my preproduction platform before apply modifications on production.

    I've just tried to install 2.1.1 on my preproduction platform but I've an issue with the Notifications params... When I click on "Save config", there is an error. All seems to be ok in general configuration: I can save modifications in global configuration (also in notification connection config) but not in the notifications text config.
    I've tried to delete Amelia plugin and install 2.1 but the problem persists.

    I need to change notifications config to include cancel url in notifications on my preproduction platform.

    I think it will a good thing to clean the amelia database on preproduction to resolve the config problem. After that, I'll can change config to include cancel url in notifications to test.

    Is there a way to clean amelia db or to activate logs or debug?

    For security reasons, I don't give access to my production platform.

    Best regards.

    Greg

  •   Gregory replied privately
  •  2,572
    Aleksandar replied

    Hello Greg.

    Unfortunately, Skype, Zoom, Teamviewer and other means of support other than ticketing is not included in the provided support of the plugin.

    There's no other way of clearing the database, other than going in and deleting all "amelia" tables in it.

    You're mentioning an error when you click on "Save config" - what error are you receiving?

    Also, which version of PHP are you using? We recommend 7+.

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •   Gregory replied privately
  •   Aleksandar replied privately
  •   Gregory replied privately
  •  2,572
    Aleksandar replied

    Hey Greg.

    This is what I meant:

    So, I'd modified notifications params directly in the database by cli and tested to book and cancel by the customer.

    I created the table in the database using your copy of the dump, and everything seems to be looking fine. Please note that issues like this are very hard to fix without remote access, so I have to ask you for some patience.

    When you receive this error, can you inspect the page and take a look at the Network tab, to see if there are some errors? I guess you'll receive one of the following errors:

    403 - Forbidden

    404 - Not Found

    500 - Internal Server Error

    Also, please take a look at your server log, and look for any errors that occurred at the time when you tried to save the changes.

    We haven't received any complaints about this, and everything works fine on our demo sites, and in local environment, but the fact that everything works fine with an older version of the plugin is definitely something we need to take a look at, somehow.

    Please let me know what you find from the console and the error log

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  6
    Pepo48 replied

    Hi guys,

    +1 for empty fields (placeholders) in cancelation notifications since update. I haven't encountered an server error though.

    Regards,
    P. 

  •  2,572
    Aleksandar replied

    Hi Pepo48.

    So, you too have a service which doesn't have custom field applied to it, and it shows up in the notification e-mail as a placeholder?

    Best regads.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  6
    Pepo48 replied

    Hi Aleksandar,

    currently I use custom field (Text Content), which is applied on multiple services. But I think that the issue, to which Gregory originally referred to, is not only related to custom fields placeholders. At least in my case, it is definitely related to placeholders like %customer_name%, %customer_phone% and %service_name%. For some reason, these 3 placeholders are empty in employees' cancellation notification emails, since last update. On the other hand every other type of email notifications work properly, so it seems to be related just to cancellation notifications. Strange is that date and time placeholders are not affected by this at all.

    Regards,

    P.

  •  4
    Gregory replied

    Hi,

    First of all, to be precise, in production I only encounter the same problem as Pepo48: empty fields in the employee's cancellation email.

    I did a lot of tests with log capture and debug tonight on my preproduction platform ...

    When canceling the appointment with the cancellation link sent to the customer, no error appears at the Apache debug level and neither at the mysql debug level.

    Just differences in the mysql debug.
    Some due to the new features of versions 2.1 and 2.1.1 and others that did not exist in the debug of 2.0.1:
    154 Prepare SELECT * FROM modXXX_amelia_extras
    154 Close stmt
    ....
    154 Prepare SELECT
                        cf cf cf_id,
                        cflabel AS cf _...
                        ....
    FROM modXXX_amelia_custom_fields cf ....
    154 Close stmt

    A command is passed with the version 2.0.1 but does not exist in the debug mysql of the new versions:
    206 Prepare SELECT * FROM modXXX_amelia_providers_to_locations WHERE modXXX_amelia_providers_to_locations.userId =?
    206 Close stmt

    With version 2.0.1, once the mysql connections are gone (205 Quit 206 Quit), there is no extra data in the seconds that follow in the debug.
    With version 2.1.1, new connections are made that apparently do not connect to Amelia's tables. However with this version it is systematic whereas there was none with version 2.0.1.

    I hope this will help solve the problem. I can provide logs and debug via an online file transfer site if needed.


    For information, I also tested after disabling all other extensions and the problem is still present.

    I am going to make a private answer for the problem concerning only the preproduction platform: the notification registration error.

    Best regards.

    Greg

  •   Gregory replied privately
  •  2,572
    Aleksandar replied

    Hi guys.

    We've just tested the notifications on a couple of live Amelia installations (all versions 2.1.1), and everything works fine.

    I will forward this to one of our developers for debugging, but without remote access, it will be very hard to replicate the issue on our end.

    One thought, though. When you're editing the Notifications (email templates), do you maybe have a browser spellcheck extension (for example Gramarly or LanguageTool)? If you do, those need to be turned off when you're editing the templates, because for some reason they mess up the notifications in the database.

    Kind regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  6
    Pepo48 replied

    Hi Aleksandar,

    I use Chrome web browser just with native Chrome spell checker and none of the plugins that you've mentioned, were used during editting the templates. Actually since last update, I edit notifications templates rather directly via database than Amelia UI. I've noticed that every new line written in notification text editor is encapsulated into paragraph html mark (<p>). Morever even break line encapsulates into paragraph now (<p><br></p>) which causes a lot of redundant blank lines in e-mails. Since there is no possibility to set a line spacing via UI, I prefer the database, where I have html syntax more under control. 


    Regards,

    Peter.

  •  2,572
    Aleksandar replied

    Understood Peter.

    Since Greg cannot share his log-in credentials with me, could you?

    If there's a way for our developers to access your WP site and database, to see what's going on on your end, please open a new private ticket, where you'd post these credentials, and we can log in and take a look what's going on.

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  4
    Gregory replied

    Hi guys,

    I just made a wordpress installation any fresh and I only installed on the plugin amelia 2.1.1. Result: same problem in the cancellation notifications. I am very surprised that you are not succeeding in reproducing the problem on your side.

    I will work to make this platform accessible from the internet, which will require me a little more time. I will communicate access by private message.

    Regarding the problem of saving the notification configuration, I found the cause of the problem and solved it. Some php modules were missing on my test platform. After installing all those installed automatically by the hosts as o2switch, no problem at this level.

    Best regards.
    Greg

  •  6
    Pepo48 replied

    Gregory, kudos to you, thank you for the testing and dealing with this problem.

    Aleksandar, I can't provide you my credentials. I think that I've already suggested in another ticket that there are a lot of alternatives how to approach such a situation. Sharing personal credentials without any surveillance is not the right one. Even if I fully trust you. For example sandboxes would be more than appropriate.

    Please, don't get me wrong, I really appreciate all the hard work that all you guys do. We, as customers, just try to address some relevant issues to make your product even better. Our effort sometimes seems to be effortless just because of the "sharing credentials". This happened at least two times to me. Moreover I can't open tickets anymore, because my support  service expired. Ability to file relevant issues should be separated from basic end-user support. Especially more skillful customers (for example like Gregory who actually helps you, not the other way round) have a disadvantage, because they don't typically bother you just with basic questions mentioned in FAQ.

    Regards,

    Peter.

  •  2,572
    Aleksandar replied

    Hi again Greg, Peter.

    I've tried to find someone else with the same problem, but honestly other than you guys, there haven't been any complaints about cancellation notifications not working properly. Have either of you guys tested them in our demo sites?

    Most issues regarding cancellation notifications that customers reported were usually displayed when they were sending out test e-mails, and after they tested with a real appointment, everything worked fine.

    We aren't able to replicate the issue locally, on our demo sites, nor in our customer's WP installations which we log into every day to help with other issues. I kept this in mind, so I did test this on a couple of installations, but everything came up great.

    Peter, one thing I did notice, though is what you mentioned about <p> and <p><br><p> being added in the database. We're looking into this issue, and hopefully it'll be resolved soon.

    When it comes to remote access, like I mentioned to Greg in one of my previous replies:

    Unfortunately, Skype, Zoom, Teamviewer and other means of support other than ticketing is not included in the provided support of the plugin.

    I thank you both for sticking to this until it's resolved, but since we couldn't replicate the issue on our end, there's not much we can do without actually taking a look at a website where the issue occurs. I'll wait for the credentials Greg, and when we locate the issue (and I'm sure we will), we'll post them here, for Peter to be able to see it also.

    Also, Peter, if you're having any other issues with the plugin, please feel free to open a pre-purchase ticket, and we will help even though your support period expired. If it's an urgent issue, or there's something wrong with the plugin, we will definitely help, regardless of if your support is still active or not.

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  4
    Gregory replied

    Hi guys,

    I tested on your demo server a few days ago but it does not test the "provider mail notifications" ... so impossible to test that.

    Moreover, the problem seems to arise only for the customer's name placeholders, phone number and mails. So if your other customers have not added this in employee notification emails, they are not likely to encounter the problem.

    I have just made accessible a brand new test platform which I communicate to you access in private message.

    Regards.

    Greg

  •   Gregory replied privately
  •  4
    Gregory replied

    Hi guys,

    I saw that you did tests and emails confirm what Peter and I have described.

    Do you still need to access my platform?
    Being a virtual machine, it forces me to leave my PC on permanently. So I would like to know if you have the elements that you need or if not, for how much longer do you need to access them?

    Regards,

    Gregory


  •  2,572
    Aleksandar replied

    Hey Gregory.

    Thanks for the credentials. We logged in on Friday and started testing it.

    We were able to replicate the issue, although we still haven't been able to pinpoint the problem. We'll continue to work on this, and I'll get back to you as soon as possible.

    Thanks for your patience, and for your help.

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  4
    Gregory replied

    Hi Aleksandar.

    Thanks for these informations.

    So, do you still need my platform or can I turn it off?

    Best regards.

    Gregory


  •  2,572
    Aleksandar replied

    Hi Gregory.

    You can turn off the platform, we're done testing. We found a bug, and we will be sending you a fix in the next few hours.

    When I tested on our live sites, I couldn't replicate the issue because it seems that the error doesn't appear in our development sites. As for those couple of customers I checked with, I'll have to try to find them again since I didn't keep track of which websites were checked, and I simply kept the issue in mind, so whenever someone gave me credentials and approval to test Google Calendar connectivity (new employee and customer needed to test this), I used those new accounts to test notifications. However, I cannot recall if it was v.2.1.1. Like I said - I will try to look through my history to find those websites and check the versions they had installed.

    Anyway, the issue definitely is on our end, and we'll get back to you in a few hours with a fix.

    I apologize that it took so long.

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  2,572
    Aleksandar replied

    Alright, guys, here's the fix.

    Please replace the files in ../wp-content/plugins/ameliabooking/src with the files located in the .zip attached to this reply.

    This will resolve the issues you were facing with the placeholders and Notifications.

    Again, I apologize it took so long.

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  6
    Pepo48 replied

    Hi Aleksandar,

    First of all thanks for the fix. I've just tested it and it seems that %customer_phone% placeholder still does not work. The other two affected placeholders (%customer_full_name%,%customer_email%) are working properly though.

    Have a nice rest of the day.

    Regards,

    Peter.

  •  4
    Gregory replied

    Hi guys,

    Thank you a lot for this fix.

    On my side it works perfectly but ONLY when the customer cancels with its cancellation url. Firstname, lastname, fullname, email and phone are all in the mail. If the administrator makes the appointment canceled, then the problem persists: no name, no email, no phone ...

    It's better and thank you for your work. If you also solve the problem when the administrator (employee too? Not tested ..) cancels an appointment, it will be perfect :)

    If you need to use my preprod platform to test, let me know here and I'll turn it on.

    Best regards.

    Gregory


  •  6
    Pepo48 replied

    Hello again,

    I can only confirm what's Gregory just mentioned - when an appointment is canceled from backend by administrator, the problem still persists. Moreover, it is also affecting rejection notifications right now, which definitely has not been issue before.

    And as I mentioned in the previous reply, I still have problem with the %customer_phone% placeholder.

    P.

  •  2,572
    Aleksandar replied

    I see, guys.

    I have forwarded the issue to our developer again, so he can take a look.

    Peter - can you tell me how it is affecting the rejection notification?

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  6
    Pepo48 replied

    Hi Aleksandar,

    exactly in the same way as cancellation notification was affected - customer_full_name, customer_phone and customer_email are empty.

    Regards,

    P.

  •  2,572
    Aleksandar replied

    Alright Peter.

    It has been forwarded to our development team. Hopefully we'll have a positive response soon enough.

    Kind regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  2,572
    Aleksandar replied

    Hello again Peter, Greg.

    We have released a new version of the plugin - 2.2 - where all these issues should be fixed.

    Could you, please, download and install the new version, and let me know if everything works fine now?

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables

  •  4
    Gregory replied

    Hello Aleksandar.

    The first time I tested after installing version 2.2, I had the same result as with the fix you sent us: ok when the customer cancels by itself but still the lack of placeholders when the admin cancels.

    I then restart my preproduction platform and it works in both cases.

    So for me it's solved. To see in production because I hope it will not require a reboot ... being hosted I do not have the hand and it will produce a break in service ...

    Regards.

    Gregory


  •  6
    Pepo48 replied

    I haven't tested the new version of Amelia yet, but I have similar experience like Gregory - phone_number placeholder, which hadn't been working for me after you provided the fix (unlike for Gregory), suddenly has started working. So my cancellation notifications seems to be fully functional right now - out of the blue (I didn't restart anything).

    Problem with rejection notifications still persists though, so I will definitely check the new version and let you know.

    Aleksandar, thank you and your team for your effort!

    Regards,

    P.

  •  2,572
    Aleksandar replied

    You're welcome guys.

    If there's anything else we can do, please feel free to let us know. Also I have to thank you both for pointing this out to us. It probably would've went under our radar for quite some time if it weren't for you guys.

    Best regards.

    Kind Regards, 

    Aleksandar Vuković
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables