-
AuthorPosts
-
ogank73 Friend
ogank73
- Join date:
- May 2014
- Posts:
- 48
- Downloads:
- 0
- Uploads:
- 10
- Thanks:
- 7
- Thanked:
- 2 times in 1 posts
June 23, 2014 at 3:27 pm #199087Hi 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 Friendogank73
- Join date:
- May 2014
- Posts:
- 48
- Downloads:
- 0
- Uploads:
- 10
- Thanks:
- 7
- Thanked:
- 2 times in 1 posts
June 23, 2014 at 5:11 pm #539905Sorry, 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.com2. 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 Moderatorpavit
- Join date:
- September 2007
- Posts:
- 15749
- Downloads:
- 199
- Uploads:
- 2274
- Thanks:
- 417
- Thanked:
- 4028 times in 3778 posts
June 23, 2014 at 5:20 pm #539908Hi
<blockquote>For info: my site is till standard JA-Tiris.</blockquote>
You installed Ja Tiris quickstart ?
ogank73 Friendogank73
- Join date:
- May 2014
- Posts:
- 48
- Downloads:
- 0
- Uploads:
- 10
- Thanks:
- 7
- Thanked:
- 2 times in 1 posts
June 23, 2014 at 5:34 pm #539912Yes, 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 Moderatorpavit
- Join date:
- September 2007
- Posts:
- 15749
- Downloads:
- 199
- Uploads:
- 2274
- Thanks:
- 417
- Thanked:
- 4028 times in 3778 posts
June 23, 2014 at 5:57 pm #539919Did you have a website backup to reinstall again ?
If you have an akeeba backup you can reinstall it on a new dbNinja Lead ModeratorNinja Lead
- Join date:
- November 2014
- Posts:
- 16064
- Downloads:
- 310
- Uploads:
- 2864
- Thanks:
- 341
- Thanked:
- 3854 times in 3563 posts
June 24, 2014 at 7:43 am #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 Friendogank73
- Join date:
- May 2014
- Posts:
- 48
- Downloads:
- 0
- Uploads:
- 10
- Thanks:
- 7
- Thanked:
- 2 times in 1 posts
June 24, 2014 at 3:44 pm #540039Ninja 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 Friendogank73
- Join date:
- May 2014
- Posts:
- 48
- Downloads:
- 0
- Uploads:
- 10
- Thanks:
- 7
- Thanked:
- 2 times in 1 posts
June 24, 2014 at 4:40 pm #540044Ok, 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
1 user says Thank You to ogank73 for this useful post
Ninja Lead ModeratorNinja Lead
- Join date:
- November 2014
- Posts:
- 16064
- Downloads:
- 310
- Uploads:
- 2864
- Thanks:
- 341
- Thanked:
- 3854 times in 3563 posts
June 25, 2014 at 7:36 am #540121I’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 Friendogank73
- Join date:
- May 2014
- Posts:
- 48
- Downloads:
- 0
- Uploads:
- 10
- Thanks:
- 7
- Thanked:
- 2 times in 1 posts
June 26, 2014 at 5:04 pm #540303Hi 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 ModeratorNinja Lead
- Join date:
- November 2014
- Posts:
- 16064
- Downloads:
- 310
- Uploads:
- 2864
- Thanks:
- 341
- Thanked:
- 3854 times in 3563 posts
June 30, 2014 at 10:18 am #540611You 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 Friendogank73
- Join date:
- May 2014
- Posts:
- 48
- Downloads:
- 0
- Uploads:
- 10
- Thanks:
- 7
- Thanked:
- 2 times in 1 posts
June 30, 2014 at 5:09 pm #540692Hi 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
1 user says Thank You to ogank73 for this useful post
Ninja Lead ModeratorNinja Lead
- Join date:
- November 2014
- Posts:
- 16064
- Downloads:
- 310
- Uploads:
- 2864
- Thanks:
- 341
- Thanked:
- 3854 times in 3563 posts
July 1, 2014 at 4:34 am #540739Awesome! Glad you found the way out.
-
AuthorPosts
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