node_save gives PDOException: in field_sql_storage_field_storage_write()

By saitanay on 6 Mar 2012 at 06:59 UTC

i m doin a node_load,. update the body and save,

getting the error:
PDOException: in field_sql_storage_field_storage_write() (line 424 of /var/www/vhosts/..xxx../modules/field/modules/field_sql_storage/field_sql_storage.module).

PDOException: in field_sql_storage_field_storage_write() (line 424 of /var/..xxx../d1/modules/field/modules/field_sql_storage/field_sql_storage.module).

the text that i m trying to insert is:

<DIV><DIV>Cigarette smoke may be more harmful to women than men when it comes to bladder cancer, according to recent research. <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p> <o:p></o:p>We all know that smoking is bad for you. But if youre a woman, listen up. A study from the University of Southern California says womens bladders may be more susceptible to cancer-causing agents in tobacco. Researchers found that when women and men smoke at comparably high levels, womens bladder cancer risk is 30 to 50 percent higher.<o:p></o:p> <o:p></o:p>The study comes on the heels of the U.S. Surgeon Generals June 27 declaration that second-hand smoke is a serious health hazard, triggering many cancers, including bladder cancer. So how does cigarette smoke affect the bladder?<o:p></o:p> <o:p></o:p>Smoke contributes to bladder cancer because carcinogens in cigarette smoke are absorbed from the lungs into the bloodstream, said Viviana Simon, Ph.D., director of scientific programs for the Society for Womens Health Research, a Washington, D.C. based non-profit research, education, and advocacy organization. The carcinogens are then filtered by the kidneys, concentrated in the urine, and can then damage the cells that line the bladder.<o:p></o:p> <o:p></o:p>The incidence of bladder cancer has been steadily increasing, according to statistics from the American Urological Association. Cigarettes top the list of risk factors. Risk increases with the duration of smoking, and decreases when smokers quit. Increasing age is also a risk factor.<o:p></o:p> <o:p></o:p>The influence of tobacco on bladder cancer susceptibility is not the only way that the disease differs between women and men. For example, bladder cancer is more common in men, but women are more likely to die from the disease. One explanation for the difference is that women are more likely than men to suffer from rarer types of bladder cancer, according to the National Cancer Institute. Another explanation for the higher mortality rate in women is because a greater number of women experience a delay in diagnosis. Women with bladder cancer are diagnosed six to nine months later than men with the disease, and womens cancers are detected at a more advanced stage.<o:p></o:p> <o:p></o:p>The warning signs of bladder cancer typically include blood in the urine or a change in urinary habits such as urinary frequency, urgency or dysuria, which is pain while urinating, according Waleed Hassen, M.D., director of urological oncology at the Mount Sinai School of Medicine in New York, N.Y. These symptoms can be sometimes confused with urinary tract infections, especially in women, which can sometimes delay diagnosis.<o:p></o:p> <o:p></o:p>If the diagnosis is delayed and the disease progresses, the patient usually has different symptoms. Later warning signs of the bladder cancer include weight loss, pain and fatigue, Hassen said.<o:p></o:p> <o:p></o:p>A timely diagnosis is crucial to survival. For patients with non-invasive bladder cancer, the five-year survival rate is over 90 percent. The rate drops below 50 percent, if the cancer spreads over the pelvic region. If it progresses to other organs, the five-year survival rate falls to just six percent.<o:p></o:p> <o:p></o:p>Thats why it is so important to see your doctor right away if you have any symptoms or problems related to urination. Treatment of the disease varies by case, but surgery is usually involved and yields the best outcome. Depending on the extent of the disease, chemotherapy, radiation and biological therapies, which stimulate the bodys immune system, may be involved.<o:p></o:p> <o:p></o:p>Because smoking is the largest known risk factor for bladder cancer, it is vital for tobacco smokers to be aware of their risk. Relatives and people who spend time with a smoker are also at risk, given the established dangers of second-hand smoke. The growing number of ways we know smoke harms health is a good reason to stop smoking or help those around you stop.<o:p></o:p> <o:p></o:p>Beyond smoking, occupational exposures to chemicals found in some dyes, paints, solvents, leather dust, inks, combustion products, rubbers, and textiles can increase the risk of bladder cancer. As a result, hairdressers, machinists, painters, printers, truck drivers, and those who work with the drugs used in chemotherapy need to be aware of their risk and the cancers symptoms.<o:p></o:p> <o:p></o:p>Source: Society for Women's Health Research (SWHR)<o:p></o:p></DIV></DIV>

a simple text as "test" is able to save the node,.

whats wrong with the above text to be saved as a node? it already passed through mysql_escape_string

Comments

Try stripping all that MSN

jaypan

Victoria, BC

commented 6 March 2012 at 13:30

Try stripping all that MSN code from the text.

It really shouldn't matter though - have you tried saving something simpler to confirm that it's the text you are saving that causes the problem, and not a larger system problem?

Contact me to contract me for D7 -> D10/11 migrations.

yeah,. simpler text like

saitanay commented 7 March 2012 at 11:54

yeah,. simpler text like "this is a test" etc are saved fine

_

WorldFallz commented 7 March 2012 at 12:59

then you answered your own question, lol. Get rid of all the ms specific garbage in the html (there's online cleaners you can use to do it).

copy & paste with MS html is almost always a recipe for trouble. Avoid it.

If it helps ...

kdinn commented 2 October 2012 at 04:28

I had the same problem and solved it by putting the string through utf8_encode.

Had the same problem when

yannickoo

Berlin

commented 7 October 2012 at 04:25

Had the same problem when trying to substr a string and solved it with drupal_substr function.

Thank you! It worked by

kidd1126 commented 30 October 2012 at 06:59

Thank you!
It worked by change to utf-8.

forceutf8

kubrt commented 4 November 2015 at 16:41

If you apply the PHP function utf8_encode() to an already-UTF8 string it will return a garbled UTF8 string.

https://github.com/neitanod/forceutf8 addresses the problem.

if (!mb_check_encoding($text)) {	
	$text = Encoding::toUTF8($text);
}

using this library https://github.com/neitanod/forceutf8

node_save gives PDOException: in field_sql_storage_field_storage_write()

Comments

Try stripping all that MSN

yeah,. simpler text like

_

If it helps ...

Had the same problem when

Thank you! It worked by

forceutf8

Thanks its working for me ...

The reason there is no error

Force utf8

New forum topics

News items

Our community

Documentation

Drupal code base

Governance of community