Textpattern CMS support forum
You are not logged in. Register | Login | Help
- Topics: Active | Unanswered
Dump import throws error for Null on body content of article
I’m trying to import a dump file. I’m getting an error
MySQL said: Documentation
- - Column ‘Body’ cannot be null
I’m assuming it’s talking about the <txp:body /> content. It references a particular article, but the article has body content saved, nothing out of the ordinary.
What’s the error about?
Offline
Re: Dump import throws error for Null on body content of article
searching for mysql error 1048 returns results regarding a mysql bug
Last edited by colak (2009-02-13 13:02:48)
Yiannis
——————————
NeMe | hblack.art | EMAP | A Sea change | Toolkit of Care
I do my best editing after I click on the submit button.
Offline
Re: Dump import throws error for Null on body content of article
That bug’s from 2005. I sure hope that was fixed by now. :)
This might be related to some other oddness I’ve been experiencing. I don’t know.
Things I’ve noticed on this particular install I’m working with:
- Null issue with dump importing (noted above)
- Delete buttons missing from next to pages I’ve created.
- No Create Thumbnail controls in the edit mode of uploaded images. (It exists in my own site installation, but not this one I’m working with. Both are 4.0.8 (r3085).)
- Mysterious styling overriding my CSS styles, but only for one particular article in the section. All other articles with same CSS not affected. (Had to delete and recreate article to get rid of the ghost impact, as it were)
I have no idea why these things are the way they are, but it’s not normal that I can tell. The MySQL for the local site (problems exhibited) is 5.0.45 while my online version is 5.0.65-log. Have no idea.
Oh, the dump import, however is also 5.0.65-log so no correlation on that point at least. Maybe it was corrupted locally though before dumping. No idea.
Offline
Re: Dump import throws error for Null on body content of article
Import issue solved. The dump was corrupt by CoCoa MySQL, which is about to be uninstalled permanently.
Command-line rules !
Offline
Re: Dump import throws error for Null on body content of article
Destry wrote:
Delete buttons missing from next to pages I’ve created.
I’m guessing the reason this is happening is because when creating new pages I’m copying pages that were initially copied from the default page, which of course has no delete button. The inability to delete seems to pass on to pages copied from the parent default. If true, this is bad. I now have some pages I want to delete and can’t, apparently, without going into phpMyAdmin. :(
I would vote this be changed in the next release.
Offline
Re: Dump import throws error for Null on body content of article
Destry wrote:
Delete buttons missing from next to pages I’ve created.
You will not be able to delete pages which are in use by any section, plus the page named error_default. So you’d first have to reassign a distinct page to the sections affected.
No Create Thumbnail controls in the edit mode of uploaded images. (It exists in my own site installation, but not this one I’m working with. Both are 4.0.8 (r3085).)
This is a symptom of a hosting environment which lacks the GD graphics library. Visit diagnostics and look for this line: GD Image Library: unavailable.
Offline
Re: Dump import throws error for Null on body content of article
Thanks wet. I’m comforted by solid explanations; even if it reveals the lobotomy I had in 87.
Offline