Re: [SM-USERS] Help with html mail plugin
Piyush Joshi gmail.com> writes: > > Hello all, > I am not happy with html_mail plugin because while > replying to mail it lost html formating specially with images, tables. > now i want to know can i use ckeditor with this plugin and using > ckeditor will solve my issue. > > Correct me if you think this is not an editor issue. It is not editor issue. Plugin has settings that control what to do when user replies to html formated email. It also has code which cleans html before putting it in compose form. If you start composing in plain text and then switch to html, original tables and images are not restored. You must set plugin to use html in replies, if you want to keep tables Upgrade to ckeditor is possible, but it requires some changes in the way html editor is initialized and I would not call it an upgrade. You will lose some html editor features, if you upgrade FCKEditor 2.1. to CKEditor 3.3.1 and want to maintain GPL compatibility. -- Tomas -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first - squirrelmail-users mailing list Posting guidelines: http://squirrelmail.org/postingguidelines List address: squirrelmail-users@lists.sourceforge.net List archives: http://news.gmane.org/gmane.mail.squirrelmail.user List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
Re: [SM-USERS] Slight modification to PostgreSQL address table definition
C. Bensend wrote:
>
>
> Hey folks,
>
>I store all my userprefs and address books in PostgreSQL, and
> I've run into a problem occasionally with the constraint suggested
> in the documentation found at:
>
> http://www.squirrelmail.org/docs/admin/admin-5.html#db-backend
>
>It suggests creating the address table with the following
> definition:
>
> CREATE TABLE "address" (
> "owner" varchar(128) NOT NULL,
> "nickname" varchar(16) NOT NULL,
> "firstname" varchar(128) NOT NULL,
> "lastname" varchar(128) NOT NULL,
> "email" varchar(128) NOT NULL,
> "label" varchar(255) NOT NULL,
> CONSTRAINT "address_pkey" PRIMARY KEY ("nickname", "owner")
> );
> CREATE UNIQUE INDEX "address_firstname_key" ON "address"
> ("firstname", "lastname");
>
>Unfortunately, that unique index is too narrow - I cannot have more
> than one user that defines an address with "Frank" and "Marshall" as
> their names, for example. I would instead suggest a constraint
> like so:
>
> CREATE UNIQUE INDEX "address_firstname_key" ON "address" ( "firstname",
>"lastname", "owner", "email" );
>
>This allows multiple users to have identical entries, which may
> or may not fit your needs. It does mine. :) Having a four-column
> unique index may produce index bloat on larger installations, I have
> less than a thousand addresses in mine and it works great.
>
MySQL schema is closer to
CREATE INDEX "address_firstname_key" ON "address" ( "firstname",
"lastname");
Are you sure that those entries need something unique?
--
View this message in context:
http://old.nabble.com/Slight-modification-to-PostgreSQL-address-table-definition-tp29095696p29107241.html
Sent from the squirrelmail-users mailing list archive at Nabble.com.
--
This SF.net email is sponsored by Sprint
What will you do first with EVO, the first 4G phone?
Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first
-
squirrelmail-users mailing list
Posting guidelines: http://squirrelmail.org/postingguidelines
List address: squirrelmail-users@lists.sourceforge.net
List archives: http://news.gmane.org/gmane.mail.squirrelmail.user
List info (subscribe/unsubscribe/change options):
https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
Re: [SM-USERS] Help with html mail plugin
Dear Tomas, I have default compose in html and also have reply in html format setting in webmail but still i lost my html formatting when i reply to any html message .. Can you point out me what i am doing wrong or show any demo where it is being used. Thanks for the reply On Thu, Jul 8, 2010 at 1:04 PM, Tomas Kuliavas wrote: > Piyush Joshi gmail.com> writes: > >> >> Hello all, >> I am not happy with html_mail plugin because while >> replying to mail it lost html formating specially with images, tables. >> now i want to know can i use ckeditor with this plugin and using >> ckeditor will solve my issue. >> >> Correct me if you think this is not an editor issue. > > It is not editor issue. Plugin has settings that control what to do when user > replies to html formated email. It also has code which cleans html before > putting it in compose form. If you start composing in plain text and then > switch > to html, original tables and images are not restored. You must set plugin to > use > html in replies, if you want to keep tables > > Upgrade to ckeditor is possible, but it requires some changes in the way html > editor is initialized and I would not call it an upgrade. You will lose some > html editor features, if you upgrade FCKEditor 2.1. to CKEditor 3.3.1 and want > to maintain GPL compatibility. > > -- > Tomas > > > -- > This SF.net email is sponsored by Sprint > What will you do first with EVO, the first 4G phone? > Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first > - > squirrelmail-users mailing list > Posting guidelines: http://squirrelmail.org/postingguidelines > List address: squirrelmail-users@lists.sourceforge.net > List archives: http://news.gmane.org/gmane.mail.squirrelmail.user > List info (subscribe/unsubscribe/change options): > https://lists.sourceforge.net/lists/listinfo/squirrelmail-users > -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first - squirrelmail-users mailing list Posting guidelines: http://squirrelmail.org/postingguidelines List address: squirrelmail-users@lists.sourceforge.net List archives: http://news.gmane.org/gmane.mail.squirrelmail.user List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
Re: [SM-USERS] Slight modification to PostgreSQL address table definition
> MySQL schema is closer to > > CREATE INDEX "address_firstname_key" ON "address" ( "firstname", > "lastname"); > > Are you sure that those entries need something unique? I personally prefer them to be unique, just so my users don't double up their contacts. It doesn't *have* to be, though. I just wanted to mention that the recommendation doesn't really do what I think is intended, as only one user can have a contact named "Bob Smith". :) Benny -- "Well, we *could* hunt down the perpetrators, pool some $$, and hire 3 or 4 baseball-bat wielding professional explainers to go explain our position to them. Figuring out how to do so without breaking any laws is the tough part..." -- Valdis Kletnieks, 2009-01-23 -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first - squirrelmail-users mailing list Posting guidelines: http://squirrelmail.org/postingguidelines List address: squirrelmail-users@lists.sourceforge.net List archives: http://news.gmane.org/gmane.mail.squirrelmail.user List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
Re: [SM-USERS] Slight modification to PostgreSQL address table definition
C. Bensend wrote: > > >> MySQL schema is closer to >> >> CREATE INDEX "address_firstname_key" ON "address" ( "firstname", >> "lastname"); >> >> Are you sure that those entries need something unique? > > I personally prefer them to be unique, just so my users don't > double up their contacts. It doesn't *have* to be, though. > I just wanted to mention that the recommendation doesn't really > do what I think is intended, as only one user can have a contact > named "Bob Smith". :) > "Robert Smith", "Bob Smith", "Bobby", "Mr. Smith" and "Brad Jr." can be same person. SquirrelMail address book has only one requirement. Unique nickname per address book. Any other restriction is specific to storage backend and might create problems when you change your backend. If unique indexes increase load of your DB, you might consider making them not unique. If users hit artificial restriction in DB, they won't see SquirrelMail address book warning, they will see DB error. Documentation needs fixes. I am not DBA, but I suspect that setting unique 4 key index not required by application is not good thing. Documentation could show several ways to do index stuff. -- View this message in context: http://old.nabble.com/Slight-modification-to-PostgreSQL-address-table-definition-tp29095696p29107643.html Sent from the squirrelmail-users mailing list archive at Nabble.com. -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first - squirrelmail-users mailing list Posting guidelines: http://squirrelmail.org/postingguidelines List address: squirrelmail-users@lists.sourceforge.net List archives: http://news.gmane.org/gmane.mail.squirrelmail.user List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
Re: [SM-USERS] Slight modification to PostgreSQL address table definition
> "Robert Smith", "Bob Smith", "Bobby", "Mr. Smith" and "Brad Jr." can be > same > person. Yes, of course. But "Mom" is pretty much the same for everyone. ;) > SquirrelMail address book has only one requirement. Unique nickname per > address book. Any other restriction is specific to storage backend and > might > create problems when you change your backend. If unique indexes increase > load of your DB, you might consider making them not unique. If users hit > artificial restriction in DB, they won't see SquirrelMail address book > warning, they will see DB error. > > Documentation needs fixes. I am not DBA, but I suspect that setting unique > 4 > key index not required by application is not good thing. Documentation > could > show several ways to do index stuff. And that is all I am asking to have changed, the documentation. :) The four-key index works very well for me, but I agree that it probably makes DBAs shudder. All I am commenting on is that the recommendation made in the documentation may not work the way many users may expect. That's all. :) Benny -- "Well, we *could* hunt down the perpetrators, pool some $$, and hire 3 or 4 baseball-bat wielding professional explainers to go explain our position to them. Figuring out how to do so without breaking any laws is the tough part..." -- Valdis Kletnieks, 2009-01-23 -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first - squirrelmail-users mailing list Posting guidelines: http://squirrelmail.org/postingguidelines List address: squirrelmail-users@lists.sourceforge.net List archives: http://news.gmane.org/gmane.mail.squirrelmail.user List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
Re: [SM-USERS] Help with html mail plugin
Piyush Joshi-3 wrote: > > Dear Tomas, > I have default compose in html and also have > reply in html format setting in webmail but still i lost my html > formatting when i reply to any html message .. > > Can you point out me what i am doing wrong or show any demo where it > is being used. > It seems that plugin needs specific set of options and when use of html is optional, plugin makes it ... optional :). Options -> Display Preferences * Show HTML Version by Default: check * Compose Messages in New Window: check, I want to see both original and compose in screenshot * Default Email Composition Format: HTML * Only Reply In HTML When Viewing HTML Format: No (Always Attempt To Reply In HTML) Create email with table and remote image. Read email, enable remote images Reply And result is http://yfrog.com/3mtesttableandimagej When weather is right and you knock on the wood twice, you can reply in html. :) -- Tomas -- View this message in context: http://old.nabble.com/Help-with-html-mail-plugin-tp29103067p29108024.html Sent from the squirrelmail-users mailing list archive at Nabble.com. -- This SF.net email is sponsored by Sprint What will you do first with EVO, the first 4G phone? Visit sprint.com/first -- http://p.sf.net/sfu/sprint-com-first - squirrelmail-users mailing list Posting guidelines: http://squirrelmail.org/postingguidelines List address: squirrelmail-users@lists.sourceforge.net List archives: http://news.gmane.org/gmane.mail.squirrelmail.user List info (subscribe/unsubscribe/change options): https://lists.sourceforge.net/lists/listinfo/squirrelmail-users
