SQL Error Access cant find proper tables...

This is an archive of the phpBB 2.0.x support forum. Support for phpBB2 has now ended.
Forum rules
Following phpBB2's EoL, this forum is now archived for reference purposes only.
Please see the following announcement for more information: viewtopic.php?f=14&t=1385785

SQL Error Access cant find proper tables...

Postby JSThePatriot » Thu Oct 21, 2004 9:31 pm

Okay I finally got phpbb to connect to my access database, do I need to create the proper tables because I get an error when I try to install the forum... below are the errors recieved.

Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver] Could not find output table 'phpbb_config'., SQL state S0002 in SQLExecDirect in d:\cust\thepatriot\the-patriotnet\web\fca\forum\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 d:\cust\thepatriot\the-patriotnet\web\fca\forum\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 d:\cust\thepatriot\the-patriotnet\web\fca\forum\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 d:\cust\thepatriot\the-patriotnet\web\fca\forum\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 d:\cust\thepatriot\the-patriotnet\web\fca\forum\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 d:\cust\thepatriot\the-patriotnet\web\fca\forum\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 d:\cust\thepatriot\the-patriotnet\web\fca\forum\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 d:\cust\thepatriot\the-patriotnet\web\fca\forum\db\msaccess.php on line 176


And the following a bit further down on the page...

An error occurred trying to update the database

Could not insert board_startdate :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('board_startdate', 1098117430) :: 871 :: d:\cust\thepatriot\the-patriotnet\web\fca\forum\install\install.php

Could not insert default_lang :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('default_lang', 'english') :: 878 :: d:\cust\thepatriot\the-patriotnet\web\fca\forum\install\install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = 'patriot@the-patriot.net' WHERE config_name = 'board_email' :: 895 :: d:\cust\thepatriot\the-patriotnet\web\fca\forum\install\install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = '/fca/forum/' WHERE config_name = 'script_path' :: 895 :: d:\cust\thepatriot\the-patriotnet\web\fca\forum\install\install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = '80' WHERE config_name = 'server_port' :: 895 :: d:\cust\thepatriot\the-patriotnet\web\fca\forum\install\install.php

Could not insert default_lang :: UPDATE phpbb_config SET config_value = 'www.the-patriot.net' WHERE config_name = 'server_name' :: 895 :: d:\cust\thepatriot\the-patriotnet\web\fca\forum\install\install.php

Could not update admin info :: UPDATE phpbb_users SET username = 'JSThePatriot', user_password='2ec418f96a6e922dfb5a4c12ce75721c', user_lang = 'english', user_email='patriot@the-patriot.net' WHERE username = 'Admin' :: 906 :: d:\cust\thepatriot\the-patriotnet\web\fca\forum\install\install.php

Could not update user_regdate :: UPDATE phpbb_users SET user_regdate = 1098117430 :: 913 :: d:\cust\thepatriot\the-patriotnet\web\fca\forum\install\install.php


Also as a side note it took over a week for me to recieve the email for confirmation. I know that you guys are busy and everything I just wanted to alert you to that Smile No biggie though.

Thanks for your help in advance. I am sure it is something I am doing.

JS
Have you ever thought about thinking on purpose?
-JS

Patriot Designs
http://www.the-patriot.net
JSThePatriot
Registered User
 
Posts: 5
Joined: Mon Oct 11, 2004 1:35 pm
Location: Tennessee, United States

Return to 2.0.x Support Forum

Who is online

Users browsing this forum: sirknight115, Yahoo [Bot] and 15 guests