Greetings,

I need to remove JSecure from my sites, since I'm using Admin Tools now. One of my sites is not allowing back end access anymore, so I'm attempting to follow the instructions from JSecure:

I'm good until I get to the SQL query. The tables on my database have the prefix jml_

Are these the steps I should take:

• log into phpMyAdmin
• select the correct database
• click on SQL in the top tabs
• Enter this query:

  DELETE FROM jml_components where option = ‘com_jsecure’
          DELETE FROM jml_plugins where element = ‘jsecure’

Am I entering the prefix correctly?
Do I need semicolons?
I tried this in various ways and it didn't work.

Thanks,
Hope

Hi Hope.

You are using 2 query lines. The first need to be separated from the second using a semi colon.

One more thing Hope,

Before using "DELETE FROM", try using "SELECT *" or just SELECTING the fields so you know what you are deleting! :-D

Thanks, Tessa.

So here's what I just did. I selected the database and clicked on SQL and pasted this info

and got this error

I'm concerned about the prefix. Am I entering the prefix correctly? See my first post.

Hello Hope,

The SQL Statement is hard to determine without me taking a look at your database tables and fields.

If you email me with the credentials to your phpMyAdmin I would love to give you an accurate sql query, without changing anything on your site. :-)


tessafenwick (at) gmail (dot) com

I have sent the credentials. Thank you!!

Checking now. :-)

Hello Hope. I was reviewing your phpMyAdmin and you do not have a com_plugins or com_components table, in fact, I don't think J1.7+ has these tables because I've never seen it before.

However, you do have all your plugins and components in your j o s _ extensions.

Type this SQL query in and view your results:

SELECT * FROM `j m l_extensions` WHERE `extension_id` = '10001';

This is your jsecure component.

Type this SQL query also:

SELECT * FROM `j m l_extensions` WHERE `extension_id` = '10000';

This is your jsecure plugin. :-)

And Remember :

Whatever you are able to SELECT, you can DELETE FROM as well. Well, you should. :-)

But I only SELECT to make sure the query works first, to prevent errors. :-)

Oh, thank you Tessa! I'll give this a shot and get back to you.
-Hope

No problem Hope.

I will be off the forums tomorrow but I will be around on Sunday. :-)

Great to know, Tessa. You're a huge help.

Hi Tessa,
The queries did run, thank you! I now feel more comfortable in phpMyAdmin.

The problem wasn't solved, however, until I downloaded bluehost courtesy backups, deleted all the files off the server, restored from the backup, dropped all the tables in phpMyAdmin, and imported the backed up database. So fun at 3 AM. (It's still dark at 5:30 so maybe I'll get some more sleep:)

I then unpublished JSecure and RSFirewall. I use Admin Tools only for security now. I get the feeling that my sites that have multiple security extensions are getting wonky. I didn't realize that Admin Tools was a security extension, so I started adding to my sites. Have you heard of conflicts between security extensions? Sounds logical.

I have Akeeba Backup files as well as the bluehost backups, but I've never used Kickstart yet and I'm nervous about it. I am so glad you have the training video for that. I watched it and will watch it again.

thanks again,
Hope

Hi Tessa,
The queries did run, thank you! I now feel more comfortable in phpMyAdmin.

You are welcome!

The problem wasn't solved, however, until I downloaded bluehost courtesy backups, deleted all the files off the server, restored from the backup, dropped all the tables in phpMyAdmin, and imported the backed up database. So fun at 3 AM. (It's still dark at 5:30 so maybe I'll get some more sleep:)

I'm glad you got that situated. Sometimes I can't sleep until I get things done and feel accomplished. :-)

I then unpublished JSecure and RSFirewall. I use Admin Tools only for security now. I get the feeling that my sites that have multiple security extensions are getting wonky. I didn't realize that Admin Tools was a security extension, so I started adding to my sites. Have you heard of conflicts between security extensions? Sounds logical.

As long as you are using extensions from trusted sources, I don't see an issue happening. You'll know if certain parts of your site doesn't work right anymore, but I don't see how that would happen.

I have Akeeba Backup files as well as the bluehosts backups, but I've never used Kickstart yet and I'm nervous about it. I am so glad you have the training video for that. I watched it and will watch it again.

Kickstart is actually very simple to use, but I would never use it on a live site first. It is best to make a duplicate of your site and test the kickstart restore from there. :-)

Thanks Tessa!
So, to use a kickstart restore, you would first duplicate your site and run the restore there?

In order to duplicate the site, would you:
1- create a subfolder on the server
2- copy and paste the public_html files into the new subfolder
3- um - how do you handle the database? :)

thanks,
Hope

Hi
To duplicate the site in a new folder.
1) Yes
2) No. Upload your Akeeba backup file. If using FTP they recommend setting to binary transfer.
3) Akeeba sorts all that out for you, very clever!
www.ostraining.com/courses/class/joomla-25/security/view/
View the tutorials regarding backup and restore.
Regards

Hi Mark,
Gosh, I just saw this post. Thank you so much for the steps you've given me.

I did see the "binary transfer" point in Akeeba's documentation. I use Dreamweaver for all my CSS tweaking and FTP. In Dreamweaver's preferences I did not see how to set the upload as binary. Do you know?

thanks again,
Hopee

Hi Hope,

Give the following documentation a try:
help.adobe.com/en_US/dreamweaver/cs/exte...17f53d6108-7fcc.html

Kind regards,
Nick

Hi Nick,
You are a swift and brilliant Internet sleuth.

So if I'm entering code into the FTPExtensionMapMac.txt file, do you know what would it say in the second and third positions?

It looks to me that the file type is jpa as well as the extension. See screenshot from dreamweaver. But the Creator Code is a mystery to me. I googled akeeba jpa "creator code" dreamweaver to no avail.


thanks,
Hope

HI Hope,

Binary transfer refers to the method the FTP client is using, not the actual file type. So when you set Dreamweaver to upload in binary mode it will uee that method, no matter what the file type is.

Some file types should only be done in binary mode. Usually the FTP program can autodetect the correct ones. You can force it to upload a particular file in binary mode through the settings. I believe that's what the Akeeba directions are getting at.

Sorry I don't have Dreameaver to check it and give you a specific answer.

Does that help?

Cheers,
Ed