Page 1 of 2 12 LastLast
Results 1 to 10 of 12
  1. #1
    Join Date
    Jan 2011
    Location
    Adelaide, Australia
    Posts
    1,599
    Plugin Contributions
    1

    red flag Upload SQL Patch via phpMyAdmin in MySQL INSTEAD OF Amin-Tools-Install AQL patch ????

    referring to the post title can this be done - I have an issue with not being able to access admin-tools-install sql patches (get a 403 errormsg) so wondering if I can import an SQL patch for a Plug-in installation directly via phpMyAdmin simply by using the import function ?? Will this work the same as the install SQL patch in admin/tools??

    cheers,
    Mike

    oooops!! Title should read 'Upload SQL Patch via phpMyAdmin in MySQL INSTEAD OF Admin-Tools-Install SQL patch ????' ...I must learn to type slower or at least lift my eyes to the screen before hitting send :)
    Last edited by shags38; 19 Aug 2012 at 10:01 AM.

  2. #2
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    10,637
    Plugin Contributions
    78

    Default Re: Upload SQL Patch via phpMyAdmin in MySQL INSTEAD OF Amin-Tools-Install AQL patch

    You can usually run (not import) a SQL patch directly via your phpmyadmin. The one caveat is that, while the Install SQL Patch tool will replace any table names with your DB_PREFIX, that won't happen under phpmyadmin. If your DB_PREFIX is null (''), then you're good-to-go; if not, you'll need to edit the provided .sql file to add the prefix (e.g. customers becomes zen_customers) before running the SQL script.

  3. #3
    Join Date
    Jan 2011
    Location
    Adelaide, Australia
    Posts
    1,599
    Plugin Contributions
    1

    Default Re: Upload SQL Patch via phpMyAdmin in MySQL INSTEAD OF Amin-Tools-Install AQL patch

    Quote Originally Posted by lat9 View Post
    You can usually run (not import) a SQL patch directly via your phpmyadmin. The one caveat is that, while the Install SQL Patch tool will replace any table names with your DB_PREFIX, that won't happen under phpmyadmin. If your DB_PREFIX is null (''), then you're good-to-go; if not, you'll need to edit the provided .sql file to add the prefix (e.g. customers becomes zen_customers) before running the SQL script.
    Thanks for that - I appreciate it. I am having my hosting provider look at sorting out the issue as per their response below.

    One thing I wondered if you might also assist me with - as collateral damage in trying to get a plug-in loaded I lost the site altogether including admin - I now have admin back and from admin I can pull up the site but I cannot get it to load unless I add to the url ... /index.php . I figured it was something to do with configure.php but that is ok as is index.php. As far as I can tell I have deleted all files I uploaded for the plug-in and re-loaded the backed up files. I am scratching my head trying to figure why when typed into the browser the site won't load (blank page) but it does from admin when clicking Online Catalogue ?

    Any ideas ??

    cheers,
    Mike

    response from Host
    "So we can resolve the mod_security trigger, please let us know the exact steps to replicate the error along with any login details required to do so. Once we have replicated the issue we can then whitelist the rules causing the grief."

  4. #4
    Join Date
    Feb 2005
    Location
    Lansing, Michigan USA
    Posts
    20,024
    Plugin Contributions
    3

    Default Re: Upload SQL Patch via phpMyAdmin in MySQL INSTEAD OF Amin-Tools-Install AQL patch

    Any chance there's a file named index.html in the root directory of your store ? If so, delete it.

  5. #5
    Join Date
    Jan 2011
    Location
    Adelaide, Australia
    Posts
    1,599
    Plugin Contributions
    1

    Default Re: Upload SQL Patch via phpMyAdmin in MySQL INSTEAD OF Amin-Tools-Install AQL patch

    Quote Originally Posted by stevesh View Post
    Any chance there's a file named index.html in the root directory of your store ? If so, delete it.
    Thanks Steve - there was a file index.php in the root (not index.html) and I deleted it but alas it hasn't solved the problem in fact it brought up a 404 error when I then tried to access the site from admin.

    That index file was there in the root previously without causing any issues so I reinstated it and now can get to the site again via admin

    I am not a developer but wondered could it be to do with auto-loaders? Anyway I will leave it to your expertise to come up with some suggestions.

    I again thank you for your assistance.

    cheers,
    Mike

  6. #6
    Join Date
    Sep 2009
    Location
    Stuart, FL
    Posts
    10,637
    Plugin Contributions
    78

    Default Re: Upload SQL Patch via phpMyAdmin in MySQL INSTEAD OF Amin-Tools-Install AQL patch

    What's in /YOUR_ADMIN/.htaccess? The unmodified file's size for v1.5.0 is 1841 bytes.

  7. #7
    Join Date
    Jan 2004
    Posts
    66,350
    Blog Entries
    7
    Plugin Contributions
    271

    Default Re: Upload SQL Patch via phpMyAdmin in MySQL INSTEAD OF Amin-Tools-Install AQL patch

    did you say you deleted index.php?
    You shouldn't be deleting index.php files anywhere unless you know exactly why you're doing that.
    .

    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.

  8. #8
    Join Date
    Jan 2011
    Location
    Adelaide, Australia
    Posts
    1,599
    Plugin Contributions
    1

    Default Re: Upload SQL Patch via phpMyAdmin in MySQL INSTEAD OF Amin-Tools-Install AQL patch

    Quote Originally Posted by lat9 View Post
    What's in /YOUR_ADMIN/.htaccess? The unmodified file's size for v1.5.0 is 1841 bytes.
    Thanks for your response lat9. MY-ADMIN/.htaccess file size is 1.94kb (note that I am still using v1.3.9h) - I have posted the contents below. I have never 'directly' modified a .htaccess file so any content I assume must be original plus any mods if any done by plug-ins. The .htaccess file content below is an exact match for the same file in another site of mine. I have also included the INCLUDES/.htaccess file in case there is an issue with it. This file is totally different to the same file in my other site - no comparison at all?

    I really do appreciate all the help I can get.

    ADMIN/.htaccess

    #
    # @copyright Copyright 2003-2010 Zen Cart Development Team
    # @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
    # @version $Id: .htaccess 16111 2010-04-29 22:39:02Z drbyte $
    #
    # This is used with Apache WebServers
    #
    # The following blocks direct HTTP requests to all filetypes in this directory recursively, except certain approved exceptions
    # It also prevents the ability of any scripts to run. No type of script, be it PHP, PERL or whatever, can normally be executed if ExecCGI is disabled.
    # Will also prevent people from seeing what is in the dir. and any sub-directories
    #
    # For this to work, you must include either 'All' or at least: 'Limit' and 'Indexes' parameters to the AllowOverride configuration in your apache/conf/httpd.conf file.
    # Additionally, if you want the added protection offered by the OPTIONS directive below, you'll need to add 'Options' to the AllowOverride list, if 'All' is not specified.
    # Example:
    #<Directory "/usr/local/apache/htdocs">
    # AllowOverride Limit Options Indexes
    #</Directory>
    ###############################
    DirectoryIndex index.php

    # deny *everything*
    <FilesMatch ".*\..*">
    Order Allow,Deny
    Deny from all
    </FilesMatch>

    # but now allow just *certain* necessary files:
    <FilesMatch "(^$|^favicon.ico$|.*\.(php|js|css|jpg|gif|png)$)">
    Order Allow,Deny
    Allow from all
    </FilesMatch>

    IndexIgnore */*


    # The following makes adjustments to the SSL protocol for Internet Explorer browsers
    <IfModule mod_setenvif.c>
    <IfDefine SSL>
    SetEnvIf User-Agent ".*MSIE.*" \
    nokeepalive ssl-unclean-shutdown \
    downgrade-1.0 force-response-1.0
    </IfDefine>
    </IfModule>

    # Fix certain PHP values

    #<IfModule mod_php4.c>
    # php_value session.use_trans_sid 0
    # php_value register_globals 1
    #</IfModule>

    # to turn off register_globals
    # php_value register_globals 0

    #turn off X-PHP-Originating-Script header when sending emails from admin
    #uncomment to activate:
    # php_flag mail.add_x_header Off

    INCLUDES/.htaccess

    #
    # @copyright Copyright 2003-2010 Zen Cart Development Team
    # @license http://www.zen-cart.com/license/2_0.txt GNU Public License V2.0
    # @version $Id: .htaccess 17394 2010-08-28 03:16:06Z drbyte $
    #
    # This is used with Apache WebServers
    #
    # The following blocks direct HTTP requests to all filetypes in this directory recursively, except certain approved exceptions
    # It also prevents the ability of any scripts to run. No type of script, be it PHP, PERL or whatever, can normally be executed if ExecCGI is disabled.
    # Will also prevent people from seeing what is in the dir. and any sub-directories
    #
    # For this to work, you must include either 'All' or at least: 'Limit' and 'Indexes' parameters to the AllowOverride configuration in your apache/conf/httpd.conf file.
    # Additionally, if you want the added protection offered by the OPTIONS directive below, you'll need to add 'Options' to the AllowOverride list, if 'All' is not specified.
    # Example:
    #<Directory "/usr/local/apache/htdocs">
    # AllowOverride Limit Options Indexes
    #</Directory>
    ###############################

    # deny *everything*
    <FilesMatch ".*">
    Order Allow,Deny
    Deny from all
    </FilesMatch>

    # but now allow just *certain* necessary files:
    <FilesMatch ".*\.(js|JS|css|CSS|jpg|JPG|gif|GIF|png|PNG|swf|SWF|xsl|XSL)$">
    Order Allow,Deny
    Allow from all
    </FilesMatch>

    IndexIgnore */*


    ## NOTE: If you want even greater security to prevent hackers from running scripts in this folder, uncomment the following line (if your hosting company will allow you to use OPTIONS):
    # OPTIONS -Indexes -ExecCGI

  9. #9
    Join Date
    Jan 2011
    Location
    Adelaide, Australia
    Posts
    1,599
    Plugin Contributions
    1

    Default Re: Upload SQL Patch via phpMyAdmin in MySQL INSTEAD OF Amin-Tools-Install AQL patch

    Quote Originally Posted by DrByte View Post
    did you say you deleted index.php?
    You shouldn't be deleting index.php files anywhere unless you know exactly why you're doing that.
    I figure that to be good advice - I had backed up just before attempting to install the mod so when Steve suggested deleting index.html if it was in the root (which it wasn't but its cousin was) I figured it would be OK to do as I had the file backed up.

    Having said that all is back to where it was but index page won't load if typed in to browser directly whereas it loads from admin or in browser with any page extenstion = jewelleryonlinestore.com.au/ANY EXTENSTION.

    In my very amateur status I figure logically it must be somewhere in the string that says 'load this page' ... so whatever files are required to implement that command come under the microscope (index.php, main_page.php, 'auto-loader' files .... and possibly a dozen others ??).

    I am trying to do file comparisons to my other site (harmonyballpendants.com) which was 'originally' a copy of jewelleryonlinestore.com.au but then with certain products deleted so it is ostensibly a mirror image of part of the JOS site - any installation of plug-ins mods done to one site is done on the other so maybe I can find some clues during this file comparison process ..... if not then I at least feel good that I am trying something :)

    Looking forward to your continued help Doc.

    cheers,
    Mike

    p.s. Host has sorted out the security_mod issue so now I have access to admin/tools/install sql patches (the catalyst to this resultant problem)
    Last edited by shags38; 20 Aug 2012 at 02:17 AM.

  10. #10
    Join Date
    Jan 2004
    Location
    N of San Antonio TX
    Posts
    8,079
    Plugin Contributions
    9

    Default Re: Upload SQL Patch via phpMyAdmin in MySQL INSTEAD OF Amin-Tools-Install AQL patch

    I figure that to be good advice - I had backed up just before attempting to install the mod so when Steve suggested deleting index.html if it was in the root (which it wasn't but its cousin was) I figured it would be OK to do as I had the file backed up.

    Steve was pretty specific
    Any chance there's a file named index.html in the root directory of your store ? If so, delete it.
    Sometimes we all miss the small things but there's a big difference between html and php.
    Not trying to knock you down. Just want lurkers to know it is important to RTFI (Read the FULL Instructions).
    Did you read the posting tips?!?
    myZenCartHost.com - Zen Cart Certified, PCI Compatible Hosting by JEANDRET
    Free Domain, SSL, and Magic Thumb with Semi-Annual or longer plan.

 

 
Page 1 of 2 12 LastLast

Similar Threads

  1. how do install a sql patch?
    By zmtak in forum General Questions
    Replies: 2
    Last Post: 9 Dec 2011, 10:36 AM
  2. How do i install sql patch?
    By humbll in forum All Other Contributions/Addons
    Replies: 1
    Last Post: 26 May 2007, 06:54 AM
  3. install sql patch using phpMyAdmin
    By MeltDown in forum All Other Contributions/Addons
    Replies: 3
    Last Post: 19 Feb 2007, 12:57 PM
  4. Invalid 'date_added' in Austpost-upload SQL patch
    By stevenicel in forum Addon Shipping Modules
    Replies: 1
    Last Post: 8 Nov 2006, 11:18 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