RSS feed for all messages. http://www.cfmbb.org/ Re-reading this maybe I wasn't clear. I wanted to add 2 fields to the registration form. These fields would be for first name and last name. I added the 2 fields to the users table in the database as VarChar. I then added the form inputs and called them fname and lname. I found the query to insert new members in the users.cfc file and changed that to insert the two new columns. What I found was that the values of the 2 new form fields (lname, fname) are not being carried through as form.lname or form.fname. I set up arguments for them and cfparam's. What is going on here, any ideas? How can I add these form fields to my registration form? http://www.cfmbb.org/messages.cfm?messageid=986A4634-F30A-9920-9D009B6EBB2EEA2D&r=1 2009-12-16T16:55:19-07:00 Add new member fields Re-reading this maybe I wasn't clear. I wanted to add 2 fields to the registration form. These fields would be for first name and last name. I added the 2 fields to the users table in the database as VarChar. I then added the form inputs and called them fname and lname. I found the query to insert new members in the users.cfc file and changed that to insert the two new columns. What I found was that the values of the 2 new form fields (lname, fname) are not being carried through as form.lname or form.fname. I set up arguments for them and cfparam's. What is going on here, any ideas? How can I add these form fields to my registration form? http://www.cfmbb.org/messages.cfm?messageid=986A3A69-BC30-DC21-7B58FB74AB750601&r=2 2009-12-16T16:55:16-07:00 Add new member fields I have added the fields in the login/register page and ten added them to the users.cfc file. Still no go. Where else do I need to add refernce to fname and lname? http://www.cfmbb.org/messages.cfm?messageid=7E60B24E-0F67-2105-F3FC8EF28E83C5F5&r=3 2009-12-11T15:34:44-07:00 Add new member fields It might be something in the SQL server settings? Dude I'm not an expert by any definition. I just know enough to be dangerous http://msdn.microsoft.com/en-us/library/aa172586(SQL.80).aspx http://www.cfmbb.org/messages.cfm?messageid=7A5A04FD-A567-D9D2-42B3D479167EEDCB&r=4 2009-12-10T20:48:57-07:00 During installaton man, thanks for posting the solution. I've never even HEARD of firehose mode... Surprised this has never come up before. http://www.cfmbb.org/messages.cfm?messageid=7A4B818B-9410-3145-4C69F49EDDC764DC&r=5 2009-12-10T20:33:06-07:00 During installaton I am trying to add 2 fields to the register form. I have added fnam and lname. I found the query to adduser in the user.cfc but the values for form.fname and form.lname do not seem to be carried through to the query. ANy ideas? http://www.cfmbb.org/messages.cfm?messageid=79E0AD40-945D-E593-3B842E33F9A5AF36&r=6 2009-12-10T18:36:25-07:00 Add new member fields Works ok when I do a single delete but when I try a multiple user delete I get an error message complaining of an empty string. Any idea? http://www.cfmbb.org/messages.cfm?messageid=79721654-CDEE-FB9F-FA5C071645ABD4B7&r=7 2009-12-10T16:35:37-07:00 Error when doing a multiple delete in admin If anyone cares I did finally figure it out. In cfcs/user.cfc the insert query for the new member has 3 fields that are null: signature, avatar_url, location. In the user table there is default values of (''). Enrolling a new member will generally function but after a number of insert queries it will lock up a SQL server database. I am assuming it places it into Firehouse mode. Adding ?init=1 does reset the db. However, removing the 3 empty cfqueryparam and associated column references in the new member insert query does seem to cure the problem. I have now had a large number of new members added over the past 24 hours without a problem. This is also the same problem I had during installation when I culdn't add the admin account. http://www.cfmbb.org/messages.cfm?messageid=796D02C6-951F-9C75-112EBD4A2767D69B&r=8 2009-12-10T16:30:05-07:00 During installaton Ok I changed the name of the application in Application.cfm and it started working. Ummm is something going on with the socket layer? Anyone have any ideas? http://www.cfmbb.org/messages.cfm?messageid=75534539-D895-D341-250E7B547E3D7340&r=9 2009-12-09T21:23:29-07:00 During installaton Is anyone watching this forum? I could really use a little help http://www.cfmbb.org/messages.cfm?messageid=754421D8-EAE7-9C37-3BD28CDC0FDA30AE&r=10 2009-12-09T21:06:57-07:00 During installaton Ok I finally managed to get this installed and created an admin account. I did this by restarting mt SQL server. I then created several test member accounts. I walked away thrilled it was all working. Now all of a sudden it is no longer allowing new members to sign up. I keep getting a General db error. Any ideas? http://www.cfmbb.org/messages.cfm?messageid=753EA90D-A2B7-1385-97F9FE337B37624A&r=11 2009-12-09T21:00:58-07:00 During installaton I have tried to create the admin account during the installation. When I do I get the folowing error along with a lengthy cfdump claiming error 170 and error 8180 [Macromedia][SQLServer JDBC Driver][SQLServer]Line 2: Incorrect syntax near ','. Error Executing Database Query. It is a Windows 2003, CF8 and SQL server 2003. I have configured the settings.ini as instructed. I tried searching this forum and have not had any luck. Any help would be appreciated! http://www.cfmbb.org/messages.cfm?messageid=6FE9197C-EFBE-489C-975E61AC1B0C31A7&r=12 2009-12-08T20:09:25-07:00 During installaton Ah, I didn't realize you were using groups. That's a "little used feature" http://www.cfmbb.org/messages.cfm?messageid=0CE9B279-E395-FE07-3EEDD5D41B420B8A&r=13 2009-11-19T14:47:39-07:00 EMail new posts to users?? The problem seems to be resolved now. I had my programmer analyze the code and this is what he had to say: Basically the problem was: 424 <cfif thisforum.groupidfk neq ""> 425 <!--- dont send notifications for non-usergroup-members ---> 426 <!---AND A.useridfk not in ( select useridfk from #variables.tableprefix#usergroup_members where groupidfk=<cfqueryparam cfsqltype="cf_sql_char" value="#thisForum.groupidfk#">)---> 427 </cfif> Line 424 basically says ?do this if the forum has a usergroup associated with it?, then 426 says ?add the user?s email to the send list, if they are NOT a member of the usergroup?. Since you have to be a member of the usergroup to access each forum / category anyway in our case, that line would be redundant whether it worked or not. http://www.cfmbb.org/messages.cfm?messageid=0932405D-F26E-6059-3FC906DCD23E3661&r=14 2009-11-18T21:28:25-07:00 EMail new posts to users?? checked those locations and there was no attempt even made to send mail to the users notifying them that there was a reply made to their post. Only mail was sent to the administrator notifying them about the reply. http://www.cfmbb.org/messages.cfm?messageid=CA8F6DD5-FDEB-4A87-91300EDC113FC54A&r=15 2009-11-06T17:34:07-07:00 EMail new posts to users?? check your coldfusion servers mail, exception, and application logs for mail errors. Look in the spool and undelivr directories to make sure emails aren't stuck there. http://www.cfmbb.org/messages.cfm?messageid=9D02F33B-C134-0195-BEFE6E7B9C4B7B31&r=16 2009-10-28T21:17:46-07:00 EMail new posts to users?? Yes just did another test. Created 2 new accounts, made a post with user 1, subscribed them to the thread. Logged in with user 2, subscribed and replied to the post. User 1 did not received any email notification about a new post, however, the adminstrator account for the forum received email notification of everything whether send on post is on or off. Any suggestions? http://www.cfmbb.org/messages.cfm?messageid=9B95A69C-F48F-4173-0E890B599EB3207C&r=17 2009-10-28T14:38:46-07:00 EMail new posts to users?? [quote="perrity"]Ok this is what I am looking for and expected to work, but for some reason no emails are sent to the people subscribed to the forum. I know email is working because they get the account confirmation email. Any ideas?[/quote] you're sure they are subscribed and not just signed up? You don't get emails autoamtically by default. http://www.cfmbb.org/messages.cfm?messageid=9155A5AA-01D5-7CE3-0E7BB0EAB5813B1E&r=18 2009-10-26T14:52:39-07:00 EMail new posts to users?? Ok this is what I am looking for and expected to work, but for some reason no emails are sent to the people subscribed to the forum. I know email is working because they get the account confirmation email. Any ideas? http://www.cfmbb.org/messages.cfm?messageid=912BC902-B62B-A46E-300795BB4E8C19FA&r=19 2009-10-26T14:06:56-07:00 EMail new posts to users?? The standard functionality of CFMBB #1 - send an email notification to subscribers of a topic if and only if we haven't sent them a notification since the last time they viewed the topic. If 10 people had responded to this topic before you viewed it again, you would've only gotten one topic notification. After you viewed the topic, you would then get another notification the next time someone responded. Though to be honest, I'm not 100% sure that you don't just get a notice on every response... :) #2 - in the email notification, the CONTENT of the message is not included. http://www.cfmbb.org/messages.cfm?messageid=78ACD03E-BD4C-537D-25A0A994EF438A65&r=20 2009-10-21T19:57:21-07:00 EMail new posts to users??