Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
Affiliate Program
Hosting Plans
UBBDev.com
UBBSkins.com
Who's Online
4 registered (Allen2010, David Dreezer, Iann128, johnmorrison1823), 37 Guests and 67 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
EMG
EMG
Registered: 10/30/08
Posts: 14
Top Posters (30 Days)
Rick 117
Ruben 99
Sirdude 77
Gizmo 63
Iann128 32
driv 22
teamzr1 20
GregK 20
Chevy454 19
David Dreezer 17
Latest Photos
rss creator
surfing dogs
Secret Falls, Belize
testing gallery
Ultima Online
Topic Options
Rate This Topic
#21548 - 05/22/01 12:09 PM ! 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/23/01 12:19 AM Re: ! No Database Selected error
Rick Offline

Registered: 06/04/06
Posts: 9905
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 11: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 01:49 PM 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 02: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 10:08 PM Re: ! No Database Selected error
Rick Offline

Registered: 06/04/06
Posts: 9905
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 05: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
Upgrade issues in version 7.5.6 (from 7.2.2)
by lcantey
Yesterday at 08:36 PM
deleting your own thread/subject
by VaGunTrader
Yesterday at 05:58 PM
changing the time.
by VaGunTrader
Yesterday at 05:27 PM
question
by Allen2010
Yesterday at 10:03 AM
Search for countries of users?
by tee
09/01/10 04:56 PM
Forum Stats
7909 Members
37 Forums
32927 Topics
173682 Posts

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