1. Joost Smits
  2. Valentina Studio
  3. Donnerstag, August 05 2021, 08:50 AM
  4.  Abonnieren via E-Mail
I tried to find an answer to this question but did not find it.

I have a table storing user names and hashed passwords (php password_hash), and some other fields in MySQL. I can add a user with such a password, which typically start with $2y$ , but that may continue for example like $2y$10$Lz. Adding (INSERT) works fine.

However, when I edit the record in Valentina Studio, and want to change one of the other fields, I get an error. See the attached screenshot.

Apparently the sequences like $2y are converted to characters (interpreted as control characters), which results in an error.

I now use an SQL script to update the record with the proper id, but that is a hassle.

What can I do to make this work? I tried escaping with \, but that does not seem to work.
Anhänge
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
The fix will be available in version 11.4.2.
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Hello Joost,

I think it requires a fix, I added it to the bug tracker.
But what about the structure of this table - is there a primary key on some integer field?
Referenzen
  1. https://valentina-db.com/bt/view.php?id=8995
Kommentar
There are no comments made yet.
Joost Smits Akzeptierte Antwort
Thank you, @Sergey. I checked. If the table has no primary record you get the error. If the table has a primary record there is no error. Looks indeed like something that needs fixing.
Here is a hashed password ("test";) for testing: $2y$10$DmcCjTU1erh9OQHzDwTeCuoRa/n6wxKyqLQOhjZC1X94sqbFbqJse (using php password_hash)
Kommentar
There are no comments made yet.
Sergey Pashkov Akzeptierte Antwort
Yes, exactly, the algorithm to apply bound parameters was fixed and will be available in the next build.
Kommentar
There are no comments made yet.
  • Seite :
  • 1


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories