Every single time I try to install 1.5 on my test site, It gives me "jtablesession::store failed
DB function failed with error number 1046
No database selected SQL=INSERT INTO jos_session ( `session_id`,`time`,`client_id` ) VALUES ( 'bk0p66gofsmmqstintg73vei06','1162169214','0' )".
What does it mean??? It comes right after I press next on the second step.
EVERY SINGLE TIME!
- RussW
- Joomla! Exemplar
- Posts: 9347
- Joined: Sun Oct 22, 2006 4:42 am
- Location: Sunshine Coast, Queensland, Australia
- Contact:
Re: EVERY SINGLE TIME!
I think the error is relating to your database build, have you made the new database for Joomla! 1.5 yet? or are you relying on Joomla! to make it for you?
This is a little odd becaue this type of error looks more like the installation is complete and it is trying to enter a current session in to the jos_session table, which would not have been created yet, which explains why the error says it has not selected any database yet.
Can you explain, step-by-step what you actions your are taking?
EG:
1) uploaded Joomla! files to /dir1
2) made dbase named dbase1, added user and password
3) opened http://www.domain.com.au/dir1 in browser etc etc etc
This is a little odd becaue this type of error looks more like the installation is complete and it is trying to enter a current session in to the jos_session table, which would not have been created yet, which explains why the error says it has not selected any database yet.
You aren't trying to install Joomla! 1.5 over the top of an existing 1.0.11 database are you? You didn't copy the configuration.php-dist to configuration.php before running the Web Installer ?No database selected SQL=INSERT INTO jos_session
Can you explain, step-by-step what you actions your are taking?
EG:
1) uploaded Joomla! files to /dir1
2) made dbase named dbase1, added user and password
3) opened http://www.domain.com.au/dir1 in browser etc etc etc
Joomla! on the fabulous Sunshine Coast...
hotmango, web & print http://www.hotmango.me/
The Styleguyz https://www.thestyleguyz.com/
hotmango, web & print http://www.hotmango.me/
The Styleguyz https://www.thestyleguyz.com/
-
- Joomla! Apprentice
- Posts: 28
- Joined: Sat Jan 21, 2006 5:21 pm
Re: EVERY SINGLE TIME!
I'm trying to install Joomla 1.5 from the very begining on a test site. And I never got to the page about mysql, just on the page after language settings.
And I have to take everything out a back to check again.
And I have to take everything out a back to check again.

-
- Joomla! Fledgling
- Posts: 3
- Joined: Tue Nov 07, 2006 3:23 pm
Re: EVERY SINGLE TIME!
I'm having a similar error. but i'm not even making it as far as you. I can't even load the first page of the installer.
I'm using:
a New database that I created in phpMyadmin just before the install attempt.
New install of 1.5 beta.
I have updated my configuration.php with the correct database name, username, and password
I also tried importing the *.sql files included with the Joomla 1.5 download, but still get this error.
I'm using:
a New database that I created in phpMyadmin just before the install attempt.
New install of 1.5 beta.
I have updated my configuration.php with the correct database name, username, and password
I also tried importing the *.sql files included with the Joomla 1.5 download, but still get this error.
I tried going to http://www.mysite.com/joomla/installation/index.php , but it kicks me right back to http://www.mysite.com/joomla/index.php with that error.jtablesession::store failed
DB function failed with error number 1146
Table 'smpwebz_joomla.jos_session' doesn't exist SQL=INSERT INTO jos_session ( `session_id`,`time`,`client_id` ) VALUES ( '414ac1a2c084a1b332ca74d2d1562b62','1162944124','0' )
- RussW
- Joomla! Exemplar
- Posts: 9347
- Joined: Sun Oct 22, 2006 4:42 am
- Location: Sunshine Coast, Queensland, Australia
- Contact:
Re: EVERY SINGLE TIME!
The configuration.php file if exists and populated with information before the installation will tell Joomla! that the isntallation is complete and thuis not run the installer.... start with an empty empty database and no configurationn.php file at all.
then re-run the installer.....
then re-run the installer.....
Joomla! on the fabulous Sunshine Coast...
hotmango, web & print http://www.hotmango.me/
The Styleguyz https://www.thestyleguyz.com/
hotmango, web & print http://www.hotmango.me/
The Styleguyz https://www.thestyleguyz.com/
-
- Joomla! Fledgling
- Posts: 3
- Joined: Tue Nov 07, 2006 3:23 pm
Re: EVERY SINGLE TIME!
OMG...I can't believe that I've been beating my head against the wall for 2 hours on this thing, and it was that simple! 
I deleted the configuration.php like you said, and it worked great! .....I guess it was just me making things more complicated than they need to be as usual
Thanks Russw!

I deleted the configuration.php like you said, and it worked great! .....I guess it was just me making things more complicated than they need to be as usual

Thanks Russw!

-
- Joomla! Apprentice
- Posts: 8
- Joined: Mon Dec 04, 2006 1:56 pm
Re: EVERY SINGLE TIME!
I’m trying to install joomla 1.5 without success for over 3 days now. I have re-installed my local web server with XAMPP (basic package) version 1.5.5 that came with Apache 2.2.3, MySQL 5.0.27; PHP 5.2.0 + PHP 4.4.4 + PEAR.
In the step 7:Finish of the joomla installation I always get this error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=INSERT INTO #__users VALUES (62, 'Administrator', 'admin', '[email protected]', 'd8578edf8458ce06fbc5bb76a58c5ca4', 'Super Administrator', 0, 1, 25, '2006-12-04 14:48:44', '0000-00-00 00:00:00', '', '')
Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\xampp\htdocs\Joomla150\installation\includes\classes.php:857) in C:\Program Files\xampp\htdocs\Joomla150\libraries\joomla\document\html\html.php on line 203
…
Could anyone help me on this?
Thanks
In the step 7:Finish of the joomla installation I always get this error:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 SQL=INSERT INTO #__users VALUES (62, 'Administrator', 'admin', '[email protected]', 'd8578edf8458ce06fbc5bb76a58c5ca4', 'Super Administrator', 0, 1, 25, '2006-12-04 14:48:44', '0000-00-00 00:00:00', '', '')
Warning: Cannot modify header information - headers already sent by (output started at C:\Program Files\xampp\htdocs\Joomla150\installation\includes\classes.php:857) in C:\Program Files\xampp\htdocs\Joomla150\libraries\joomla\document\html\html.php on line 203
…
Could anyone help me on this?

Thanks
Last edited by fmarocha on Mon Dec 04, 2006 2:24 pm, edited 1 time in total.
- feldon27
- Joomla! Explorer
- Posts: 334
- Joined: Tue Aug 23, 2005 2:18 pm
- Location: Houston, TX
Re: EVERY SINGLE TIME!
This tells me that Joomla needs to check if the configuration.php file has been modified and if so, put a warning.