Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBSkins.com
Who's Online
1 registered (FordDoctor), 8 Guests and 47 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 06/04/06
Posts: 12825
Top Posters (30 Days)
Ruben 116
Rick 44
Gizmo 41
JAISP 19
24hourcampfire 18
pinkmelon 16
Daryl Fawcett 14
Ian 14
FordDoctor 13
bakerzdosen 12
Latest Photos
Gizmo goes Locks of Love...
Sleepy eyes
Hang Time
Our get away hobby
This is a test
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: 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.

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

-------------------
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, usrbingeek 
Shout Box

Today's Birthdays
wmearn
Recent Topics
Gallery Permissions
by Willzter
07/01/09 08:50 PM
SERIOUS EMERGENCY. NEED A QUICK ANSWER STAT
by 24hourcampfire
07/01/09 02:18 PM
What do I have to do to have a forum where only users with 200 plus post can post?
by pinkmelon
07/01/09 02:06 PM
New host, but I don't know full path
by SAPA IT Guy
07/01/09 12:54 PM
Problems on a new Host
by rich_ay
07/01/09 12:07 PM
Forum Stats
4443 Members
33 Forums
31485 Topics
162438 Posts

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