SOLVED PHPMyAdmin Truncate Table bug

[Gareth-AWD]

In cPanel which uses PHPMyAdmin 4.7.7. If you go to truncate table, it pops up to confirm but the confirm automatically triggers without doing anything in both Chrome and Firefox.

Not sure if it's a cPanel specific bug or PHPMyadmin

 

[cPanelMichael]

Hello @Gareth-AWD,

I've been unable to reproduce this issue (using either phpMyAdmin version 4.7.7, or phpMyAdmin version 4.8.3 in version 76). In both cases, there's a confirmation dialog that appears upon clicking on the "Empty the table (TRUNCATE)" option. Have you reproduced this on multiple workstations?

Thank you.

 

[Gareth-AWD]

Yup, two workstations and different browsers and on two different cPanel servers. We had one user accidentally clear a table because of the issue. Version info below:

• Server: Localhost via UNIX socket
• Server type: MySQL
• Server version: 5.6.41 - MySQL Community Server (GPL)
• Protocol version: 10
• User: [email protected]
• Server charset: UTF-8 Unicode (utf8)

• cpsrvd 11.74.0.10
• Database client version: libmysql - 5.1.73
• PHP version: 5.6.30

• Version information: 4.7.7

 

[cPanelMichael]

Hello @Gareth-AWD,

Upon further testing, I was able to reproduce this behavior on cPanel & WHM version 74, but not on version 70 or version 76. It looks like the newer phpMyAdmin version included in 76 solves the issue that exists in 74. Version 74 will reach EOL status as soon as 76 reaches STABLE (it's currently in RELEASE) since it's not a LTS version.

Are you able to upgrade one of the affected servers to confirm the issue is solved in version 76?

Thank you.

 

[Gareth-AWD]

Yup, upgraded to 76 and it now longer does it