#21548 - 05/22/0110:09 AM! No Database Selected error
Anonymous
Unregistered
First thing I am a total newbie to Php and Mysql, and this is the error I am getting when I run the createtable.php via browser: Creating the tables...
Seeya! No Database Selected: 1046Board table created...
Seeya! No Database Selected: 1046Posts table created...
Adding a master poll table...
Seeya! No Database Selected: 1046Adding the poll results table...
Seeya! No Database Selected: 1046Seeya! No Database Selected: 1046Last viewed table created...
Seeya! No Database Selected: 1046Category table created...
Seeya! No Database Selected: 1046Seeya! No Database Selected: 1046Users table created...
Seeya! No Database Selected: 1046Moderator table created...
Seeya! No Database Selected: 1046Messages table created...
Seeya! No Database Selected: 1046Banned table created...
Seeya! No Database Selected: 1046Groups table createdSeeya! No Database Selected: 1046Seeya! No Database Selected: 1046Seeya! No Database Selected: 1046Seeya! No Database Selected: 1046Basic groups created...
Seeya! No Database Selected: 1046Online table created...
Seeya! No Database Selected: 1046Subscribe table created...
Creating table for the address book...
Seeya! No Database Selected: 1046
All tables created. I checked the config file and I believe everything is set up properly (not sure though).
This is the part of the config.inc file for you to have a look <?
// Database Variables // What type of database are you running
// current options
// mysql, (postgres, sybase are available but untested)
$config['dbtype'] = "mysql"; // Server hosting the database
$config['dbserver'] = "localhost"; // Username that has permissions to the database
$config['dbuser'] = "flashtribute"; // Password for the database
$config['dbpass'] = "fla926"; // Name of the database
$config['dbname'] = "db1.mdb"; // If you are using mysql do you want to use persistent connections?
// Note that on some hosted servers you may not be allowed to do this
// so contact your host before setting this to "on"
// Options: "on" - Use persistent: "off" - Don't use persistent
$config['persistent'] = "on"; My host told me I need a db like access or similar, is he right? I looked all over the forums but have found no solution.
#21549 - 05/22/0110:19 PMRe: ! No Database Selected error
Rick
Registered: 06/04/06
Posts: 8514
Loc: Aberdeen, WA
Someone can correct me if I am wrong but I don't think you can have a period in your database name. That would be the first thing I would try is create a database without the . and change the config.inc.php file to match and try again.
#21550 - 05/23/0109:15 AMRe: ! No Database Selected error
Anonymous
Unregistered
I renamed the database without the . but still doesn't work, I am sure I am doing something wrong but dunno what... Is my host write in telling that the database can be like an access database? or can it be a simple text file? I am new to it and I have no idea... Thanks for your help
#21551 - 05/23/0111:49 AMRe: ! No Database Selected error
Anonymous
Unregistered
What database engine are you using? MySQL, Access, or what? If you're trying to use Access (which I gleaned from your .mdb name), then I believe you're SOL. Hell, if this package was able to talk MS SQL, I'd have purchased it for another org that I am in charge of forums for...I *hate* ASP based forums...this is a nice engine. If you have MySQL set up, you need to create a database and give permissions to the user you configured for the forums (mine defaulted to 'nobody'). bryan
#21552 - 05/24/0112:20 AMRe: ! No Database Selected error
Anonymous
Unregistered
I am using Access because that's what my host told me to do, but I know the server runs Mysql and that's what I want to use, but the thing is probably that I am not sure on how do I create the database and my host doesn't really know what is talking about...
#21553 - 05/23/0108:08 PMRe: ! No Database Selected error
Rick
Registered: 06/04/06
Posts: 8514
Loc: Aberdeen, WA
Ah, you do need to use mysql. Mysql is the only supported database at this time with the PHP version. I don't believe you will be able to create the database yourself on a hosted server. The host needs to just run the mysqladmin command to create the database for you and then mysql_setpermission to set the permissions. Fairly easy, and if they offer mysql then this should be a standard setup for them.