Please Help DB function failed with error number 1146

Discussion regarding Joomla! 1.5 Performance issues.

Moderator: General Support Moderators

Forum rules
Forum Rules
Absolute Beginner's Guide to Joomla! <-- please read before posting, this means YOU.
Security and Performance FAQs
Forum Post Assistant - If you are serious about wanting help, you will use this tool to help you post.
Locked
madstarr
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Wed Mar 25, 2009 10:21 pm

Please Help DB function failed with error number 1146

Post by madstarr » Thu Jan 07, 2010 6:15 am

Please help me. I am getting this error when going to my joomla website http://www.hasapool.com/whyhasa
Joomla 1.5.9

jtablesession::Store Failed
DB function failed with error number 1146
Table '7_018600b_2.session' doesn't exist SQL=INSERT INTO `session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( '0fb518e6a35375e020205fa42c2e72d6','1262844516','','0','1','0' )

It was working fine until: I am hosting with Network Solutions and they have a joomla control panel that says Make this my joomla my home page. I clicked on this to make it happen (as I have done successfully with other joomla sites) and then I immediately started getting this error.

Please help, if you can.

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

Re: Please Help DB function failed with error number 1146

Post by pe7er » Thu Jan 07, 2010 9:44 am

This topic has been answered many times before.
Did you search this forum on keyword "1146" or "error 1146"?

Could you check the configuration.php?
What is your "var $dbprefix"?
Is it:

Code: Select all

var $dbprefix = 'jos_';
Kind Regards,
Peter Martin, Global Moderator
https://db8.nl - Joomla specialist, Nijmegen, Nederland
The best website: https://the-best-website.com

madstarr
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Wed Mar 25, 2009 10:21 pm

Re: Please Help DB function failed with error number 1146

Post by madstarr » Thu Jan 07, 2010 4:01 pm

pe7er wrote:This topic has been answered many times before.
Did you search this forum on keyword "1146" or "error 1146"?

Could you check the configuration.php?
What is your "var $dbprefix"?
Is it:

Code: Select all

var $dbprefix = 'jos_';
Yes that is what it says, is this correct? i have compared a configuration.php from before this error started to what is currently on the server and they are the same. I would appreciate any help I can get this site contains a lot of data and it is for a big customer of mine.

Thank you.

madstarr
Joomla! Apprentice
Joomla! Apprentice
Posts: 5
Joined: Wed Mar 25, 2009 10:21 pm

Re: Please Help DB function failed with error number 1146

Post by madstarr » Thu Jan 07, 2010 4:48 pm

pe7er

Thank you for your assistance. After a fresh look today, I found what you were talking about and indeed the the dbprefix was not set properly.

This shed a whole new light on my understanding of joomla and php and mysql.
:)

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

Re: Please Help DB function failed with error number 1146

Post by pe7er » Thu Jan 07, 2010 6:53 pm

Great! Thanks for the follow-up!
Kind Regards,
Peter Martin, Global Moderator
https://db8.nl - Joomla specialist, Nijmegen, Nederland
The best website: https://the-best-website.com


Locked

Return to “Performance - Joomla! 1.5”