Install problems

[bobby_fudge]

I am trying to install phpbb on my site (hosted by fasthosts). My Provider obviously don't support this as its 3rd party but assured me that other customers have succesfully set it up on their systems.

I am new to this and I'm having problems.

Does the database I create and upload to the site need to have anything in it or just a blank database. I'm using MS Access 2003 (ODBC). I have setup a DSN on the server and uploaded the blank database (.mdb).

Here is what I have done and where the problem begins.

1. Downloaded and unzipped phpbb
2. Uploaded files to Web Server.
3. Unable to change config.php permissions but my provider assured me that on Fasthosts I should need to.
4. Accessed the install.php via web.
5. Chose ODBC as database type
6. Database Server Hostname / DSN = my DSN name (bhaa)
7. Your Database Name = my database I uploaded (forum) this is blank.
8. Database Username = nothing as I didn't set a username
9. Database Password = nothing as I didn't set a password
10. entered email address, username etc... click Start Install

I get the following:
Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'phpbb_config'., SQL state S0002 in SQLExecDirect in e:\domains\b\brighouseangling.co.uk\user\htdocs\phpbb2\db\msaccess.php on line 159

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'phpbb_config'., SQL state S0002 in SQLExecDirect in e:\domains\b\brighouseangling.co.uk\user\htdocs\phpbb2\db\msaccess.php on line 159

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'phpbb_config'. Make sure it exists and that its name is spelled correctly., SQL state S0002 in SQLExecDirect in e:\domains\b\brighouseangling.co.uk\user\htdocs\phpbb2\db\msaccess.php on line 176

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'phpbb_config'. Make sure it exists and that its name is spelled correctly., SQL state S0002 in SQLExecDirect in e:\domains\b\brighouseangling.co.uk\user\htdocs\phpbb2\db\msaccess.php on line 176

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'phpbb_config'. Make sure it exists and that its name is spelled correctly., SQL state S0002 in SQLExecDirect in e:\domains\b\brighouseangling.co.uk\user\htdocs\phpbb2\db\msaccess.php on line 176

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'phpbb_config'. Make sure it exists and that its name is spelled correctly., SQL state S0002 in SQLExecDirect in e:\domains\b\brighouseangling.co.uk\user\htdocs\phpbb2\db\msaccess.php on line 176

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'phpbb_users'. Make sure it exists and that its name is spelled correctly., SQL state S0002 in SQLExecDirect in e:\domains\b\brighouseangling.co.uk\user\htdocs\phpbb2\db\msaccess.php on line 176

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'phpbb_users'. Make sure it exists and that its name is spelled correctly., SQL state S0002 in SQLExecDirect in e:\domains\b\brighouseangling.co.uk\user\htdocs\phpbb2\db\msaccess.php on line 176

.................................................................

An error has occurred during installation
An error occurred trying to update the database

Could not insert board_startdate :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_startdate', 1136415540) :: 888 :: e:\domains\b\brighouseangling.co.uk\user\htdocs\phpbb2\install\install.php

Could not insert default_lang :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_lang', 'english') :: 895 :: e:\domains\b\brighouseangling.co.uk\user\htdocs\phpbb2\install\install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = 'webmaster@brighouseangling.co.uk' WHERE config_name = 'board_email' :: 912 :: e:\domains\b\brighouseangling.co.uk\user\htdocs\phpbb2\install\install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = '/phpbb2/' WHERE config_name = 'script_path' :: 912 :: e:\domains\b\brighouseangling.co.uk\user\htdocs\phpbb2\install\install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = '80' WHERE config_name = 'server_port' :: 912 :: e:\domains\b\brighouseangling.co.uk\user\htdocs\phpbb2\install\install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = 'www.brighouseangling.co.uk' WHERE config_name = 'server_name' :: 912 :: e:\domains\b\brighouseangling.co.uk\user\htdocs\phpbb2\install\install.php

Could not update admin info :: UPDATE phpbb_users SET username = 'ianbo', user_password='2c29c5afc9fb708812dc196fa661c380', user_lang = 'english', user_email='webmaster@brighouseangling.co.uk' WHERE username = 'Admin' :: 923 :: e:\domains\b\brighouseangling.co.uk\user\htdocs\phpbb2\install\install.php

Could not update user_regdate :: UPDATE phpbb_users SET user_regdate = 1136415540 :: 930 :: e:\domains\b\brighouseangling.co.uk\user\htdocs\phpbb2\install\install.php


Any help would be gratefully appreciated.

[Lumpy Burgertushie]

there is no good reason to use Access for this. if this is your host:
http://www.fasthosts.co.uk/hosting/
they provide mysql on their windows and their linux plans.

contact them about how to set up a mysql database for your plan.

then use it for the phpbb . Acess is only good for a couple of members and a very lite type board.


robert

[bobby_fudge]

yes that is my host.... thanks for the help.

Would I not need to create the database in MySQL then ? or do the hosts do it ?

What do I need to tell them as they have already told me that they don't support phpbb, I'm sure if I asked for a database for this reason they'd say no.

Thanks again.

[bobby_fudge]

can anyone offer any advise on this

[bobby_fudge]

anyone.... please..... anyone ????

[Marshalrusty]

Tell them you need a MySQL database. If they say no, get a better host. You'll need to upload the install and contrib folder and run the installed on the MySQL database.

Did they say that you are not allowed to run phpBB, or that they just don't support 3rd party software? Cause the latter is understandable.

[bobby_fudge]

the thing is the forum will only be dealing with a couple of users at a time, thats why I was going to use Access. my host supports MySQL but its an additional charge that I don't think the company will fork out for, as they are non profit.

Yes my host said they won't support phpbb, but other customers have got it working.

So going back to using an Access database, how do I set that up ?

Many Thanks

[phillyph]

Tell them you need a MySQL database. If they say no, get a better host. You'll need to upload the install and contrib folder and run the installed on the MySQL database.

Did they say that you are not allowed to run phpBB, or that they just don't support 3rd party software? Cause the latter is understandable.

yes indeed. if all this is too much trouble, i would find a better host.

[phillyph]

the thing is the forum will only be dealing with a couple of users at a time, thats why I was going to use Access. my host supports MySQL but its an additional charge that I don't think the company will fork out for, as they are non profit.

Yes my host said they won't support phpbb, but other customers have got it working.

So going back to using an Access database, how do I set that up ?

Many Thanks

if they dont support it, there are many free ones that will.

[Lumpy Burgertushie]

ok, your host doesn't support phpbb. that doesn't mean you cant use it, it just means, dont' ask them for help

according to what I saw on their site, you already have a mysql database available to you.

go to your control panel for your hosting account. find the mysql section, create a database, give it a name, a username and a password.

then you will have what you need to put in the install page.

if you think you don't get any support for phpbb, wait till you try to get support for using a Access database. nobody uses this for anything but home computer type of record keeping.

robert