I can't login my admin, member can't login. Please help me

[joymax27104000]

Hello all,

I got big error, I can't login my admin, member can't login. Please help me

How can i fix it? Thanks for helping

 

[joymax27104000]

Re: I can't login my admin, member can't login. Please help

Updated:
I check my phpmyadmin,

"#145 - Table './we_home/sessions' is marked as crashed and should be repaired"

I were repair it, and my site it working now. but Why Did This Happen to Me?

Thanks for helping

 

[ysmods]

Re: I can't login my admin, member can't login. Please help

Database tables sometimes crash, it happens, all you can do is repair them and move on.

 

[ollie]

Re: I can't login my admin, member can't login. Please help

This happens if the database was not shut down properly. It can also happen if you don't have enough resources for mysql on the server.

 

[pullvideos]

Re: I can't login my admin, member can't login. Please help

I get same problem! empty session table but still can't login!Thanks

 

[coffee]

Re: I can't login my admin, member can't login. Please help

Empty command to the table does not repair it. Do a repair

When sessions is working, it will look like this:

 

[pullvideos]

Re: I can't login my admin, member can't login. Please help

Thanks for support!problem solved but it is not problem of database, it is my personal problems of my site!

 

[bdepadey4815]

Re: I can't login my admin, member can't login. Please help

Is there any other solution to this? I did a phpmyadmin repair database but still the problem exists. I also ran the check session script and it said sessions are being stored ok.

 

[denniskessler4933]

same problem to me.
cant login anymore
seession repaired and deleted, still cant login.
Please help asap
thanks

 

[cybernetwebdesign5415]

Same with my problem!!!

 

[enricodias4654]

Re: I can't login my admin, member can't login. Please help

Database tables sometimes crash, it happens, all you can do is repair them and move on.

Databases shout NOT crash like this. I recommend changing the engine to innodb on tables that receive many write requests. Leave myisam just on tables that are mostly static.

 

[paypal1352]

i recommend you backup your database, clear all tables and import the stock database and see if that works, if it does you can just import your content

 

[admin5333]

i have the same extact problem, the DB has crashed
[ERROR] mysqld: Table './xxx/sessions' is marked as crashed and last (automatic?) repair failed
[ERROR] mysqld: Table './xxx/file' is marked as crashed and last (automatic?) repair failed

how can i fix this???

 

[enricodias4654]

i have the same extact problem, the DB has crashed
[ERROR] mysqld: Table './xxx/sessions' is marked as crashed and last (automatic?) repair failed
[ERROR] mysqld: Table './xxx/file' is marked as crashed and last (automatic?) repair failed

how can i fix this???

If you can't repair the table you lost the data. The data in the session table is not important and you can just truncate it. The file table holds data about the uploaded files. I hope you have a backup.

 

[admin5333]

how can i repair them?, i have no DB back up...the /var/lib/mysql/yetidata/sessions.MYD has increased its size to 15GB....i guess this is causing the crash

 

[admin5333]

here is what mysqlcheck is telling me:
yetidata.background_task OK
yetidata.background_task_log OK
yetidata.banned_files OK
yetidata.banned_ips OK
yetidata.country_info OK
yetidata.cross_site_action OK
yetidata.download_page OK
yetidata.download_token OK
yetidata.download_tracker OK
yetidata.file
warning : Table is marked as crashed and last repair failed
warning : 1 client is using or hasn't closed the table properly
warning : Size of indexfile is: 5120000 Should be: 411648
error : Found 939 keys of 938
error : Corrupt
yetidata.file_action OK
yetidata.file_folder OK
yetidata.file_report OK
yetidata.file_server OK
yetidata.file_server_status OK
yetidata.file_status OK
yetidata.internal_notification OK
yetidata.language OK
yetidata.language_content OK
yetidata.language_key OK
yetidata.login_failure OK
yetidata.login_success OK
yetidata.payment_log OK
yetidata.plugin OK
yetidata.plugin_imageviewer_category OK
yetidata.plugin_imageviewer_category_file OK
yetidata.plugin_imageviewer_embed_token OK
yetidata.plugin_imageviewer_image_like OK
yetidata.plugin_imageviewer_meta OK
yetidata.plugin_imageviewer_watermark OK
yetidata.plugin_mediaconverter_queue OK
yetidata.plugin_mediaconverter_watermark OK
yetidata.plugin_reward OK
yetidata.plugin_reward_affiliate_id OK
yetidata.plugin_reward_aggregated OK
yetidata.plugin_reward_country_list OK
yetidata.plugin_reward_outpayment_method OK
yetidata.plugin_reward_ppd_complete_download OK
yetidata.plugin_reward_ppd_detail OK
yetidata.plugin_reward_ppd_group OK
yetidata.plugin_reward_ppd_group_country OK
yetidata.plugin_reward_ppd_group_rate OK
yetidata.plugin_reward_ppd_range OK
yetidata.plugin_reward_withdraw_request OK
yetidata.premium_order OK
yetidata.remote_url_download_queue OK
yetidata.sessions
warning : Table is marked as crashed and last repair failed
warning : 1 client is using or hasn't closed the table properly
warning : Size of indexfile is: 109745152 Should be: 10240
error : Found 101 keys of 100
error : Corrupt
yetidata.site_config OK
yetidata.stats
warning : Table is marked as crashed and last repair failed
warning : 1 client is using or hasn't closed the table properly
warning : Size of indexfile is: 29355008 Should be: 57344
error : Size of datafile is: 175603712 Should be: 175603924
error : Corrupt
yetidata.theme OK
yetidata.user_level
warning : Found row where the auto_increment column has the value 0
status : OK
yetidata.user_level_pricing OK
yetidata.users OK

 

[enricodias4654]

how can i repair them?, i have no DB back up...the /var/lib/mysql/yetidata/sessions.MYD has increased its size to 15GB....i guess this is causing the crash

Size doesn't crash tables. If you can't repair the table you have lost it's contents. I can't believe you don't have a backup of your database, backup is a must!

This is the sql syntax to repair tables: REPAIR TABLE tablename.

 

[admin5333]

I have managed to have stats and file repaired, the problem is with sessions which has grown to a massive 15GB and it is leaving the server with no space and can not fix it