Error when trying to approve.

Newbie Joined: Jun 08, 2006 Posts: 2 Location: Oklahoma

I ahve upgraded a site running rn2.0202 to rn 2.10. I have managed to get everything to work with the exception, of AML. I was using cnbya750.442. I elected to do away with that and use AML. It will not let me approve any members, I get the error:

ERROR:
Unknown column 'requestor' in 'field list'ERROR:
Unknown column 'requestor' in 'field list'ERROR:
Unknown column 'requestor' in 'field list'.

Also for some reason, the "members waiting" in the user info block is not showing the waiting approval members now. I do not know if this has to do with this mod or not.

Thanks, Kevin

Site Admin/Owner Joined: Feb 12, 2005 Posts: 946

Kevin,

You have missed a step in the upgrade to RN 2.10.00. You need to go back to the HowToInstall manual, the upgrade page, and see which step was missed under the database part of the upgrade.

To help narrow your search, this issue you have raised is specific to you not having installed the Resend Email SQL changes.

Regards,
montego

Newbie Joined: Jun 08, 2006 Posts: 2 Location: Oklahoma

Ahh, Shoot. I thought that was not needed as I had it installed on the other version. That fixed it.

Thanks.!!

Site Admin/Owner Joined: Feb 12, 2005 Posts: 946

Awesome. Glad you're up and running.

Newbie Joined: May 12, 2007 Posts: 5

Hi, I am having the same problem receiving the error

ERROR:
Unknown column 'requestor' in 'field list'

when I try to approve members. This is from a fresh install of Raven Nuke 2.10.00. I read through the earlier posts and went back and made sure the resened email tables were loaded to no avail.

Any help with this would be appreciated
Thanks

Spam Stopper - Comments Modules · Site Admin Joined: Jul 18, 2005 Posts: 307

Can you post the table structure here please

Newbie Joined: May 12, 2007 Posts: 5

ok, here's the structure for the tables

Database jbraddo_nuke
Table structure for table nuke_approvedemailaddresses
Field Type Null Default
idnum smallint(5) No
approved_email varchar(255) No
Dumping data for table nuke_approvedemailaddresses

Table structure for table nuke_approvedemaildomains
Field Type Null Default
idnum smallint(5) No
approved_domain varchar(255) No
Dumping data for table nuke_approvedemaildomains

Table structure for table nuke_approve_config
Field Type Null Default
idnum smallint(5) No
notapp tinyint(1) No 4
actemail char(1) No Y
addmessage char(1) No N
mailadmin char(1) No Y
appstatus char(1) No 1
Dumping data for table nuke_approve_config
1 4 Y N N 1
Table structure for table nuke_pendingusers
Field Type Null Default
user_id int(10) No
username varchar(25) No
user_email varchar(255) No
user_password varchar(40) No
user_regdate varchar(20) No
check_num varchar(50) No
time varchar(14) No
fusent int(1) No 0
fuemail text Yes NULL
fusentdate varchar(20) Yes NULL
user_ip varchar(15) No
Dumping data for table nuke_pendingusers
1 TestUser jb73185@yahoo.com password May 13, 2007 3e720e1dd48b028300e4f23dfac85236 1179087300 0 NULL NULL 207.138.252.50
Table structure for table nuke_stdemail
Field Type Null Default
idnum smallint(5) No
rmessage text Yes NULL
fumessage text Yes NULL
appmessage text Yes NULL
Dumping data for table nuke_stdemail
2 Place your own rejection message here. Place your own follow up message here You have been approved!
Table structure for table nuke_users_temp
Field Type Null Default
user_id int(10) No
username varchar(25) No
user_email varchar(255) No
user_password varchar(40) No
user_regdate varchar(20) No
check_num varchar(50) No
time varchar(14) No
Dumping data for table nuke_users_temp

If there is a cleaner way of posting this so its easier to read let me know, also let me know if you need anything else...

Thanks again

Site Admin/Owner Joined: Feb 12, 2005 Posts: 946

Looks like the step for resend email was not done or maybe it failed. From within phpMyAdmin, execute the following SQL:

Code:

ALTER TABLE `nuke_users_temp` ADD `requestor` varchar(25) NOT NULL default '' AFTER `time`;

This should fix you right up.

Site Admin/Owner Joined: Feb 12, 2005 Posts: 946

Kestrel731, I have decided to split out your additional topic on the & vs. & to a new thread here:

http://montegoscripts.com/ftopict-182.html

I prefer to keep threads clean and focused on ONE issue.

Here is the text from your very last post that I had to split out:

Kestrel731 wrote:

Thank you, that fixed the Unknown column 'requestor' in 'field list' problem, but unfortunately I have another problem now. I tried to approve a test user and everything runs smoothly, I get the e-mail with the activation link. When I click that activation link it takes me straight to the login screen, when I try to login it says "login incorrect." It seems that the users stay in the pending_users table but are not put in the regular users table. When I try to modify these users from the admin panel, it says "user does not exist" so they are not even there.

Not sure what is causing this but any input would help
Thanks again

I think i found the problem, has nothing to do with the databases, whenever it sends the activation link it puts in Your_Account&op=activate&username...
this causes it to send you to the wrong page, how do I fix this and get rid of those amp after the & symbol?
If I type the link in without those it works fine...

Thanks

Let us continue the new discussion over at the new thread. Thanks.