Gossamer Forum
Home : Products : Gossamer Links : Discussions :

More problems with bsd move

Quote Reply
More problems with bsd move
I recently moved from linux to bsd and I'm having some more problems. I think I've got all of the mysql modules installed but something is still going wrong. I'm getting a fatal error when I try to run in dynamic mode:
A fatal error has occured:

Can't call method "quote" on an undefined value at /usr/home/gravityf/usr/local/etc/httpd/htdocs/gravitydex/cgi-bin/links/admin/GT/SQL/Driver.pm line 211, chunk 412.

I also get a fatal error when trying to access the links (in the admin):
A fatal error has occured:

GT::SQL::Table (36215): Wrong argument passed to this subroutine. Usage: Arguments to count() must either be a hash or a hash ref or GT::SQL::Condition object at (eval 8) line 6.

ANyone know whats goin on? Thanks as always....


Quote Reply
Re: [gravity] More problems with bsd move In reply to
Hi,

Sounds like your mysql username/password no longer works, but to be sure, turn debug on and print out what $DBI::errstr or $GT::SQL::error says.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] More problems with bsd move In reply to
I'm not sure what you mean about the username/password but here is the error info from the debug:

A fatal error has occured:

GT::SQL::Table (96911): Wrong argument passed to this subroutine. Usage: Arguments to count() must either be a hash or a hash ref or GT::SQL::Condition object at (eval 8) line 6.

Please enable debugging in setup for more details.

Stack Trace
======================================
Links (96911): Links::environment called at /usr/home/gravityf/usr/local/etc/httpd/htdocs/gravitydex/cgi-bin/links/admin/Links.pm line 457 with no arguments.Links (96911): Links::fatal called at (eval 6) line 81 with arguments (GT::SQL::Table (96911): Wrong argument passed to this subroutine. Usage: Arguments to count() must either be a hash or a hash ref or GT::SQL::Condition object at (eval 8) line 6.
).Links (96911): GT::Base::error called at /usr/home/gravityf/usr/local/etc/httpd/htdocs/gravitydex/cgi-bin/links/admin/GT/SQL/Base.pm line 176 with arguments (Links::Link=HASH(0x845546c), BADARGS, FATAL, Arguments to count() must either be a hash or a hash ref or GT::SQL::Condition object).Links (96911): GT::SQL::Base::count called at /usr/home/gravityf/usr/local/etc/httpd/htdocs/gravitydex/cgi-bin/links/admin/GT/SQL/Base.pm line 211 with arguments (Links::Link=HASH(0x845546c), [undef]).Links (96911): GT::SQL::Base::hits called at (eval 3) line 13 with arguments (Links::Link=HASH(0x845546c)).Links (96911): GT::SQL::Admin::search_results called at /usr/home/gravityf/usr/local/etc/httpd/htdocs/gravitydex/cgi-bin/links/admin/GT/SQL/Admin.pm line 193 with arguments (Links::Admin=HASH(0x83c7a94)).Links (96911): GT::SQL::Admin::AUTOLOAD called at /usr/home/gravityf/usr/local/etc/httpd/htdocs/gravitydex/cgi-bin/links/admin/GT/SQL/Admin.pm line 83 with arguments (Links::Admin=HASH(0x83c7a94)).Links (96911): GT::SQL::Admin::process called at /usr/local/etc/httpd/htdocs/gravitydex/cgi-bin/links/admin/db.cgi line 35 with arguments (Links::Admin=HASH(0x83c7a94), db, GT::SQL=HASH(0x82554d8), cgi, GT::CGI=HASH(0x81e3cb4)).Links (96911): main::main called at /usr/local/etc/httpd/htdocs/gravitydex/cgi-bin/links/admin/db.cgi line 25 with no arguments.

System Information
======================================
Perl Version: 5.00503
Links SQL Version: 2.0.3
DBI.pm Version: 1.19
Persistant Env: mod_perl (0) SpeedyCGI (0)
GT::SQL::error = GT::SQL::Table (96911): Wrong argument passed to this subroutine. Usage: Arguments to count() must either be a hash or a hash ref or GT::SQL::Condition object at (eval 8) line 6.

DBI::errstr = Unknown database 'links'@INC =
/usr/home/gravityf/usr/local/etc/httpd/htdocs/gravitydex/cgi-bin/links/admin
/usr/local/lib/perl5/5.00503/i386-freebsd
/usr/local/lib/perl5/5.00503
/usr/local/lib/site_perl
/usr/local/lib/site_perl
.

CGI INPUT
======================================
ID =>
ID-opt => =
Username =>
Username-opt => =
db => Links
do => search_results
keyid =>
keyword => *
todo => search_results


CGI Cookies
======================================


ENVIRONMENT
======================================
AUTH_TYPE => Basic
DOCUMENT_ROOT => /usr/local/etc/httpd/htdocs/gravitydex
GATEWAY_INTERFACE => CGI/1.1
GT_TMPDIR => /usr/home/gravityf/usr/local/etc/httpd/htdocs/gravitydex/cgi-bin/links/admin/tmp
HOME => /
HTTP_ACCEPT => image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/msword, application/vnd.ms-powerpoint, application/vnd.ms-excel, */*
HTTP_ACCEPT_ENCODING => gzip, deflate
HTTP_ACCEPT_LANGUAGE => en-us
HTTP_AUTHORIZATION => Basic Z3Jhdml0eWY6eWFoby10aXA=
HTTP_CONNECTION => Keep-Alive
HTTP_HOST => www.gravitydex.com
HTTP_REFERER => http://www.gravitydex.com/cgi-bin/links/admin/admin.cgi?do=page&page=db_nav.html
HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 5.5; Windows 98; Win 9x 4.90; {Cablevision Optimum Online})
PATH => /bin:/usr/bin:/usr/ucb:/usr/bsd:/usr/local/bin
QUERY_STRING => keyword=*&Username=&ID=&do=search_results&ID-opt=%3D&Username-opt=%3D&db=Links&todo=search_results&keyid=
REMOTE_ADDR => 24.189.122.73
REMOTE_HOST => 24.189.122.73
REMOTE_PORT => 3006
REMOTE_USER => gravityf
REQUEST_METHOD => GET
REQUEST_URI => /cgi-bin/links/admin/db.cgi?keyword=*&Username=&ID=&do=search_results&ID-opt=%3D&Username-opt=%3D&db=Links&todo=search_results&keyid=
SCRIPT_FILENAME => /usr/local/etc/httpd/htdocs/gravitydex/cgi-bin/links/admin/db.cgi
SCRIPT_NAME => /cgi-bin/links/admin/db.cgi
SERVER_ADMIN => webmaster
SERVER_NAME => www.gravitydex.com
SERVER_PORT => 80
SERVER_PROTOCOL => HTTP/1.1
SERVER_SOFTWARE => Apache/1.2.6 BSafe-SSL/1.1 FrontPage/3.0.4
USER => gravityf

Sorry for such a long list but obviously i haven't a clue about what is happening. thanks for your help!


Quote Reply
Re: [gravity] More problems with bsd move In reply to
Quote:
DBI::errstr = Unknown database 'links'

Did you move your MySQL database as well?

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] More problems with bsd move In reply to
The entire site was copied to the new server, including the database. At least I think it was. If not, I have a backup on my hard disk. What should I look for to correct the problem? Or should I send you log in info to take a look. Sorry I'm so retarded. I thought the move to the new server would be smooth.
Quote Reply
Re: [gravity] More problems with bsd move In reply to
Hi,

It looks like the MySQL database wasn't copied, or it was copied incorrectly, as now MySQL is saying there is no database called links.

If you want, you can send me an email with server info and we can repair (we would need to charge you to do it though). May want to get whoever did the copy to look at it first.

Cheers,

Alex
--
Gossamer Threads Inc.