| :: |
| Author |
Message |
stewaia
Joined: 09 Nov 2007
Posts: 8
|
 Posted: Fri Nov 09, 2007 5:26 am Post subject: Board Error |
|
|
Hello, I tried to install the dynamic meta tags mod on this site manually and after I went through step by step my forum went down and is now looking for the install file. I went back and carefully replaced all that I added and it still is looking for the install file. Please help me..
My forum: http://www.thestocktalk.net
Thank you very much! |
|
|
| Back to top |
|
 |
|
|
SeO
Administrateur - Site Admin
Joined: 15 Mar 2006
Posts: 3477
|
|
| Back to top |
|
|
stewaia
Joined: 09 Nov 2007
Posts: 8
|
| Posted: Sat Nov 10, 2007 2:31 am Post subject: Re: Board Error |
|
|
Ok, my config file was blank. I'm not sure if you would know about this but after I filled in the config file I got this error:
General Error
SQL ERROR [ mysql4 ]
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '/config WHERE is_dynamic = 1' at line 2 [1064]
An sql error occurred while fetching this page. Please contact an administrator if this problem persists.
Any help would be appreciated! Thank you for your help so far! |
|
|
| Back to top |
|
|
dcz
Administrateur - Site Admin
Joined: 28 Apr 2006
Posts: 14279
|
| Posted: Sat Nov 10, 2007 3:16 pm Post subject: Re: Board Error |
|
|
| stewaia wrote: | Ok, my config file was blank. I'm not sure if you would know about this but after I filled in the config file I got this error:
General Error
SQL ERROR [ mysql4 ] |
How did that happened ?
The config.php file should never be altered once the forum is installed.
I don't see how the dynamic meta tag could be involved in this.
Anyway, what did you put in the config.php file ?
The error seems to suggest that you have entered "/" as the table prefix.
++ |
_________________
Useful links :
SEO Forum || SEO Directory || SEO phpBB || SEO phpBB3 || Search
____________________
Liens Utiles :
Forum référencement || Annuaire référencement || Référencement phpBB || Référencement phpBB3 || Recherche |
|
| Back to top |
|
|
stewaia
Joined: 09 Nov 2007
Posts: 8
|
| Posted: Sat Nov 10, 2007 4:57 pm Post subject: Re: Board Error |
|
|
I also posted on the phpbb forum about this and was instructed to re-create my config file in order to fix it. Here is the link to the other thread:
http://www.phpbb.com/community/viewtopic.php?f=46&t=589926
So I used the link he gave me to re-create it and I did put / for the table prefix. I guess I misunderstood the meaning of it because when I used the default phpbb_ for the table prefix it tells me that the table doesn't exist.
Here is what's in my config file:
| Code: | <?php
// phpBB 3.0.x auto-generated configuration file
// Do not change anything in this file!
$dbms = 'mysql'; //database type it may not be mysql
$dbhost = 'xxxxxxx';
$dbport = 'database port if not default';
$dbname = 'xxxxx';
$dbuser = 'xxxx';
$dbpasswd = 'xxxxxx';
$table_prefix = 'phpbb_';
$acm_type = 'file';
$load_extensions = '';
@define('PHPBB_INSTALLED', true);
//@define('DEBUG', true);
//@define('DEBUG_EXTRA', true);
?> |
Thank you so much for your help so far! |
|
|
| Back to top |
|
|
SeO
Administrateur - Site Admin
Joined: 15 Mar 2006
Posts: 3477
|
| Posted: Sat Nov 10, 2007 5:20 pm Post subject: Re: Board Error |
|
|
All right, I removed the potentially "sensible data from your post, such as db login and server. Even though the password was hidden, it's till better not to provide with any information about your db.
So, two things, first :
| Code: | | $dbport = 'database port if not default'; |
Should most likely be :
Since chances are not great that your db server do not uses the default port. If not so, your host should be able to tell you what port to set in.
Then, if it "tells" you that the table doesn't exist, it can ever be because phpBB3 is not installed at all or because you did not use phpbb_ as table prefix when you installed it. You should have a db access with phpmyadmin for your web account, and be able to check the table prefix from there as well as to make sure the phpBB3 table do exist. |
_________________
phpBB SEO || SEO Forum || Forum Référencement
GYM Sitemap & RSS for phpBB3 has been released ! || GYM Sitemap & RSS for phpBB3 est disponible ! |
|
| Back to top |
|
|
stewaia
Joined: 09 Nov 2007
Posts: 8
|
| Posted: Sat Nov 10, 2007 6:06 pm Post subject: Re: Board Error |
|
|
| Thanks for the censoring. I've never used phpmyadmin before. My database is on godaddy. Can I still use phpmyadmin to find that information? |
|
|
| Back to top |
|
|
SeO
Administrateur - Site Admin
Joined: 15 Mar 2006
Posts: 3477
|
|
| Back to top |
|
|
stewaia
Joined: 09 Nov 2007
Posts: 8
|
| Posted: Sat Nov 10, 2007 6:11 pm Post subject: Re: Board Error |
|
|
Yes, I had my forum installed and running. I'm really not sure how editing the files specified by the mod could cause this to happen.
I found on godaddy where they gave me something familiar and they gave me this:
| Code: | <?php
//Connect To Database
$hostname='p50mysql49.secureserver.net';
$username='*****';
$password='your password';
$dbname='*****';
$usertable='your_tablename';
$yourfield = 'your_field';
mysql_connect($hostname,$username, $password) OR DIE ('Unable to connect to database! Please try again later.');
mysql_select_db($dbname);
$query = 'SELECT * FROM $usertable';
$result = mysql_query($query);
if($result) {
while($row = mysql_fetch_array($result)){
$name = $row['$yourfield'];
echo 'Name: '.$name;
}
}
?> |
|
|
|
| Back to top |
|
|
SeO
Administrateur - Site Admin
Joined: 15 Mar 2006
Posts: 3477
|
| Posted: Sat Nov 10, 2007 6:17 pm Post subject: Re: Board Error |
|
|
hacking could explain, but it's not very likely in this case, wrong file manipulation as well, but config.php is not touched by the dynamic meta tag, so ...
Who knows, what matters now is to find a way to go back online. Do you have a backup to grab the file from ?
Do you remember the table prefix you used upon install ? phpbb3_ ? worth giving a try. |
_________________
phpBB SEO || SEO Forum || Forum Référencement
GYM Sitemap & RSS for phpBB3 has been released ! || GYM Sitemap & RSS for phpBB3 est disponible ! |
|
| Back to top |
|
|
stewaia
Joined: 09 Nov 2007
Posts: 8
|
| Posted: Sat Nov 10, 2007 6:28 pm Post subject: Re: Board Error |
|
|
From what I remember I thought that phpbb3 defined its' own table prefix. I remember a step during the install that said something along the lines of table prefixes defined or something like that and I don't remember ever specifying the name.
It's not phpbb3_..good thinking though..
I have a downloaded backup file, Is there any way to use that? |
|
|
| Back to top |
|
|
stewaia
Joined: 09 Nov 2007
Posts: 8
|
| Posted: Sat Nov 10, 2007 9:43 pm Post subject: Re: Board Error |
|
|
Ok, So I got into phpmyadmin through godaddy and I can't find any prefixes. I've tried the ones that look like prefixes such as facl_ and fconfig, but no luck. Here is a picture of what I'm looking at let me know if you have any ideas..
 |
|
|
| Back to top |
|
|
SeO
Administrateur - Site Admin
Joined: 15 Mar 2006
Posts: 3477
|
|
| Back to top |
|
|
stewaia
Joined: 09 Nov 2007
Posts: 8
|
| Posted: Sun Nov 11, 2007 4:03 am Post subject: Re: Board Error |
|
|
YAYAYAYAYAYAYAYAY!!!!!!!!!!
I really can't thank you enough!!!
It's working by the way.. |
|
|
| Back to top |
|
|
|
|
