Ressurrector Posted September 17, 2006 Share Posted September 17, 2006 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 wrongWarning: 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 48Warning: mysql_error(): supplied argument is not a valid MySQL-Link resource in /home/studioan/public_html/phpBB/db/mysql4.php on line 330Warning: mysql_errno(): supplied argument is not a valid MySQL-Link resource in /home/studioan/public_html/phpBB/db/mysql4.php on line 331phpBB : Critical ErrorCould not connect to the databaseI have got in files and changed passwords but seems I am doin something very wrong. Hope yall can help. Quote Link to comment https://forums.phpfreaks.com/topic/21019-phpmysql-error/ Share on other sites More sharing options...
JustinMs66@hotmail.com Posted September 17, 2006 Share Posted September 17, 2006 you need to tell us what code is on those lines. Quote Link to comment https://forums.phpfreaks.com/topic/21019-phpmysql-error/#findComment-93313 Share on other sites More sharing options...
Ressurrector Posted September 17, 2006 Author Share Posted September 17, 2006 ok I just edited the config.php file for a new db and got thisphpBB : Critical ErrorCould not query config informationDEBUG MODESQL Error : 1146 Table 'studioan_james.phpbb_config' doesn't existSELECT * FROM phpbb_configLine : 219File : common.php Quote Link to comment https://forums.phpfreaks.com/topic/21019-phpmysql-error/#findComment-93326 Share on other sites More sharing options...
markbett Posted September 17, 2006 Share Posted September 17, 2006 ok then create the table?? Quote Link to comment https://forums.phpfreaks.com/topic/21019-phpmysql-error/#findComment-93336 Share on other sites More sharing options...
Ressurrector Posted September 17, 2006 Author Share Posted September 17, 2006 [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. Quote Link to comment https://forums.phpfreaks.com/topic/21019-phpmysql-error/#findComment-93365 Share on other sites More sharing options...
wildteen88 Posted September 17, 2006 Share Posted September 17, 2006 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 Link to comment https://forums.phpfreaks.com/topic/21019-phpmysql-error/#findComment-93467 Share on other sites More sharing options...
Ressurrector Posted September 17, 2006 Author Share Posted September 17, 2006 [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. Quote Link to comment https://forums.phpfreaks.com/topic/21019-phpmysql-error/#findComment-93592 Share on other sites More sharing options...
Ressurrector Posted September 17, 2006 Author Share Posted September 17, 2006 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? Quote Link to comment https://forums.phpfreaks.com/topic/21019-phpmysql-error/#findComment-93620 Share on other sites More sharing options...
Ressurrector Posted September 21, 2006 Author Share Posted September 21, 2006 guys any suggestions? help? Quote Link to comment https://forums.phpfreaks.com/topic/21019-phpmysql-error/#findComment-96275 Share on other sites More sharing options...
mrparanoid Posted October 11, 2006 Share Posted October 11, 2006 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 Quote Link to comment https://forums.phpfreaks.com/topic/21019-phpmysql-error/#findComment-107641 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.