activation email

registered · Site Admin Joined: Jun 04, 2004 Posts: 6437

First, not a good idea to post your root path and database name in a public forum.

It appears that an update was missed that included the installation of tables required to use TegoNuke Mailer. That would explain why no one gets an activation email to create their accounts.

I haven't used the fixUsersTempTable script, but I'd first make sure the database has been updated to contain the most current information.

Client Joined: Aug 14, 2005 Posts: 151

How do I go about updating it? What information am I supposed to update to it?

http://www.ravenphpscripts.com/postt15200.html

I found this link and did just what they said. It may have fixed the mailer issue but I still get a registration error as shown on the screen grab I posted. As it stands now the registration is not completing so no email would be sent.

I think this is probably over my head. Does anyone here work on the side that would be willing to look into this? I need this fixed asap.

Posted: Fri Aug 15, 2008 11:29 pm

A few questions:
- was this a new installation of RN 2.20.x?
- do you have access to phpMyAdmin?

Posted: Fri Aug 15, 2008 11:31 pm

I installed the site a few weeks ago and it was the newest here. where will it confirm the version I am running

Yes I have access to phpmyadmin

Posted: Fri Aug 15, 2008 11:50 pm

If you can send a PM with access to phpMyAdmin, I can take a look at the database. I'll also need FTP access (if it's the cPanel account info, it will serve both purposes) so I can check the software.

Posted: Sat Aug 16, 2008 12:06 am

The previously listed errors must be old or misleading as the mail config table is there, but it may not have the current layout? Still looking...

Posted: Sat Aug 16, 2008 12:08 am

BUT...there is no users table! Very strange...

Posted: Sat Aug 16, 2008 12:15 am

Please send another PM with the following:

the Your Regular Member UserName, password and email address (so I can create the user table with data).

Posted: Sat Aug 16, 2008 12:29 am

wait! I believe the users table is there. Its just a different name

nuke_common_users

that is what it was named on the old site.. I edited the config.php to reflect this.. Did I need to add this soemwhere else? Surprised

Posted: Sat Aug 16, 2008 12:32 am

OK. First, try to log in with your user via Your Account. I will attempt to register for the site now.

Posted: Sat Aug 16, 2008 12:35 am

Wow...the log is 53MB. Let me rename that...

It won't hurt to have the other table. But I WAS able to log in with your account. I'll keep checking.

Posted: Sat Aug 16, 2008 12:39 am

Did you copy the table from the old site? If so, it probably doesn't have the correct structure. Checking...

Posted: Sat Aug 16, 2008 12:42 am

Fields are the same. Must be a problem with the table name. Checking...

Posted: Sat Aug 16, 2008 12:43 am

yes i did.. so your probably correct :0

Logging in was never an issue.. Try creating a new account. that is where the problem is.

Posted: Sat Aug 16, 2008 1:07 am

It's working now. The problem was that if the $user_prefix doesn't match the $prefix, both the _users and _users_temp tables must have the same $user_prefix. I simply renamed the temp table, and confirmed that it's working correctly.

Posted: Sat Aug 16, 2008 1:15 am

wow. damnit.. something that silly.. I knew it..