DB function failed with error number 1146

lefcakis · Post by **lefcakis** » Tue Nov 04, 2008 4:56 pm

I have PHP 5 installed with the latest version of mysql.

I installed the latest version of Joomla as of Nov 3.

When I run the installation I get the following error.

jtablesession::Store Failed
DB function failed with error number 1146
Table 'ucsurpcnis.jos_session' doesn't exist SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'i8hct2alqq0hdal3u89prmqdm6','1225815348','','0','1','0' )

I checked and made sure the username for the database has full access to the database. does this install actually create the tables or do I need to do something first?

asankasrilal · Post by **asankasrilal** » Tue Nov 11, 2008 9:58 am

me too have the same problem..

dutchmarshalls · Post by **dutchmarshalls** » Sun Dec 21, 2008 10:31 am

Do you manage to solve this problem and if you do How did you do it, Because a lot of people have this problem and dont know how to solve it. including my self.

Neerav · Post by **Neerav** » Tue Jun 30, 2009 5:37 am

Hi,
Use case sensitive table names in code to avoid this problem.

Gapz · Post by **Gapz** » Mon Jul 13, 2009 2:51 pm

No, the tables are all case sensitive already.

In phpMyAdmin i ticked the jos_session table then clicked repair from the drop down menu and all works fine!

papwilly · Post by **papwilly** » Sun Jul 26, 2009 11:07 am

I tried to repair the table and I got the message:

The storage engine for the table doesn't support repair

What does this mean, and what can I do? The storage engine for the table is InnoDB.

andypat · Post by **andypat** » Wed Sep 30, 2009 3:38 pm

goto joomla[directory] -->configuration.php [notepad] ---> Search and Set dbprefix = 'jos_' properly which u used during installation

JhoomPK · Post by **JhoomPK** » Tue Dec 29, 2009 12:39 pm

No solution?????

JhoomPK · Post by **JhoomPK** » Thu Dec 31, 2009 2:32 pm

It was my hosting company issue.....
I changed the hosting and it works fine....

noobski · Post by **noobski** » Fri Jun 04, 2010 11:55 pm

Was there a solution!? My error reads as follows:

jtablesession::Store Failed
DB function failed with error number 1146
Table 'joomla15.jos_session' doesn't exist SQL=INSERT INTO `jos_session` ( `session_id`,`time`,`username`,`gid`,`guest`,`client_id` ) VALUES ( 'mqlhfgk3t7mafi8q3g5ql1gig1','1275695631','','0','1','0' )
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 40 bytes) in C:\xampp\xampp\htdocs\joomla15\libraries\joomla\error\exception.php on line 117

PLEASE HELP!

danmir · Post by **danmir** » Mon Jul 05, 2010 7:00 pm

hy everyone....solution to your problems is

in configuration.php change var $dbprefix like this:

var $dbprefix = 'jos_';

wooollaaaa

jags0001 · Post by **jags0001** » Sat Jul 17, 2010 9:41 am

Hi! whats in
var $dbprefix = 'jos_';

I have it also in my configure.php..

how to solve this problem?

dre1 · Post by **dre1** » Sat Aug 21, 2010 2:32 pm

Thanks Danmir,

I just changed var $dbprefix_sgj to _jos and it worked.

The Joomla! Forum™

DB function failed with error number 1146

DB function failed with error number 1146

Re: DB function failed with error number 1146

Re: DB function failed with error number 1146

Re: DB function failed with error number 1146

Re: DB function failed with error number 1146

Re: DB function failed with error number 1146

Re: DB function failed with error number 1146

Re: DB function failed with error number 1146

Re: DB function failed with error number 1146

Re: DB function failed with error number 1146

Re: DB function failed with error number 1146

Re: DB function failed with error number 1146

Re: DB function failed with error number 1146