BT-server User creation error

Get Started | Login

Discussion Forums > Uncategorized

Replies: 8 Views: 164

theGreek Aspiring developer Posts: 648 Reg: May 25, 2011 Schaumburg, IL 7,830	confirm \| cancel 11/30/11 11:46 AM (14 years ago) BT-server User creation error I discovered an error and I'm looking for a way to resolve it. I created joe blow user with email and password. I then deleted that user and attempted to add him back in again. When I do that it throws an error saying the email ID is already in use. How do I remove that from the tables and what table would that be. Thanks Title Comments I discovered an error and I'm looking for a way to resolve it. I created joe blow user with email and password. I then deleted that user and attempted to add him back in again. When I do that it throws an error saying the email ID is already in use. How do I remove that from the tables and what table would that be. Thanks

David @ buzztouch buzztouch Evangelist Posts: 6866 Reg: Jan 01, 2010 Monterey, CA 78,840	11/30/11 11:55 AM (14 years ago) Great find! So, bt_users in the database holds all the users. These are users you added in the control panel to log into the panel, not users you add to an individual app. Big difference. The trouble: When you create a new user, then delete the user, they are not remvoed from the database. They are marked as deleted. status = deleted in the database. Next, when you add a new user, it checks to see if a user exists with the email. Because they do, it complains. It should look for users that exists that are NOT deleted. I've updated the project and the next release will include this fix. In the meantime, the easiest way to get around this now is: a) open up your database editor, change the email address for the deleted user to something 'fake' - save. This will allow you to re-create a new user with the proper email. Good one. Comments Great find! So, bt_users in the database holds all the users. These are users you added in the control panel to log into the panel, not users you add to an individual app. Big difference. The trouble: When you create a new user, then delete the user, they are not remvoed from the database. They are marked as deleted. status = deleted in the database. Next, when you add a new user, it checks to see if a user exists with the email. Because they do, it complains. It should look for users that exists that are NOT deleted. I've updated the project and the next release will include this fix. In the meantime, the easiest way to get around this now is: a) open up your database editor, change the email address for the deleted user to something 'fake' - save. This will allow you to re-create a new user with the proper email. Good one.

theGreek Aspiring developer Posts: 648 Reg: May 25, 2011 Schaumburg, IL 7,830	11/30/11 12:08 PM (14 years ago) The Cpanel I'm using does not look like it has an editor for the DB. I do have mysql installed on my PC. Not sure if I can point to the DB on the hosted platform and make a change like that. Guess I will find out... Thanks Comments The Cpanel I'm using does not look like it has an editor for the DB. I do have mysql installed on my PC. Not sure if I can point to the DB on the hosted platform and make a change like that. Guess I will find out... Thanks

David @ buzztouch buzztouch Evangelist Posts: 6866 Reg: Jan 01, 2010 Monterey, CA 78,840	11/30/11 02:02 PM (14 years ago) Totally get it. If you can't get to the database, or just want to update the file that has the error (the one you found and I fixed), check your email. I sent you the updated file. FTP it to the /includes folder and overwrite the existing one. It's class.User.php Comments Totally get it. If you can't get to the database, or just want to update the file that has the error (the one you found and I fixed), check your email. I sent you the updated file. FTP it to the /includes folder and overwrite the existing one. It's class.User.php

theGreek Aspiring developer Posts: 648 Reg: May 25, 2011 Schaumburg, IL 7,830	11/30/11 02:04 PM (14 years ago) Thanks David... I appreciate it... Comments Thanks David... I appreciate it...

theGreek Aspiring developer Posts: 648 Reg: May 25, 2011 Schaumburg, IL 7,830	11/30/11 02:14 PM (14 years ago) David I get the following error after doing that. I can add new people like someone else. But if I go back to that other person and try to add him again with the same email I get the following error.... An error ocurred in running the fnExecuteNonQuery() method in utilityFunctions.php (6) Comments David I get the following error after doing that. I can add new people like someone else. But if I go back to that other person and try to add him again with the same email I get the following error.... An error ocurred in running the fnExecuteNonQuery() method in utilityFunctions.php (6)

David @ buzztouch buzztouch Evangelist Posts: 6866 Reg: Jan 01, 2010 Monterey, CA 78,840	11/30/11 02:50 PM (14 years ago) Think I have it. A few more files in email. Back later... Comments Think I have it. A few more files in email. Back later...

theGreek Aspiring developer Posts: 648 Reg: May 25, 2011 Schaumburg, IL 7,830	11/30/11 03:02 PM (14 years ago) Thanks again for the fix. As soon as I get out of the place I call work and get home I will apply the changes and get back to you so you know they worked. Thanks again... Comments Thanks again for the fix. As soon as I get out of the place I call work and get home I will apply the changes and get back to you so you know they worked. Thanks again...

theGreek Aspiring developer Posts: 648 Reg: May 25, 2011 Schaumburg, IL 7,830	11/30/11 04:25 PM (14 years ago) David, Thank you. It worked fine. I deleted and added him back in. A few times... :) Comments David, Thank you. It worked fine. I deleted and added him back in. A few times... :)

Login + Screen Name Required to Post Login to participate so you can start earning points. Once you're logged in (and have a screen name entered in your profile), you can subscribe to topics, follow users, and start learning how to make apps like the pros.