Results 1 to 5 of 5
  1. #1
    Join Date
    Aug 2009
    Location
    Bedford, England
    Posts
    966
    Plugin Contributions
    0

    Default SQL Patches Admin Tool Question

    Never tried this but too chicken to try on the fly.. as a tool for testing tables etc and finding entries can you run a query like

    SELECT * FROM products WHERE products_id = 1

    and if so will the tool display the results? its never occured to me to do this before but if it has that functionality it would save me logging into the server all the time! lol
    Phil Rogers
    A problem shared is a problem solved.

  2. #2
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: SQL Patches Admin Tool Question

    No. The SQL Patch tool is intended for applying patches, making changes. Not for randomly running ad hoc queries against the database. Those are operations best left for a database administrator, not the casual shopowner.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  3. #3
    Join Date
    Aug 2009
    Location
    Bedford, England
    Posts
    966
    Plugin Contributions
    0

    Default Re: SQL Patches Admin Tool Question

    makes sense I guess, but you could argue that various other things available in the admin are not either - like developers tool kit.. but I guess this is now dealt with through admin profiles..

    was just curious!

    thanks for clarifying DrByte.
    Phil Rogers
    A problem shared is a problem solved.

  4. #4
    Join Date
    Jan 2004
    Posts
    66,364
    Blog Entries
    7
    Plugin Contributions
    274

    Default Re: SQL Patches Admin Tool Question

    Quote Originally Posted by philip937 View Post
    makes sense I guess, but you could argue that various other things available in the admin are not either - like developers tool kit.
    Fair comment.

    I should add that rewriting phpMyAdmin to include inside Zen Cart is a rather pointless expenditure of developer time and expertise when someone else already focuses on that specifically.
    .

    Zen Cart - putting the dream of business ownership within reach of anyone!
    Donate to: DrByte directly or to the Zen Cart team as a whole

    Remember: Any code suggestions you see here are merely suggestions. You assume full responsibility for your use of any such suggestions, including any impact ANY alterations you make to your site may have on your PCI compliance.
    Furthermore, any advice you see here about PCI matters is merely an opinion, and should not be relied upon as "official". Official PCI information should be obtained from the PCI Security Council directly or from one of their authorized Assessors.

  5. #5
    Join Date
    Aug 2009
    Location
    Bedford, England
    Posts
    966
    Plugin Contributions
    0

    Default Re: SQL Patches Admin Tool Question

    I should add that rewriting phpMyAdmin to include inside Zen Cart is a rather pointless expenditure of developer time and expertise when someone else already focuses on that specifically.
    haha also fair comment.. touche
    Phil Rogers
    A problem shared is a problem solved.

 

 

Similar Threads

  1. How do I run the stock_attribute.sql via Install SQL Patches in admin
    By vivaraquel in forum All Other Contributions/Addons
    Replies: 4
    Last Post: 9 Apr 2007, 01:55 AM
  2. Twice the "Install SQL Patches" tool listed in Admin ?
    By rtw819 in forum General Questions
    Replies: 6
    Last Post: 19 Mar 2007, 06:33 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg
Zen-Cart, Internet Selling Services, Klamath Falls, OR