Jump to content


Photo

php,mysql error


  • Please log in to reply
9 replies to this topic

#1 Ressurrector

Ressurrector
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 17 September 2006 - 12:02 AM

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.

#2 JustinMs66@hotmail.com

JustinMs66@hotmail.com
  • Members
  • PipPipPip
  • Advanced Member
  • 138 posts

Posted 17 September 2006 - 12:50 AM

you need to tell us what code is on those lines.

#3 Ressurrector

Ressurrector
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 17 September 2006 - 01:03 AM

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

#4 markbett

markbett
  • Members
  • PipPipPip
  • Advanced Member
  • 133 posts

Posted 17 September 2006 - 01:22 AM

ok then create the table??

#5 Ressurrector

Ressurrector
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 17 September 2006 - 02:51 AM

ok then create the table??



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

#6 wildteen88

wildteen88
  • Staff Alumni
  • Advanced Member
  • 10,482 posts
  • LocationUK, Bournemouth

Posted 17 September 2006 - 01:27 PM

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.

#7 Ressurrector

Ressurrector
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 17 September 2006 - 05:59 PM

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.


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.

#8 Ressurrector

Ressurrector
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 17 September 2006 - 06:49 PM

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?

#9 Ressurrector

Ressurrector
  • New Members
  • Pip
  • Newbie
  • 6 posts

Posted 21 September 2006 - 07:39 PM

guys any suggestions?          help?

#10 mrparanoid

mrparanoid
  • New Members
  • Pip
  • Newbie
  • 8 posts

Posted 11 October 2006 - 10:40 PM

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




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users