View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Bug with table prefix - ProjeQtOr
 

Bug with table prefix

More
13 Jan 2019 21:56 #1 by ppmichirones
ProjeQtOr version 7.3.3

When I install:
  1. At parameters configuration page, I set DbPrefix with "abCd_" string
  2. All configuration correct. The parameters.php file contains a "$paramDbPrefix='abCd_';" line
  3. I login with admin/admin default. Database population occurs.
  4. I regard in log file that database tables are created with "abcd_" prefix (pay attention to character case)
  5. When database population finish, the new parameters.php file contains "$paramDbPrefix='abCd_';" line
  6. Now, the login to ProjQtOr with admin/admin is posible, but stops at login page.

I have to manually change the new parameter.php in order to set "$paramDbPrefix='abcd_';" line and the first connection occurs.

I think this is a bug.

Please Log in or Create an account to join the conversation.

More
16 Jan 2019 16:38 #2 by babynus
Replied by babynus on topic Bug with table prefix
You are right : parameter should be stored in lowercase.
Ticket #3776 recorded.

NB : this converstion to lowercase is important to ensure PostgreSql compatibility (who converts table names to lower case, whaterver to case on the script)
This has no impact on Windows but uppercased-prefix issue may occur on linux.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.038 seconds

Cookies settings

×

Functional Cookies

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

Please login to see yours activities!

Other cookies

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