Help - Search - Members - Calendar
Full Version: Lost archives, possibly entries
Movable Type Community Forum > Other Product Discussion > Bugs and Odd Behavior
Charles W. Stricklin
I've just encountered some disconcerting behavior on the past of Movable Type. I saved, then published a new entry, and it displayed an error, saying:

QUOTE
An error occurred:


Statement has no result columns to bind (perhaps you need to successfully call execute first) at lib/MT/ObjectDriver/DBI.pm line 79.


Now, nothing appears under the archives division, the calendar does show any days in bold, and when I click "Edit Entries" no entries are available.

Help!
Charles W. Stricklin
Please, someone help! sad.gif
ndns
Remember that everyone here is a volunteer. It may take longer than a few hours to receive a reply to your post.

For more tips on using the forums, read girlie's list.
girlie
Charles, run the REPAIR command on your MySQL database (using a tool like phpMyAdmin, for example), and see if that clears up the error.

Also, the search feature of the forum would have turned up results for this (i.e., statement has no result columns to bind in older posts in all open forums). Just something to keep in mind when the volunteers are at their paying jobs during the day. wink.gif
Charles W. Stricklin
Sorry. sad.gif
Charles W. Stricklin
biggrin.gif Girlie, as always, was right.

I logged into myPHPAdmin, executed the following queries and everything was right as rain!

REPAIR TABLE mt_author;
REPAIR TABLE mt_blog;
REPAIR TABLE mt_category;
REPAIR TABLE mt_comment;
REPAIR TABLE mt_entry;
REPAIR TABLE mt_ipbanlist;
REPAIR TABLE mt_log;
REPAIR TABLE mt_notification;
REPAIR TABLE mt_permission;
REPAIR TABLE mt_placement;
REPAIR TABLE mt_plugindata;
REPAIR TABLE mt_tbping;
REPAIR TABLE mt_template;
REPAIR TABLE mt_templatemap;
REPAIR TABLE mt_trackback;

Thanks, Girlie, for helping out and not scolding me too bad for my etiquette faux pas.
Solomonia
Thank you, thank you, thank you on this, esp. to Charles for coming back and reporting results. I just had the *exact* same problem, but followed the instructions here (I know nothing of PHPMyadmin, but I puzzled it through) and seem to have recovered (all but the last two entries which I can re-create).

Thanks again. (I hope it doesn't happen again.)
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2008 Invision Power Services, Inc.