View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Supportez nous sur Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Database migration and utf8 char conversion - ProjeQtOr

Prochaines sessions de formation

Les prochaines formations et démonstrations sont ouvertes, inscrivez-vous rapidement !

 

Démonstration de ProjeQtOr

(gratuit, sur inscription)

Mardi 23 avril (10h30-12h)

Jeudi 16 mai (16h-17h30)

Jeudi 13 juin (10h30-12h)

 
 

Planifiez avec ProjeQtOr

3 et 4 avril (9h - 12h30)

 
 

Administrez avec ProjeQtOr

10 et 11 avril (9h - 12h30)

 

 

 
 

Database migration and utf8 char conversion

More
08 Déc 2018 12:44 #1 by phvincent
Hello All

I've successfully migrated my projeqtor DEV environment from 6.2.4 to 7.2.7 (I was doubtful but finally it's a great job from you to maintain migration pathes :-) ).

Database is fine except that existing non-ascii chars are not well displayed.
Initial v6 DB had UTF8 charset and utf8_general_ci collation; same for new v7 database.
Did I miss something in the migration setup?

I'd like to solve this issue before migrating my PROD environment for 2 main reasons:
1) providing a correct data display to my users (obvious)
2) more important: make the projeqtor API return well-encoded chars! This is because I developed php scripts using API and json_decode()... which fails when API return json objects with incorrect chars

Thanks for your advices

Please Connexion or Create an account to join the conversation.

More
08 Déc 2018 13:58 #2 by babynus
Please explain :
How you installed Dev env ( I guess charset issue appears here before migration )
Hiw you migrated

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
08 Déc 2018 15:00 #3 by phvincent
DEV was installed with standard method : unzipping v7 package in a new htdocs folder (xampp), leaving the v6 database online to start migration process at first admin login.
I've checked my database is correctly setup and populated after migration.

Continuing investigation I found a workaround: adding "$enforceUTF8='1';" in my parameters.php file (it was present in v6 but disappeared in v7).
Issue seems to be solved.
If you think there's a better way, please let me know.

Cheers

Please Connexion or Create an account to join the conversation.

More
11 Déc 2018 09:17 #4 by babynus
Issue was to unzip in new folder : you should overwrite existing code with new one.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
11 Déc 2018 09:57 #5 by phvincent
Hello Dear Babynus

Ok... I didn't pay attention to the fact that new release has no "default" parameters.php file, so I guess my old parameters would have been preserved.
Thanks for your support and have a nice day

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.042 seconds

Paramétrages de cookies

×

Cookies fonctionnels

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Veuillez vous connecter pour voir vos activités!

Autres cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.