Group registration in newsletters conflicts with the "Use email as username" feature
- Status
- Open
- Subject
- Group registration in newsletters conflicts with the "Use email as username" feature
- Version
- 6.x
7.x
8.x
9.x - Category
- Conflict of two features (each works well independently)
- Feature
- Newsletters
User Administration (Registration, Login & Banning) - Submitted by
- Marc Laporte
- Lastmod by
- Marc Laporte
- Rating
- Description
To reproduce
- Install a fresh Tiki
- Create some usernames as usual
- Set "Use email as username" feature to yes
- Create more users (this time, username will be the email)
- Create a newsletter
- Subscribe the Registered group to the newsletter
- Send a newsletter
The system will crash and be unable to send the newsletter because some users don't have valid emails. If you error reporting is activated, you will get a message like this:System error. The following error message was returned: Duplicate entry '3-mcradmin-g' for key 'PRIMARY' The query was: INSERT INTO `tiki_newsletter_subscriptions` (`nlId`,`email`,`code`,`valid`,`subscribed`,`isUser`,`included`) VALUES (?,?,?,?,?,?,?) Values: 3 mcradmin 6b78cc21c16e768dd8fbb6b538c6bf78 y 1339700591 g n The built query was likely: INSERT INTO `tiki_newsletter_subscriptions` (`nlId`,`email`,`code`,`valid`,`subscribed`,`isUser`,`included`) VALUES ('3','mcradmin','6b78cc21c16e768dd8fbb6b538c6bf78','y','1339700591','g','n') Things to check: Is your database up and running? Is your database corrupt? Please see how to repair your database Are your database credentials accurate? (username, database name, etc in db/local.php) Did you complete the Tiki Installer? Please see the documentation for more information.- Solution
- The system should check if all values are valid emails, and then ignore and report the usernames in the errors.
- Workaround
Rename all the users to have proper emails. (Really, you should have done this already for consistency.
- Importance
- 2
- Easy to solve?
- 4
- Priority
- 8
- Demonstrate Bug (Tiki 19+)
-
This bug has been demonstrated on show2.tiki.org
Please demonstrate your bug on show2.tiki.org
Version: Create show2.tiki.org instanceAbout show2.tiki.orgTo help developers solve the bug, we kindly request that you demonstrate your bug on a show2.tiki.org instance. To start, simply select a version and click on "Create show2.tiki.org instance". Once the instance is ready (in a minute or two), as indicated in the status window below, you can then access that instance, login (the initial admin username/password is "admin") and configure the Tiki to demonstrate your bug. Priority will be given to bugs that have been demonstrated on show2.tiki.org.
- Ticket ID
- 4244
- Created
- Thursday 14 June, 2012 21:58:43 GMT-0000
by Marc Laporte - LastModif
- Monday 28 October, 2013 07:10:50 GMT-0000
Attachments
| filename | created | hits | comment | version | filetype | ||
|---|---|---|---|---|---|---|---|
| No attachments for this item | |||||||
;){kind=link}
;){kind=link}
- Browse Directory is broken
- Wiki argument variables, Documentation; The help tools of Tiki for Wiki argument variables redirect to the wrong page
- Plugin List, Wiki Argument Variables; Admin should see a warning when the Wiki Argument Variables is not enabled and he tries to use it.
- General, Navigation; Endless loop, too much redirect error, if a wiki page is the value of the option
- Tiki tag ~ hs ~ is lost on wiki page duplication
;){kind=link}
;){kind=link}