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

[shags38]

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 :)

[lat9]

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.

[shags38]

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."

[stevesh]

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

[shags38]

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

[lat9]

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

[DrByte]

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.