Gossamer Forum
Home : Products : Gossamer Links : Discussions :

validated link and got error..

Quote Reply
validated link and got error..
I have just done a server move... all went well etc...
Just went to validate a new ad, and recieved the following output

Quote:

A fatal error has occured:
Can't call method "fetchrow" on an undefined value at /home/simcoecl/public_html/cgi-bin/classifieds/admin/Links/Table/Links.pm line 235.

Please enable debugging in setup for more details.
Anyone know what is wrong or i forgot to do?
Quote Reply
Re: [6foot4] validated link and got error.. In reply to
Have you checked that the database settings are correct in /admin/defs/database.def?

Otherwise, try turning debugging on, and see if any SQL error message is shown.

Hope that helps.

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!
Quote Reply
Re: [Andy] validated link and got error.. In reply to
Here is what I get with debugging on..

Quote:


A fatal error has occured:
Can't call method "fetchrow" on an undefined value at /home/simcoecl/public_html/cgi-bin/classifieds/admin/Links/Table/Links.pm line 235.

Please enable debugging in setup for more details.Stack Trace ====================================== Links (14139): Links::environment called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/Links.pm line 524 with no arguments. Links (14139): Links::fatal called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/Links/Table/Links.pm line 235 with arguments (Can't call method "fetchrow" on an undefined value at /home/simcoecl/public_html/cgi-bin/classifieds/admin/Links/Table/Links.pm line 235. ). Links (14139): Links::Table::Links::_plg_modify called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/Links/Table/Links.pm line 210 with arguments (Links::Table::Links=HASH(0x8435f48), HASH(0x84e2e08)). Links (14139): Links::Table::Links::__ANON__ called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/GT/Plugins.pm line 112 with arguments (HASH(0x84e2e08)). Links (14139): GT::Plugins::dispatch called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/Links/Table/Links.pm line 210 with arguments (GT::Plugins, /home/simcoecl/public_html/cgi-bin/classifieds/admin/Plugins, modify_link, CODE(0x84eff70), HASH(0x84e2e08)). Links (14139): Links::Table::Links::modify called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/Links/Tools.pm line 1087 with arguments (Links::Table::Links=HASH(0x8435f48), HASH(0x84e2e08)). Links (14139): Links::Tools::_validate_record called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/GT/Plugins.pm line 112 with arguments (HASH(0x84e2e08)). Links (14139): GT::Plugins::dispatch called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/Links/Tools.pm line 1001 with arguments (GT::Plugins, /home/simcoecl/public_html/cgi-bin/classifieds/admin/Plugins, validate_link, CODE(0x8364b60), HASH(0x84e2e08)). Links (14139): Links::Tools::_validate called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/Links/Tools.pm line 571 with arguments (Links::Table::Links=HASH(0x8435f48)). Links (14139): Links::Tools::validate_links called at GT::Template::_call_func line 821 with no arguments. Links (14139): GT::Template::_call_func called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/templates/admin/compiled/tools_validate.html.compiled line 24 with arguments (GT::Template=HASH(0x81e7198), Links::Tools::validate_links). Links (14139): GT::Template::parsed_template called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/GT/Template.pm line 640 with arguments (GT::Template=HASH(0x81e7198)). Links (14139): GT::Template::_parse called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/GT/Template.pm line 122 with arguments (GT::Template=HASH(0x81e7198), tools_validate.html, HASH(0x81e6fa0)). Links (14139): GT::Template::parse called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/Links.pm line 309 with arguments (GT::Template, tools_validate.html, ARRAY(0x81e6f4c), HASH(0x81e6fa0)). Links (14139): Links::admin_page called at admin.cgi line 49 with no arguments. Links (14139): main::main called at admin.cgi line 23 with no arguments. System Information ====================================== Perl Version: 5.008004 Links SQL Version: 2.2.0 DBI.pm Version: 1.45 Running under mod_perl: No Running under SpeedyCGI: No GT::SQL::error = Failed to execute query: 'SELECT isValidated,ExpiryDate FROM lsql_Links WHERE ID = ?' Reason: Unknown column 'ExpiryDate' in 'field list' @INC = /home/simcoecl/public_html/cgi-bin/classifieds/admin /usr/lib/perl5/5.8.4/i686-linux /usr/lib/perl5/5.8.4 /usr/lib/perl5/site_perl/5.8.4/i686-linux /usr/lib/perl5/site_perl/5.8.4 /usr/lib/perl5/site_perl/5.8.0 /usr/lib/perl5/site_perl . CGI INPUT ====================================== 1-Ad_Expiry_Date => 2005-01-11 1-Ad_Last_Renewal => 2004-10-14 1-Ad_Num_Renewals => 0 1-Ad_Status => New 1-Ad_Time_Period => 90 1-Add_Date => 2004-10-14 1-CatLinks.CategoryID => 45 1-Contact_Email => dcyr47@hotmail.com 1-Contact_Name => ontario 1-Date_Checked => 0000-00-00 00:00:00 1-Description => 1990 38'King Mallard Trailer with 2 tip outs, 2 bedroom, C/A, full bath, double fridge 9'x20'addroom 8'x10'sheed on 50'x50'lot. Can be moved. $15000.or bo call 519-754-0175 1-Hits => 0 1-ID => 363 1-Image => 1-LinkOwner => ontario 1-Mod_Date => 2004-10-14 1-Phone => 519-754-0175 1-Rating => 0.00 1-Status => 0 1-Timestmp => 20041014123119 1-Title => 1990 38'King Mallard Trailer 1-URL => http:// 1-Votes => 0 1-isChanged => No 1-isNew => Yes 1-isPopular => No 1-isValidated => No 2-Ad_Expiry_Date => 2005-01-10 2-Ad_Last_Renewal => 2004-10-13 2-Ad_Num_Renewals => 0 2-Ad_Status => New 2-Ad_Time_Period => 90 2-Add_Date => 2004-10-13 2-CatLinks.CategoryID => 112 2-Contact_Email => tadah_v@sympatico.ca 2-Contact_Name => Tracey Vanderhoef 2-Date_Checked => 0000-00-00 00:00:00 2-Description => 1999 Honda EX400 Quad excellent condition, must sell $4200.00 OBO 2-Hits => 0 2-ID => 362 2-Image => 2-LinkOwner => Tracey Vanderhoef 2-Mod_Date => 2004-10-13 2-Phone => (705)792-4793 2-Rating => 0.00 2-Status => 0 2-Timestmp => 20041013195202 2-Title => 99 Honda EX400 Quad 2-URL => http:// 2-Votes => 0 2-isChanged => No 2-isNew => Yes 2-isPopular => No 2-isValidated => No do => page page => tools_validate.html reason-362 => Your Ad: 99 Honda EX400 Quad that was submitted on 2004-10-13 has been rejected for one of the following reasons: 1. Unsuitable content. 2. Not a local listing. 3. No contact number provided. If you have any questions, please don't hesitate to ask. webmaster@simcoeclassifieds.com reason-363 => Your Ad: 1990 38'King Mallard Trailer that was submitted on 2004-10-14 has been rejected for one of the following reasons: 1. Unsuitable content. 2. Not a local listing. 3. No contact number provided. If you have any questions, please don't hesitate to ask. webmaster@simcoeclassifieds.com validate-363 => validate CGI Cookies ====================================== cprelogin => yes cpsession => closed popupmaster => done ENVIRONMENT ====================================== AUTH_TYPE => Basic CONTENT_LENGTH => 2345 CONTENT_TYPE => application/x-www-form-urlencoded DOCUMENT_ROOT => /home/simcoecl/public_html GATEWAY_INTERFACE => CGI/1.1 GT_TMPDIR => /home/simcoecl/public_html/cgi-bin/classifieds/admin/tmp HTTP_ACCEPT => image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-shockwave-flash, */* HTTP_ACCEPT_ENCODING => gzip, deflate HTTP_ACCEPT_LANGUAGE => en-us HTTP_CACHE_CONTROL => no-cache HTTP_CONNECTION => Keep-Alive HTTP_COOKIE => popupmaster=done; cprelogin=yes; cpsession=closed HTTP_HOST => www.simcoeclassifieds.com HTTP_REFERER => http://www.simcoeclassifieds.com/cgi-bin/classifieds/admin/admin.cgi?do=page&page=tools_validate.html HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1) PATH => /usr/local/bin:/usr/bin:/bin QUERY_STRING => REMOTE_ADDR => 67.71.198.98 REMOTE_PORT => 62501 REMOTE_USER => admin REQUEST_METHOD => POST REQUEST_URI => /cgi-bin/classifieds/admin/admin.cgi SCRIPT_FILENAME => /home/simcoecl/public_html/cgi-bin/classifieds/admin/admin.cgi SCRIPT_NAME => /cgi-bin/classifieds/admin/admin.cgi SERVER_ADDR => 66.199.241.26 SERVER_ADMIN => webmaster@simcoeclassifieds.com SERVER_NAME => www.simcoeclassifieds.com SERVER_PORT => 80 SERVER_PROTOCOL => HTTP/1.1 SERVER_SOFTWARE => Apache/1.3.31 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.9 FrontPage/5.0.2.2634a mod_ssl/2.8.19 OpenSSL/0.9.7a
Quote Reply
Re: [6foot4] validated link and got error.. In reply to
This is the problem: "Unknown column 'ExpiryDate' in 'field list'". Try upgrading again to the lastest version - it looks like the new columns weren't added to your tables.
Quote Reply
Re: [afinlr] validated link and got error.. In reply to
I am using the Classifieds pluigin by Mel.. Not sure if that makes a difference.
How do i go about upgrading?
Quote Reply
Re: [6foot4] validated link and got error.. In reply to
Shouldn't be a problem.

Just upload the latest 2.2.0 install.dat/.cgi files into your admin folder; CHMOD install.cgi to 755, and then run from your browser.

BTW... I'd recommend doing a backup first, just in case;

Quote:
mysqldump --add-drop-tables -uSQL_USERNAME -pSQL_PASSWORD DB_NAME > latest_backup.sql
cd /path/to/your/lsql/cgi-bin (i.e where add.cgi is)
tar -cvvf cgibin.tar *

Hope that helps.

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!
Quote Reply
Re: [Andy] validated link and got error.. In reply to
did that.. but still seem to be getting errors... after I try to validate links
Quote Reply
Re: [6foot4] validated link and got error.. In reply to
Here is the error I get now. (not sure if its the same as before or not)

Quote:

A fatal error has occured:
Can't call method "fetchrow" on an undefined value at /home/simcoecl/public_html/cgi-bin/classifieds/admin/Links/Table/Links.pm line 235.

Please enable debugging in setup for more details. Stack Trace
======================================
Links (18041): Links::environment called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/Links.pm line 524 with no arguments.
Links (18041): Links::fatal called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/Links/Table/Links.pm line 235 with arguments
(Can't call method "fetchrow" on an undefined value at /home/simcoecl/public_html/cgi-bin/classifieds/admin/Links/Table/Links.pm line 235.
).
Links (18041): Links::Table::Links::_plg_modify called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/Links/Table/Links.pm line 210 with arguments
(Links::Table::Links=HASH(0x843231c), HASH(0x84e24bc)).
Links (18041): Links::Table::Links::__ANON__ called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/GT/Plugins.pm line 112 with arguments
(HASH(0x84e24bc)).
Links (18041): GT::Plugins::dispatch called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/Links/Table/Links.pm line 210 with arguments
(GT::Plugins, /home/simcoecl/public_html/cgi-bin/classifieds/admin/Plugins, modify_link, CODE(0x84ec7d0), HASH(0x84e24bc)).
Links (18041): Links::Table::Links::modify called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/Links/Tools.pm line 1087 with arguments
(Links::Table::Links=HASH(0x843231c), HASH(0x84e24bc)).
Links (18041): Links::Tools::_validate_record called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/GT/Plugins.pm line 112 with arguments
(HASH(0x84e24bc)).
Links (18041): GT::Plugins::dispatch called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/Links/Tools.pm line 1001 with arguments
(GT::Plugins, /home/simcoecl/public_html/cgi-bin/classifieds/admin/Plugins, validate_link, CODE(0x8363ce4), HASH(0x84e24bc)).
Links (18041): Links::Tools::_validate called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/Links/Tools.pm line 571 with arguments
(Links::Table::Links=HASH(0x843231c)).
Links (18041): Links::Tools::validate_links called at GT::Template::_call_func line 821 with no arguments.
Links (18041): GT::Template::_call_func called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/templates/admin/compiled/tools_validate.html.compiled line 24 with arguments
(GT::Template=HASH(0x81e7020), Links::Tools::validate_links).
Links (18041): GT::Template::parsed_template called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/GT/Template.pm line 640 with arguments
(GT::Template=HASH(0x81e7020)).
Links (18041): GT::Template::_parse called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/GT/Template.pm line 122 with arguments
(GT::Template=HASH(0x81e7020), tools_validate.html, HASH(0x81e6e28)).
Links (18041): GT::Template::parse called at /home/simcoecl/public_html/cgi-bin/classifieds/admin/Links.pm line 309 with arguments
(GT::Template, tools_validate.html, ARRAY(0x81e6dd4), HASH(0x81e6e28)).
Links (18041): Links::admin_page called at admin.cgi line 49 with no arguments.
Links (18041): main::main called at admin.cgi line 23 with no arguments.


System Information
======================================
Perl Version: 5.008004
Links SQL Version: 2.2.0
DBI.pm Version: 1.45
Running under mod_perl: No
Running under SpeedyCGI: No
GT::SQL::error = Failed to execute query: 'SELECT isValidated,ExpiryDate FROM lsql_Links WHERE ID = ?' Reason: Unknown column 'ExpiryDate' in 'field list'
@INC =
/home/simcoecl/public_html/cgi-bin/classifieds/admin
/usr/lib/perl5/5.8.4/i686-linux
/usr/lib/perl5/5.8.4
/usr/lib/perl5/site_perl/5.8.4/i686-linux
/usr/lib/perl5/site_perl/5.8.4
/usr/lib/perl5/site_perl/5.8.0
/usr/lib/perl5/site_perl
.

CGI INPUT
======================================
1-Ad_Expiry_Date => 2005-01-11
1-Ad_Last_Renewal => 2004-10-14
1-Ad_Num_Renewals => 0
1-Ad_Status => New
1-Ad_Time_Period => 90
1-Add_Date => 2004-10-14
1-CatLinks.CategoryID => 45
1-Contact_Email => dcyr47@hotmail.com
1-Contact_Name => ontario
1-Date_Checked => 0000-00-00 00:00:00
1-Description => 1990 38'King Mallard Trailer
with 2 tip outs, 2 bedroom, C/A, full bath, double fridge 9'x20'addroom
8'x10'sheed on 50'x50'lot. Can be moved.
$15000.or bo
call
519-754-0175
1-Hits => 0
1-ID => 363
1-Image =>
1-LinkOwner => ontario
1-Mod_Date => 2004-10-14
1-Phone => (519) 754-0175
1-Rating => 0.00
1-Status => 0
1-Timestmp => 20041014123119
1-Title => 1990 38'King Mallard Trailer
1-URL => http://
1-Votes => 0
1-isChanged => No
1-isNew => Yes
1-isPopular => No
1-isValidated => No
2-Ad_Expiry_Date => 2005-01-10
2-Ad_Last_Renewal => 2004-10-13
2-Ad_Num_Renewals => 0
2-Ad_Status => New
2-Ad_Time_Period => 90
2-Add_Date => 2004-10-13
2-CatLinks.CategoryID => 112
2-Contact_Email => tadah_v@sympatico.ca
2-Contact_Name => Tracey Vanderhoef
2-Date_Checked => 0000-00-00 00:00:00
2-Description => 1999 Honda EX400 Quad excellent condition, must sell
$4200.00 OBO
2-Hits => 0
2-ID => 362
2-Image =>
2-LinkOwner => Tracey Vanderhoef
2-Mod_Date => 2004-10-13
2-Phone => (705)792-4793
2-Rating => 0.00
2-Status => 0
2-Timestmp => 20041013195202
2-Title => 99 Honda EX400 Quad
2-URL => http://
2-Votes => 0
2-isChanged => No
2-isNew => Yes
2-isPopular => No
2-isValidated => No
do => page
page => tools_validate.html
reason-362 => Your Ad:

99 Honda EX400 Quad

that was submitted on 2004-10-13 has been rejected
for one of the following reasons:


1. Unsuitable content.
2. Not a local listing.
3. No contact number provided.



If you have any questions, please don't hesitate to ask.

webmaster@simcoeclassifieds.com





reason-363 => Your Ad:

1990 38'King Mallard Trailer

that was submitted on 2004-10-14 has been rejected
for one of the following reasons:


1. Unsuitable content.
2. Not a local listing.
3. No contact number provided.



If you have any questions, please don't hesitate to ask.

webmaster@simcoeclassifieds.com





validate-363 => validate


CGI Cookies
======================================
s => 2d2af338998f3a4ae43dd04d0562cf0b


ENVIRONMENT
======================================
AUTH_TYPE => Basic
CONTENT_LENGTH => 2351
CONTENT_TYPE => application/x-www-form-urlencoded
DOCUMENT_ROOT => /home/simcoecl/public_html
GATEWAY_INTERFACE => CGI/1.1
GT_TMPDIR => /home/simcoecl/public_html/cgi-bin/classifieds/admin/tmp
HTTP_ACCEPT => image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/msword, application/x-shockwave-flash, */*
HTTP_ACCEPT_LANGUAGE => en-us
HTTP_CACHE_CONTROL => no-cache
HTTP_CONNECTION => Keep-Alive
HTTP_COOKIE => s=2d2af338998f3a4ae43dd04d0562cf0b
HTTP_HOST => simcoeclassifieds.com
HTTP_REFERER => http://simcoeclassifieds.com/cgi-bin/classifieds/admin/admin.cgi
HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)
HTTP________________ => ----- -------
PATH => /usr/local/bin:/usr/bin:/bin
QUERY_STRING =>
REMOTE_ADDR => 65.94.192.104
REMOTE_PORT => 4172
REMOTE_USER => admin
REQUEST_METHOD => POST
REQUEST_URI => /cgi-bin/classifieds/admin/admin.cgi
SCRIPT_FILENAME => /home/simcoecl/public_html/cgi-bin/classifieds/admin/admin.cgi
SCRIPT_NAME => /cgi-bin/classifieds/admin/admin.cgi
SERVER_ADDR => 66.199.241.26
SERVER_ADMIN => webmaster@simcoeclassifieds.com
SERVER_NAME => www.simcoeclassifieds.com
SERVER_PORT => 80
SERVER_PROTOCOL => HTTP/1.1
SERVER_SOFTWARE => Apache/1.3.31 (Unix) mod_auth_passthrough/1.8 mod_log_bytes/1.2 mod_bwlimited/1.4 PHP/4.3.9 FrontPage/5.0.2.2634a mod_ssl/2.8.19 OpenSSL/0.9.7a
Quote Reply
Re: [6foot4] validated link and got error.. In reply to
Send over LinksSQL admin panel details (via email) if you want, and I'll take a look for you (should be something simple).

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!
Quote Reply
Re: [Andy] validated link and got error.. In reply to
sent ya an email....

thanks