Re: tikiwiki failed
I do not understand like can fail as much this, already is the third time that happens the same, until now had recovered a previous Backup but he is not very unstable?
Thanks!
> 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');
>
>
>
> Error
>
>
>
> consulta SQL:
>
>
> SHOW CREATE TABLE `iesmariarubies`.`tiki_articles`
>
>
> MySQL ha dicho:
>
>
> #1016 - Can't open file: 'tiki_articles.MYI' (errno: 145)
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>