Site down:1.5.2. DB function failed with error number 145

[igirisjin]

Got up to find this today after working no problem - any solution?
White screen.

jtablesession::Store Failed
DB function failed with error number 145
Table './outdoor3_joomla/jos_session' is marked as crashed and should be repaired SQL=INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'b1caaf8b92a75a009434c3146cefa0ab','1207867176','','0','1','0' )


running sql command doesnt seem to work....
Andy

[pe7er]

Do you have phpMyAdmin access to your database?
There should be a table repair option on the page where you can see the structure of your database (which shows all tables on the main/right screen, and also shows the possible overhead per table)
Use it to repair the jos_session table.

(before doing so: backup the current database).

[igirisjin]

Thanks! I checked my site at breakfast as a last minute thing before leaving on a 12 hour flight...
By the time I read your email I had already tried importing back a daily emailed database backup file (joomla mod). Worked but I lost all the Japanese characters (1/2 the site) and with no other backup I then had to redo all the Japanese content manually. Do have an html copy at home when I return so not too bad except for the calendar database stuff which is trash now.

Its a bit worrisome as that mod does seem to have problems with utf-8.
Now I know I can at least try a repair from myphp admin - next time!

Thanks,
Andy

[hassanprime]

I have the same error, I am looking for the responsible of this error. what is the file that displays that?

Why I am looking for this file, because I want to display a personalized message when I have this error 145.

Thank you.

[erickaps]

I just experienced this error myself with Joomla v1.5.3. and resolved it very simply.

Using phpMyAdmin - 2.10.0.1 in my host's Control Panel, I found no 'table repair' option as advised by pe7er so I simply clicked on jos_session in the table list on the left and then clicked on the 'Empty' tab at the top above the table's list of fields.

I then tried the website again and voila!, problem resolved.

b.t.w - no idea why this happended.

[Fjody]

To: Erickaps

I really works! Thanks a lot.

[xdoktor]

chEERS erickaps...your solution did it for me too!
mine happen mid save....PC crashed!

cheers
dok

Joomla 1.5.7
VM 1.1.2

[marcgpx]

Anybody know why this error happen?
Thanks

[paily]

I too had the same problem. Mine is simplescript/fanatstico installation of joomla 1.5.7
The solution I used was to click at mysql databases icon on c-panel and not php MyAdmin. This took me to MySQL Databases page where I had the option to modify databases in which there was an option to repair database. Here I chose my joomla data base and clicked repair and the problem was solved. Hope it helps the newbies and the c-panel users.

[TechGirl]

I am getting a similar error:
jtablesession::Store Failed
DB function failed with error number 145
Table './eilmccco_cmsicdc/jos_session' is marked as crashed and should be repaired SQL=INSERT INTO jos_session ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'ca7331cb8a008d79e24df425257229ea','1227636484','','0','1','0' )

Repairing the table worked; however, it happened again. Like others, I would like to know the cause and how to prevent it. Although, I can repair it; it is not comforting that the sites can go down at anytime.

Thanks much.

Josepha

[marcgpx]

Hi
I suspect that this happen when server is dirty rebooted?

Repairing is not a long term solution!

Thanks, Marko

[jchris]

This happened to me, on Joomla 1.5.8
The solution worked for me as well.
I would love to know what I can do to prevent this from happening.

[ChokDK]

I also had the error using version 1.0.13, and the solution worked as well for me. I am really greatful - thank you..
Please write here whenever someone finds a more long term solution..

[ghogilee]

Well, this is the session problem. I think that Joomla have unnecessary indexes on jos_session table. This table is very often overhead, and thus giving you a problem.
Possible causes:

1. Flooding. (Check your http access logs for access IP's, and your PHP error logs). Solution: Try dropping the time out down temporally to a lower value, to see if the sessions clear or not.

2. SEF . If your site has a lot of visitors table jos_session can accumulate substantial overhead. And if you use default SEF, some 404 pages can make some bots to enter into loop, and those bots gives you a huge session overhead.

Solutions:

If you want to make your Joomla site runs faster, then you might think about these following options:

1. Don't use site statistics from within Joomla. (Enabling statistics through your site configuration just adds extra MySQL queries and increases server loads. If you need stats, see if your host will provide them for you (Awstats, Webalizer, etc) or use Google statistics.

2. Don't use SEF URL's unless you really need to. (Search engines don't care if your URL's are the standard Joomla URL's or SEF URL's)

3. If you don't need to use an editor, remove it. (Many people use external editors and cut n paste their content. If you are using Joomla in this way, remove the editor and set your configuration to NO WYSIWYG Editor - this improves the performance and speed of the administrator backend.)

4. Do try using gzip and caching (if your server allows gzip compression, and most do) you can turn these on through your administrator configuration options.

5. Use phpMyAdmin or other MySQL management tool to periodically optimize your MySql database tables. When records are deleted, MySql does not reclaim unused space until the tables are optimized.

And thats it

[TechGirl]

Thanks for the response.

In my own investigation:

1. My host "BlueHost" seems to be doing unscheduled maintenance which is not good because it happens at any time without warning.

2. I am remembering that the sites in question have been up for at least a few months without this problem. I had not been working in them as much until recently; however, they did stay up.

I recall turning "indexing" on within the last two to three weeks; however. I cannot remember where I turned it on. Could this have something to do with it? Something has to have changed if they existed successfully until a couple of weeks ago -- right?

What do you think about that (indexing) and where would I turn it off. Is it somewhere within the phpsqladmin or is it in the Joomla 1.5.7 configuration? I am not that well-versed in MySQL, but am comfortable in the Joomla back-end and directly editing files with instruction.

Thanks again, Josepha

[afresh01]

We tried it and it worked to. Excellent

Thanks

[jchris]

FYI...here are instructions from my host that worked for me:
Login to your cPanel
Click on the "phpmyadmin" under the databases category Click on 1 of your
databases on the left hand side Scroll to the bottom of that page and click the "check all" button to highlight all tables Select "repair tables" from the drop down list on the right After that finishes return to the previous page and click the "check all" button again This time select "optimize tables" from the dropdown list to the right.
Repeat this process for all databases in your account.

[Taragon]

I got the same error..

I even get it when i try to log in to my CP so i cant install PHPMyAdmin on the site.
All my other sites works fine.

Any tips on how to get it to work again?

plx help

[jchris]

Just to clarify for Taragon, you want to log in to the control panel of your HOST. For there you should be able to access the PHPMyAdmin or your databases directly.

[Taragon]

Yeah that didnt work but i fixed the problem.

Just used HeidiSQL to connect to the joomla server and then repare.

[daytonyouth]

I know its been a little while but I am now having the same problem. I went into my phpmyadmin and emptied the table and still no luck. Is there something I'm missing? I'm not SQL expert

Any ideas?

[daytonyouth]

Fixed Now!

[Kathe]

I just had the same problem and the solution Erickaps posted worked for me.

[sithburns]

I had the same problem on three sites with one hosting company. They claimed not to know why it happened.

Said i possibly had a corrupt file uploaded?

Anyone have a good reason why this happens?

[Jhazzi]

Repair database worked for me. Thanks to EVERYONE for your input!

[peetree21]

I simply clicked on jos_session in the table list on the left and then clicked on the 'Empty' tab at the top above the table's list of fields.

i just had this happen to me as well.

still not sure why this has happened?

i use J1.5.9 and have default joomla sef turned on.

(i will be upgrading to J1.5.11 soon i know )

[kaushalsharma]

Hi All,

i must say, it helped me by just clicking on 'empty' tab on jos_session table.


-Thanks a lot.

[AngelinaC]

Dear erickaps,

Another grateful person for the solution you posted for error 145.


THANKS!!!

[xiangdian]

I met the same problem with 1.5.12 on my site this morning. it was fixed with erickaps' solution! Thanks!

According to ghogilee's information, I found that this problem happened after I enabled the ‘statistics’ module a few days ago. Not sure if this is a cause... so I disabled it. FYI

Many thanks to pe7er, erickaps, ghogilee and all!

Cheers!
Xiangdian

[liveandlearn]

I too had the same problem. Mine is simplescript/fanatstico installation of joomla 1.5.7
The solution I used was to click at mysql databases icon on c-panel and not php MyAdmin. This took me to MySQL Databases page where I had the option to modify databases in which there was an option to repair database. Here I chose my joomla data base and clicked repair and the problem was solved. Hope it helps the newbies and the c-panel users.

This Helped me too! Thanks so much for an easy solution.