phpmyadmin/phpmyadmin

Random millisecond value wen editing time in the webinterface

Open

#19,620 建立於 2025年3月5日

在 GitHub 查看
 (3 留言) (0 反應) (0 負責人)PHP (3,454 fork)batch import
Bugaffects/5.2affects/6.0confirmed/5.2help wanted

倉庫指標

Star
 (6,886 star)
PR 合併指標
 (平均合併 2天 17小時) (30 天內合併 11 個 PR)

描述

Describe the bug

Wen i try to edit the decimal places of a time value of a database entry in the phpMyAdmin webUI the decimal places value gets changed to a seemingly random value.

To Reproduce

Steps to reproduce the behavior:

  1. Go to a table containing a time [not time(0) ]
  2. Doubleclick on the a time value to edit it
  3. Change the decimal places using the text field
  4. Press enter to set new value
  5. See that the value was not changed to the value typed into the textfield
  6. The displayed SQL query already contains a seemingly random value for the millisecond part
  7. even if you try to type the same decimal places value over and over again the decimal places will always be different

Expected behavior

I would expect that the value i type is taken as new value (potentaly to many digist shloud be cut of). Wen i use the millisecond slider it works as expected despite that slider "typing" in a value in the text field.

Screenshots

If applicable, add screenshots to help explain the bug.

Server configuration

The server is just a rented wordpress installation

  • Operating system: Ubuntu 22.04 (?)
  • Web server: Apache
  • Database version: 10.6.20-MariaDB-ubu2204
  • PHP version: 8.0.30
  • phpMyAdmin version: 5.2.2

Client configuration

  • Browser: Firefox & Chromium
  • Operating system: Kubuntu 24.10

Additional context

I used time(2) and manly tested with that because i need precision to 1/100 of a second but the behavior was similar wen using other values for the size of the time field.

貢獻者指南