I hope someone can help me with this one. I inadvertantly discovered a limitation of the default sizes for fields in my PHPNuke/MySQL install. By default the "Sections" articles use a MySQL datatype of "Text" which has a limit of 65536 characters. This was too small for my needs (discovered it when I saw articles I had posted were truncating). I went in through phpmyadmin and saw that datattype "text" was in use and that two others ("mediumtext" and "longtext") were available. I initially chose longtext and this solved my problem (or so I thought). I could put my long articles in and they showed up on the website as expected. But once I cleared out the old articles and started putting them all back in again as new articles, after about 8-10 of them, I could no longer enter the Sections admin section of the website! I would receive a 500 error "Internal Server Error - The server encountered an unexpected condition which prevented it from fulfilling the request.". Is this due to expanding beyond my 100MB database size in terms of these longer datatypes? The mediumtext is 16 million characters, and the longtext is 4 billion! I backed off to mediumtext but still ran aground after several entries. And when I look at my host providers online administration they show that of my 100MB database I'm using only 1.89 MB! So I should have plenty of space. Would running an optimize from the MySQL interface shorten the size of the text fields? That is to say if the actual text occupying the content field (in the nuke_seccont table) is say 250K, would running an optimize make that field take up 250K instead of 16MB (if I have the fieldtype set to mediumtext)?
Thanks to anyone who can assist with this...
