Jump to content

Archived

This topic is now archived and is closed to further replies.

Ressurrector

php,mysql error

Recommended Posts

What happened is I had two php forums on a site that was free hosted. I have restored the site(another host) but I can't seem to get the forums to work. Maybe someone here can decyper this and tell me what I am doin wrong


Warning: mysql_connect() [function.mysql-connect]: Access denied for user 'ressurre_phpbb2'@'localhost' (using password: YES) in /home/studioan/public_html/phpBB/db/mysql4.php on line 48

Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/studioan/public_html/phpBB/db/mysql4.php on line 330

Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/studioan/public_html/phpBB/db/mysql4.php on line 331
phpBB : Critical Error

Could not connect to the database


I have got in files and changed passwords but seems I am doin something very wrong. Hope yall can help.

Share this post


Link to post
Share on other sites
ok I just edited the config.php  file for a new db and got this

phpBB : Critical Error

Could not query config information

DEBUG MODE

SQL Error : 1146 Table 'studioan_james.phpbb_config' doesn't exist

SELECT * FROM phpbb_config

Line : 219
File : common.php

Share this post


Link to post
Share on other sites
[quote author=markbett link=topic=108343.msg435853#msg435853 date=1158456174]
ok then create the table??
[/quote]


Ok in phpmyadmin make a table. Ok I don't have a clue what value to put on this.  ummm help  lol.

Share this post


Link to post
Share on other sites
Did you make backups of your phpBB database from your other host, before you moved to your new host? If you did then you need to restore the database with your Backup you made. Therer is no point in recreated the tables as your phpBB forum will fail to work still.

If you ahve not backup of the database then you need to make a fresh install of your phpBB forum.

Share this post


Link to post
Share on other sites
[quote author=wildteen88 link=topic=108343.msg435989#msg435989 date=1158499658]
Did you make backups of your phpBB database from your other host, before you moved to your new host? If you did then you need to restore the database with your Backup you made. Therer is no point in recreated the tables as your phpBB forum will fail to work still.

If you ahve not backup of the database then you need to make a fresh install of your phpBB forum.
[/quote]

Well I backed up the site through cpanelx.    Now the forums files are there from what I can tell.  Now moving to a new server you would have to change the database names if I'm right and I did that in config.php to reflect that. I told my host to restore my files like 3 times and they didn't so I just zipped up everything and unzipped on my new hosting through cpanelx. Site is back but forums are not so I edited a config file and made a new database user to that database and pass and directed config to that. Ya know its very possible I didn't back up something I needed but think.  I got it all and hate to reinstall.  Ok maybe I did back up what is needed I have a file called phpbb2.gz file by itself inside is a single file. Also have a phpbb1.gz. Is this a Mysql backup?  These files are not part of the main site backup zip file.

Share this post


Link to post
Share on other sites
Ok just tryed backing up the .gz files in phpmyadmin. After each is done it acknowledges it with a message for example "import has been successfully finished, 1437 queries executed"      though I can't tell it has done anything and forums still don't work. Did I miss something?

Share this post


Link to post
Share on other sites
That's phpbb right? I guess ur problem comes with the config.php file,

Please check if your mysql server address is ok, it might not always be "localhost", it can be another address or some ip address.

Give me some feedback about it.

Cheers

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.