tikiwiki failed
Hello,
Upgrading an article of the Tikiwiki has failed me and now he/she appears me the following error:
Context:
File /tiki/tiki-view_articles.php
Url /tiki/tiki-view_articles.php?topic=1
Query:
select `tiki_articles`.*, `users_users`.`avatarLibName`, `tiki_article_types`.`use_ratings`, `tiki_article_types`.`show_pre_publ`, `tiki_article_types`.`show_post_expire`, `tiki_article_types`.`heading_only`, `tiki_article_types`.`allow_comments`, `tiki_article_types`.`show_image`, `tiki_article_types`.`show_avatar`, `tiki_article_types`.`show_author`, `tiki_article_types`.`show_pubdate`, `tiki_article_types`.`show_expdate`, `tiki_article_types`.`show_reads`, `tiki_article_types`.`show_size`, `tiki_article_types`.`show_topline`, `tiki_article_types`.`show_subtitle`, `tiki_article_types`.`show_linkto`, `tiki_article_types`.`show_image_caption`, `tiki_article_types`.`show_lang`, `tiki_article_types`.`creator_edit` from `tiki_articles`, `tiki_article_types`, `users_users` where ( `tiki_articles`.`topicId`=? ) and (`tiki_articles`.`publishDate`? or `tiki_article_types`.`show_post_expire`='y') and `tiki_articles`.`type` = `tiki_article_types`.`type`and `tiki_articles`.`author` = `users_users`.`login` order by `publishDate` desc
Values:
0 1
1 1138748399
2 1138651028
Message:
Error Message Can't open file: 'tiki_articles.MYI' (errno: 145)
He/she would thank them a lot that they helped me to solve it it is a very serious problem.
I have tried to make a Dump of the MySQL and he/she gives me an error in the process of creation of the backup, also flaw in the process of the articles.
Can they tell me as solving it?
Volcar la base de datos para la tabla `tiki_article_types`
--
INSERT INTO `tiki_article_types` VALUES ('Article', 'n', 'n', 'y', 'n', 'y', 'y', 'n', 'y', 'y', 'n', 'y', 'y', 'n', 'n', 'n', 'n', 'n', 'n', 'n');
INSERT INTO `tiki_article_types` VALUES ('Review', 'y', 'n', 'y', 'n', 'y', 'y', 'n', 'y', 'y', 'n', 'y', 'y', 'n', 'n', 'n', 'n', 'n', 'n', 'n');
INSERT INTO `tiki_article_types` VALUES ('Event', 'n', 'n', 'n', 'n', 'y', 'y', 'n', 'y', 'y', 'n', 'y', 'y', 'n', 'n', 'n', 'n', 'n', 'n', 'n');
INSERT INTO `tiki_article_types` VALUES ('Classified', 'n', 'n', 'n', 'y', 'n', 'y', 'n', 'y', 'y', 'n', 'y', 'y', 'n', 'n', 'n', 'n', 'n', 'n', 'n');
INSERT INTO `tiki_article_types` VALUES ('NotÃcies generals', 'n', 'n', 'n', 'n', 'n', 'y', 'n', 'n', 'y', 'n', 'y', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n');
INSERT INTO `tiki_article_types` VALUES ('NotÃcies internes', 'n', 'n', 'n', 'n', 'n', 'y', 'n', 'y', 'y', 'n', 'y', 'n', 'n', 'n', 'n', 'n', 'n', 'n', 'n');
<!-- PMA-SQL-ERROR --> <table border="0" cellpadding="2" cellspacing="1"> <tr> <th class="tblHeadError"><div class="errorhead">Error</div></th> </tr> <tr> <td><div class="tblWarn"><p> <b>consulta SQL:</b> <a href="tbl_properties.php?lang=es-utf-8&server=1&collation_connection=utf8_general_ci&db=iesmariarubies&table=tiki_articles&sql_query=SHOW+CREATE+TABLE+%60iesmariarubies%60.%60tiki_articles%60&show_query=1"><img src=" ./themes/original/img/b_edit.png" width="16" height="16" border="0" hspace="2" align="middle" alt="Editar" /></a></p> <p> <span class="syntax"><span class="syntax_alpha syntax_alpha_reservedWord">SHOW</span> <span class="syntax_alpha syntax_alpha_reservedWord">CREATE</span> <span class="syntax_alpha syntax_alpha_reservedWord">TABLE</span> <span class="syntax_quote syntax_quote_backtick">`iesmariarubies`</span><span class="syntax_punct syntax_punct_qualifier">.</span><span class="syntax_quote syntax_quote_backtick">`tiki_articles`</span> </span> </p></div> <div class="tblWarn"><p> <b>MySQL ha dicho: </b><a href="http://dev.mysql.com/doc/mysql/en/Error-returns.html" target="mysql_doc"><img src="./themes/original/img/b_help.png" width="11" height="11" border="0" alt="Documentación" title="Documentación" hspace="2" align="middle" /></a> </p> <code>
- 1016 - Can't open file: 'tiki_articles.MYI' (errno: 145)
<!--
function reload_querywindow () {
if (parent.frames.queryframe && parent.frames.queryframe.querywindow && !parent.frames.queryframe.querywindow.closed && parent.frames.queryframe.querywindow.location) {
// no submit, query was invalid
}
}
function focus_querywindow(sql_query) {
if (parent.frames.queryframe && parent.frames.queryframe.querywindow && !parent.frames.queryframe.querywindow.closed && parent.frames.queryframe.querywindow.location) {
if (parent.frames.queryframe.querywindow.document.querywindow.querydisplay_tab != 'sql') {
parent.frames.queryframe.querywindow.document.querywindow.querydisplay_tab.value = "sql";
parent.frames.queryframe.querywindow.document.querywindow.query_history_latest.value = sql_query;
parent.frames.queryframe.querywindow.document.querywindow.submit();
parent.frames.queryframe.querywindow.focus();
} else {
parent.frames.queryframe.querywindow.focus();
}
return false;
} else if (parent.frames.queryframe) {
new_win_url = 'querywindow.php?sql_query=' + sql_query + '&lang=es-utf-8&server=1&collation_connection=utf8_general_ci&db=iesmariarubies&table=tiki_articles';
parent.frames.queryframe.querywindow=window.open(new_win_url, '','toolbar=0,location=0,directories=0,status=1,menubar=0,scrollbars=yes,resizable=yes,width=600,height=400');
if (!parent.frames.queryframe.querywindow.opener) {
parent.frames.queryframe.querywindow.opener = parent.frames.queryframe;
}
// reload_querywindow();
return false;
}
}
reload_querywindow();
//-->
</body>
</html>