Forum

No login possible w...
 
Notifications
Retirer tout

No login possible with table prefix containing underscore

6 Posts
3 Utilisateurs
0 Reactions
1,414 Vu
(@laurentc)
Posts: 100
Estimable Member
Début du sujet
 
[#7803]

Hello,
I've tested the last version 9.2.4 (fresh install) with XAMPP.
XAMPP rune correctly
Databse created, OK.
Tables created, OK
But impossible to connect with admin/admin.
Message:
ERRORS DURING UPGRADE TO VERSION V9.2.4

The root cause has been identified: it's a "_" in the prefix table name !! 
Best regards,
#L.
 


 
Posté : 05/10/2021 6:40 pm
Flou
 Flou
(@flou)
Posts: 253
Reputable Member
 

Hello,

indeed it is possible that it can create some issues.
have you a screenshoot of your issue message ?


 
Posté : 12/10/2021 11:54 am
(@laurentc)
Posts: 100
Estimable Member
Début du sujet
 

No screenshot as the database needed to be erased and re-created.
The message was "XXXX database errors". I do not remind how much was XXXX, but it was a huge value.
During the installation, I've put a "PT_" prefix. A quick look at the database content shows that the "PT_" It has been changed to "PT@".


 
Posté : 12/10/2021 12:02 pm
(@babynus)
Posts: 14952
Membre Admin
 

Strange, I create db with prefix "PT_", it was just changed to lowercase "pt_" and works fine.
With Database / Version are you using ?
What is the encoding of yourt DB ? (UTF-8 required)


 
Posté : 15/10/2021 2:04 pm
(@laurentc)
Posts: 100
Estimable Member
Début du sujet
 

The impacted database has been erased and replaced with a "no prefix" one, which works fine. But, anyway, except the prefix it may have the same parameters than the parameters.txt attached.  Yes, it' utf-8.


 
Posté : 15/10/2021 3:35 pm
(@laurentc)
Posts: 100
Estimable Member
Début du sujet
 

.


 
Posté : 15/10/2021 3:36 pm
Share:
Retour en haut