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:<br /><br />Creating the tables...<br />Seeya! No Database Selected: 1046Board table created...<br />Seeya! No Database Selected: 1046Posts table created...<br />Adding a master poll table...<br />Seeya! No Database Selected: 1046Adding the poll results table...<br />Seeya! No Database Selected: 1046Seeya! No Database Selected: 1046Last viewed table created...<br />Seeya! No Database Selected: 1046Category table created...<br />Seeya! No Database Selected: 1046Seeya! No Database Selected: 1046Users table created...<br />Seeya! No Database Selected: 1046Moderator table created...<br />Seeya! No Database Selected: 1046Messages table created...<br />Seeya! No Database Selected: 1046Banned table created...<br />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...<br />Seeya! No Database Selected: 1046Online table created...<br />Seeya! No Database Selected: 1046Subscribe table created...<br />Creating table for the address book...<br />Seeya! No Database Selected: 1046<br />All tables created.<br /><br />I checked the config file and I believe everything is set up properly (not sure though).<br />This is the part of the config.inc file for you to have a look<br /><br /><?<br />// ------------------------------------------------------------------------<br />// WWWThreads - PHP<br />// Wired Community Software<br />// Rick Baker (rbaker@wcsoft.net)<br />// (c) Copyright 1999-2000<br />// ------------------------------------------------------------------------<br /><br /> // ------------------<br /> // Database Variables<br /><br /> // What type of database are you running<br /> // current options<br /> // mysql, (postgres, sybase are available but untested)<br /> $config['dbtype'] = "mysql";<br /><br /> // Server hosting the database<br /> $config['dbserver'] = "localhost";<br /><br /> // Username that has permissions to the database<br /> $config['dbuser'] = "flashtribute";<br /><br /> // Password for the database<br /> $config['dbpass'] = "fla926";<br /><br /> // Name of the database<br /> $config['dbname'] = "db1.mdb";<br /><br /> // If you are using mysql do you want to use persistent connections?<br /> // Note that on some hosted servers you may not be allowed to do this<br /> // so contact your host before setting this to "on"<br /> // Options: "on" - Use persistent: "off" - Don't use persistent<br /> $config['persistent'] = "on";<br /><br />My host told me I need a db like access or similar, is he right?<br /><br />I looked all over the forums but have found no solution.<br />Can please someone help?<br />Thanks<br />Luke01<br /><br />

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.<br /><br />-------------------<br />Scream<br />WWWThreads

I renamed the database without the . but still doesn't work, I am sure I am doing something wrong but dunno what...<br />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...<br />Thanks for your help<br /><br /><br />

What database engine are you using? MySQL, Access, or what?<br /><br />If you're trying to use Access (which I gleaned from your .mdb name), then I believe you're SOL.<br /><br />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.<br /><br />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').<br /><br />bryan<br /><br />

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...<br />Thanks for helping, I guess I do need it...<br />Luke01<br /><br /><br />

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.<br /><br />-------------------<br />Scream<br />WWWThreads

OK, sorted out!!!<br />The problem was obviusly the database name,username and password, once I clearly told my host what to do I solved the problem...<br />Thanks for your help<br />I really appreciate it<br />Luke01<br /><br />