The Joomla! Forum ™



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.



Post new topic Reply to topic  [ 13 posts ] 
Author Message
PostPosted: Tue Nov 04, 2008 4:56 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat Oct 18, 2008 3:19 am
Posts: 6
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?


Top
 Profile  
 
PostPosted: Tue Nov 11, 2008 9:58 am 
Joomla! Fledgling
Joomla! Fledgling

Joined: Tue Nov 11, 2008 9:49 am
Posts: 4
me too have the same problem..


Top
 Profile  
 
PostPosted: Sun Dec 21, 2008 10:31 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Tue Dec 04, 2007 4:51 pm
Posts: 20
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.


Top
 Profile  
 
PostPosted: Tue Jun 30, 2009 5:37 am 
User avatar
Joomla! Intern
Joomla! Intern

Joined: Fri Jun 26, 2009 7:42 am
Posts: 94
Location: Ahmedabad->Gujarat->India
Hi,
Use case sensitive table names in code to avoid this problem.

_________________
Neerav Dobaria
Freelance PHP/MySQL Developer
http://www.techna2.com/blog


Top
 Profile  
 
PostPosted: Mon Jul 13, 2009 2:51 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Mon Jul 13, 2009 12:23 pm
Posts: 1
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!


Top
 Profile  
 
PostPosted: Sun Jul 26, 2009 11:07 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Wed Jun 17, 2009 6:27 pm
Posts: 5
Location: Kumasi, Ghana
I tried to repair the table and I got the message:

Quote:
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.

_________________
“Opportunities multiply as they are seized.” - Sun Tzu


Top
 Profile  
 
PostPosted: Wed Sep 30, 2009 3:38 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Thu Sep 17, 2009 10:41 am
Posts: 3
goto joomla[directory] -->configuration.php [notepad] ---> Search and Set dbprefix = 'jos_' properly which u used during installation


Top
 Profile  
 
PostPosted: Tue Dec 29, 2009 12:39 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Tue Dec 08, 2009 6:44 pm
Posts: 11
No solution?????


Top
 Profile  
 
PostPosted: Thu Dec 31, 2009 2:32 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Tue Dec 08, 2009 6:44 pm
Posts: 11
It was my hosting company issue.....
I changed the hosting and it works fine....


Top
 Profile  
 
PostPosted: Fri Jun 04, 2010 11:55 pm 
Joomla! Apprentice
Joomla! Apprentice

Joined: Thu Jun 03, 2010 9:27 pm
Posts: 5
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!


Top
 Profile  
 
PostPosted: Mon Jul 05, 2010 7:00 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Mon Jul 05, 2010 6:57 pm
Posts: 1
hy everyone....solution to your problems is

in configuration.php change var $dbprefix like this:


var $dbprefix = 'jos_';

wooollaaaa


Top
 Profile  
 
PostPosted: Sat Jul 17, 2010 9:41 am 
Joomla! Apprentice
Joomla! Apprentice

Joined: Sat Jul 17, 2010 6:54 am
Posts: 5
Hi! whats in
var $dbprefix = 'jos_';

I have it also in my configure.php..

how to solve this problem?


Top
 Profile  
 
PostPosted: Sat Aug 21, 2010 2:32 pm 
Joomla! Fledgling
Joomla! Fledgling

Joined: Sat Aug 07, 2010 3:39 pm
Posts: 1
Thanks Danmir, :laugh: I just changed var $dbprefix_sgj to _jos and it worked.


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 13 posts ] 



Who is online

Users browsing this forum: No registered users and 2 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:  
Powered by phpBB® Forum Software © phpBB Group