activation email

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

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.

manoe · Client Joined: Aug 14, 2005 Posts: 151

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

Only registered users can see links on this board!
Get registered or login to the forums!

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.

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

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

manoe · Client Joined: Aug 14, 2005 Posts: 151

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

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

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.

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

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

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

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

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

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

manoe · Client Joined: Aug 14, 2005 Posts: 151

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

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

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

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

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.

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

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

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

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

manoe · Client Joined: Aug 14, 2005 Posts: 151

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.

kguske · Site Admin Joined: Jun 04, 2004 Posts: 6044

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.

manoe · Client Joined: Aug 14, 2005 Posts: 151

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