Contentteller

Contentteller Support Forums
Home Forums > Contentteller > Version 1.x >

Error: Can't select the database

Discussion in 'Version 1.x' started by digibri, Jul 13, 2003.

  1. digibri Guest

    Error: Can't select the database

    Howdy,

    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.

    After waiting quite a while to see if the cinstall.php would give me a message, I tried going to the index.php in the root.

    I get the error: "Error: Can't select the database"

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


    Thanks,

    B.
    digibri, Jul 13, 2003
    #1
  2. Philipp Guest

    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.
    Philipp, Jul 13, 2003
    #2
  3. digibri Guest

    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.
    digibri, Jul 13, 2003
    #3
  4. Philipp Guest

    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.
    Philipp, Jul 13, 2003
    #4
  5. digibri Guest

    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.
    digibri, Jul 13, 2003
    #5
  6. Philipp Guest

    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.
    Philipp, Jul 13, 2003
    #6
  7. digibri Guest

    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.
    digibri, Jul 13, 2003
    #7
  8. Philipp Guest

    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 = ""; )?
    Philipp, Jul 13, 2003
    #8
  9. digibri Guest

    Error: Can't select the database

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

    B.
    digibri, Jul 13, 2003
    #9
  10. Philipp Guest

    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.
    Philipp, Jul 13, 2003
    #10
  11. digibri Guest

    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.
    digibri, Jul 13, 2003
    #11
  12. bluedigitalmedia Guest

    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
    bluedigitalmedia, Sep 3, 2003
    #12
  13. Philipp Guest

    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:
    Code:
    $action = $_GET["action"];
    After:
    Code:
    $extra7 = $_POST["extra7"];
    An updated freeware version is now also available in the members area.

    Philipp
    Philipp, Sep 3, 2003
    #13
  14. bluedigitalmedia Guest

    Error: Can't select the database

    Thanks - that did it!!!

    Cliff
    bluedigitalmedia, Sep 3, 2003
    #14
  15. Varsosnill Guest

    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 :(
    Varsosnill, Mar 24, 2004
    #15
  16. Philipp Guest

    Error: Can't select the database

    It's here:
    http://www.esselbach.com/scripts/cfix.php.txt
    Philipp, Mar 24, 2004
    #16
Tweet
Facebook:
Forgot your password?
Contentteller Support Forums
Home Forums > Contentteller > Version 1.x >
  • Home
  • Forums

    Forums

    Quick Links
    • Search Forums
    • What's New?
  • Members

    Members

    Quick Links
    • Registered Members
    • Current Visitors
    • Recent Activity
  • Help

    Help

    Quick Links
    • Smilies
    • BB Codes
    • Trophies

Separate names with a comma.

Advanced search...
    Forum software by XenForo™ ©2011 XenForo Ltd.