Problems sending email since 4.5.1 upgrade

[Proware]

Since upgrading, I get the following error when sending emails.

In short, it thinks the text is too long for the email.description field. If I send an HTML only version by eleting the text only component of the email and resend then it is fine.

I have checked the table and description is LONGTEXT and the problem only occurs with a moderately long email and I have run the query directly in MySQL and it does not complain.

Where could the restriction on the description field come from?


Query Failed:INSERT into emails set id='344056c5-1ea3-7ccb-4839-45f4e0b6b50c', date_entered='2007-03-12 05:09:11', date_modified='2007-03-12 05:09:11', assigned_user_id='97a4a64b-9582-5644-7345-4472501a6ad7', modified_user_id='97a4a64b-9582-5644-7345-4472501a6ad7', created_by='97a4a64b-9582-5644-7345-4472501a6ad7', team_id='1', name='Sydney Seminar 15.03 ver3: [Test]: We are inviting you to a FREE TSM Seminar. A dinner and a gift\r\n await you as well.', date_start='1999-12-31', time_start='13:00:00', parent_type='Contacts', parent_id='daec2be8-c77a-c6b5-66fc-45c806dc9465', description='\"Do you want to know\nwho\'s stealing your profits?\"\n\n\nDo any of the following apply to your business: Late billing or jobs not billed? Difficulty in tracking field staff movements? Multiple reocording of the same data? Black or missing stock? Working long hours to catch up? Inaccurate and inefficient schedule management? I could go on but I am sure you get the picture.\n\n\nThe Service Manager (TSM) is an industry leader in Field Service Software with over 20 years experience. We\'re more than just a service company, we solve the business problems service companies don\'t know they have.\n\nWe invite you to attend our exclusive 2-hour seminar which will introduce you to the tools you need to typically improve your productivity by 20%, double your field service staff without increasing administration, work 10 hours less per week and increase profits by $50,000 in the first year.\n\nOur recent Melbourne seminar booked out and this seminar is strictly limited to only 20 people on a first come-first served basis. Do not register if you are not serious about improving your service business!\n\nDetails of the Seminar:\n\nMoved to a new date!\n\nMarch 15, 2007 (Tuesday)\n\n5.30 p.m. (Registration)\n\n6:00 pm to 8:00 pm (Actual Seminar)\n\nParramatta Waldorf Apartment Hotel\n\n110-114 James Ruse Drive\n\nRosehill, NSW\n\n\nRegister Now at http://www.theservicemanager.com/seminar/syd\n\n \n\nOr you can call us at (02) 9690 3888 to register.\n\n\nWe do not charge for this seminar.\n\nTake advantage of this special seminar and register now! If you know of\n\nsomeone who wants to improve their service management, forward\n\nthis email to them so they can register away.\n\n\nRegister Now at http://www.theservicemanager.com/seminar/syd\n\nOr you can call us at (02) 9690 3888 to register.\n\n\nSeminar Coverage\n\nBy attending the seminar, we will show you the means to:\n\n� Improve scheduling to save time and money\n\n� Automate field service management\n\n� Eliminate \'Black Stock\' or \'Missing Stock\'\n\n� Increase customer retention and repeat business\n\n� Monitor technicians\' movements\n\n� Use management information to run your business better\n\n� Reduce telecommunication cost \n \n\nAn Exclusive Gift!\n\n \n\nWe have a special gift to the first ten (10) people that register for this\n\nseminar. So what are you waiting for?\n\nRegister Now. Seats are strictly limited to 20.\n\nYes, I need help. Sign me up for the seminar. Click here to\n\nregister http://www.theservicemanager.com/seminar/syd \n\n\nOr you can call us at (02) 9690 3888 to register.\n\nTheServiceManager.com\nSuite 2a, 199 Regent Street Redfern NSW\nPh 02 96903888\n\n\n \n\n\n\nTo remove yourself from this email list go to http://www1.theservicemanager.com/sugarcrmpro/removeme.php?identifier=cc1047c3-5a9e-2f79-0dd9-45f4e05448dd\n', description_html='

[ruchida]

Proware,

What is the exact error message? I think it's chopped off.

[Proware]

MySQL error 1406: Data too long for column 'description' at row 1

[siro]

any news on this problem? I seem to be getting the same error as above when i check my email in sugar 4.5.1e

[o_baeko]

1 Query Failed:INSERT into emails set id='7d558343-9b33-7861-62a8-46bd49395b43', date_entered='2007-08-11 05:30:01', date_modified='2007-08-11 05:30:01', assigned_user_id='c241e770-04b9-017e-cc88-41c1398cb85f', modified_user_id='c241e770-04b9-017e-cc88-41c1398cb85f', created_by='c241e770-04b9-017e-cc88-41c1398cb85f', name='Newsletter test: [Test]: Testing: Extarnal images', date_start='1999-12-31', time_start='17:00:00', parent_type='Users', parent_id='c241e770-04b9-017e-cc88-41c1398cb85f', description=null, description_html='\n\n\n \n\n\n\n \n\n \n \n \n \n \n \n \n \n \n \n \n \n \n
\"\"
October 2005 Issue No: 01
\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
\n

Welcome to the first issue of Inside Offshoring: Offshoring information from Outsourceit.

�ystein Baeko

\n

We will be tracking both the international and domestic scene to bring you an objective and reliable information about offshoring, thus the articles will be in both English and Norwegian. This is a free monthly newsletter from us providing you with updated news, views and trends about the offshoring industry to add value to your offshore outsourcing decision. The newsletter will provide you with the summary of the news article and for those of you who are interested in depth reading a link to the source is provided.

The interests for offshoring is substantially growing; according to a market research conducted by Accenture buying of goods and services from low cost countries like China and India will nearly double within the year 2007. There are many firms who are keen but sceptical to this new method of working, therefore we hope that these newsletters will inform you as objectively as possible about the advantages, challenges, risk and benefits associated with offshoring so you can make an informed decision for your firm.

Enjoy\nReading!
\n
\n

Offshoring News!
\n
\n

10 Ways to Get Offshoring Right
\n
\n

How do you design and implement an effective offshore initiative? What are the key issues to keep in mind? The offshoring landscape is littered with the spectacular failures of companies that missed or lost sight of the big picture. Heed the following tips from expert offshore outsourcing consultants, vendors, and analysts.
\n

1. \n Never Outsource Your Core Value- Firmly establish which IT functions are key to your company\'s and which is not. \"The ones who succeed are the ones who\'ve thought it through ... have very clear areas they want to outsource, and [have] a long-term strategy.\"
2. \n Get Boardroom Ownership- Get senior management committed to your offshoring initiative in its initial phases
3. \n Forge Internal Competencies- Build a strong internal project management team
4. \n Fix Your Process Before Offshoring IT- Companies must clean up their internal IT processes before sending them abroad.
5. \n Demand Domain Expertise- Look at financial strength, legal and regulatory compliance capability, security practices, and the ability to provide insurance against eventualities in your vendors.
6. \n Require Evidence of Best Practices- It\'s vital that vendors abide by industry standards.
7. \n Write Talent Into the Contract- Aside from standard provisions such as security, compliance, and data privacy,it\'s crucial to structure the contract to address make-or-break issues such as project staffing.
8. \n Investigate Pricing Models- Select the pricing structure that offers the biggest bangyou’re your buck.
9. \n Acclimate to Cultural Differences- Experts urge regular visits to offshore vendors and investing time to get to know individuals in both business and social settings.
10. \n Get Your Feet Wet- Last but not least, companies should stick their toes in the water before plunging in headfirst.
\n

\n

Source: CRMBuyer
Top
\n
\n

Norge Offshorer ikke nok
\n
\n

Norske it-bedrifter er ikke gode nok til å bruke lavkostland, og taper i forhold til svenske og danske konkurrenter.
Dette mener Fredrik Syvertsen i IKT Norge.

Norsk it-næring er senest ut med å skaffe seg avtaler med underleverandårer fra lavkostland. Dette styrker ikke vør konkurranseposisjon, sier Syvertsen.

Han forsetter- Offshoring er ikke en stor fare, heller tvert imot. Vi vil ikke miste arbeidsplassene \nvåre til India, men vi vil miste dem til konkurrenter i naboland som er flinkere til offshoring enn vi, mener Syvertsen. Han peker på land som Sverige og Danmark, som i større grad har brukt internasjonaliseringen til å få konkurransefortrinn.

Source: CIO Computerworld
Top
\n
\n

Industry knowledge will be priority for IT staff in 2008
\n
\n

Society for Information Management study finds that about one-third of IT staff positions will be outsourced within three years.

Understanding business domains, industry knowledge, and client-facing skills will be more critical for in-house IT staff over the next three years, while the importance of programming, operations, and help-desk skills will decline as such jobs are increasingly outsourced, according to preliminary findings of a survey of senior IT and human-resources\nexecutives by the Society for Information Management.
\n

Generally, programming, operations, desktop and help desk, and mainframe and legacy-system management skills will be considered less critical in-house capabilities in 2008, according to the study. But specialized skills still considered critical and likely to remain in-house include expertise in Web-based Java and .Net, enterprise-resource-planning reporting, integration, wireless, imaging and sound, and security auditing.
\n

Source: Informationweek
Top
\n
\n

Outsourceit provides Norwegian businesses with software outsourcing services to low cost countries. We coordinate and manage software projects, handling both juridicial and payment issues while our partners in low costs countries perform the development tasks. We also assist Norwegian businesses with establishing their own department or firms in low cost countries.
\n
\n
\n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n \n
\n

Outsourceit\'s News!
\n
\n

New Project Agreement
\n
\n

Outsourceit has signed a new project deal with IBS Media search. This is the fourth project from this client. The project will be based on a time and material model.
\n
\n

Outsourceit has developed mobile content management system
\n
\n


The project was to redesign and develop a new version of an existing mobile content management system for our client who provides e-commerce, mobile and publishing solutions. This application is a part of a system for handling mobile content like java games and poly tone (ring tones) for mobile phones.
\n
\n

Outsourceit completes PDF conversion project for the construction industry
\n
\n


The project was to create a number of active input forms and reports based on electronic paper versions of the forms (pdf). The client is a leading software development firm in the construction and building industry. Our vendor in Vietnam did the conversion while we coordinated and monitored the project development process. The project was completed on time and was well accepted by the client.
\n

\n

For Comments,Questions and Information email us at post@outsourceit.no
\n






\n

\n', from_addr='oystein@outsourceit.no', to_addrs='Øystein Baeko', cc_addrs=null, bcc_addrs=null, to_addrs_ids='c241e770-04b9-017e-cc88-41c1398cb85f;', to_addrs_names='Øystein Baeko;', to_addrs_emails='oystein@outsourceit.no;', type='archived', status='sent', deleted='0'::MySQL error 1406: Data too long for column 'description_html' at row 1

[o_baeko]

Hi, the data first, now the explanation.

I'm trying to create a newsletter campaign, and used an old email template for testing.

The error occures when I'm sending the test mail.

the description_html coloum is of type LONGTEXT, whcih to my knowledge has a max size or 2^32, and it is no way that I exide this size.

hope some one can solve this :-