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

Need help with the Administration of your Joomla! 1.5 site? This is the spot for you.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
igirisjin
Joomla! Apprentice
Joomla! Apprentice
Posts: 17
Joined: Wed Jan 16, 2008 2:21 pm
Location: Tokyo
Contact:

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

Post by igirisjin » Thu Apr 10, 2008 10:45 pm

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

User avatar
pe7er
Joomla! Master
Joomla! Master
Posts: 22235
Joined: Thu Aug 18, 2005 8:55 pm
Location: Nijmegen, The Netherlands
Contact:

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

Post by pe7er » Thu Apr 10, 2008 10:58 pm

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).
Kind Regards,
Peter Martin, Global Moderator
https://db8.nl - Joomla specialist, Nijmegen, Nederland
Co-developer of d2 Content https://data2site.com/joomla-extensions/d2-content

igirisjin
Joomla! Apprentice
Joomla! Apprentice
Posts: 17
Joined: Wed Jan 16, 2008 2:21 pm
Location: Tokyo
Contact:

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

Post by igirisjin » Wed Apr 16, 2008 10:36 pm

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
Joomla! Apprentice
Joomla! Apprentice
Posts: 12
Joined: Tue Jan 16, 2007 11:27 pm

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

Post by hassanprime » Tue Jun 17, 2008 6:50 am

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.

User avatar
erickaps
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 101
Joined: Thu Aug 17, 2006 9:27 am
Location: United Kingdom
Contact:

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

Post by erickaps » Tue Jul 15, 2008 4:04 pm

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
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Mon Aug 25, 2008 4:45 pm

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

Post by Fjody » Mon Aug 25, 2008 6:25 pm

To: Erickaps

I really works! Thanks a lot.

xdoktor
Joomla! Apprentice
Joomla! Apprentice
Posts: 13
Joined: Wed Apr 16, 2008 3:13 am

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

Post by xdoktor » Sat Oct 04, 2008 4:03 am

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
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Tue Nov 18, 2008 5:47 pm

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

Post by marcgpx » Tue Nov 18, 2008 5:48 pm

Anybody know why this error happen?
Thanks

paily
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Sun Aug 27, 2006 6:27 am

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

Post by paily » Mon Nov 24, 2008 2:51 am

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
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Sun Nov 30, 2008 9:09 pm

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

Post by TechGirl » Sun Nov 30, 2008 9:25 pm

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
Joomla! Apprentice
Joomla! Apprentice
Posts: 6
Joined: Tue Nov 18, 2008 5:47 pm

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

Post by marcgpx » Sun Nov 30, 2008 9:37 pm

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

Repairing is not a long term solution!

Thanks, Marko

User avatar
jchris
Joomla! Intern
Joomla! Intern
Posts: 57
Joined: Fri Feb 23, 2007 5:56 am
Location: Illinois

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

Post by jchris » Mon Dec 01, 2008 4:04 pm

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.

User avatar
ChokDK
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 194
Joined: Sat Aug 20, 2005 3:31 am
Location: Et sted i NordWestjylland

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

Post by ChokDK » Thu Dec 04, 2008 7:37 am

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.. :)
Der er altid 3 ting jeg aldrig kan huske. Det 1.ste er...... ? :)

User avatar
ghogilee
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Thu Dec 04, 2008 8:33 am
Location: Novi Sad, Serbia
Contact:

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

Post by ghogilee » Thu Dec 04, 2008 8:52 am

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
Joomla! Fledgling
Joomla! Fledgling
Posts: 3
Joined: Sun Nov 30, 2008 9:09 pm

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

Post by TechGirl » Thu Dec 04, 2008 3:09 pm

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
Joomla! Fledgling
Joomla! Fledgling
Posts: 1
Joined: Mon Dec 08, 2008 7:10 pm

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

Post by afresh01 » Mon Dec 08, 2008 7:13 pm

We tried it and it worked to. Excellent

Thanks

User avatar
jchris
Joomla! Intern
Joomla! Intern
Posts: 57
Joined: Fri Feb 23, 2007 5:56 am
Location: Illinois

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

Post by jchris » Wed Dec 10, 2008 4:44 pm

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
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Thu Feb 12, 2009 3:11 pm

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

Post by Taragon » Thu Feb 12, 2009 3:15 pm

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

User avatar
jchris
Joomla! Intern
Joomla! Intern
Posts: 57
Joined: Fri Feb 23, 2007 5:56 am
Location: Illinois

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

Post by jchris » Thu Feb 12, 2009 4:56 pm

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
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Thu Feb 12, 2009 3:11 pm

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

Post by Taragon » Thu Feb 12, 2009 9:25 pm

Yeah that didnt work but i fixed the problem.

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

daytonyouth
Joomla! Intern
Joomla! Intern
Posts: 58
Joined: Mon Oct 06, 2008 6:35 pm

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

Post by daytonyouth » Mon Mar 23, 2009 1:41 pm

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
Joomla! Intern
Joomla! Intern
Posts: 58
Joined: Mon Oct 06, 2008 6:35 pm

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

Post by daytonyouth » Mon Mar 23, 2009 1:50 pm

Fixed Now!

Kathe
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 157
Joined: Fri Jun 22, 2007 6:37 pm

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

Post by Kathe » Sat Mar 28, 2009 1:14 pm

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

User avatar
sithburns
Joomla! Apprentice
Joomla! Apprentice
Posts: 26
Joined: Tue Feb 10, 2009 1:51 pm
Location: Florida, USA
Contact:

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

Post by sithburns » Mon Apr 13, 2009 3:13 pm

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?
http://www.burnseo.com - Website Design/SEO
http://burn-seo.duoservers.com/ - Cheap Joomla Hosting

Jhazzi
Joomla! Intern
Joomla! Intern
Posts: 67
Joined: Fri Dec 14, 2007 7:40 am
Location: USA

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

Post by Jhazzi » Thu Jun 04, 2009 5:14 pm

Repair database worked for me. Thanks to EVERYONE for your input!
Hug life with love.

peetree21
Joomla! Enthusiast
Joomla! Enthusiast
Posts: 115
Joined: Sat Nov 26, 2005 1:16 am

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

Post by peetree21 » Sun Jun 14, 2009 3:33 am

erickaps wrote: 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
Joomla! Intern
Joomla! Intern
Posts: 75
Joined: Mon Jul 27, 2009 7:53 am
Location: India

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

Post by kaushalsharma » Fri Aug 07, 2009 10:52 am

Hi All,

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


-Thanks a lot.

User avatar
AngelinaC
Joomla! Intern
Joomla! Intern
Posts: 72
Joined: Thu Apr 24, 2008 2:04 am
Location: USA

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

Post by AngelinaC » Mon Sep 21, 2009 1:25 pm

Dear erickaps,

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


THANKS!!! :D

User avatar
xiangdian
Joomla! Apprentice
Joomla! Apprentice
Posts: 8
Joined: Thu Sep 10, 2009 12:50 am
Location: Beijing, China
Contact:

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

Post by xiangdian » Sun Oct 04, 2009 6:07 am

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
Joomla! Fledgling
Joomla! Fledgling
Posts: 2
Joined: Thu Oct 01, 2009 7:41 am

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

Post by liveandlearn » Tue Oct 13, 2009 10:25 pm

paily wrote: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.


Locked

Return to “Administration 1.5”