Gossamer Forum
Home : Products : Gossamer Links : Discussions :

HELP!! I have an emergency!

Quote Reply
HELP!! I have an emergency!
I just had mySQL upgraded on my server to version 2.23. Our server provider (Adgrafix.com) did the upgrade. Now I am getting this error message when I try to do a search:

A fatal error has occured:

Can't call method "prepare" without a package or object reference at /opt/botcw/httpd/cgi-bin/se/admin/GT/SQL/Driver/MYSQL.pm line 36.

I received this email from my server provider:
Please note that with the upgarde to MySql 3.23.32, it's not possible to convert the mysql priviliges table to the format of 3.23.32. I have created the mysql root user with the mysql root password. If there are any more usr, you will need to re-create them
-----------

Can anyone tell me what I need to do to get Links working again. I'm not very familiar with mySQL.

Thanks,

Jeff White
http://www.botcw.com


Best of the Christian Web
http://www.botcw.com
Quote Reply
Re: HELP!! I have an emergency! In reply to
As far as I know, that error isn't to do with the upgrade of mysql but I need someone to back me up.

Try replacing MYSQL.pm with a new copy or upgrade to 2.0.3 to see if that fixes it.

Paul Wilson.
Installations:
http://www.wiredon.net/gt/
Quote Reply
Re: HELP!! I have an emergency! In reply to
Paul, Links was working perfectly before the upgrade and I have not changed anything within Links. I think I may need to add a new user to mySQL that was trasnferred over in the upgrade. Can you tell me how to add a new user to mySQL.

Jeff

Best of the Christian Web
http://www.botcw.com
Quote Reply
Re: HELP!! I have an emergency! In reply to
Your host will have to do it unless you have root access.

IF you are allowed to do it.....Login to your telnet account and then into mysql:

shell> mysql -uUSERNAME -pPASSWORD

mysql> GRANT SELECT,INSERT,UPDATE,DELETE,DROP,CREATE,ALTER ON DB_NAME.* TO username@localhost IDENTIFIED BY 'PASSWORD';

mysql> FLUSH PRIVILEGES;

Paul Wilson.
Installations:
http://www.wiredon.net/gt/
Quote Reply
Re: HELP!! I have an emergency! In reply to
Paul, thanks. Did that and now I am getting this output when I do a search:

Unknown Tag: 'Title'(Added: Unknown Tag: 'Add_Date' Hits: Unknown Tag: 'Hits' User Rating: Unknown Tag: 'Rating' Votes: Unknown Tag: 'Votes') Rate It
Send this link to a friend!

You can see what it does at this link:
http://www.botcw.com/cgi-bin/se/search.cgi?query=books&mh=25&bool=and&substring=0



Best of the Christian Web
http://www.botcw.com