Site Links
Home
Features
Documentation
Pricing & Order
Members Area
Support Options
UBBDev.com
UBBWiki.com
Who's Online
2 registered (A-GATE, Jake), 29 Guests and 13 Spiders online.
Key: Admin, Global Mod, Mod
Featured Member
Registered: 04/09/11
Posts: 140
Top Posters (30 Days)
Ruben 51
Gizmo 24
DennyP 24
Dunny 15
SteveS 14
AllenAyres 12
SD 10
dbremer 10
drkknght00 9
doug 8
Latest Photos
OK Corral Shoot Out
Testing
Basildon Train Station
Basildon Town Centre looking from the rounderbout
Basildon Town Square
Topic Options
#21548 - 05/22/01 01: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 01:19 AM Re: ! No Database Selected error
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
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 12:15 PM 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 02: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 03: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 11:08 PM Re: ! No Database Selected error
Rick Offline
Post-a-holic
Registered: 06/04/06
Posts: 10164
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 06: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



Shout Box

Today's Birthdays
No Birthdays
Recent Topics
Temporary Password email not being received
by
05/24/12 10:02 PM
Ability to "like" individual posts (not Facebook "likes)
by doug
05/23/12 09:03 AM
Island Permissions
by ThreadsUser
05/22/12 03:03 PM
streaming video
by prkrgrp
05/20/12 07:02 PM
New Posts Corrupted? Can someone help?
by PianoWorld
05/19/12 09:41 AM
Forum Stats
10492 Members
36 Forums
33842 Topics
181709 Posts

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