Gossamer Forum
Home : Products : Gossamer Links : Discussions :

breadcrumb not displaying correct link

Quote Reply
breadcrumb not displaying correct link
Hi,
I recently had someone add a link which I validated and all was fine until they came back and said, can find link in search but not in breadcrumb.

I checked and found I have a problem that the link subfolder is output wrongly by LSQL so when i click on it I get 404 page cannot be found, but it does exist, and it follows the link is found by a search but when I navigate to its 'home' the directory it was added to, it is not there.

I am really stumped by this, I have done a staggered full revalidate all. Would appreciate any help as to how to solve this please, many thanks

Kev
edit i just noticed the rebuild options. 2 of those look safe to run, one has a warning so i will run the safer ones now and feedback.

Last edited by:

pgtips: Mar 14, 2016, 12:52 PM
Quote Reply
Re: [pgtips] breadcrumb not displaying correct link In reply to
ah, rebuild has reported a problem, and now I'm really stuck. Is this a major error ?
Started at Mon Mar 14 16:06:51 2016. Indexing Links Database ... 103821 links. 1000 2000 3000 4000 5000 6000 7000 8000 9000 10000 11000 12000 13000 14000 15000 16000 17000 18000 19000 20000 21000 22000 23000 24000 25000 26000 27000 28000 29000 30000 31000 32000 33000 34000 35000 36000 37000 38000 39000 40000 41000 42000 43000 44000 45000 46000 47000 48000 49000 50000 51000 52000 53000 54000 55000 56000 57000 58000 59000 60000 61000 62000 63000 64000 65000 66000 67000 68000 69000 70000 71000 72000 73000 74000 75000 76000 77000 78000 79000 80000 81000 82000 83000 84000 85000 86000 87000 88000 89000 90000 91000 92000 93000 94000 95000 96000 97000 98000 99000 100000 101000 102000 103000 Done! Reindexing Category Database ... 20407 categories. Can't call method "fetchrow_arrayref" on an undefined value at /home/ukpages/public_html/cgi-bin/search/admin/GT/SQL/Search/INTERNAL/Indexer.pm line 248. Stack Trace ====================================== Links (145936): Links::environment called at /home/ukpages/public_html/cgi-bin/search/admin/Links.pm line 780 with no arguments. Links (145936): Links::fatal called at /home/ukpages/public_html/cgi-bin/search/admin/GT/SQL/Search/INTERNAL/Indexer.pm line 248 with arguments (Can't call method "fetchrow_arrayref" on an undefined value at /home/ukpages/public_html/cgi-bin/search/admin/GT/SQL/Search/INTERNAL/Indexer.pm line 248. ). Links (145936): GT::SQL::Search::INTERNAL::Indexer::reindex_all called at GT::SQL::Table::reindex line 1061 with arguments (GT::SQL::Search::INTERNAL::Indexer=HASH(0x23302c8), Links::Table::Category=HASH(0x22d91e8), HASH(0x2330250)). Links (145936): GT::SQL::Table::reindex called at nph-index.cgi line 180 with arguments (Links::Table::Category=HASH(0x22d91e8), HASH(0x2330250)). Links (145936): main::reindex called at /home/ukpages/public_html/cgi-bin/search/admin/GT/Plugins.pm line 133 with no arguments. Links (145936): GT::Plugins::dispatch called at nph-index.cgi line 52 with arguments (GT::Plugins=HASH(0x1d6da30), reindex_database, CODE(0x1d473f0)). Links (145936): main::main called at nph-index.cgi line 28 with no arguments. System Information ====================================== Current user: ukpages (710) Perl version: 5.10.1 Gossamer Links version: 3.3.0 GT::SQL version: 1.112 GT::Template version: 2.170 DBI.pm version: 1.633 Running under mod_perl: No Running under SpeedyCGI: No @INC = /home/ukpages/public_html/cgi-bin/search/admin /usr/local/lib64/perl5 /usr/local/share/perl5 /usr/lib64/perl5/vendor_perl /usr/share/perl5/vendor_perl /usr/lib64/perl5 /usr/share/perl5 . GT::SQL::error = Failed to execute query: 'SELECT ID,Name,Description FROM lsql_Category LIMIT 0,10000': Unknown column 'Description' in 'field list' CGI Cookies ====================================== Horde => d06umnj2bn9ejb9geo78r39n64 cpsession => ukpages:v54qxWS_yvsS2ppO,ae61765e366300fc686f34e51a16279e horde_secret_key => 7aSfH-PHpz7eOSS-aYpUhw1 timezone => Europe/London Environment ====================================== AUTH_TYPE => Basic DOCUMENT_ROOT => /home/ukpages/public_html GATEWAY_INTERFACE => CGI/1.1 GT_TMPDIR => /home/ukpages/public_html/cgi-bin/search/admin/tmp HTTP_ACCEPT => text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8 HTTP_ACCEPT_ENCODING => gzip, deflate, sdch HTTP_ACCEPT_LANGUAGE => en-GB,en;q=0.8 HTTP_CONNECTION => keep-alive HTTP_COOKIE => horde_secret_key=7aSfH-PHpz7eOSS-aYpUhw1; Horde=d06umnj2bn9ejb9geo78r39n64; timezone=Europe/London; cpsession=ukpages%3av54qxWS_yvsS2ppO%2cae61765e366300fc686f34e51a16279e HTTP_HOST => www.ukpages.co.uk HTTP_REFERER => http://www.ukpages.co.uk/cgi-bin/search/admin/admin.cgi?page=db_nav.html HTTP_UPGRADE_INSECURE_REQUESTS => 1 HTTP_USER_AGENT => Mozilla/5.0 (Windows NT 10.0; WOW64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/48.0.2564.116 Safari/537.36 PATH => /usr/local/bin:/usr/bin:/bin QUERY_STRING => REMOTE_ADDR => 195.147.62.243 REMOTE_PORT => 60244 REMOTE_USER => admin REQUEST_METHOD => GET REQUEST_URI => /cgi-bin/search/admin/nph-index.cgi SCRIPT_FILENAME => /home/ukpages/public_html/cgi-bin/search/admin/nph-index.cgi SCRIPT_NAME => /cgi-bin/search/admin/nph-index.cgi SERVER_ADDR => 69.73.144.31 SERVER_ADMIN => webmaster@ukpages.co.uk SERVER_NAME => www.ukpages.co.uk SERVER_PORT => 80 SERVER_PROTOCOL => HTTP/1.1 SERVER_SIGNATURE => SERVER_SOFTWARE => Apache UNIQUE_ID => VucZ20VJkB8AAjU3WzwAAAAw
Quote Reply
Re: [pgtips] breadcrumb not displaying correct link In reply to
Hi,

Can you email me the full error message on andy@ultranerds.co.uk? Bit hard to tell from the way you pasted it :)

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!