Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

No login possible w...
 
Notifications
Clear all

No login possible with table prefix containing underscore

6 Posts
3 Users
0 Reactions
1,415 Views
(@laurentc)
Posts: 100
Active Member
Topic starter
 
[#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.
 


 
Posted : 05 Oct 2021 18H40
Flou
 Flou
(@flou)
Posts: 253
Active Member
 

Hello,

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


 
Posted : 12 Oct 2021 11H54
(@laurentc)
Posts: 100
Active Member
Topic starter
 

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@".


 
Posted : 12 Oct 2021 12H02
(@babynus)
Posts: 14952
Member 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)


 
Posted : 15 Oct 2021 14H04
(@laurentc)
Posts: 100
Active Member
Topic starter
 

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.


 
Posted : 15 Oct 2021 15H35
(@laurentc)
Posts: 100
Active Member
Topic starter
 

.


 
Posted : 15 Oct 2021 15H36
Share:

Scroll to Top