I am trying to get Google maps running.
I acquired a key, and have set up the configuration.
However when I Edit geographic place locations
I get the error message:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE: General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
I have set up PGV with UTF-8. However it is sharing the same database as Joomla.
When I go into mysql I get the following message:
mysql> select collation('hello');
+-------------+
| collation('hello') |
+-------------+
| latin1_swedish_ci |
+-------------+
1 row in set (0.00 sec)
Please help, what is wrong, and how to correct it,
Thanks
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hallo All,
I am trying to get Google maps running.
I acquired a key, and have set up the configuration.
However when I Edit geographic place locations
I get the error message:
Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE: General error: 1267 Illegal mix of collations (utf8_unicode_ci,IMPLICIT) and (utf8_general_ci,IMPLICIT) for operation '='
I have set up PGV with UTF-8. However it is sharing the same database as Joomla.
When I go into mysql I get the following message:
mysql> select collation('hello');
+-------------+
| collation('hello') |
+-------------+
| latin1_swedish_ci |
+-------------+
1 row in set (0.00 sec)
Please help, what is wrong, and how to correct it,
Thanks
Probably same issue as this:
https://sourceforge.net/projects/phpgedview/forums/forum/185166/topic/3500610
Hallo,
I looked at the link and starting experimenting.
After creating a new MySQL database, setting up PGV, and reimporting the previous saved GEDCOM, the problem was solved.
TIP: do not delete or overwrite the media folder, then the links are OK.
Danke