Montego Scripts: Forums
 

 

View next topic
View previous topic
Post new topic   Reply to topic
Author Message
kevinkap
Newbie
Newbie



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

PostPosted: Thu May 10, 2007 2:48 pm Reply with quote

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

_________________
Kevin Kappes
www.maysvillesports.com
www.themizefamily.net 
View user's profile Send private message Visit poster's website AIM Address
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1399

PostPosted: Thu May 10, 2007 4:39 pm Reply with quote

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

_________________
“To err is human, but when the eraser wears out ahead of the pencil, you’re overdoing it.”
-- Josh Jenkins 
View user's profile Send private message Visit poster's website
kevinkap
Newbie
Newbie



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

PostPosted: Thu May 10, 2007 5:16 pm Reply with quote

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

Thanks.!!

_________________
Kevin Kappes
www.maysvillesports.com
www.themizefamily.net 
View user's profile Send private message Visit poster's website AIM Address
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1399

PostPosted: Thu May 10, 2007 11:42 pm Reply with quote

Awesome. Glad you're up and running.
 
View user's profile Send private message Visit poster's website
Kestrel731
Newbie
Newbie



Joined: May 12, 2007
Posts: 5

PostPosted: Sun May 13, 2007 4:36 pm Reply with quote

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
 
View user's profile Send private message
Guardian
Site Admin
Site Admin



Joined: Jul 18, 2005
Posts: 397

PostPosted: Mon May 14, 2007 6:16 am Reply with quote

Can you post the table structure here please
 
View user's profile Send private message
Kestrel731
Newbie
Newbie



Joined: May 12, 2007
Posts: 5

PostPosted: Mon May 14, 2007 3:15 pm Reply with quote

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
 
View user's profile Send private message
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1399

PostPosted: Mon May 14, 2007 8:16 pm Reply with quote

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.
 
View user's profile Send private message Visit poster's website
montego
Site Admin/Owner
Site Admin/Owner



Joined: Feb 12, 2005
Posts: 1399

PostPosted: Wed May 16, 2007 8:28 am Reply with quote

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.
 
View user's profile Send private message Visit poster's website
Display posts from previous:       
Post new topic   Reply to topic

View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001-2007 phpBB Group
All times are GMT - 4 Hours
 
Forums ©
linear-bunch
linear-bunch