SQL Errors when trying to set up PHPBB

[SleightOfHand]

Ok im trying to set up phpbb using MS Access.
My access db is an Access 2000 database.

I get these php errors:

Code: Select all

Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'phpbb_config'., SQL state S0002 in SQLExecDirect in d:\home\natekrygier_yahoo.com\sleight\forum\db\msaccess.php on line 159

Warning: odbc_exec(): SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'phpbb_config'., SQL state S0002 in SQLExecDirect in d:\home\natekrygier_yahoo.com\sleight\forum\db\msaccess.php on line 159

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:\home\natekrygier_yahoo.com\sleight\forum\db\msaccess.php on line 176

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:\home\natekrygier_yahoo.com\sleight\forum\db\msaccess.php on line 176

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:\home\natekrygier_yahoo.com\sleight\forum\db\msaccess.php on line 176

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:\home\natekrygier_yahoo.com\sleight\forum\db\msaccess.php on line 176

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:\home\natekrygier_yahoo.com\sleight\forum\db\msaccess.php on line 176

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:\home\natekrygier_yahoo.com\sleight\forum\db\msaccess.php on line 176


and then these phpbb errors:

Code: Select all

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', 1134328845) :: 888 :: d:\home\natekrygier_yahoo.com\sleight\forum\install\install.php

Could not insert default_lang :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_lang', 'english') :: 895 :: d:\home\natekrygier_yahoo.com\sleight\forum\install\install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = 'natekrygier@gmail.com' WHERE config_name = 'board_email' :: 912 :: d:\home\natekrygier_yahoo.com\sleight\forum\install\install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = '/sleight/forum/' WHERE config_name = 'script_path' :: 912 :: d:\home\natekrygier_yahoo.com\sleight\forum\install\install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = '80' WHERE config_name = 'server_port' :: 912 :: d:\home\natekrygier_yahoo.com\sleight\forum\install\install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = 'www.nthm05274.general-hosting.com' WHERE config_name = 'server_name' :: 912 :: d:\home\natekrygier_yahoo.com\sleight\forum\install\install.php

Could not update admin info :: UPDATE phpbb_users SET username = 'Punisher', user_password='401386caf989acd267897388a0e122cf', user_lang = 'english', user_email='natekrygier@gmail.com' WHERE username = 'Admin' :: 923 :: d:\home\natekrygier_yahoo.com\sleight\forum\install\install.php

Could not update user_regdate :: UPDATE phpbb_users SET user_regdate = 1134328845 :: 930 :: d:\home\natekrygier_yahoo.com\sleight\forum\install\install.php



[Marshalrusty]

Is there any way that you can use MySQL instead of MS Access? Even if you get it working, it will only allow a few users to be on at once.

[espicom]

Recommendation - do not start down the path of darkness that is ACCESS+PHPBB. The limitations are significant (such as no support for MODs, limited utility with more than one user, etc.), and there are free alternatives that work much better.

When using ACCESS, you must make sure that the file is located somewhere that the IIS user has write privileges, or it will not work. The usual place for this is in the IIS wwwroot directory, or another directory that you have set either "Everyone" or at least the IIS user to "Full Control" of the directory and file.

[SleightOfHand]

No, unless I want to pay my host 35 bucks to install MySQL

[Marshalrusty]

No, unless I want to pay my host 35 bucks to install MySQL

Whoa. I suggest you look for a better host if they charge $35 for a basic thing like MySQL

[espicom]

I agree with Marshalrusty - $35 bucks to install something that has lower overhead? That host is out of wack with reality! MySQL requires far fewer system resources than supporting Access files. Any host who charges extra for it has swallowed too much Microsoft Kool-Aid.

[SleightOfHand]

Good idea, I think ill get the host listed in your profile.
Everyone is so much better, even the beginner edition is better than what I have now for 7 a month.

Im thinking Ill get the Linux Home package

[espicom]

If you have a broadband connection, you can host a significant PHPBB site without killing your downloads speed, and then shop for an outside host while building your board... The only problem is if your provider blocks traffic to port 80.

Setting up a Linux server for PHPBB will help, if you have an old pentium-based computer laying around not doing anything; Linux can do a lot on limited hardware.