1. Joost Smits
  2. Valentina Studio
  3. Четверг, Август 05 2021, 08:50 AM
  4.  Подписаться через 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.
Вложения
Комментарий
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