The Joomla! Extensions Directory ™

Download

Demo

joshharle

Extensions(2)
Reviews(1)
Favourites(0)
 
Results 1 - 1 of 1
Letterman Newsletter
fix for "No User you could select!"
byjoshharle, March 22, 2008
Letterman Newsletter
As stated by another reviewer, there is no support for this extension. This seems like as good a place as any to give a fix to Joomla users who receive the error "No User you could select!" when trying to assign users.

The problem (for me at least) was that my Joomla! created the database tables as collation: latin1_swedish_ci. When letterman tries to join one of its tables to a core joomla one, it gives:

#1267 - Illegal mix of collations (latin1_swedish_ci,IMPLICIT) and (latin1_general_ci,IMPLICIT) for operation '='

The fix is to go into your database using phpMyAdmin, and change the _letterman_* tables to the same collation as your joomla ones.

Hope that saves you trouble!
Support Joomla!