How do I change the default installation language from spanish to english or swedish? I don't understand now because it's in spanish. I did a new fresh installation, before that i took a backup of my ged-com file.
Thanks
//Tobbe
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
"ERROR:-1 DB Error: unknown error
SQL:SELECT DISTINCT n_surn, n_surname, n_id FROM pgv_individuals JOIN pgv_name ON (i_id=n_id AND i_file=n_file) WHERE n_file=1 AND n_type!='_MARNM' AND (n_sort LIKE 'GARNEIJ,%') ORDER BY n_sort [nativecode=1267 ** Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=']
Fatal error: Call to undefined method DB_Error::fetchRow() in /customers/smultronet.org/smultronet.org/httpd.www/familjer/includes/functions/functions_db.php on line 667
Konfigurationsområde My Tasks
Task Name"
My Server Info
-----------------
OS Linux
Database Data Disk Usage 2,8 MiB
Server Apache
Database Index Disk Usage 1,5 MiB
PHP v5.2.8
MYSQL Maximum Packet Size 16,0 MiB
MYSQL v5.0.32-Debian_7etch8-log
MYSQL Maximum No. Connection 2.048
GD bundled (2.0.34 compatible)
PHP Short Tag On
Server Hostname smultronet.org
PHP Safe Mode On
PHP Memory Limit 24,0 MiB
PHP Max Upload Size 12,0 MiB
PHP Max Post Size 12,0 MiB
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
For all the other somewhat confused users out there:
During installation, PGV will use the first language in the browser's preferred language list that it supports. If none of the browser languages are in PGV's supported languages list, it will default to English.
Thus, if you want to install in Swedish, you need to make sure that Swedish is ahead of any other language in the browser's preferred language list. If you want to do the work in English, you need to make sure that English is first in the list.
Remember that the browser's preferred language list is in order of preference. If you're seeing things in Spanish where you'd rather see them in Swedish or English, Spanish must currently be ahead of other languages.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
<<For all the other somewhat confused users out there:
During installation, PGV will use the first language in the browser's preferred language list that it supports. If none of the browser languages are in PGV's supported languages list, it will default to English.
Thus, if you want to install in Swedish, you need to make sure that Swedish is ahead of any other language in the browser's preferred language list. If you want to do the work in English, you need to make sure that English is first in the list.
Remember that the browser's preferred language list is in order of preference. If you're seeing things in Spanish where you'd rather see them in Swedish or English, Spanish must currently be ahead of other languages. >>
I still think this is the wrong way to do it. It's fine to auto-detect but forcing someone to change some arcane browser setting to override it is not the best way to go. It may be good programming, but it's bad "design". Being from Canada I use en-gb as the default language so there are sites that force me to the UK version of their site, which is often wrong.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
I think the original reason for en-gb was something to do with the spell checker, but I don't really remember anymore. Or it may be just the normal default if you download the en-gb localised version of Firefox. Anyway it isn't really a problem for me unless a website sends me to the UK version and doesn't give me an option to switch to US or Canadian or North American or whatever. That's the "bad design" I was referring to.
<<Anyway, I disagree that we're "forcing a user to change an arcane browser setting"
If the user knows how to change it, it's not arcane.>>
Trouble is the average user >doesn't< know how to change it :)
<<And if the user doesn't know how to change it, then it's still set to English, isn't it? >>
I don't personally have a problem with it of course. But some people do, and a lot of those people don't find their way here to find out how to work around it.
<<Still, it might be one step better to read all the browser prefs, and put them into a menu in order.
Let the very first step be selecting a language from that menu. (with the top being the default) >>
Doing that doesn't even require reading any browser prefs. It can default to English and allow a change to any supported language in a drop down. Or use the browser sniffing to pick the language it opens in and have a dropdown of all supported languages in PGV, not necessarily the languages the browser lists.
Using browser sniffing and geo-location is a tool that can be useful, but it isn't infallible. For instance one geo-location database for quite a while had my Montreal, Canada IP address located in Florida. That's why it's "good design" to allow the user a fast (and simple!) way to over-ride things.
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
If the user's browser isn't set to English, *somebody* must have done it. Surely, if you've installed the French version of your OS or picked French when installing your browser, you must have a preference for French?
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
Hi,
How do I change the default installation language from spanish to english or swedish? I don't understand now because it's in spanish. I did a new fresh installation, before that i took a backup of my ged-com file.
Thanks
//Tobbe
Fixed it anyway :)
But...I get this instead:
"ERROR:-1 DB Error: unknown error
SQL:SELECT DISTINCT n_surn, n_surname, n_id FROM pgv_individuals JOIN pgv_name ON (i_id=n_id AND i_file=n_file) WHERE n_file=1 AND n_type!='_MARNM' AND (n_sort LIKE 'GARNEIJ,%') ORDER BY n_sort [nativecode=1267 ** Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=']
Fatal error: Call to undefined method DB_Error::fetchRow() in /customers/smultronet.org/smultronet.org/httpd.www/familjer/includes/functions/functions_db.php on line 667
Konfigurationsområde My Tasks
Task Name"
My Server Info
-----------------
OS Linux
Database Data Disk Usage 2,8 MiB
Server Apache
Database Index Disk Usage 1,5 MiB
PHP v5.2.8
MYSQL Maximum Packet Size 16,0 MiB
MYSQL v5.0.32-Debian_7etch8-log
MYSQL Maximum No. Connection 2.048
GD bundled (2.0.34 compatible)
PHP Short Tag On
Server Hostname smultronet.org
PHP Safe Mode On
PHP Memory Limit 24,0 MiB
PHP Max Upload Size 12,0 MiB
PHP Max Post Size 12,0 MiB
<<Illegal mix of collations (utf8_general_ci,IMPLICIT) and (utf8_unicode_ci,IMPLICIT) for operation '=']>>
use phpMyAdmin (or some other tool) to convert the collation all your tables (and all the columns within them) from utf8_general_ci to utf8_unicode_ci
For all the other somewhat confused users out there:
During installation, PGV will use the first language in the browser's preferred language list that it supports. If none of the browser languages are in PGV's supported languages list, it will default to English.
Thus, if you want to install in Swedish, you need to make sure that Swedish is ahead of any other language in the browser's preferred language list. If you want to do the work in English, you need to make sure that English is first in the list.
Remember that the browser's preferred language list is in order of preference. If you're seeing things in Spanish where you'd rather see them in Swedish or English, Spanish must currently be ahead of other languages.
Hi,
Done that. All is ok.
Thanks alot :)
//Tobbe
<<For all the other somewhat confused users out there:
During installation, PGV will use the first language in the browser's preferred language list that it supports. If none of the browser languages are in PGV's supported languages list, it will default to English.
Thus, if you want to install in Swedish, you need to make sure that Swedish is ahead of any other language in the browser's preferred language list. If you want to do the work in English, you need to make sure that English is first in the list.
Remember that the browser's preferred language list is in order of preference. If you're seeing things in Spanish where you'd rather see them in Swedish or English, Spanish must currently be ahead of other languages. >>
I still think this is the wrong way to do it. It's fine to auto-detect but forcing someone to change some arcane browser setting to override it is not the best way to go. It may be good programming, but it's bad "design". Being from Canada I use en-gb as the default language so there are sites that force me to the UK version of their site, which is often wrong.
Being from Canada, can't you use en-ca ?
Anyway, I disagree that we're "forcing a user to change an arcane browser setting"
If the user knows how to change it, it's not arcane.
And if the user doesn't know how to change it, then it's still set to English, isn't it?
Still, it might be one step better to read all the browser prefs, and put them into a menu in order.
Let the very first step be selecting a language from that menu. (with the top being the default)
<<Being from Canada, can't you use en-ca ?>>
I think the original reason for en-gb was something to do with the spell checker, but I don't really remember anymore. Or it may be just the normal default if you download the en-gb localised version of Firefox. Anyway it isn't really a problem for me unless a website sends me to the UK version and doesn't give me an option to switch to US or Canadian or North American or whatever. That's the "bad design" I was referring to.
<<Anyway, I disagree that we're "forcing a user to change an arcane browser setting"
If the user knows how to change it, it's not arcane.>>
Trouble is the average user >doesn't< know how to change it :)
<<And if the user doesn't know how to change it, then it's still set to English, isn't it? >>
I don't personally have a problem with it of course. But some people do, and a lot of those people don't find their way here to find out how to work around it.
<<Still, it might be one step better to read all the browser prefs, and put them into a menu in order.
Let the very first step be selecting a language from that menu. (with the top being the default) >>
Doing that doesn't even require reading any browser prefs. It can default to English and allow a change to any supported language in a drop down. Or use the browser sniffing to pick the language it opens in and have a dropdown of all supported languages in PGV, not necessarily the languages the browser lists.
Using browser sniffing and geo-location is a tool that can be useful, but it isn't infallible. For instance one geo-location database for quite a while had my Montreal, Canada IP address located in Florida. That's why it's "good design" to allow the user a fast (and simple!) way to over-ride things.
I'm NOT going to change this (again).
If the user's browser isn't set to English, *somebody* must have done it. Surely, if you've installed the French version of your OS or picked French when installing your browser, you must have a preference for French?
This script will convert the db, worked well for me:)
// your connection
mysql_connect("localhost","root","***");
mysql_select_db("db1");
// convert code
$res = mysql_query("SHOW TABLES");
while ($row = mysql_fetch_array($res))
{
foreach ($row as $key => $table)
{
mysql_query("ALTER TABLE " . $table . " CONVERT TO CHARACTER SET utf8 COLLATE utf8_unicode_ci");
echo $key . " => " . $table . " CONVERTED<br />";
}
}