1. Joost Smits
  2. Valentina Studio
  3. 木, 8月 05 2021, 08:50 AM
  4.  メールで購読
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.
添付ファイル
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
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?
参照
  1. https://valentina-db.com/bt/view.php?id=8995
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
The fix will be available in version 11.4.2.
コメント
There are no comments made yet.
Joost Smits 承諾済みの回答
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)
コメント
There are no comments made yet.
Sergey Pashkov 承諾済みの回答
Yes, exactly, the algorithm to apply bound parameters was fixed and will be available in the next build.
コメント
There are no comments made yet.
  • ページ :
  • 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