Gossamer Forum
(Advanced Search)
for
Home : Products : Gossamer Links : Discussions :

Can't call method "fetchrow_array"

Jul 17, 2003, 4:46 AM
Scampi
Novice (31 posts)
Scampi's avatar
Jul 17, 2003, 4:46 AM
Post #1 of 9
Views: 6042
Shortcut
Quote Reply
Can't call method "fetchrow_array"
Hi there, I hope someone can nail this one for me, I've looked in the forums and can't find much on the subject...

""
A fatal error has occurred:

Can't call method "fetchrow_array" on an undefined value at d:/virtualservers/055871/thebigtravelguide/cgi-bin/links/admin/Links/Link.pm line 573.

Please enable debugging in setup for more details.

""

I'm trying to re-create the error with debugging on, but its an allusive little thing! Basically it happens when we add a record; every now and then this pops up. The strange thing is is that we can re-try and add the record the second time with no problems, other than a noticeable de-creases in speed.

Anyone got any ideas? Thanks
Scampi.

-----------------------------------------------------
A Little Madness Now And Then,
Is Relished By The Wisest Men
- Mr Willy Wonka
-----------------------------------------------------
Jul 17, 2003, 5:33 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jul 17, 2003, 5:33 AM
Post #2 of 9
Views: 5950
Shortcut
Quote Reply
Re: [Scampi] Can't call method "fetchrow_array" In reply to
If you turn on debugging to 2, what does it say?

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jul 17, 2003, 6:08 AM
Scampi
Novice (31 posts)
Scampi's avatar
Jul 17, 2003, 6:08 AM
Post #3 of 9
Views: 5926
Shortcut
Quote Reply
Re: [Andy] Can't call method "fetchrow_array" In reply to
I'm trying to re-create the error, but for once it doesn't want to show Shocked

Once I can get the debugging message, I'll post it here. The strange thing about it is that it doesn't always happen, and when It does the same site can be added with no problems by hitting back and submit again...
Scampi.

-----------------------------------------------------
A Little Madness Now And Then,
Is Relished By The Wisest Men
- Mr Willy Wonka
-----------------------------------------------------
Jul 18, 2003, 5:25 AM
Scampi
Novice (31 posts)
Scampi's avatar
Jul 18, 2003, 5:25 AM
Post #4 of 9
Views: 6016
Shortcut
Quote Reply
Re: [Andy] Can't call method "fetchrow_array" In reply to
Andy:

Finaly I got some debugging informaiton! I hope it helps someone help solve this strange problem,

<flood>

A fatal error has occured:

Can't call method "fetchrow_array" on an undefined value at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/Link.pm line 573.

Please enable debugging in setup for more details.

Stack Trace
======================================
Links (2380): Links::environment called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links.pm line 431 with no arguments.
Links (2380): Links::fatal called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/Link.pm line 573 with arguments
(Can't call method "fetchrow_array" on an undefined value at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/Link.pm line 573.
).
Links (2380): Links::Link::HTML::get_all_categories called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/User/Add.pm line 195 with arguments
(Links::Link::HTML=HASH(0x22a8008), ARRAY(0x1a8d7d8), CatLinks.CategoryID, 1).
Links (2380): Links::User::Add::_category_list called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/User/Add.pm line 76 with no arguments.
Links (2380): Links::User::Add::add_link called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/Plugins.pm line 108 with arguments
(HASH(0x1a37094)).
Links (2380): GT::Plugins::dispatch called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/User/Add.pm line 31 with arguments
(GT::Plugins, d:/virtualservers/055871/mysite/cgi-bin/links/admin/Plugins, user_add_link, CODE(0x1a9ab60), HASH(0x1a37094)).
Links (2380): Links::User::Add::handle called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/Plugins.pm line 108 with no arguments.
Links (2380): GT::Plugins::dispatch called at d:\virtualservers\055871\mysite\cgi-bin\links\add.cgi line 25 with arguments
(GT::Plugins, d:/virtualservers/055871/mysite/cgi-bin/links/admin/Plugins, handle_add, CODE(0x1ab3e88)).


System Information
======================================
Perl Version: 5.006001
Links SQL Version: 2.1.2
DBI.pm Version: 1.37
Persistant Env: mod_perl (0) SpeedyCGI (0)
GT::SQL::error = Could not connect to database. Reason:
DBI::errstr = [Microsoft][ODBC SQL Server Driver]Timeout expired (SQL-HYT00)(DBD: db_login/SQLConnect err=-1)
@INC =
d:/virtualservers/055871/mysite/cgi-bin/links/admin
D:/Perl/lib
D:/Perl/site/lib
.

CGI INPUT
======================================
CatLinks.CategoryID => 28
Contact_Email => jhg@hjgf.com
Contact_Name => jhg
Description => kjh
Title => ghf
URL => http://www.google.com
add => Add Link


ENVIRONMENT
======================================
ALLUSERSPROFILE => C:\Documents and Settings\All Users
COMMONPROGRAMFILES => C:\Program Files\Common Files
COMPUTERNAME => INETC107
COMSPEC => C:\WINNT\system32\cmd.exe
CONTENT_LENGTH => 787
CONTENT_TYPE => multipart/form-data; boundary=---------------------------7d339919d0b36
DISKEEPERICON => C:\Program Files\Executive Software\DiskeeperServer\
GATEWAY_INTERFACE => CGI/1.1
GT_TMPDIR => d:/virtualservers/055871/mysite/cgi-bin/links/admin/tmp
HTTPS => off
HTTP_ACCEPT => image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, */*
HTTP_ACCEPT_ENCODING => gzip, deflate
HTTP_ACCEPT_LANGUAGE => en-gb
HTTP_CACHE_CONTROL => no-cache
HTTP_CONNECTION => Keep-Alive
HTTP_CONTENT_LENGTH => 787
HTTP_CONTENT_TYPE => multipart/form-data; boundary=---------------------------7d339919d0b36
HTTP_HOST => www.mysite.com
HTTP_REFERER => http://www.mysite.com/.../links/add.cgi?ID=28
HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; ; (Links::Category=HASH(0x229c8b4)).
GT::Base (2380): GT::SQL::Table::select called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/Link.pm line 571 with arguments
(Links::Category=HASH(0x229c8b4), ARRAY(0x22a7f3c)).
GT::Base (2380): Links::Link::HTML::get_all_categories called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/User/Add.pm line 195 with arguments
(Links::Link::HTML=HASH(0x22a8008), ARRAY(0x1a8d7d8), CatLinks.CategoryID, 1).
GT::Base (2380): Links::User::Add::_category_list called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/User/Add.pm line 76 with no arguments.
GT::Base (2380): Links::User::Add::add_link called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/Plugins.pm line 108 with arguments
(HASH(0x1a37094)).
GT::Base (2380): GT::Plugins::dispatch called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/User/Add.pm line 31 with arguments
(GT::Plugins, d:/virtualservers/055871/mysite/cgi-bin/links/admin/Plugins, user_add_link, CODE(0x1a9ab60), HASH(0x1a37094)).
GT::Base (2380): Links::User::Add::handle called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/Plugins.pm line 108 with no arguments.
GT::Base (2380): GT::Plugins::dispatch called at d:\virtualservers\055871\mysite\cgi-bin\links\add.cgi line 25 with arguments
(GT::Plugins, d:/virtualservers/055871/mysite/cgi-bin/links/admin/Plugins, handle_add, CODE(0x1ab3e88)).
Can't call method "fetchrow_array" on an undefined value at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/Link.pm line 573.
.NET CLR 1.0.3705; .NET CLR 1.1.4322)
INSTANCE_ID => 767
LOCAL_ADDR => 195.224.253.126
NUMBER_OF_PROCESSORS => 1
OS => Windows_NT
OS2LIBPATH => C:\WINNT\system32\os2\dll;
PATH => D:\Perl\bin\;C:\WINNT\system32;C:\WINNT;C:\WINNT\System32\Wbem;C:\Program Files\Symantec\pcAnywhere\;C:\MSSQL7\BINN;c:\batch;C:\Program Files\Executive Software\DiskeeperServer\
PATHEXT => .COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WSF;.WSH;.VBS
PATH_INFO => /cgi-bin/links/add.cgi
PATH_TRANSLATED => d:\virtualservers\055871\mysite\cgi-bin\links\add.cgi
PROCESSOR_ARCHITECTURE => x86
PROCESSOR_IDENTIFIER => x86 Family 6 Model 8 Stepping 10, GenuineIntel
PROCESSOR_LEVEL => 6
PROCESSOR_REVISION => 080a
PROGRAMFILES => C:\Program Files
REMOTE_ADDR => 81.101.218.61
REMOTE_HOST => 81.101.218.61
REQUEST_METHOD => POST
SCRIPT_NAME => /cgi-bin/links/add.cgi
SERVER_NAME => www.mysite.com
SERVER_PORT => 80
SERVER_PORT_SECURE => 0
SERVER_PROTOCOL => HTTP/1.1
SERVER_SOFTWARE => Microsoft-IIS/5.0
SYSTEMDRIVE => C:
SYSTEMROOT => C:\WINNT
TEMP => C:\WINNT\TEMP
TMP => C:\WINNT\TEMP
USERPROFILE => C:\Documents and Settings\Default User
WINDIR => C:\WINNT





</flood>
Scampi.

-----------------------------------------------------
A Little Madness Now And Then,
Is Relished By The Wisest Men
- Mr Willy Wonka
-----------------------------------------------------
Jul 18, 2003, 5:31 AM
Andy
Veteran / Moderator (18441 posts)
Andy's avatar
Jul 18, 2003, 5:31 AM
Post #5 of 9
Views: 5929
Shortcut
Quote Reply
Re: [Scampi] Can't call method "fetchrow_array" In reply to
Is that on debug setting 2? (not 1). We need to see the SQL error if possible.

Cheers

Andy (mod)
andy@ultranerds.co.uk
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package | GLinks ULTRA Package PRO
Links SQL Plugins | Website Design and SEO | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Jul 18, 2003, 6:02 AM
Scampi
Novice (31 posts)
Scampi's avatar
Jul 18, 2003, 6:02 AM
Post #6 of 9
Views: 6095
Shortcut
Quote Reply
Re: [Andy] Can't call method "fetchrow_array" In reply to
Here you go, hope this helps more

GT::SQL (3124): Creating new table object for lsql_CatLinks at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/SQL/Base.pm line 120.
GT::SQL::Table (3124): Loading state for lsql_CatLinks at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/SQL/Table.pm line 178.
GT::SQL::Table (3124): State loaded for lsql_CatLinks at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/SQL/Table.pm line 182.
Links::Category (3124): Query: SELECT Full_Name FROM lsql_Category WHERE ID = ?
GT::SQL::Driver::ODBC (3124): Preparing query: SELECT Full_Name FROM lsql_Category WHERE ID = ? at GT::SQL::Driver::prepare line 157.
GT::SQL::Driver::ODBC::sth (3124): Executing query: SELECT Full_Name FROM lsql_Category WHERE ID = 43
GT::Base (3124): GT::SQL::Driver::ODBC::sth::execute called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/SQL/Table.pm line 950 with arguments
(GT::SQL::Driver::ODBC::sth=HASH(0x2115800), 43).
GT::Base (3124): GT::SQL::Table::do_query called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/SQL/Table.pm line 866 with arguments
(Links::Category=HASH(0x2289f78), SELECT Full_Name FROM lsql_Category WHERE ID = ? , ARRAY(0x21158c0)).
GT::Base (3124): GT::SQL::Table::select called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/User/Add.pm line 132 with arguments
(Links::Category=HASH(0x2289f78), HASH(0x20de180), ARRAY(0x20dcd44)).
GT::Base (3124): Links::User::Add::add_link called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/Plugins.pm line 108 with arguments
(HASH(0x1a37518)).
GT::Base (3124): GT::Plugins::dispatch called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/User/Add.pm line 31 with arguments
(GT::Plugins, d:/virtualservers/055871/mysite/cgi-bin/links/admin/Plugins, user_add_link, CODE(0x1a9d0b0), HASH(0x1a37518)).
GT::Base (3124): Links::User::Add::handle called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/Plugins.pm line 108 with no arguments.
GT::Base (3124): GT::Plugins::dispatch called at d:\virtualservers\055871\mysite\cgi-bin\links\add.cgi line 25 with arguments
(GT::Plugins, d:/virtualservers/055871/mysite/cgi-bin/links/admin/Plugins, handle_add, CODE(0x1ab9184)).

GT::SQL::Driver::ODBC (3124): Using stored connection: DBI:ODBC:mysite_sql at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/SQL/Driver.pm line 77.
Links::Link (3124): Query: INSERT INTO lsql_Links (Description,Title,LinkOwner,Rating,Hits,Votes,isNew,URL,Status,Contact_Name,Contact_Email,isChanged,Mod_Date,isPopular,isValidated,Add_Date) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)
GT::SQL::Driver::ODBC (3124): Preparing query: INSERT INTO lsql_Links (Description,Title,LinkOwner,Rating,Hits,Votes,isNew,URL,Status,Contact_Name,Contact_Email,isChanged,Mod_Date,isPopular,isValidated,Add_Date) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?) at GT::SQL::Driver::prepare line 157.
GT::SQL::Driver::ODBC::sth (3124): Executing query: INSERT INTO lsql_Links (Description,Title,LinkOwner,Rating,Hits,Votes,isNew,URL,Status,Contact_Name,Contact_Email,isChanged,Mod_Date,isPopular,isValidated,Add_Date) VALUES ('test','test','admin',0,0,0,'Yes','http://www.google.co.uk',0,'keir','kmc@workslikeadream.com','No','2003-07-18','No','No','2003-07-18')
GT::Base (3124): GT::SQL::Driver::ODBC::sth::execute called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/SQL/Table.pm line 950 with arguments
(GT::SQL::Driver::ODBC::sth=HASH(0x208df40), test, test, admin, 0, 0, 0, Yes, http://www.google.co.uk, 0, keir, kmc@workslikeadream.com, No, 2003-07-18, No, No, 2003-07-18).
GT::Base (3124): GT::SQL::Table::do_query called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/SQL/Table.pm line 294 with arguments
(Links::Link=HASH(0x2346428), INSERT INTO lsql_Links (Description,Title,LinkOwner,Rating,Hits,Votes,isNew,URL,Status,Contact_Name,Contact_Email,isChanged,Mod_Date,isPopular,isValidated,Add_Date) VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?), ARRAY(0x22395e8)).
GT::Base (3124): GT::SQL::Table::insert called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/SQL/Table.pm line 219 with arguments
(Links::Link=HASH(0x2346428), HASH(0x1a39464)).
GT::Base (3124): GT::SQL::Table::add called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/Link.pm line 100 with arguments
(Links::Link=HASH(0x2346428), HASH(0x1a39464)).
GT::Base (3124): Links::Link::_plg_add called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/Link.pm line 84 with arguments
(Links::Link=HASH(0x2346428), HASH(0x1a39464)).
GT::Base (3124): Links::Link::__ANON__ called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/Plugins.pm line 108 with arguments
(HASH(0x1a39464)).
GT::Base (3124): GT::Plugins::dispatch called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/Link.pm line 84 with arguments
(GT::Plugins, d:/virtualservers/055871/mysite/cgi-bin/links/admin/Plugins, add_link, CODE(0x21126a8), HASH(0x1a39464)).
GT::Base (3124): Links::Link::add called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/User/Add.pm line 149 with arguments
(Links::Link=HASH(0x2346428), HASH(0x1a39464)).
GT::Base (3124): Links::User::Add::add_link called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/Plugins.pm line 108 with arguments
(HASH(0x1a37518)).
GT::Base (3124): GT::Plugins::dispatch called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/User/Add.pm line 31 with arguments
(GT::Plugins, d:/virtualservers/055871/mysite/cgi-bin/links/admin/Plugins, user_add_link, CODE(0x1a9d0b0), HASH(0x1a37518)).
GT::Base (3124): Links::User::Add::handle called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/Plugins.pm line 108 with no arguments.
GT::Base (3124): GT::Plugins::dispatch called at d:\virtualservers\055871\mysite\cgi-bin\links\add.cgi line 25 with arguments
(GT::Plugins, d:/virtualservers/055871/mysite/cgi-bin/links/admin/Plugins, handle_add, CODE(0x1ab9184)).

GT::SQL::Driver::ODBC (3124): Using stored connection: DBI:ODBC:mysite_sql at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/SQL/Driver.pm line 77.
GT::SQL::Table (3124): Query: INSERT INTO lsql_CatLinks (LinkID,CategoryID) VALUES (?,?)
GT::SQL::Driver::ODBC (3124): Preparing query: INSERT INTO lsql_CatLinks (LinkID,CategoryID) VALUES (?,?) at GT::SQL::Driver::prepare line 157.
GT::SQL::Driver::ODBC::sth (3124): Executing query: INSERT INTO lsql_CatLinks (LinkID,CategoryID) VALUES (29,43)
GT::Base (3124): GT::SQL::Driver::ODBC::sth::execute called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/SQL/Table.pm line 950 with arguments
(GT::SQL::Driver::ODBC::sth=HASH(0x20795a0), 29, 43).
GT::Base (3124): GT::SQL::Table::do_query called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/SQL/Table.pm line 294 with arguments
(GT::SQL::Table=HASH(0x2355538), INSERT INTO lsql_CatLinks (LinkID,CategoryID) VALUES (?,?), ARRAY(0x208fa48)).
GT::Base (3124): GT::SQL::Table::insert called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/Link.pm line 112 with arguments
(GT::SQL::Table=HASH(0x2355538), HASH(0x208de44)).
GT::Base (3124): Links::Link::_plg_add called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/Link.pm line 84 with arguments
(Links::Link=HASH(0x2346428), HASH(0x1a39464)).
GT::Base (3124): Links::Link::__ANON__ called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/Plugins.pm line 108 with arguments
(HASH(0x1a39464)).
GT::Base (3124): GT::Plugins::dispatch called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/Link.pm line 84 with arguments
(GT::Plugins, d:/virtualservers/055871/mysite/cgi-bin/links/admin/Plugins, add_link, CODE(0x21126a8), HASH(0x1a39464)).
GT::Base (3124): Links::Link::add called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/User/Add.pm line 149 with arguments
(Links::Link=HASH(0x2346428), HASH(0x1a39464)).
GT::Base (3124): Links::User::Add::add_link called at d:/virtualservers/055871/mysite/cgi-bin/links/Content-type: text/html



<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"> <html><!-- InstanceBegin template="/Templates/default.dwt" codeOutsideHTMLIsLocked="false" --> <head> <!-- InstanceBeginEditable name="doctitle" --> <title>The Big Travel Guide - Add Success!</title> <!-- InstanceEndEditable --> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1"> <!-- InstanceBeginEditable name="head" --><!-- InstanceEndEditable --> <style type="text/css"> <!--
.links {
font-family: Arial, Helvetica, sans-serif;
font-size: 12px;
font-style: normal;
line-height: normal;
font-weight: bold;
color: #000000;
}
--> </style> </head> <body> <table width="90%" height="1%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td height="1"><div align="center"><img src="http://www.mysite.com/...ges/default/tbtg.jpg" width="656" height="139"><br><br></div></td> </tr> <tr> <td style="border-style: none none none none; border-width: 1; border-color: #ffffff;" height="1" bgcolor="#FF9900"> <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td><span class="links"><a href="http://www.mysite.com/pages" class="links">Home</a></span><font color="#FFFFFF" face="Arial, Helvetica, sans-serif">
| <span class="links"><a href="http://www.mysite.com/...s/add.cgi?ID=Unknown Tag: 'category_id'" class="links">Add
Site</a></span> | <span class="links"> <script>
// (C) 2000 www.CodeLifter.com
// http://www.codelifter.com
// Free for all users, but leave in this header
// message to show in non-IE browsers
var txt = "Bookmark"
// url you wish to have bookmarked
var url = "http://www.The BIG Travel Guide.com";
// caption to appear with bookmark
var who = "www.The BIG Travel Guide.com"
// do not edit below this line
// ===========================
var ver = navigator.appName
var num = parseInt(navigator.appVersion)
if ((ver == "Microsoft Internet Explorer")&&(num>= 4)) {
document.write('<A HREF="javascript:window.external.AddFavorite(url,who);" class="links"');
document.write('onMouseOver=" window.status=')
document.write("txt; return true ")
document.write('"onMouseOut=" window.status=')
document.write("' '; return true ")
document.write('">'+ txt + '</a>')
}else{
txt += " (Ctrl+D)"
document.write(txt)
}
</script> </span></font></td> </tr> </table> </td> </tr> <tr> <form name="search_form" method="GET" action="http://www.mysite.com/...bin/links/search.cgi"> <td height="30" align="center" bgcolor="#FFCC00"> <div align="left"> <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td><input type="TEXT" name="query" size="30">&nbsp;&nbsp;<input type="Submit" value="Search"></td> </tr> </table> </div></td> </form> </tr> <tr> <td height="1" align="left"><div align="center"> <table width="720" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td align="left" valign="top">&nbsp;</td> </tr> <tr> <td align="left" valign="top"> <!-- InstanceBeginEditable name="main" --> <table border=0 width="100%" cellpadding=0 cellspacing=0> <tr> <td width=6 rowspan=2>&nbsp; </td> <td> <table border=0 width="100%" cellpadding=3 cellspacing=0> <tr bgcolor="#ffffff"><td width="30%"> <font face="Arial,Helvetica" size=2 color="#000000"><b>LINK ADDED!</b></font></td> <td bgcolor=white width="70%">&nbsp;</td></tr> <tr><td colspan=2 align=center> <table border=0 cellpadding=3 cellspacing=0> <tr> <td colspan=2 valign=middle> <br> <font face="Arial,Helvetica" size=2 color="black">We have received the following link:</font></td></tr> <tr><td><font face="Arial,Helvetica" size=2 color="black">Title:</td><td><b>test</b></font></td></tr> <tr><td><font face="Arial,Helvetica" size=2 color="black">URL:</td><td><b>http://www.google.co.uk</b></font></td></tr> <tr><td><font face="Arial,Helvetica" size=2 color="black">Category:</td><td><b>North America/Canada</b></font></td></tr> <tr><td><font face="Arial,Helvetica" size=2 color="black">Description:</td><td><b>test</b></font></td></tr> <tr><td><font face="Arial,Helvetica" size=2 color="black">Contact Name:</td><td><b>keir</b></font></td></tr> <tr><td><font face="Arial,Helvetica" size=2 color="black">Contact Email:</td><td><b>kmc@workslikeadream.com</b></font></td></tr> <tr><td colspan=2><font face="Arial,Helvetica" size=2 color="black">Thank you! We will send you an email once your link has been validated.</font></td></tr> <tr><td colspan=2>&nbsp;</td><tr> </table> </td></tr></table> </td></tr></table> <!-- InstanceEndEditable --></td> </tr> <tr> <td align="left" valign="top">&nbsp;</td> </tr> </table> </div> </td> </tr> <tr> <td style="border-style: none none none none; border-width: 1; border-color: #ffffff;" height="1" bgcolor="#FFCC00">&nbsp;</td> </tr> <tr> <td height="10" bgcolor="#FF9900"> <table width="90%" border="0" align="center" cellpadding="0" cellspacing="0"> <tr> <td><span class="links"><a href="http://www.mysite.com/pages" class="links">Home</a></span><font color="#FFFFFF" face="Arial, Helvetica, sans-serif">
| <span class="links"><a href="http://www.mysite.com/...s/add.cgi?ID=Unknown Tag: 'category_id'" class="links">Add
Site</a></span> | <span class="links"> <script>
// (C) 2000 www.CodeLifter.com
// http://www.codelifter.com
// Free for all users, but leave in this header
// message to show in non-IE browsers
var txt = "Bookmark"
// url you wish to have bookmarked
var url = "http://www.The BIG Travel Guide.com";
// caption to appear with bookmark
var who = "www.The BIG Travel Guide.com"
// do not edit below this line
// ===========================
var ver = navigator.appName
var num = parseInt(navigator.appVersion)
if ((ver == "Microsoft Internet Explorer")&&(num>= 4)) {
document.write('<A HREF="javascript:window.external.AddFavorite(url,who);" class="links"');
document.write('onMouseOver=" window.status=')
document.write("txt; return true ")
document.write('"onMouseOut=" window.status=')
document.write("' '; return true ")
document.write('">'+ txt + '</a>')
}else{
txt += " (Ctrl+D)"
document.write(txt)
}
</script> </span></font></td> </tr> </table> </td> </tr> </table> </body> <!-- InstanceEnd --></html>
admin/GT/Plugins.pm line 108 with arguments
(HASH(0x1a37518)).
GT::Base (3124): GT::Plugins::dispatch called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/Links/User/Add.pm line 31 with arguments
(GT::Plugins, d:/virtualservers/055871/mysite/cgi-bin/links/admin/Plugins, user_add_link, CODE(0x1a9d0b0), HASH(0x1a37518)).
GT::Base (3124): Links::User::Add::handle called at d:/virtualservers/055871/mysite/cgi-bin/links/admin/GT/Plugins.pm line 108 with no arguments.
GT::Base (3124): GT::Plugins::dispatch called at d:\virtualservers\055871\mysite\cgi-bin\links\add.cgi line 25 with arguments
(GT::Plugins, d:/virtualservers/055871/mysite/cgi-bin/links/admin/Plugins, handle_add, CODE(0x1ab9184)).
Scampi.

-----------------------------------------------------
A Little Madness Now And Then,
Is Relished By The Wisest Men
- Mr Willy Wonka
-----------------------------------------------------
Jul 18, 2003, 6:26 AM
Scampi
Novice (31 posts)
Scampi's avatar
Jul 18, 2003, 6:26 AM
Post #7 of 9
Views: 5901
Shortcut
Quote Reply
Re: [Andy] Can't call method "fetchrow_array" In reply to
And, to make matters worse, instead of displaying any messages, its now downloading the add.cgi script and leaving me with one of those anoying 'object' icons in IE. Sometimes it does it (when it responds realy fast) and sometimes it displays error messages (when it takes quite a long time)
Scampi.

-----------------------------------------------------
A Little Madness Now And Then,
Is Relished By The Wisest Men
- Mr Willy Wonka
-----------------------------------------------------
Jul 18, 2003, 7:56 AM
Scampi
Novice (31 posts)
Scampi's avatar
Jul 18, 2003, 7:56 AM
Post #8 of 9
Views: 5891
Shortcut
Quote Reply
Re: [Scampi] Can't call method "fetchrow_array" In reply to
Afternoon once again.

Ok, I'm going nuts! Blame this lovely warm Friday afternoon, but I missed something quite major and simple! Crazy

The code I posted above, as some of you may have noticed, is actually the code from my Add_Sucsess template! So the form is working, and sites are going into the system, but does anyone know why add.cgi is being ether displayed in code, or being downloaded by my browser (same problem in IE and Opera). I have uploaded the code again (In ancii, I made sure), to no avail.

Thanks for your time and patience!

Chris Williams (cwi@workslikeadream.com)

P.s The sooner this is done, the sooner we can all go and drink beers! I love summer Sly
Jul 18, 2003, 4:27 PM
Paul
Veteran (19537 posts)
Jul 18, 2003, 4:27 PM
Post #9 of 9
Views: 5886
Shortcut
Quote Reply
Re: [Scampi] Can't call method "fetchrow_array" In reply to
The error message was present in post 4.

>>
GT::SQL::error = Could not connect to database. Reason:
DBI::errstr = [Microsoft][ODBC SQL Server Driver]Timeout expired (SQL-HYT00)(DBD: db_login/SQLConnect err=-1)
<<

Looks like the server timed out logging you in or something.