Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Rebuild Search / Re-index database problem

Quote Reply
Rebuild Search / Re-index database problem
When I go to re-index my database by using the "Rebuild Search" feature it just stops at...

Started at Wed Nov 17 11:54:32 2004.

Indexing Links Database ... 151 links.

Any ideas as to what could be wrong??? I've enabled debugging and the error.log of the re-index ends like as seen below...

=====================================

GT::SQL::Driver::MYSQL::sth (46055): Executing query: INSERT INTO lsql_Category_Word_List (Word, Frequency) VALUES ('phone-services', 1) from main::reindex at nph-index.cgi line 169
GT::SQL::Driver::MYSQL::sth (46055): Query execution took: 0.002693s from main::reindex at nph-index.cgi line 169
GT::SQL::Driver::MYSQL::sth (46055): Executing query: SELECT ID,Description,Name FROM lsql_Category LIMIT 10000,10000 from main::reindex at nph-index.cgi line 169
GT::SQL::Driver::MYSQL::sth (46055): Query execution took: 0.007012s from main::reindex at nph-index.cgi line 169
[Wed Nov 17 12:11:50 2004] [error] [client 209.33.9.214] File does not exist: /htdocs/mysite/mysite.com/favicon.ico
GT::Plugins (49272): Plugin: pre handle_page running => Plugins::PageBuilder::handle_page at /home/htdocs/users/mysite/mysite/mysite.com/cgi-bin/search/admin/GT/Plugins.pm line 127.
GT::Config (49272): Loading '/home/htdocs/users/mysite/mysite/mysite.com/cgi-bin/search/admin/defs/database.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '1', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at /home/htdocs/users/mysite/mysite/mysite.com/cgi-bin/search/admin/GT/Config.pm line 145.
GT::Config (49272): Not loading '/home/htdocs/users/mysite/mysite/mysite.com/cgi-bin/search/admin/defs/database.def' from cache at /home/htdocs/users/mysite/mysite/mysite.com/cgi-bin/search/admin/GT/Config.pm line 161.
GT::Config (49272): Adding '/home/htdocs/users/mysite/mysite/mysite.com/cgi-bin/search/admin/defs/database.def' to the regular cache at /home/htdocs/users/mysite/mysite/mysite.com/cgi-bin/search/admin/GT/Config.pm line 175.
GT::Config (49272): Loading '/home/htdocs/users/mysite/mysite/mysite.com/cgi-bin/search/admin/defs/lsql_Category.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '0', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at /home/htdocs/users/mysite/mysite/mysite.com/cgi-bin/search/admin/GT/Config.pm line 145.
GT::Config (49272): Not loading '/home/htdocs/users/mysite/mysite/mysite.com/cgi-bin/search/admin/defs/lsql_Category.def' from cache at /home/htdocs/users/mysite/mysite/mysite.com/cgi-bin/search/admin/GT/Config.pm line 161.
GT::Config (49272): Adding '/home/htdocs/users/mysite/mysite/mysite.com/cgi-bin/search/admin/defs/lsql_Category.def' to the regular cache at /home/htdocs/users/mysite/mysite/mysite.com/cgi-bin/search/admin/GT/Config.pm line 175.
GT::Config (49272): Loading '/home/htdocs/users/mysite/mysite/mysite.com/cgi-bin/search/admin/defs/lsql_Links.def' with options: inheritance => '0', local => '0', cache => '1', create_ok => '0', empty => '0', chmod => '438', strict => '0', debug => '1', compile_subs => '' at /home/htdocs/users/mysite/mysite/mysite.com/cgi-bin/search/admin/GT/Config.pm line 145.
GT::Config (49272): Not loading '/home/htdocs/users/mysite/mysite/mysite.com/cgi-bin/search/admin/defs/lsql_Links.def' from cache at /home/htdocs/users/mysite/mysite/mysite.com/cgi-bin/search/admin/GT/Config.pm line 161.
GT::Config (49272): Adding '/home/htdocs/users/mysite/mysite/mysite.com/cgi-bin/search/admin/defs/lsql_Links.def' to the regular cache at /home/htdocs/users/mysite/mysite/mysite.com/cgi-bin/search/admin/GT/Config.pm line 175.
GT::SQL::Driver::MYSQL::sth (49272): Executing query: SELECT COUNT(*) FROM lsql_Links WHERE ((ExpiryCounted = 0 AND ExpiryDate < 1100711554 AND isValidated = 'Yes')) at GT::SQL::Driver::sth::execute line 78.
GT::SQL::Driver::MYSQL::sth (49272): Executing query: SELECT * FROM lsql_Category WHERE FatherID = 0 ORDER BY Full_Name ASC at GT::SQL::Driver::sth::execute line 78.
GT::SQL::Driver::MYSQL::sth (49272): Executing query: SELECT * FROM lsql_Links WHERE isNew = 'Yes' AND isValidated = 'Yes' ORDER BY Add_Date DESC Limit 10 at GT::SQL::Driver::sth::execute line 78.

====================================

I hate posting large logs like that but I thought it may help.

Thanks for any insight of suggestions!
Quote Reply
Re: [Jonze] Rebuild Search / Re-index database problem In reply to
4 day proplem fixed.... not sure why, but it's now finishing a "Rebuild Search".

All I did was run via SSH: perl /path/to/admin/folder/nph-index.cgi --reindex

Everything finish then I went back to my admin to try and It worked. Strange... but at least it's working now Wink

Thanks for the read.