How to make all acajoom users confirmed at once

Recently i realised that sometimes after installing ACAJOOM and importing some users with the correct format in csv file type:

Name,Email,1,1

some users (no idea why) had a non-confirmed status.

 

So i found out somewhere a way to fix this (workaround) and here i share it with you

Step 1 -- You login to your cpanel and go to phpMyadmin

Step 2 -- You select your database from the drop down and click on SQL from the horizontal menu

You paste this

"UPDATE `jos_acajoom_subscribers` SET `confirmed` = '1';"

in the SQL text area

You click Go!

Step 3 -- It shows you how many users you fixed (if it works then all will be fixed)

Download here a pdf with a representation of the above procedure:

HOW TO SET ALL ACAJOOM USERS TO CONFIRMED STATUS

Contact us for any of our services or for any other kind of web related service you may need. If you can imagine it, then we can do it!