For my main LisaShea forums I ran a rebuild of the categories, then forums, then posts. When I got to the posts level, which has I think 500k entries, it chugged for a while. Then it jammed on what I think is a spam post. Now what?

\forum\libs\content_rebuild.inc.php
Line#: 89
SQL Error: Incorrect string value: '\xA5\xC3\xA1\xC3\xAD\xC3...' for column 'POST_BODY' at row 1
SQL Error #: 1366
Query: UPDATE ubbt_POSTS SET POST_BODY = '

 ñàìûé òîðæåñòâåííûé, ðîìàíòè÷åñêèé èëè ðàäîñòíûé ìîìåíò íàøåé æèçíè ìû âñïîìèíàåì î öâåòàõ. ×òî, åñëè íå áóêåò öâåòîâ ïîâûøàåò íàñòðîåíèå è âûçûâàåò áëàæåííóþ óëûáêó íà íàøèõ ëèöàõ? Ôëîðèñòû íàøåãî öâåòî÷íîãî ìàãàçèíà "Òþëüïàíû" ñòàðàþòñÿ ïîäõîäèòü ê ñîñòàâëåíèþ êàæäîãî áóêåòà èíäèâèäóàëüíî è ñîçäàþò íåïîâòîðèìûå êîìïîçèöèè, áóäü òî ñâàäåáíûé áóêåò, áèçíåñ-áóêåò èëè áóêåò äëÿ Âàøåãî ëþáèìîãî ÷åëîâåêà. Íåëüçÿ ñêàçàòü, ÷òî â íàøåé êîëëåêöèè òþëüïàíîâ åñòü ëó÷øèå è èìåííî îíè èñïîëüçóþòñÿ â ñîñòàâëåíèè áèçíåñ...�áíûõ è äðóãèõ áóêåòîâ. Íåò.  íàøåé êîëåêöèè ÊÀÆÄÛÉ òþëüïàí ëó÷øèé, ïîýòîìó è áóêåòû, ñîñòàâëÿåìûå íàìè âñåãäà ïðåêðàñíû è îðèãèíàëüíû. Ïîçâîíèòå íàì è îôîðìèòå çàêàç öâåòîâ' WHERE POST_ID = 202806


I have direct access to MySQL. Should I empty out the post_body for post_id=202806? And then just rerun the entire rebuild from scratch?

I wanted to report it so you could account for this in the script.

Lisa


Lisa Shea, owner, BellaOnline.com
BellaOnline Website
BellaOnline Forums - UBB since Apr 2002 - 58,000 members / 850,000 posts