Browser installation of joomla gives session table error.

Asked By faizi 10 points N/A Posted on - 09/27/2011

While installing Joomla through "browser installation"  method, I get this error:

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

 

my database name is "studenttest" and i have kept $db_prefix=jos_

Kindly help me out with this.

• Status: Open
• Question Views: 2467
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: PHP

Best Answer by Armand Well

Go To Solution

Best Answer

Best Answer

Answered By Armand Well 0 points N/A #82639

Browser installation of joomla gives session table error.

After I see the error, the problem of installation of your Joomla is pointing to the prefix of your database. in your error StoreFailed, your table said that you have prefix "studenttest.jos_" see this line:

Table 'studenttest.jos_session' doesn't exist SQL=INSERT INTO `jos_session`

Maybe you mistype at the dbprefix question on installation. The best way to fix this, open your Joomla web folder in htdocs, then open configuration.php with your text editor. Find this line:

var $dbprefix = 'jos_'

Change it to
var $dbprefix = 'studenttest.jos_'

Then refresh your browser with you local web address to see is the error still there.

About Armand Well

Questions
0

Answers
3

Best Answers
1

• Vote Up 0 Vote Down

• Posted on - 09/30/2011
• Question Category: PHP

Answered By Carl Jack 10 points N/A #82641

Browser installation of joomla gives session table error.

Hello Faizi,

To resolve the issue that you are getting, you will need to observe the following:

• First, ensure that you are using the correct MySQL username as well as database in your configuration.php file.
• You can as well utilize the MySQL Databases tool in your cPanel if you want to check the correct username and database that you are using for your Joomla.
• To add on that, you will need to ensure that your MySQL username is added to your database. If you need more information concerning that matter, you can check out the following tutorial: How to create a MySQL database and user.
• The issue that you are having could also be caused by errors within the database itself. If that is the case, you will need to try restoring your Joomla database.

Hope this helps.

Regards,

Carl

About Carl Jack

Questions
1

Answers
1657

Best Answers
417

• Vote Up 0 Vote Down

• Posted on - 09/13/2012
• Question Category: PHP