Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

How to resolve time zone error while connecting External account MYSQL Data base in adobe Campaign classic client console

Avatar

Level 2

Hi Team,

I am getting below error while trying to connect with external account MYSQL Database.

"MYS-230000 MYSQL error 1298:Unknown or incorrect timezone:"

MySQL Database server is with time zone (GMT-05:00)Est(united states and Canada).

Could you please suggest how to fix the issue.

Thanks

Vinaya

3 Replies

Avatar

Level 2

Hi Amritakedia, The value for WDB-200001 SQL statement 'SET time_zone='America/New_York'' .

 

Yes its not resolving to WDB time zone.

 

Thanks Vinaya

Avatar

Level 1

Hi @vinayababu, Was this resolved? Can you help me with this?

I remember someone telling me that zoneinfo.zip to be modified [or] xtk:commons:timezone needs to be changed before the server loads. but I'm unable to remember it clearly.