Comment Box system

Bouzy210

I am making a comment box system (basically a shout box) for my site. I did get my form boxes to render (I am good with xhtml and css) but then I realized it didn't work. Now I have it to the point where I just get an error message. If you need to see my code let me know but hear is the error...

http://www.goldfishgraphicshome.com/Orangebox/tutorials.php

If that link doesn't work try

http://www.goldfishgraphicshome.com/Orangebox/index.php

then click on tutorials.

I am rather new to php so I really just copied and pasted a lot of code, but I did it carefully and can understand most php just not write it well. I hope to get better but I really need this system to work.

YAOMK

A simple google search for your error message returned this as the first result:

http://dev.mysql.com/doc/refman/5.0/en/old-client.html

Bouzy210

Acually I had found that earlier but I don't really understand it. Is it saying basically its a problem with my mysql not my code? SO I need to change my password? Not the one in my code though? mhhh could you explain it please (I should have updated versions of things like that because I have godaddy hosting.

YAOMK

You can solve it by running the following in the mysql rdbms.

SET PASSWORD FOR user@localhost = OLD_PASSWORD('password');

But since you are on a shared host, you should contact godaddy.com's support and have them fix the issue for you. The issue is that the mysql client's authentication protocol is not compatible with the rdbms server's authentication protocol in that particular machine. The script above simply tells the rdbms to treat your password (the one set by through the mysql client with the older authentication protocol) using backward compatibility by means of the older, deprecated authentication protocol.

I came across a discussion on the issue. Users said godaddy.com staff advice them to switch from windows to linux, and that this solved their problems. I'm not sure why godaddy would take this approach to fix a configuration issue, but I like linux better so, I'm not opposed to the initiative 🙂