Jump to content

Archived

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

fhripper

Help with PHP and IB forums

Recommended Posts

Hi Guys,

PLease bare with me as im new to this and still learning

but heres my so called forums link

[a href=\"http://www.clublan.info/forums/\" target=\"_blank\"]http://www.clublan.info/forums/[/a]

as you find the following issue

Warning: mysql_connect(): Client does not support authentication protocol requested by server; consider upgrading MySQL client in /var/virtual/web/w0653/html/forums/sources/Drivers/mySQL.php on line 64

Warning: mysql_select_db(): supplied argument is not a valid MySQL-Link resource in /var/virtual/web/w0653/html/forums/sources/Drivers/mySQL.php on line 67
ERROR: Cannot find database
Warning: mysql_query(): supplied argument is not a valid MySQL-Link resource in /var/virtual/web/w0653/html/forums/sources/Drivers/mySQL.php on line 100

Now this is a problem as my host just changed servers to the optus data center my host is smarty.

I have tryed to contact but seems they a re very busy and wont get back in touch with me..

Anyone have any ideas how i can fix this issue i dont wanna loose my forums as there were a few registed member sna a few threads.

anyone help pleasee...

Cheers

Tim

Share this post


Link to post
Share on other sites
All the errors you are getting are caused by the first error message. Once the first error message is solved all the other errors will disappear.


To solve this error you will need set the password for your mysql username with the OLD_PASSWORD function.

You can do this via the command line/shell if you have access to this. If you dont then ask you host to set your mysql password with the OLD_PASSWORD function.

[a href=\"http://dev.mysql.com/doc/refman/5.0/en/old-client.html\" target=\"_blank\"]Click here[/a] for more information on how to set your mysql passord with the OLD_PASSWORD function.

Share this post


Link to post
Share on other sites
[!--quoteo(post=375177:date=May 19 2006, 08:38 PM:name=wildteen88)--][div class=\'quotetop\']QUOTE(wildteen88 @ May 19 2006, 08:38 PM) [snapback]375177[/snapback][/div][div class=\'quotemain\'][!--quotec--]
All the errors you are getting are caused by the first error message. Once the first error message is solved all the other errors will disappear.
To solve this error you will need set the password for your mysql username with the OLD_PASSWORD function.

You can do this via the command line/shell if you have access to this. If you dont then ask you host to set your mysql password with the OLD_PASSWORD function.

[a href=\"http://dev.mysql.com/doc/refman/5.0/en/old-client.html\" target=\"_blank\"]Click here[/a] for more information on how to set your mysql passord with the OLD_PASSWORD function.
[/quote]


Im sorry but i have no idea how to do this ...

I cannot contact my host as there useless and this is driving me crazy ..

im with smarty host

Could you explained it a little easyer on what i have to doo

Share this post


Link to post
Share on other sites
Ok ifound a SQL qury box in PHP my admin for the server

this is the responce i got

#1064 - 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 'mysql> SET PASSWORD FOR
-> 'w0653@localhost' = OLD_PASSWORD

update

i was able to run

SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass');

and it said it was fine

but still issues with site...

Share this post


Link to post
Share on other sites
You should use this query:
[code]SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass');[/code]
Make sure that you change where it says [b]some_user[/b] is changed to your actuall mysql username and [b]some_host[/b] is changed to [b]localhost[/b]. Then type in your actual password where it says [b]mypass[/b]

That should sort out your problem. If it doesn't then there isn't anything else you can do AFAIK. In order for this problem to be sorted out you will need to get in contact with your host to sort the problem out.

What I find strange is that you can use phpMyAdmin but you cant use IPB!

Share this post


Link to post
Share on other sites
[!--quoteo(post=375237:date=May 20 2006, 12:47 AM:name=wildteen88)--][div class=\'quotetop\']QUOTE(wildteen88 @ May 20 2006, 12:47 AM) [snapback]375237[/snapback][/div][div class=\'quotemain\'][!--quotec--]
You should use this query:
[code]SET PASSWORD FOR 'some_user'@'some_host' = OLD_PASSWORD('mypass');[/code]
Make sure that you change where it says [b]some_user[/b] is changed to your actuall mysql username and [b]some_host[/b] is changed to [b]localhost[/b]. Then type in your actual password where it says [b]mypass[/b]

That should sort out your problem. If it doesn't then there isn't anything else you can do AFAIK. In order for this problem to be sorted out you will need to get in contact with your host to sort the problem out.

What I find strange is that you can use phpMyAdmin but you cant use IPB!
[/quote]

I have done this and it tlls me to reload privages.

do i have to login to complete this.. (login into mysql)
is there a command i need to login with

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.