Menu

#2613 SQL History

2.11.3
invalid
Interface (555)
5
2013-06-11
2007-12-31
warforge00
No

It would be nice when I click on a link in the "SQL history" tab to put the statement in the "SQL" tab as well as running the statement like it does. The reason being is when it runs the statement, I only get the "Refresh" option and not the "Edit, Explain SQL, Create PHP Code, and Refresh" options...giving me no way to view or edit the code ran since it gets cut off.

"SQL history" link
[`ecomm`.`PriceDistributor`] SELECT [...] 1:24:00' OR MC.LastUpdate > '2007-12-31 11:24:00')

SQL query:
SELECT
P.DistributorPartNumber, P.VendorPartNumber, P.SKUStatus
FROM PriceDistributor P
LEFT JOIN MasterVendorDef MVD ON MVD.VendorNumber = P.VendorNumber
LEFT JOIN MasterVendor MV ON MV.VendorID = MVD.VendorID
LEFT JOIN MasterCategoryDef MCD ON MCD.CategoryNumber = P.CategoryNumber
LEFT JOIN MasterCategory MC ON MC.CategoryID = MCD.CategoryID
WHERE
MVD.DistributorID = 1 AND
MCD.DistributorID = 1 AND
MC.isActive = 1 AND
[...]

"SQL" tab
SELECT * FROM `PriceDistributor` WHERE 1

Discussion

  • Marc Delisle

    Marc Delisle - 2008-01-01
    • assigned_to: nobody --> lem9
    • status: open --> pending
     
  • Marc Delisle

    Marc Delisle - 2008-01-01

    Logged In: YES
    user_id=210714
    Originator: NO

    When I try, I get "Edit, Explain SQL, Create PHP Code, and Refresh" on the main panel. Admittedly I did not try the same query as yours. Does this happen for you with a shorter query? If not, please attach a small export with your tables structure and the full query you are trying.

     
  • warforge00

    warforge00 - 2008-01-01
    • status: pending --> open
     
  • warforge00

    warforge00 - 2008-01-01

    Logged In: YES
    user_id=1914403
    Originator: YES

    A shorter query gives me the "Edit, Explain SQL, Create PHP Code, and Refresh", but when i have one that joins a lot of tables like the one above, it only gives me the "Refresh" form button. I will try and get a test case together to demonstrate the issue.

     
  • Marc Delisle

    Marc Delisle - 2008-01-04

    Logged In: YES
    user_id=210714
    Originator: NO

    Yes, please attach a test case.

     
  • Marc Delisle

    Marc Delisle - 2008-01-04
    • status: open --> pending
     
  • warforge00

    warforge00 - 2008-01-09

    Logged In: YES
    user_id=1914403
    Originator: YES

    It looks like setting $cfg['MaxCharactersInDisplayedSQL'] larger (or 0 in my case from bug 1863451) fixes the issue and shows me the "Edit, Explain SQL, Create PHP Code, and Refresh".

     
  • warforge00

    warforge00 - 2008-01-09
    • status: pending --> open
     
  • Marc Delisle

    Marc Delisle - 2008-01-13

    Logged In: YES
    user_id=210714
    Originator: NO

    Closing, please reopen if I missed something.

     
  • Marc Delisle

    Marc Delisle - 2008-01-13
    • status: open --> closed-invalid
     
  • Michal Čihař

    Michal Čihař - 2013-06-11
    • Status: closed-invalid --> invalid