Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Affiliate Program
UBBDev.com
UBBSkins.com
Who's Online
3 registered (driv, Dunny, 1 invisible), 14 Guests and 47 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 11/05/08
Posts: 35
Top Posters (30 Days)
Sirdude 134
lightningrod 84
Gizmo 82
Rick 75
Ruben 48
Wisc.Tiger 35
Bad Frog 31
David Dreezer 28
JAISP 24
SteveS 20
Latest Photos
Tower Speakers, everyone needs them!
Going old style
the Frog
My Tractor Design and Build Project
Tombstone AZ
Topic Options
Rate This Topic
#21548 - 05/22/01 10: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
<?

// ------------------------------------------------------------------------

// WWWThreads - PHP

// Wired Community Software

// Rick Baker (rbaker@wcsoft.net)

// (c) Copyright 1999-2000

// ------------------------------------------------------------------------
// ------------------

// 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.

Can please someone help?

Thanks

Luke01
Top
#21549 - 05/22/01 10:19 PM Re: ! No Database Selected error
Rick Offline

Registered: 06/04/06
Posts: 9460
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.

-------------------
Scream
<A target="_blank" HREF=http://www.wwwthreads.com>WWWThreads</A>
Top
#21550 - 05/23/01 09:15 AM Re: ! 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
Top
#21551 - 05/23/01 11:49 AM Re: ! 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
Top
#21552 - 05/24/01 12:20 AM Re: ! 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...

Thanks for helping, I guess I do need it...

Luke01
Top
#21553 - 05/23/01 08:08 PM Re: ! No Database Selected error
Rick Offline

Registered: 06/04/06
Posts: 9460
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.

-------------------
Scream
<A target="_blank" HREF=http://www.wwwthreads.com>WWWThreads</A>
Top
#21554 - 05/24/01 03:56 PM Re: ! No Database Selected error
Anonymous
Unregistered

OK, sorted out!!!

The problem was obviusly the database name,username and password, once I clearly told my host what to do I solved the problem...

Thanks for your help

I really appreciate it

Luke01
Top


Moderator:  AllenAyres, Gizmo, Harold, Ian, Ron M, Sirdude 
Shout Box

Facebook Page
Today's Birthdays
No Birthdays
Recent Topics
Domo different then download? Need Help
by Hook them Lipps
Yesterday at 05:19 PM
User getting logged off......
by wish
Yesterday at 10:22 AM
Notepad Creates Errors when working with PHP
by lightningrod
Yesterday at 05:08 AM
Waiting For Software
by Hook them Lipps
03/09/10 06:26 PM
Deleting posts...
by Sherri
03/09/10 06:16 PM
Forum Stats
6743 Members
35 Forums
32457 Topics
170081 Posts

Max Online: 978 @ 06/24/07 08:19 PM
Random Image