Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

CRM
e-Commerce
会計
在庫
PoS
プロジェクト
MRP

All apps

全てのポスト人々バッジ

タグ (全て表示)

odoo accounting v14 pos v15

このフォーラムについて

ヘルプ

Google Calendar Sync: "Ending date cannot be set before starting date."

error dates synchronization google_calendar

4 返信

6499 ビュー

James White

First sync with Odoo and everything appears fine but when I push the "Sync with Google" button, I get this error:

"Ending date cannot be set before starting date."

Unfortunately, the error gives me no idea of which item it is referring to. I have viewed all appointments in list view to confirm that they all have a valid start vs end time (and they all have a positive duration)

Is this something that I can look up in an error log somewhere?

<gripe>

And WHY OH WHY would any developer not include some reference in his error? An error saying "yer screwed mate" is not nearly as valuable as one that says "Record with start date 20171201 has an error of the following type..."

</gripe>

Marco Viviani

最善の回答

No James, you are not the only one.
This just happened to me too (same error message), suddenly, with no apparent reason, and I am searching desperately a way to fix.

I am using version 10 and I am experiencing date troubles.
As far as we tried to fix it, we suppose (just suppose) it is a date format problem, probably in the calendar.py file

# Convert the start date to saved timezone (or context tz) as it'll
# define the correct hour/day asked by the user to repeat for recurrence.

startdate = startdate.astimezone(timezone) # transform "+hh:mm" timezone

rset1 = rrule.rrulestr(str(self.rrule), dtstart=startdate, forceset=True)

recurring_meetings = self.search([('recurrent_id', '=', self.id), '|', ('active', '=', False), ('active', '=', True)])

for meeting in recurring_meetings:
rset1._exdate.append(todate(meeting.recurrent_id_date))
return [d.astimezone(pytz.UTC) for d in rset1]

Did you experienced problems with recurring events?

James White

著作者

Hi Marco, it suddenly started working - I did nothing. Now I am on Odoo 11+e and everything works fine. I count on recurring appointments and so far have had no problems at all.

I strongly recommend upgrading to 11 - it is a good upgrade and solves some problems.

Marco Viviani

Thank you for the quick reply!

I will try to upgrade, but I never did it.

Is it possible to keep the same PostgreSQL DB used with Odoo 10?

James White

著作者

Yes... kind of. Go to https://upgrade.odoo.com and fill in the form. You will see instructions on how to EXPORT your existing database for upgrading. Once they are completed upgrading and testing for you, they will supply the UPGRADED database which you then import.

The first time you really want to read the instructions, but it goes pretty smoothly overall.

Marco Viviani

Thank you James, we upgraded to version 12 and many bugs are over now :-)

anyway we still have a problem with recurrent events when the time switches from winter to summer time. Odoo shiftes the meeting hour of 1 and this causes a lot of problems...

May be you solved this one too?

Thank you very much

Marco Viviani

...actually I just solved it. Just set the timezone for your User.

James White

著作者

Very good. I was going to go into my settings to check timezones... but you beat me to it!

James White

著作者

I have burned two weeks trying to figure out if the problem is in Google or Odoo. Since neither has any support at all - it's really just trial and error.

After exporting my .ics from Google, I have manually reviewed every appointment and NONE of them have an event that ends before it starts. So now this just looks like an Odoo bug.

Am I the only person having this problem?

Dimitri

I also have the "Ending date cannot be set before starting date." issue (Odoo 11 CE). The difference is that this calendar didn't complete a sync yet. It is a calendar which contains data over the past 10 years and I don't have a week to spare to check all these appointments...

A more useful error message would be appreciated. If someone has a quick solution, that would be great.

James White

著作者

Hi Dimitri, it is interesting that both of us are trying to import very OLD calendars. perhaps that is a hint.

Also interesting, the problem has recently solved itself and I have done nothing to make this happen. Is your calendar still having the problem?

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！

今すぐアカウントを作成して、限定機能を利用したり、素晴らしいコミュニティと交流しましょう！

登録

関連投稿	返信	ビュー
Fehler 400: redirect_uri_mismatch - Synch Google Calender / 17.0 synchronization google_calendar	0 3月 24	4
odoo 11 CE: google calendar synchronisation connection error 400 error device invalid synchronization google_calendar	2 9月 18	6031
How to sync multi calendars of the same google account calendar synchronization google_calendar	1 2月 24	5577
Synchronization with Google Calendar working only one way - Odoo v14 calendar synchronization google_calendar	0 4月 21	3445
[Google Calendar Synchronisation] - Duplicated evenements synchronization google_calendar duplicated	0 7月 20	3507

この質問にフラグが付けられました

ディスカッションを楽しんでいますか？読むだけでなく、参加しましょう！