Database error when i try to install.

[Ravenheart]

Hi, i'm having trouble installing phpBB onto my database.

I am goign to run it through MS Access. I have created the database and the DSL. But, when i try to install phpBB i get the following text:

----------------------------------------------------------

An error occurred trying to update the database

Could not insert board_startdate :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_startdate', 1139525112) :: 888 :: D:Webspacesilentoutpost.netwwwrootforuminstallinstall.php

Could not insert default_lang :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_lang', 'english') :: 895 :: D:Webspacesilentoutpost.netwwwrootforuminstallinstall.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = 'mail@silentoutpost.net' WHERE config_name = 'board_email' :: 912 :: D:Webspacesilentoutpost.netwwwrootforuminstallinstall.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = '/forum/' WHERE config_name = 'script_path' :: 912 :: D:Webspacesilentoutpost.netwwwrootforuminstallinstall.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = '80' WHERE config_name = 'server_port' :: 912 :: D:Webspacesilentoutpost.netwwwrootforuminstallinstall.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = 'www.silentoutpost.net' WHERE config_name = 'server_name' :: 912 :: D:Webspacesilentoutpost.netwwwrootforuminstallinstall.php

Could not update admin info :: UPDATE phpbb_users SET username = 'Ravenheart', user_password='ed54681d62d1fc69b1beefd9af6eb059', user_lang = 'english', user_email='mail@silentoutpost.net' WHERE username = 'Admin' :: 923 :: D:Webspacesilentoutpost.netwwwrootforuminstallinstall.php

Could not update user_regdate :: UPDATE phpbb_users SET user_regdate = 1139525112 :: 930 :: D:Webspacesilentoutpost.netwwwrootforuminstallinstall.php

THEN I get:

PHP Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'phpbb_config'., SQL state S0002 in SQLExecDirect in D:Webspacesilentoutpost.netwwwrootforumdbmsaccess.php on line 159 PHP Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'phpbb_config'., SQL state S0002 in SQLExecDirect in D:Webspacesilentoutpost.netwwwrootforumdbmsaccess.php on line 159 PHP Warning: odbc_exec(): 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 D:Webspacesilentoutpost.netwwwrootforumdbmsaccess.php on line 176 PHP Warning: odbc_exec(): 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 D:Webspacesilentoutpost.netwwwrootforumdbmsaccess.php on line 176 PHP Warning: odbc_exec(): 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 D:Webspacesilentoutpost.netwwwrootforumdbmsaccess.php on line 176 PHP Warning: odbc_exec(): 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 D:Webspacesilentoutpost.netwwwrootforumdbmsaccess.php on line 176 PHP Warning: odbc_exec(): 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 D:Webspacesilentoutpost.netwwwrootforumdbmsaccess.php on line 176 PHP Warning: odbc_exec(): 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 D:Webspacesilentoutpost.netwwwrootforumdbmsaccess.php on line 176

--------------------------------------------

What does all of this mean? I am new to phpBB, so if possible, speak in dummy talk and give me a very clear explanation of what the problem is, and what to do next.

I think that the config file is not creating the bbs. I can't understand the rest.

Thanks alot, Ravenheart.

[Marshalrusty]

Before you go down the MS Access path, consider this: you will never be able to run a successful forum on Access. The limits it sets will only allow a few users to be on at once. Is there a way you can use MySQL instead?

[Ravenheart]

Before you go down the MS Access path, consider this: you will never be able to run a successful forum on Access. The limits it sets will only allow a few users to be on at once. Is there a way you can use MySQL instead?

There is, but i don't like the idea of having to pay £25 a year for it. Why does MS Access have such limits?

And will someone please answer my original query please.

[~AJK~]

Access will be rough on you when your forum get's bigger. MySql is free. When you see that error message look at:

Code: Select all

Could not find output table 'phpbb_config'.

and

Code: Select all

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.

You haven't set up your connection to the DB correctly.

You may want to look at the The phpBB2 Welcome Package

The welcome package contains information about:

1. Hosting requirements
2. Resources to find hosts to run phpBB on
3. The latest version of phpBB
4. The official installation guide
5. Flash tutorials on installing, managing, and using phpBB
6. Step by step instructions
7. The official userguide
8. Instructions on how to search for your answer on phpbb.com
9. Links to the Official Knowledgebase
10. A link to the Support Request Template to be used when posting a topic in the support forum.
11. and more....

[Lumpy Burgertushie]

all those errors are another reason why Access is not good, it is too hard to figure out how to make it work.


robert

[Ravenheart]

Access will be rough on you when your forum get's bigger. MySql is free. When you see that error message look at:

Code: Select all

Could not find output table 'phpbb_config'.

and

Code: Select all

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.

You haven't set up your connection to the DB correctly.

You may want to look at the The phpBB2 Welcome Package

The welcome package contains information about:

1. Hosting requirements
2. Resources to find hosts to run phpBB on
3. The latest version of phpBB
4. The official installation guide
5. Flash tutorials on installing, managing, and using phpBB
6. Step by step instructions
7. The official userguide
8. Instructions on how to search for your answer on phpbb.com
9. Links to the Official Knowledgebase
10. A link to the Support Request Template to be used when posting a topic in the support forum.
11. and more....

Thanks, but my hosts say that adding a MySQL server will cost me 25 pounds a year...

Can i keep the MS Access database (the only one i am allowed to make there) and then use a MySQL DSL for it?

[Ravenheart]

Forget that, i'm downloading MySQL right now

Where do i put it once i have downloaded it?

[~AJK~]

Ask your host (or find a different one).

[Ravenheart]

Ask your host (or find a different one).

Umm, this looks a little tricky to install. I have installed it right, but it doesn't show up anywhere! Where is it, how do i get it onto my domain and where do i put it once inside?

[Marshalrusty]

If you are on a shared server, you cannot install MySQL yourself. And if your host charges £25 a year for it, switch hosts; that is a ridicuous price for something so standard..

[Ravenheart]

If you are on a shared server, you cannot install MySQL yourself. And if your host charges £25 a year for it, switch hosts; that is a ridicuous price for something so standard..

So it isn't free? Ugh. Ugh. Ugh.

So they have to install it for me?