Error: Can't select the database

It's here:
 http://www.esselbach.com/scripts/cfix.php.txt

Error: Can't select the database

Originally posted by Philipp:

The database installation is complete.

It seems like that config.php had not the correct permission (777).

In attachment a script which write the configuration to config.php

To use this script:
1.) Rename the script to cfix.php

2.) Open the script in an editor and change the following:

//MySQL settings
$dbhost = "localhost";
$dbuser = "username"; <= MySQL Username
$dbpass = "password"; <= MySQL Password
$dbname = "database"; <= MySQL Database

//Website details
$wsname = "Website Name"; <= Website name
$wsurl = " http://www.yourdomain.com"; <= Website url

3.) Upload the script to your cadmin directory

4.) Run the script:  http://www.yourdomain/cadmin/cfix.php

If the script can't write config.php, please check the permissions of this file again.

Philipp, where is attached script? I can't see it

Error: Can't select the database

Thanks - that did it!!!

Cliff

Error: Can't select the database

Hello Cliff,

I found the problem. There is a line missing in the installer of the freeware version, which cause this problem on newer PHP versions.

Please add the following in cadmin/cinstall.php:

$action = $_GET["action"];

After:

$extra7 = $_POST["extra7"];

An updated freeware version is now also available in the members area.

Philipp

Error: Can't select the database

OK - I am pulling my hair out on this issue - Following the EXACT instructions as listed in the support area for installation for the free version, I cannot get the install script in the /cadmin folder to get past the very first page - I click on next and it just sits there - nothing happens.

I even went so far as to creating my own .sql file and running it to populate my dev servers database - It created some tables, but still didn't do anything else - before I did this, I received an error message stating it couldn't find specific tables related to the database, once I ran the sql query and actually got tables to populate in the database, I received an error message saying no database could be found.

I'm at a loss as to what to try next to get this to work - I have been at it for 2 hours and still no working test site on my dev server to see if this will meet my needs.

I find it quite frustrating to not even have an error message in the install to state why the database tables will not populate.

I am running the latest build of PHP 4 and MySQL 3.23.x running Apche 1.3.27

Any ideas as to why I can't get the free version to work???

TIA,

Cliff

Error: Can't select the database

Super, that did the trick.
It's weird that the problem was permissions - I logged in via SSH and used "chmod 777 filenam" as per your online installation instructions.
I guess I'll have to be more diligent about verifying that the permission changes worked...

Thanks for all your help - I suspect that few other organizations would be as responsive.

Now it's time to customize...

:-)

B.

Error: Can't select the database

The database installation is complete.

It seems like that config.php had not the correct permission (777).

In attachment a script which write the configuration to config.php

To use this script:
1.) Rename the script to cfix.php

2.) Open the script in an editor and change the following:

//MySQL settings
$dbhost = "localhost";
$dbuser = "username"; <= MySQL Username
$dbpass = "password"; <= MySQL Password
$dbname = "database"; <= MySQL Database

//Website details
$wsname = "Website Name"; <= Website name
$wsurl = " http://www.yourdomain.com"; <= Website url

3.) Upload the script to your cadmin directory

4.) Run the script:  http://www.yourdomain/cadmin/cfix.php

If the script can't write config.php, please check the permissions of this file again.

Error: Can't select the database

There are 33 tables.
Yes, config.php is empty.

B.

Error: Can't select the database

Originally posted by digibri
PHPmyAdmin shows a lot of esselbach_st_* tables.

How many tables are there? A complete installation needs 33 tables.

Is config.php empty (e.g. $estc = ""; )?

Error: Can't select the database

This is a clean install of the Standard edition.

PHPmyAdmin shows a lot of esselbach_st_* tables.

Software versions:
- PHP4.3.1
- mySQL 3.23.54
- Apache 1.3.27

Further details can be found here:  http://64.158.235.172/_util/info.php

B.

Error: Can't select the database

Originally posted by digibri
I edited bbwrapper.php and copied it into the root, as you suggested.
I also reran cinstall.php but got the same results as originally described.

Is this a clean install or an upgrade from basic edition? Can you check with phpMyAdmin whether there are esselbach_st_* tables in the database?

Also, which versions of PHP/MySQL are installed?

Originally posted by digibri
At what point should I run bbwrapper.php? Or, does the cinstall.php call it automatically?

The bbwrapper.php is an external database connector module and will be automatically used by the login/comments function of Storyteller CMS.

Error: Can't select the database

I edited bbwrapper.php and copied it into the root, as you suggested.
I also reran cinstall.php but got the same results as originally described.

At what point should I run bbwrapper.php? Or, does the cinstall.php call it automatically?

B.

Error: Can't select the database

Originally posted by digibri
Should I try rerunning the cinstall.php?

Yes, please try it again.

Originally posted by digibri
What about bbwrapper.php, when do I utilize that?

Open the bbwrapper.php in an editor and change the settings to your vBulletin configuration:

$bb_host = "localhost";
$bb_dbname = "dbname"; <= database name
$bb_dbuser = "username"; <= database username
$bb_dbpasswd = "password"; <= database password
$bb_url = "/forums/"; <= forum location (e.g. /forums/ for http://www.yourdomain.com/forums/)
$bb_panel = $$_url."usercp.php"; <= Location to user control panel (don't change)
$bb_private = ""; <= Forum IDs of the private forums

Then copy the file to the storyteller root directory.

Error: Can't select the database

Wow, thanks for your quick reply!

Yes, I did chmod 777 as per the installation instructions.

Should I try rerunning the cinstall.php?
What about bbwrapper.php, when do I utilize that?

B.

Error: Can't select the database

Originally posted by digibri
I just bought a copy and have run cinstall.php.
Question, should the cinstall.php report when it's done? It did not do so for me.

Did you chmod config.php to 777

Originally posted by digibri
When I ran the cinstall.php script, I filled in the database name currently being used by vBulletins. Was this the correct procedure?

Should be no problem. However, I recommend to use a second database for the script.