Support forumCategory: BugsGoogle calendar not syncing with EA
jose_luis_penades_perez asked 1 month ago

Hi there,
First to say that creating appointments in GC and then to be able to see them in EA was the reason to buy the plugin.
Second, supposedly to buy the plugin give you a full year support, but unfortunately, I’m still waiting for an answer to my first post that I wrote 3 days ago. I understand you are a one man show, but 3 days is a long time my friend.
Third, when I bought the plugin I created an event in GA, and honestly it worked at first try, although it was created completely empty in EA. But now, I do not know why, GC is not syncing with EA anymore.
I have read all the post talking about this problem, and I have tried all possible solutions, like to remove the token and authorize the app again, actually I have even delete the APP credentials in google developer console and then created again, just in case. It does not solve the problem either.
 
In another post you talk about to change the wp-cron behaviour, but I have tried to run wp-cron manually, and it does not work either. Actually, I have installed WP-CONTROL, and I have execute manually all the events related with EA, including the event called: “eac_google_sync”, but GC is not syncing with EA either. BTW, although I have selected that wp-cron is running every 5 minutes, WP-CONTROL shows that the even is generated every 15 minutes, it’s so weird!
I have download the log file, and the only I can see is an error that says: “There are no new appointments needed to be send to Google Calendar”, but there is no error which says that GA is not sending events from the calendar, I mean there is no error related with my problem either. Here below I copy you the full log, well.. one of the entries, because there are many of them in different hours.

[2021-03-05 18:53:51.035243] [info] Syncing events for Calendar: primary
[2021-03-05 18:53:51.035279] [info] Sync event within next 0
[2021-03-05 18:53:51.262762] [info] Fetched from Google Calendar 20 events
[2021-03-05 18:53:51.273703] [info] Synced events : 0
[2021-03-05 18:53:51.273757] [info] Total sync events : 0
[2021-03-05 18:53:51.274303] [info] There are no new appointments needed to be send to Google Calendar
[2021-03-05 18:53:51.274323] [info] Sync Done
[2021-03-05 18:54:39.733622] [info] Sync started
[2021-03-05 18:54:39.734663] [debug] Calendars for sync
primary: array(
‘location’ => ‘*’,
‘service’ => ‘*’,
‘worker’ => ‘*’,

I have event took a look to the database, and I have seen that the only events are recorded in the DB is the events created in the backend of the website, so it’s clear the system is not populating results from GC to EA.
Summing up… My main reason to buy the plugin was to be able to create events in both directions as the website says very clearly as its first feature, and also to have support from the webmaster. So, if I can not have the plugin working, not to have you as the developer trying to solve the issue, I prefer that you return back my money and to try another solution for my website that works instead.
So… Could you please let me know what could be happening or return my money instead?
 
Thanks in advance!
José Luis Penadés

9 Answers
jose_luis_penades_perez answered 1 month ago

One important thing… The synchronization between EA and Google is working, I mean, if I create an event in EA that appointment is populated to GC perfectly. What it’s not working now, and it was, it is if I create an appointment in GC, that appointment is not populated to EA.
 
I hope you can be able to answer to me asap
 
Thanks in advance!

Nikola Loncar Staff answered 1 month ago

Hi by looking at log there were no events inside Google Calendar. Can you please do the next thing, create advance sync option mappings inside Extension settings that are not set to any but have selected location/service and worker.

Best regards,
Nikola

jose_luis_penades_perez answered 1 month ago

Hi Nikola,
thank you for your answer. Actually, it’s what I have at the beginning. Although in your instructions you said it’s not needed to create a connection in EA Advanced Table if you want that only your primary google calendar is connected to EA, I created that connection, but it doesn’t work now. I will re create again, I will do testing, and I will let you know, although I have no hope about it.
I will keep you posted!
 
José Luis

jose_luis_penades_perez answered 1 month ago

Hi Nikola,
I was able to create an appointment in GA, and now after have created a connection in Advance Tab directly pointing to the service and worker, now GC is in sync with EA. Cool!! Thanks!
But now, maybe we can go to solve the other issue, which is that GC does not send any info about the appointment, I mean GC does not send the Title of the event, nor the description, etc… GC just send the hour and that’s all.
Is the synchronization failing from GC to EA, or there is a correct way to fill out the event in GC so that EA can fill out the info about the appointment?
 
Let me know,
José Luis

sjoerd_van_dijk replied 1 month ago

When you delete an event (made and synced in GC) in GC is it also deleted out of EA? That is my problem for now.

jose_luis_penades_perez replied 1 month ago

Hi Sjoerd, if you delete an event in Google Calendar, that event is deleted from EA as well, independently of it was created in EA or GC.

Said this, if you created the event in GC, that event will not be deleted from EA until the cron job called “eac_google_sync” is executed in WordPress.

As I have written in another post, at least in my case, I have selected in the options and interval of 5 minutes for the cron jobs to be executed, but this option is not working, and the cron job is being executed every 15 minutes.

So, you have two options to check if the cron job is working:

1. Install a plugin like WP-Control, and look for the cron job “eac_google_sync” and run it manually and check if the event is deleted.
2. wait 15 minutes until the cron job is executed. Maybe you would be in the minute 14 of the cycle when you delete the event in GC, so you will se that the event is deleted after only one minute.

IMPORTANT!! Regarding cron jobs… if you have disable wordpress to do cron jobs, the time of execution of the WordPress cron jobs will depend of the time you have given to the cron job you did in cPanel or Plesk, ok? If you do not understand nothing of I have told you here, is because your wordpress is still running the cron jobs for you, hehe…

I hope I help you!

Best Regards,
José Luis

sjoerd_van_dijk replied 1 month ago

Hi José,

Thanks for your respons. The cronjob is working. I used my own cronjob interval trough Directadmin and checked it with the plugin Cronjobs. I use the interval of 5 minutes also in Directadmin. The event made in GC and after syncing deleting it in GC is not working. But I will check and test all my settings again and let you know.

Regards.

jose_luis_penades_perez replied 1 month ago

Oops, I’m sorry for the problems!

In my case, the thing that make the synchronization work it was to configure every service/worker in the advance tab. I have 3 services for just one worker, and I created 3 connections, one for each service for the same worker.

I checked after I read your message, because as you know I have more problems that this one. I created an event in GC, and then I checked in EA, and everything was ok. Then I deleted in GC, and after force the cron job to sync EA with GC, that event created in GC was deleted.

If you can not make it work, maybe you can upload an screenshot of your configuration here: https://imgur.com/, and I could see if your parameters are equal to the ones I have. Of course, cross out any relevant personal information on the image, ok?

Maybe is a simple thing and we can solve it without Nikola’s help.
A user helping another user, OMG!

sjoerd_van_dijk replied 1 month ago

Thanks for your message José.

Only removing of the events made in GC is not syncing/working correctly. Not that big of a problem for me for now, is uncommon. But would be nice if it worked.

See the screenshot for my settings: https://imgur.com/a/Jr8Wujo

sjoerd_van_dijk replied 1 month ago

ps. I only have one worker and one service

blenkhn replied 1 month ago

Did you solve this?

sjoerd_van_dijk replied 1 month ago

Hi,

Not the syncing between GC and EA when removed a event made in GC. But there is a new version so I gonna test again.

jose_luis_penades_perez answered 1 month ago

Any news regarding this Nikola?
Again three days waiting for an answer and no news from you!
 
I tried a solution offered by another user, I deactivated the “Copy Settings” button, but it doesn’t solve my problem. I could try to delete the tables in the database as well as that user suggest, but I prefer first to know if you think that could solve the problem, before starting to touch those kind of things.
As I told you I can create an admin link to the backend of site to see into it if you prefer.
 

elkosx18 answered 1 month ago

you just need to delete the data from that one table because its the relation between the google_cal id and the ea ones. so from sync perspective its already done if the google id is present. therefor I suggested to drop delete FROM `wp_2_ea_connect_links` and it will be inserted again and in my case exactly (even the custom fields). on the connect tab I use for DELETE FROM `wp_2_ea_connect_links`
if you like I send screenshots of my settings if you mail elkosx18ATgmail.com your address. alrready prepared
 

elkosx18 replied 1 month ago

sorry, messed something with cut&paste
Settings https://osteopathie-lechner.de/settings.png
Result in google: https://osteopathie-lechner.de/google.png
maybe its a help. Its all at ~/wp-admin/admin.php?page=easy_app_connect

elkosx18 replied 1 month ago

and you can deactivate crons by
define( ‘DISABLE_WP_CRON’, true);

in wp-config.php and I am using a wrapper script (cpanel or whatsorever) like

#!/bin/sh
cd ~/webseiten/wp_ol.de
/usr/bin/php /home/user/webseiten/wp_ol.de/wp-cron.php 2>&1 >> wp.log

blenkhn replied 1 month ago

my ea_connect_links table is empty. what is wrong?

jose_luis_penades_perez replied 1 month ago

Hi Elkosx,
Unfortunately I can not create cron jobs in this website in the way you create it in your hosting. You have cPanel, but I can not access to any cPanel in my hosting. But I know how to disable WP_CRON and make it work every 5/10 minutes, because I have other websites that have cPanel available.

I can not see anything wrong in the screenshot of your parameters. They are really similar to what I have configured in my settings, with the exception of the Event Subject and Description tags. I’m not sure if that could have something to do, but all my tags are separated by commas, instead by hyphens or blank spaces.

I have a very short acknowledge of php, and if that filed is processed in the code taking in count those commas to separate the different variables, that’s could be the reason of the fail. Of course, I’m not sure, and Nikola can really let us know whether those tags should be separated with commas, or just with blank spaces is enough. But… maybe it deserves a try, right?

Can you separate those tags with commas and give it a try?
I mean to replace #anrede# #vorname# — by — #anrede#, #vorname#

jose_luis_penades_perez replied 1 month ago

Another thing is that when you delete and event in GC, you must wait again to the proper cron job to run in your website. I’m not sure if the cron job that delete reservations is this one: “easyapp_hourly_event” or this one “eac_google_sync”. But if you do not want to wait to the cron job is executed, install WP-CONTROL plugin, enter in the events tab, look for thsoe cron jobs and click on “Run Now”. That way you will be able to see the result of removing events in GC instantly. I mean… just to be sure that the problem is not those cron jobs, you know?

elkosx18 replied 1 month ago

well, as I just have production sites using the calendar I cannot change things for testing. But I have no “,” right behind the #value# #of# #custom_fields# and all is doing well. Try without?! 🙂

elkosx18 replied 1 month ago

also my cronjob is running fine, I just wanted to help you pasting my setup because all is working perfect at my pages. I had some issues solved by the resyncing arround xmas because I changed the google account and had to recreate the api keys at google dev console, after that it wsnt synching until I found the solution I have suggested to you earlier. So no problems at my end sorry I coudnt help you

elkosx18 replied 1 month ago

but just seen the primary: array(
‘location’ => ‘*’,
‘service’ => ‘*’,
‘worker’ => ‘*’,

It should be the number of the service,worker and location instead of a *.
Probably therefor it cannot find the correct relation between the ea part and the google part i guess. I would try to add an entry at backend->ea->connect beta->Advanced Calendars sync add … and would bet you get it working

Nikola Loncar Staff answered 1 month ago

Hi Jose, new version is deployed so you should be able to see description field synced back to EA for new events on Google Calendar.

Best regards,
Nikola

jose_luis_penades_perez replied 1 month ago

Hi Nikola, I can confirm that now it’s working properly. In any case, I suggest you to find a way to allocate the title in GC of the events to the Client field in EA, and then allocate the description in GC to description field in EA. Maybe writing a character like @ or %, or the like before the title and description? Think about it!

jose_luis_penades_perez answered 4 weeks ago

Hi Nikola, I’m not happy to return here again, but since the update everything this is not working again. Nothing is synced from GC to EA, because all the events are created with the same id = 0.
After a deep look to what can be happening, this behaviour is not only happening in the appointments table, but on all the tables. I mean, if your create a new service, this service is created with id=0, or if you see into the options table, all the options has id=0.
 
I do not know what change in the last version, but all my database is a disaster, and nothing works again. I do not know what to do now actually, but I would like to start again from zero after have been entering all my events for the upcoming months for so many hours. OMG!
Any idea Nikola of what happened?
Am I the only one with a problem like this one?

jose_luis_penades_perez answered 4 weeks ago

Hi Nikola, I’m not happy to return here again, but since the update everything this is not working again. Nothing is synced from GC to EA, because all the events are created with the same id = 0.
After a deep look to what can be happening, this behaviour is not only happening in the appointments table, but on all the tables. I mean, if your create a new service, this service is created with id=0, or if you see into the options table, all the options has id=0.
 
I do not know what change in the last version, but all my database is a disaster, and nothing works again. I do not know what to do now actually, but I would like to start again from zero after have been entering all my events for the upcoming months for so many hours. OMG!
Any idea Nikola of what happened?
Am I the only one with a problem like this one?

jose_luis_penades_perez replied 4 weeks ago

Sorry, I wanted to say that I would not like to start again from zero again if possible, it was a hard to transfer all my events from my agenda to EA.

Nikola Loncar Staff replied 4 weeks ago

Hi Jose, can you please send me access to WP Admin part to nikolanbg[at]gmail[dot]com

Best regards,
Nikola