1. Joost Smits
  2. Valentina Studio
  3. Thursday, August 05 2021, 08:50 AM
  4.  Subscribe via email
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.
Attachments (1)
Comment
There are no comments made yet.
Sergey Pashkov Accepted Answer
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?
References
  1. https://valentina-db.com/bt/view.php?id=8995
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 1
Sergey Pashkov Accepted Answer
The fix will be available in version 11.4.2.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 2
Joost Smits Accepted Answer
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)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 3
Sergey Pashkov Accepted Answer
Yes, exactly, the algorithm to apply bound parameters was fixed and will be available in the next build.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Studio
  3. # 4
  • Page :
  • 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