Author |
Message |
domuk
WebHelper
![WebHelper WebHelper](images/rank_2.gif)
Joined: 15 Jan 2004
Posts: 91
|
Posted:
Thu Mar 11, 2004 6:22 pm (20 years, 1 month ago) |
![Reply with Quote Reply with Quote](templates/4WebHelp2/images/lang_english/icon_quote.gif) ![Back to Top Back to Top](templates/4WebHelp2/images/icon_up.gif) |
Hi all,
I have just started working with the PHPBB forum and it has been working for aprox 3 weeks, when i tried to access it today and the following message came up.
I have cleared my temp internet folders and was wondering if this was anything to do with it or could my sql database be down on the server?
Code: | phpBB : Critical Error
Could not query config information
DEBUG MODE
SQL Error : 1146 Table 'number.phpbb_config' doesn't exist
SELECT * FROM phpbb_config
Line : 166 |
Your help is always appreciated,
Dom.. |
Last edited by domuk on Sun Apr 11, 2004 7:55 am, edited 1 time in total |
|
![Offline](templates/4WebHelp2/images/offline.gif) ![View User's Profile View User's Profile](templates/4WebHelp2/images/lang_english/icon_profile.gif) ![Find all posts by domuk Find all posts by domuk](templates/4WebHelp2/images/lang_english/icon_search.gif) ![Send Personal Message Send Personal Message](templates/4WebHelp2/images/lang_english/icon_pm.gif) |
![](images/spacer.gif) |
Daniel
Team Member
![](images/rank_6.gif)
![](http://www.4webhelp.net/forums/images/daniel_avatar.php)
Joined: 06 Jan 2002
Posts: 2564
|
Posted:
Thu Mar 11, 2004 6:28 pm (20 years, 1 month ago) |
![Reply with Quote Reply with Quote](templates/4WebHelp2/images/lang_english/icon_quote.gif) ![Back to Top Back to Top](templates/4WebHelp2/images/icon_up.gif) |
I would contact your host. The error means that the "phpbb_config" table in the "oebfoiyx2e16" database doesn't exist (anymore). |
________________________________
![Image Image](http://www.4webhelp.net/images/daniel_sig.gif) |
|
![Offline](templates/4WebHelp2/images/offline.gif) ![View User's Profile View User's Profile](templates/4WebHelp2/images/lang_english/icon_profile.gif) ![Find all posts by Daniel Find all posts by Daniel](templates/4WebHelp2/images/lang_english/icon_search.gif) ![Send Personal Message Send Personal Message](templates/4WebHelp2/images/lang_english/icon_pm.gif) |
![](images/spacer.gif) |
domuk
WebHelper
![WebHelper WebHelper](images/rank_2.gif)
Joined: 15 Jan 2004
Posts: 91
|
Posted:
Thu Mar 11, 2004 6:51 pm (20 years, 1 month ago) |
![Reply with Quote Reply with Quote](templates/4WebHelp2/images/lang_english/icon_quote.gif) ![Back to Top Back to Top](templates/4WebHelp2/images/icon_up.gif) |
Thanks Daniel,
I seem to recall that you were and are an expert in PHPBB....
I have not touched the site in weeks, therefore how could this happen and more to the point what can i do about it?
Thanks again,
Dom..
(Ps i went with 34sp.com for hosting and i think they are very good so far, so thanks for all your advice on that also.. ) |
|
|
![Offline](templates/4WebHelp2/images/offline.gif) ![View User's Profile View User's Profile](templates/4WebHelp2/images/lang_english/icon_profile.gif) ![Find all posts by domuk Find all posts by domuk](templates/4WebHelp2/images/lang_english/icon_search.gif) ![Send Personal Message Send Personal Message](templates/4WebHelp2/images/lang_english/icon_pm.gif) |
![](images/spacer.gif) |
Daniel
Team Member
![](images/rank_6.gif)
![](http://www.4webhelp.net/forums/images/daniel_avatar.php)
Joined: 06 Jan 2002
Posts: 2564
|
Posted:
Thu Mar 11, 2004 7:56 pm (20 years, 1 month ago) |
![Reply with Quote Reply with Quote](templates/4WebHelp2/images/lang_english/icon_quote.gif) ![Back to Top Back to Top](templates/4WebHelp2/images/icon_up.gif) |
Login to Plesk, go into PhpMyAdmin (http://www.4webhelp.net/faqs/read/49/) and see if the table(s) is/are still there. |
________________________________
![Image Image](http://www.4webhelp.net/images/daniel_sig.gif) |
|
![Offline](templates/4WebHelp2/images/offline.gif) ![View User's Profile View User's Profile](templates/4WebHelp2/images/lang_english/icon_profile.gif) ![Find all posts by Daniel Find all posts by Daniel](templates/4WebHelp2/images/lang_english/icon_search.gif) ![Send Personal Message Send Personal Message](templates/4WebHelp2/images/lang_english/icon_pm.gif) |
![](images/spacer.gif) |
domuk
WebHelper
![WebHelper WebHelper](images/rank_2.gif)
Joined: 15 Jan 2004
Posts: 91
|
Posted:
Fri Mar 12, 2004 9:09 am (20 years, 1 month ago) |
![Reply with Quote Reply with Quote](templates/4WebHelp2/images/lang_english/icon_quote.gif) ![Back to Top Back to Top](templates/4WebHelp2/images/icon_up.gif) |
The tables are not there .
I assume that when the PHPBB was working, they had to be there.
How could this have happened?
How can i fix it?
Could you point me in the direction of a beginners guide to Database usage with PHP (mysql)?
Thanks,
Dom. |
|
|
![Offline](templates/4WebHelp2/images/offline.gif) ![View User's Profile View User's Profile](templates/4WebHelp2/images/lang_english/icon_profile.gif) ![Find all posts by domuk Find all posts by domuk](templates/4WebHelp2/images/lang_english/icon_search.gif) ![Send Personal Message Send Personal Message](templates/4WebHelp2/images/lang_english/icon_pm.gif) |
![](images/spacer.gif) |
adam
Forum Moderator & Developer
![](images/rank_6.gif)
Joined: 26 Jul 2002
Posts: 704
Location: UK
|
Posted:
Fri Mar 12, 2004 11:15 am (20 years, 1 month ago) |
![Reply with Quote Reply with Quote](templates/4WebHelp2/images/lang_english/icon_quote.gif) ![Back to Top Back to Top](templates/4WebHelp2/images/icon_up.gif) |
if you've made a backup, you can restore the table from there...otherwise, contact the host and find out if they have a backup (though many hosts won't). |
________________________________ It's turtles all the way down... |
|
![Offline](templates/4WebHelp2/images/offline.gif) ![View User's Profile View User's Profile](templates/4WebHelp2/images/lang_english/icon_profile.gif) ![Find all posts by adam Find all posts by adam](templates/4WebHelp2/images/lang_english/icon_search.gif) ![Send Personal Message Send Personal Message](templates/4WebHelp2/images/lang_english/icon_pm.gif) ![Visit Poster's Website Visit Poster's Website](templates/4WebHelp2/images/lang_english/icon_www.gif) |
![](images/spacer.gif) |
domuk
WebHelper
![WebHelper WebHelper](images/rank_2.gif)
Joined: 15 Jan 2004
Posts: 91
|
Posted:
Fri Mar 12, 2004 11:38 am (20 years, 1 month ago) |
![Reply with Quote Reply with Quote](templates/4WebHelp2/images/lang_english/icon_quote.gif) ![Back to Top Back to Top](templates/4WebHelp2/images/icon_up.gif) |
How could this have happened when no-one has used ftp on this site for a number of weeks?
They have had a server go down recently. Could this be the reason why the tables are gone from the data base or could it be some kind of auto-archive setting in the phpbb software?
If they don't have a back-up, do I have to reinstall software or can I create a new table in the PhpMyAdmin area?
If I can create a table could you let me know how to set it up to work with phpbb.
Also how do I back-up the data base so this doesn't happen in the future?
Thanks Adam&Daniel-your help is appreciated
Dom |
|
|
![Offline](templates/4WebHelp2/images/offline.gif) ![View User's Profile View User's Profile](templates/4WebHelp2/images/lang_english/icon_profile.gif) ![Find all posts by domuk Find all posts by domuk](templates/4WebHelp2/images/lang_english/icon_search.gif) ![Send Personal Message Send Personal Message](templates/4WebHelp2/images/lang_english/icon_pm.gif) |
![](images/spacer.gif) |
adam
Forum Moderator & Developer
![](images/rank_6.gif)
Joined: 26 Jul 2002
Posts: 704
Location: UK
|
Posted:
Fri Mar 12, 2004 12:02 pm (20 years, 1 month ago) |
![Reply with Quote Reply with Quote](templates/4WebHelp2/images/lang_english/icon_quote.gif) ![Back to Top Back to Top](templates/4WebHelp2/images/icon_up.gif) |
yes, this could be something to do with the server going down. You should be able to manually re-create the table, but I'm not entirely sure what you would need to include in it since I don't have much experience with phpBB (other than simply posting on it ) |
________________________________ It's turtles all the way down... |
|
![Offline](templates/4WebHelp2/images/offline.gif) ![View User's Profile View User's Profile](templates/4WebHelp2/images/lang_english/icon_profile.gif) ![Find all posts by adam Find all posts by adam](templates/4WebHelp2/images/lang_english/icon_search.gif) ![Send Personal Message Send Personal Message](templates/4WebHelp2/images/lang_english/icon_pm.gif) ![Visit Poster's Website Visit Poster's Website](templates/4WebHelp2/images/lang_english/icon_www.gif) |
![](images/spacer.gif) |
Daniel
Team Member
![](images/rank_6.gif)
![](http://www.4webhelp.net/forums/images/daniel_avatar.php)
Joined: 06 Jan 2002
Posts: 2564
|
Posted:
Fri Mar 12, 2004 2:01 pm (20 years, 1 month ago) |
![Reply with Quote Reply with Quote](templates/4WebHelp2/images/lang_english/icon_quote.gif) ![Back to Top Back to Top](templates/4WebHelp2/images/icon_up.gif) |
Run the following SQL queries in phpMyAdmin to recreate an empty phpBB board:
http://cvs.sourceforge.net/viewcvs.py/*checkout*/phpbb/phpBB2/install/schemas/mysql_schema.sql?content-type=text%2Fplain&rev=1.35.2.7
http://cvs.sourceforge.net/viewcvs.py/*checkout*/phpbb/phpBB2/install/schemas/Attic/mysql_basic.sql?content-type=text%2Fplain&rev=1.29.2.6
The default username & password are:
Admin - admin
Make sure you change the password!
Also go into the General Configuration area in the Admin Panel to modify the appropriate values. |
________________________________
![Image Image](http://www.4webhelp.net/images/daniel_sig.gif) |
|
![Offline](templates/4WebHelp2/images/offline.gif) ![View User's Profile View User's Profile](templates/4WebHelp2/images/lang_english/icon_profile.gif) ![Find all posts by Daniel Find all posts by Daniel](templates/4WebHelp2/images/lang_english/icon_search.gif) ![Send Personal Message Send Personal Message](templates/4WebHelp2/images/lang_english/icon_pm.gif) |
![](images/spacer.gif) |
domuk
WebHelper
![WebHelper WebHelper](images/rank_2.gif)
Joined: 15 Jan 2004
Posts: 91
|
Posted:
Tue Apr 06, 2004 7:26 pm (20 years ago) |
![Reply with Quote Reply with Quote](templates/4WebHelp2/images/lang_english/icon_quote.gif) ![Back to Top Back to Top](templates/4WebHelp2/images/icon_up.gif) |
Thanks again Daniel for your help..
I have just tried your suggestions and they have worked....
Thanks,
Dom. |
|
|
![Offline](templates/4WebHelp2/images/offline.gif) ![View User's Profile View User's Profile](templates/4WebHelp2/images/lang_english/icon_profile.gif) ![Find all posts by domuk Find all posts by domuk](templates/4WebHelp2/images/lang_english/icon_search.gif) ![Send Personal Message Send Personal Message](templates/4WebHelp2/images/lang_english/icon_pm.gif) |
![](images/spacer.gif) |
domuk
WebHelper
![WebHelper WebHelper](images/rank_2.gif)
Joined: 15 Jan 2004
Posts: 91
|
Posted:
Wed Apr 07, 2004 9:18 am (20 years ago) |
![Reply with Quote Reply with Quote](templates/4WebHelp2/images/lang_english/icon_quote.gif) ![Back to Top Back to Top](templates/4WebHelp2/images/icon_up.gif) |
Hi Daniel,
I was setting up the PHPBB last night when my ISP kicked me off the net. I was in administrator mode at the time and did not have the time to logout.
Now when I went back to it appears not to be working properly.
I try and log in and it gives me a:
Bad Gateway
The following error occurred:
[code=DNS_HOST_NOT_FOUND] The host name was not found during the DNS lookup. Contact your system administrator if the problem is not found by retrying the URL.
--------------------------------------------------------------------------------
Please contact the administrator.
The strange thing is that if you then try and say check
your messages it has logged you in and you can check them.
Do you understand my explanation?
Do you know how to fix it?
Ps. I don't think I tried to log out once I had logged in with a new admin password. (so it worked at least once, which leads me to believe that the problem started following the kick off from my ISP) |
|
|
![Offline](templates/4WebHelp2/images/offline.gif) ![View User's Profile View User's Profile](templates/4WebHelp2/images/lang_english/icon_profile.gif) ![Find all posts by domuk Find all posts by domuk](templates/4WebHelp2/images/lang_english/icon_search.gif) ![Send Personal Message Send Personal Message](templates/4WebHelp2/images/lang_english/icon_pm.gif) |
![](images/spacer.gif) |
Daniel
Team Member
![](images/rank_6.gif)
![](http://www.4webhelp.net/forums/images/daniel_avatar.php)
Joined: 06 Jan 2002
Posts: 2564
|
Posted:
Wed Apr 07, 2004 4:16 pm (20 years ago) |
![Reply with Quote Reply with Quote](templates/4WebHelp2/images/lang_english/icon_quote.gif) ![Back to Top Back to Top](templates/4WebHelp2/images/icon_up.gif) |
What's your board's address? I'm wondering if the board URL fields aren't filled in correctly in the Configuration area... |
________________________________
![Image Image](http://www.4webhelp.net/images/daniel_sig.gif) |
|
![Offline](templates/4WebHelp2/images/offline.gif) ![View User's Profile View User's Profile](templates/4WebHelp2/images/lang_english/icon_profile.gif) ![Find all posts by Daniel Find all posts by Daniel](templates/4WebHelp2/images/lang_english/icon_search.gif) ![Send Personal Message Send Personal Message](templates/4WebHelp2/images/lang_english/icon_pm.gif) |
![](images/spacer.gif) |
domuk
WebHelper
![WebHelper WebHelper](images/rank_2.gif)
Joined: 15 Jan 2004
Posts: 91
|
Posted:
Wed Apr 07, 2004 6:00 pm (20 years ago) |
![Reply with Quote Reply with Quote](templates/4WebHelp2/images/lang_english/icon_quote.gif) ![Back to Top Back to Top](templates/4WebHelp2/images/icon_up.gif) |
removed by dom |
Last edited by domuk on Sun Apr 11, 2004 7:57 am, edited 1 time in total |
|
![Offline](templates/4WebHelp2/images/offline.gif) ![View User's Profile View User's Profile](templates/4WebHelp2/images/lang_english/icon_profile.gif) ![Find all posts by domuk Find all posts by domuk](templates/4WebHelp2/images/lang_english/icon_search.gif) ![Send Personal Message Send Personal Message](templates/4WebHelp2/images/lang_english/icon_pm.gif) |
![](images/spacer.gif) |
Daniel
Team Member
![](images/rank_6.gif)
![](http://www.4webhelp.net/forums/images/daniel_avatar.php)
Joined: 06 Jan 2002
Posts: 2564
|
Posted:
Wed Apr 07, 2004 6:15 pm (20 years ago) |
![Reply with Quote Reply with Quote](templates/4WebHelp2/images/lang_english/icon_quote.gif) ![Back to Top Back to Top](templates/4WebHelp2/images/icon_up.gif) |
Yes, that's the problem. Go into your database (via phpMyAdmin) and modify the field which contains "myserver.tld" in the phpbb_config table. |
________________________________
![Image Image](http://www.4webhelp.net/images/daniel_sig.gif) |
|
![Offline](templates/4WebHelp2/images/offline.gif) ![View User's Profile View User's Profile](templates/4WebHelp2/images/lang_english/icon_profile.gif) ![Find all posts by Daniel Find all posts by Daniel](templates/4WebHelp2/images/lang_english/icon_search.gif) ![Send Personal Message Send Personal Message](templates/4WebHelp2/images/lang_english/icon_pm.gif) |
![](images/spacer.gif) |
domuk
WebHelper
![WebHelper WebHelper](images/rank_2.gif)
Joined: 15 Jan 2004
Posts: 91
|
Posted:
Wed Apr 07, 2004 6:48 pm (20 years ago) |
![Reply with Quote Reply with Quote](templates/4WebHelp2/images/lang_english/icon_quote.gif) ![Back to Top Back to Top](templates/4WebHelp2/images/icon_up.gif) |
to what?
the database server of my host? |
|
|
![Offline](templates/4WebHelp2/images/offline.gif) ![View User's Profile View User's Profile](templates/4WebHelp2/images/lang_english/icon_profile.gif) ![Find all posts by domuk Find all posts by domuk](templates/4WebHelp2/images/lang_english/icon_search.gif) ![Send Personal Message Send Personal Message](templates/4WebHelp2/images/lang_english/icon_pm.gif) |
![](images/spacer.gif) |
|