Hi,
I have installed links 3.2.0 on the server. when using the admin I get a lot of fetchrow errors like the one above when i want to check duplicates. Other fetchrow errors on validate, verify, build all a.s.o. What is the problem?
Cheers,
Wolfgang

Hi,

Please turn on Setup > Misc > Debugging Enabled, and then see what the MySQL errors are coming up as.

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Hi,

Also, please don't post duplicate threads. If someone's going to answer, they will do it on your original one =) I've removed the duplicate post.

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Hi Andy,
this is the message:
Stack Trace
======================================
Links (8951): Links::environment called at /home/ameta/www/cgi-bin/links3/admin/Links.pm line 750 with no arguments.
Links (8951): Links::fatal called at /home/ameta/www/cgi-bin/links3/admin/Links/Tools.pm line 910 with arguments
(Can't call method "fetchrow_hashref" on an undefined value at /home/ameta/www/cgi-bin/links3/admin/Links/Tools.pm line 910.
).
Links (8951): Links::Tools::validate_links called at GT::Template::_call_func line 791 with no arguments.
Links (8951): GT::Template::_call_func called at /home/ameta/www/cgi-bin/links3/admin/templates/admin/compiled/tools_validate.html.compiled line 22 with arguments
(GT::Template=HASH(0x82ad05c), Links::Tools::validate_links, 1, 0).
Links (8951): GT::Template::parsed_template called at /home/ameta/www/cgi-bin/links3/admin/GT/Template.pm line 565 with arguments
(GT::Template=HASH(0x82ad05c)).
Links (8951): GT::Template::_parse called at /home/ameta/www/cgi-bin/links3/admin/GT/Template.pm line 154 with arguments
(GT::Template=HASH(0x82ad05c), tools_validate.html, HASH(0x82b0d38)).
Links (8951): GT::Template::parse called at Links::admin_page line 307 with arguments
(GT::Template, tools_validate.html, ARRAY(0x82b9694), HASH(0x82b0d38)).
Links (8951): Links::admin_page called at /home/ameta/www/cgi-bin/links3/admin/admin.cgi line 50 with no arguments.
Links (8951): main::main called at /home/ameta/www/cgi-bin/links3/admin/admin.cgi line 24 with no arguments.

System Information
======================================
Current user: ameta (501)
Perl version: 5.6.1
Gossamer Links version: 3.2.0
GT::SQL version: 1.111
GT::Template version: 2.161
DBI.pm Version: 1.19
Running under mod_perl: No
Running under SpeedyCGI: No
@INC =
/home/ameta/www/cgi-bin/links3/admin
/usr/lib/perl5/5.6.1/i586-linux
/usr/lib/perl5/5.6.1
/usr/lib/perl5/site_perl/5.6.1/i586-linux
/usr/lib/perl5/site_perl/5.6.1
/usr/lib/perl5/site_perl
.
GT::SQL::error = Failed to execute query: 'SELECT COUNT(*) FROM Links WHERE (((isValidated = ?)))': Unknown column 'isValidated' in 'where clause'

CGI Input
======================================
do => page
page => tools_validate.html

Environment
======================================
AUTH_TYPE => Basic
DOCUMENT_ROOT => /home/ameta/www
GATEWAY_INTERFACE => CGI/1.1
GT_TMPDIR => /home/ameta/www/cgi-bin/links3/admin/tmp
HTTP_ACCEPT => image/gif, image/x-xbitmap, image/jpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-powerpoint, application/vnd.ms-excel, application/msword, application/x-icq, */*
HTTP_ACCEPT_LANGUAGE => de
HTTP_CONNECTION => Keep-Alive
HTTP_HOST => ameta.de
HTTP_REFERER => http://ameta.de/cgi-bin/links3/admin/admin.cgi?page=db_nav.html
HTTP_UA_CPU => x86
HTTP_USER_AGENT => Mozilla/4.0 (compatible; MSIE 7.0; Windows NT 5.1; .NET CLR 1.1.4322; .NET CLR 2.0.50727)
HTTP_X_MCPROXYFILTER => *************
PATH => /sbin:/usr/sbin:/usr/local/sbin:/root/bin:/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/lib/java/bin:/usr/games/bin:/usr/games:/opt/gnome/bin:/opt/kde2/bin:/opt/kde/bin:/opt/gnome/bin
QUERY_STRING => do=page&page=tools_validate.html
REMOTE_ADDR => 80.145.101.63
REMOTE_PORT => 2956
REMOTE_USER => i01
REQUEST_METHOD => GET
REQUEST_URI => /cgi-bin/links3/admin/admin.cgi?do=page&page=tools_validate.html
SCRIPT_FILENAME => /home/ameta/www/cgi-bin/links3/admin/admin.cgi
SCRIPT_NAME => /cgi-bin/links3/admin/admin.cgi
SERVER_ADDR => 62.80.124.121
SERVER_ADMIN => root2@omegainternet.de
SERVER_NAME => ameta.de
SERVER_PORT => 80
SERVER_PROTOCOL => HTTP/1.1
SERVER_SIGNATURE =>
Apache/1.3.17 Server at ameta.de Port 80

SERVER_SOFTWARE => Apache/1.3.17 (Unix) PHP/4.0.4pl1
UNIQUE_ID => R0p8mT5QfHkAAD1kFrg

Cheers,
Wolfgang

Hi,

It looks like you are missing some important fields in your installation :/


GT::SQL::error = Failed to execute query: 'SELECT COUNT(*) FROM Links WHERE (((isValidated = ?)))': Unknown column 'isValidated' in 'where clause'


isValidated should exist in your Links table - otherwise GLinks has no way of knowing what links are validated =)

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Hi Andy,
if this field is missing, why does everything work without problem on Links 1.11
Cheers,
Wolfgang

Links 1.11? Never used that version :/ Thats gotta be over 6 or 7 years old :|

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates

Hi Andy,
yes is a 1999 edition. As far as i can see the new installation has added the new tables to the databasa but not added the new fields to the existing tables. What can I do?
Cheers,
Wolfgang

Hi,

Mmm.. may be an issue, because its such an old version. Only thing I can suggest - is getting in contact with support@gossamer-threads.com, and seeing what they suggest :)

Hope that helps.

Cheers

Andy (mod)
andy@ultranerds.co.uk

---

IMPORTANT: I've now moved to ultranerds.co.uk, and the .com will no longer work!
Want to give me something back for my help? Please see my Amazon Wish List
GLinks ULTRA Package (plugins total "value" $3,325 & rising, for just $350)| GLinks ULTRA Package PRO (plugins total "value" $5,625 & rising, for just $500)
Support Forum | Links SQL Plugins | DMOZ Dumps | UltraNerds | ULTRAGLobals Plugin | Pre-Made Template Sets | FREE GLinks Plugins!
Compare our different Plugin packages *new* Free CSS Templates