Viewing 13 posts - 1 through 13 (of 13 total)
  • Author
    Posts
  • ogank73 Friend
    #199087

    Hi there,

    I need your help again. My site is crash. It is show error message

    <blockquote>Table ‘./k7051503_do2lanku/xr9fw_session’ is marked as crashed and last (automatic?) repair failed SQL=INSERT INTO `xr9fw_session` (`session_id`, `client_id`, `time`) VALUES (‘0d661fe9d58bb1e3ec0dd87dfaf70fba’, 1, ‘1403536576’)</blockquote>

    Could you help me to fix this problem? and do you have explanation why my site become crash like this?
    For info: my site is till standard JA-Tiris.

    Regards

    ogank73 Friend
    #539905

    Sorry, I try to fix by myself but more worst.
    What I have done is
    1. Import table from local but I set drop table (:((>:() then I lost the table in dodolanku.com

    2. The message error now becomes
    Table ‘k7051503_do2lanku.xr9fw_session’ doesn’t exist SQL=INSERT INTO `xr9fw_session` (`session_id`, `client_id`, `time`) VALUES (‘0d661fe9d58bb1e3ec0dd87dfaf70fba’, 1, ‘1403542060’)

    3. Each time I import table or copy table I got error
    #3 – Error writing file ‘./k7051503_do2lanku/xr9fw_session.frm’ (Errcode: 122)

    So what should I do now?

    Regards

    pavit Moderator
    #539908

    Hi

    <blockquote>For info: my site is till standard JA-Tiris.</blockquote>

    You installed Ja Tiris quickstart ?

    ogank73 Friend
    #539912

    Yes, before this problem happen I got captcha problem but it was solved.
    I got help from Alexmirnov and since then I was update anything.
    After view days, I wanted to check my site and I got this problem.

    regards

    pavit Moderator
    #539919

    Did you have a website backup to reinstall again ?
    If you have an akeeba backup you can reinstall it on a new db

    Ninja Lead Moderator
    #539985

    <em>@ogank73 433536 wrote:</em><blockquote>Hi there,

    I need your help again. My site is crash. It is show error message

    Could you help me to fix this problem? and do you have explanation why my site become crash like this?
    For info: my site is till standard JA-Tiris.
    </blockquote>

    Please access phpMyAdmin, select the database, click the checkbox on that table (xr9fw_session). Scroll down to the bottom of the page, and in the select box select “Repair”.

    ogank73 Friend
    #540039

    Ninja Lead, thanks for your response. But somehow I deleted that table (xr9fw_session).
    Right now, I’m trying to create new table with same name but still no luck.

    I got error message
    #3 – Error writing file ‘./k7051503_do2lanku/xr9fw_session.frm’ (Errcode: 122)

    is it related with folder permission? if yes, which folder permission that I need to change?

    thanks

    ogank73 Friend
    #540044

    Ok, I think the problem solved. I just rename other table with the same structure then the website can running smooth.

    But I’m still wondering, Why is this happen? what is the function of session table?
    and how to avoid this problem? Should I backup my database everyday or twice a day?

    Regards

    Ninja Lead Moderator
    #540121

    I’m not sure why you got this bug. I think it might relate to the problem database (crash) in core Joomla.

    You should raise this bug to JOOMLA forum: http://forum.joomla.org/, you will get better answer from there.

    ogank73 Friend
    #540303

    Hi Ninja,

    Unfortunately, I can’t go to their forum since my IP address suspected as spammer :((
    OK, so what is your suggestion about database backup. daily backup or twice a day?

    regards

    Ninja Lead Moderator
    #540611

    You can give it a try with addon anonymoX from chrome or firefox browser to change your IP to go Joomla forum.

    Regarding your site backup, it depends on data input and output on your site. It can be daily backup or twice a day. Akeeba tool will help you to do that and you can set automated backup tool, visit this article for reference here

    ogank73 Friend
    #540692

    Hi Ninja Lead..

    Thanks for your info…
    I found the real problem now. The real problem was came from my hosting server and related with the storage limit.
    That’s why my table (_session) got problem (corrupt).

    Thanks for your help

    regards, Ogank73

    Ninja Lead Moderator
    #540739

    Awesome! Glad you found the way out.

Viewing 13 posts - 1 through 13 (of 13 total)

This topic contains 13 replies, has 3 voices, and was last updated by  Ninja Lead 10 years, 4 months ago.

We moved to new unified forum. Please post all new support queries in our New Forum