Zend Database query explorer shows params in the wrong order

General discussion forum for the Zend Server

Zend Database query explorer shows params in the wrong order

Postby mart9934 on Mon Sep 18, 2017 10:00 am

Hello Zend support,

I've been trying to use Zend Server as a profiler and so far I find it a great tool. I just want to report that after debugging some Symfony Doctrine 2 queries I found out that the parameters are in the wrong order displayed:

Code: Select all
UPDATE magento.customer_entity SET entity_type_id = '2017-09-18 10:49:53', website_id = '2017-09-05 00:56:15', email = 0, group_id = 3, store_id = 1, created_at = 1, updated_at = 'testemail@email', disable_auto_group_change = 2 WHERE entity_id = 901561

The right order would THIS:
UPDATE magento.customer_entity SET entity_type_id = 1, website_id = 2, email = 'testemail@email', group_id = 1, store_id = 3, created_at = '2017-09-05 00:56:15', updated_at = '2017-09-18 10:49:53', disable_auto_group_change = 0 WHERE entity_id = 901561


As you can see it's not the WHERE part of the query where this happens, but in the UPDATE or INSERT parameters.
The right order is displayed if we install the Doctrine2 plugin from the gallery. There it seems the order is respected.

Is this normal behaviour or something that can be corrected ? Thanks for your feedback
mart9934
 
Posts: 1
Joined: Mon Sep 18, 2017 9:23 am
Location: Berlin

Re: Zend Database query explorer shows params in the wrong o

Postby MickeyZend on Mon Oct 02, 2017 9:11 am

Hi,

Thanks for trying out Zend Server and for the positive feedback!
...and thanks for reporting, we will fix this bug.
Please don't hesitate to report issues using our support team, in order to get better and quicker response.


Hoping to see you as one of our customers,
Mickey.
User avatar
MickeyZend
Zend Product Manager
 
Posts: 94
Joined: Mon Aug 19, 2013 1:34 pm
Location: Israel

Re: Zend Database query explorer shows params in the wrong o

Postby alic5309 on Tue Nov 28, 2017 8:34 am

Such a great post to know different useful information.
alic5309
 
Posts: 1
Joined: Tue Nov 28, 2017 8:33 am

Re: Zend Database query explorer shows params in the wrong o

Postby henr2734 on Tue Nov 28, 2017 1:38 pm

hello will remain until the end of time on your PC, steadily stopping it up like a hair stuck in a sink ClickEssay .com deplete, until the point when you at long last dispose of them for the last time
henr2734
 
Posts: 1
Joined: Tue Nov 28, 2017 1:34 pm


Return to Zend Server

Who is online

Users browsing this forum: No registered users and 4 guests