Meta Keyword update gives blank page
Permalink
I have a site running OK for some months now. My client updated one of the pages to add some keywords to the meta data (which she has successfully done for other pages). For some reason each time you try to add meta data to this page the process returns a white page and the update is not comleted. I turned on Debugging and this returned the following error:
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1406: Data too long for column 'content' at row 1] in EXECUTE("INSERT INTO PageSearchIndex (cID,cName,cDescription,cPath,cDatePublic,content) VALUES ('56','SOLUTIONS','about solutions','/solutions','2009-11-25 15:46:00','Solutions\r\n With proven credentials and accreditations in Unified Communications, Network Infrastructure and Contact Centre solutions, NSC transforms organisations to better meet the demands of a constantly changing business landscape. Whether we are delivering an end-to-end solution or layering convergent applications on top of an existing network, NSC successfully connects your business to an IP world providing you with a more effective way to communicate and collaborate. \r\n\r\n\r\n \r\n\r\n\r\nUnified Communications\r\n Unified Communications (UC), the convergence of business communications applications includes voice and video telephony, conferencing, collaboration, voice and video mail, instant messaging, email, ca in D:\wwwroot\nsc.net.au\concrete\libraries\3rdparty\adodb\adodb-exceptions.inc.php on line 78
Can anyone point me to the correct solution to this problem. The site is built on version 5.3.3.1
Regards Ian
Fatal error: Uncaught exception 'ADODB_Exception' with message 'mysql error: [1406: Data too long for column 'content' at row 1] in EXECUTE("INSERT INTO PageSearchIndex (cID,cName,cDescription,cPath,cDatePublic,content) VALUES ('56','SOLUTIONS','about solutions','/solutions','2009-11-25 15:46:00','Solutions\r\n With proven credentials and accreditations in Unified Communications, Network Infrastructure and Contact Centre solutions, NSC transforms organisations to better meet the demands of a constantly changing business landscape. Whether we are delivering an end-to-end solution or layering convergent applications on top of an existing network, NSC successfully connects your business to an IP world providing you with a more effective way to communicate and collaborate. \r\n\r\n\r\n \r\n\r\n\r\nUnified Communications\r\n Unified Communications (UC), the convergence of business communications applications includes voice and video telephony, conferencing, collaboration, voice and video mail, instant messaging, email, ca in D:\wwwroot\nsc.net.au\concrete\libraries\3rdparty\adodb\adodb-exceptions.inc.php on line 78
Can anyone point me to the correct solution to this problem. The site is built on version 5.3.3.1
Regards Ian
The url is as you mentioned
http://www.nsc.net.au
I am not sure why the closing tags for html and body are not there as they are in the footer.php file for the theme (slightly modified greensalad). I will investigate this a bit more.
I do not believe this is the cause of my problem with the meta tags though as the site has been live since Februaru and has had no problems before.
http://www.nsc.net.au
I am not sure why the closing tags for html and body are not there as they are in the footer.php file for the theme (slightly modified greensalad). I will investigate this a bit more.
I do not believe this is the cause of my problem with the meta tags though as the site has been live since Februaru and has had no problems before.
The amount of data/text you wanna store in the field 'content' is more then that field can have under the table SearchPageIndex.
If you copy/paste from MS Word into the text box, they are dragging along all the formatting code from MS Word this brings a lot of unnecessary junk (some of your text is showing a bunch of "\r\n\r\n\r\n \r\n\r\n\r\n") so this might be the case.
Have them put the text into a plain text editor (Notepad), do some minimal formatting, then you can paste it into the text box.
If this is not the case then increase the size of your content field under the table PageSearchIndex, so instead of the column type being TEXT change it to LONGTEXT, you can do this using something like phpMyAdmin.
If you copy/paste from MS Word into the text box, they are dragging along all the formatting code from MS Word this brings a lot of unnecessary junk (some of your text is showing a bunch of "\r\n\r\n\r\n \r\n\r\n\r\n") so this might be the case.
Have them put the text into a plain text editor (Notepad), do some minimal formatting, then you can paste it into the text box.
If this is not the case then increase the size of your content field under the table PageSearchIndex, so instead of the column type being TEXT change it to LONGTEXT, you can do this using something like phpMyAdmin.
Thanks for the advice. I have asked the client to paste into Notepad before placing text into the CMS but they sometimes miss this. Also I notice that because I am using Mattorgel Area Splitter to create a series of tabbed pages in the one page there is an extraordinary amount of content in this page on the site. I think there is a need to rework this site to clean it up.
Once again, thanks.
Once again, thanks.
http://www.nsc.net.au/
I noticed that this site seems to be missing </body></html> which is not good.