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

---

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!

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

---

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!

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

---

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!

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

---

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!

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

---

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!