First I want to let the XOOPS team know that a new XOOPS site hit the net yesterday: http://www.bswa.org. Thanks to the whole XOOPS community for creating such a great CMS.

We've already got close to 300 registered users

BUT

most of those who are registering can't log in.

These users fall into 2 categories. The first are the 150 users I migrated from our previous installation of phpbb2. I used the script phpBB2_XoopsBB_converter.sql kindly provided courtesy Randall Emery. It's a bit old but all seemed to migrate everything okay. I instucted old phpbb2 users to log in using old name and password, but they've been reporting that they can only go as far as their user profile page and no further.

The other group are the 100+ users that have signed up since the site migration yesterday and haven't received email confirmation. This is really strange because it's not effecting all users, but so far as I can tell it's effecting most users. The complaints have only just started rolling in.

I'm using "sendmail" as the mail delivery method and I have a working version of exim (which provides sendmail) installed on Debian Linux server. I've noticed that in the xoops_users table of MySQL most of the users don't have activation keys. But I'm guessing this is because they haven't received their confirmation emails.

Any ideas on how I can troubleshoot this? Is there a db update query I can run that will activate all those who've registered but haven't confirmed yet?

thanks in advance;

Hi,

The migration script phpBB2_XoopsBB_converter.sql is uncomplete because the users are not add in users registered group.

You must execute this query :


For activate the users inactives you can execute this query :



Best regards

Thanks Christian for your prompt and helpful reply.


This seems to have worked. Thanks


This query won't work.

I tried this:

and MySQL complains about a syntax error, which seems odd to me. Anyway, based on this advice I can see now what the nature of the problem is with the migrated users and I think I can fix it.

Thanks again; sol