Created procedure (using side-column) shows up in triggers...

[claskfosmic]

Steps to reproduce

1. Create a new database with a table with a trigger on it. Also, create a procedure for the database.

CREATE TABLE `Table_03` (
  `id` int(11) NOT NULL,
  `valueA` int(11) NOT NULL DEFAULT '0',
  `valueB` int(11) NOT NULL DEFAULT '0',
  `sum` int(11) NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


DELIMITER $$
CREATE TRIGGER `trigger_03` BEFORE UPDATE ON `Table_03` FOR EACH ROW SET NEW.`sum` = NEW.`valueA`+NEW.`valueB`
$$
DELIMITER ;

ALTER TABLE `Table_03` ADD PRIMARY KEY (`id`);

DELIMITER $$

CREATE DEFINER=`root`@`localhost` PROCEDURE `test_01` (IN `foo` INT(11), OUT `bar` INT(11))  NO SQL
SET bar = foo$$

DELIMITER ;

2. After creating, everything will be shown in phpMyAdmin. When going the tab 'Triggers', the page will look something like this:

3. Now, use the 'New' button (see image above, red squared), from the side menu to create a new procedure... It doesn't matter what the procedure does... Just create someting.

4. After clicking the 'Go' button in the modal-popup, the created procedure will be shown in the list with triggers:

Expected behaviour

The created procedure should not appear in the list with triggers.

Actual behaviour

The created procedure appears in the list with triggers, however, it doesn't belong here.

Server configuration

Operating system: Ubuntu 15.10 (GNU/Linux 4.2.0-16-generic x86_64)

Web server: Apache/2.4.12 (Ubuntu)

Database: 5.7.12-1exp1+deb.sury.orgwily+1 - (Ubuntu)

PHP version: 7.1.0-dev

phpMyAdmin version: 4.7.1

Client configuration

Browser: Google Chrome 58.0.3029.110 (64-bit)

Operating system: Windows 10 Pro Build 10586.916

[williamdes]

Confirmed on phpMyAdmin 5.0.0-dev

[williamdes]

@vibhuti019 could you fix this one?

[vibhuti019]

It may require some help. I can try @williamdes.

[vibhuti019]

Can you guide me on how to remove this bug?

[williamdes]

@vibhuti019 did you reproduce this issue on your local setup ?
@kartik1000 could you please help on this one ?

[kartik1000]

@williamdes I will reproduce and let you know.

[vibhuti019]

Yes, @williamdes. I have reproduced this issue.
But, it gets removed once I refresh the page.

[williamdes]

Yes, @williamdes. I have reproduced this issue.
But, it gets removed once I refresh the page.

It gets moved to the right section ;)
Now you need to discover what makes it go into the wrong section (triggers/functions)

Do you need further help?

[vibhuti019]

Not just with the procedure.
But this issue is with all functions which create a new entry (except Indexes).

Like, in this case, I have generated a trigger while I am in the Procedure tab.

And in this case, I have created a trigger while viewing the list of Databases.

The problem could be due to the JavaScript function which updates the table.
I could not find that function.
Please guide me.

[shucon]

Working on this!

[shucon]

Hey @williamdes , I'm unable to reproduce this issue on the current master.

[williamdes]

Reproduced by following the initial steps

https://phpmyadmin-pr-16640.wdes.eu.org/ (root/public public/public)

[shucon]

Got it! I wasn't opening the Triggers page before adding the procedure. Will try to fix this.

[williamdes]

Confirmed on QA_5_1 demo server