Author: Per Kummervold Email: [EMAIL PROTECTED] Message: Thanks again gluke for your answer. I have tried everything above. The results did surprise me, but I couldnt find out how to fix it myself.
First of all, there isn't any relevant errors in apaches error_log. I tried the search.cgi script, and was very surprised by the result. It works perfectly for my new database(mnogo), but when I change to my old database (mnoGoSearch) it produses exactly the same "no result" error that the php does on my new database! The settings in the beginning of search.htm was almost identical. To be sure that the error wasn't here, I made the settings-part in search.htm simpler, and identical. (search.cgi uses search.htm located in /usr/local/mnogosearch/etc/ while search.php uses search.htm located in my homepage directory). Im now using the following settings (for the part before --top--) in both files: DBAddr mysql://root:mypassword@localhost/mnogo/ DBMode single LocalCharset iso-8859-1 BrowserCharset iso-8859-1 StopwordFile /usr/local/mnogosearch/etc/stopwords/en.sl MinWordLength 1 MaxWordLength 32 HlBeg <font color="000088"><b> HlEnd </b></font> (There is some inconsistencies here in search.cgi using MinWordLen instead of MinWordLength, but I dont think this is relevant for my problem, and I should probably submit it as a bug instead.) Anyway this still gives fails for php reading my new 3.2 database (and for cgi reading my old database). Here are the query log from mysql: Using search.cgi on my 3.2 database(gives more than 1000 hits): 10 Connect root@localhost on mnogo 10 Query SELECT url_id,intag FROM dict WHERE word='love' 10 Query SELECT rec_id,url,content_type,last_mod_time,title,txt,docsize,next_index_time,referrer,keywords,description,crc32,tag,category,lang,charset FROM url WHERE rec_id IN (3169,3172,1147,980,981,3118,3788,1034,3871,2504) ORDER BY rec_id 10 Query SELECT rec_id,url,content_type,last_mod_time,docsize FROM url WHERE crc32=834999358 AND (status=200 OR status=304 OR status=206) 10 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 10 Query SELECT rec_id,url,content_type,last_mod_time,docsize FROM url WHERE crc32=1109686258 AND (status=200 OR status=304 OR status=206) 10 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 10 Query SELECT rec_id,url,content_type,last_mod_time,docsize FROM url WHERE crc32=884126020 AND (status=200 OR status=304 OR status=206) 10 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 10 Query SELECT rec_id,url,content_type,last_mod_time,docsize FROM url WHERE crc32=-604877458 AND (status=200 OR status=304 OR status=206) 10 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 10 Query SELECT rec_id,url,content_type,last_mod_time,docsize FROM url WHERE crc32=-883373823 AND (status=200 OR status=304 OR status=206) 10 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 10 Query SELECT rec_id,url,content_type,last_mod_time,docsize FROM url WHERE crc32=1029885801 AND (status=200 OR status=304 OR status=206) 10 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 10 Query SELECT rec_id,url,content_type,last_mod_time,docsize FROM url WHERE crc32=-204597878 AND (status=200 OR status=304 OR status=206) 10 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 10 Query SELECT rec_id,url,content_type,last_mod_time,docsize FROM url WHERE crc32=615291516 AND (status=200 OR status=304 OR status=206) 10 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 10 Query SELECT rec_id,url,content_type,last_mod_time,docsize FROM url WHERE crc32=-690531724 AND (status=200 OR status=304 OR status=206) 10 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 10 Query SELECT rec_id,url,content_type,last_mod_time,docsize FROM url WHERE crc32=1920405040 AND (status=200 OR status=304 OR status=206) 10 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 10 Quit Using search.php on my 3.2 database(gives 0 hits): 13 Connect root@localhost on mnogo 13 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 13 Query SELECT rec_id,path,link,name FROM categories WHERE path LIKE '__' 13 Query SELECT url_id,intag FROM dict WHERE word='love' 13 Quit In case it should be relevant, I also include the searches from the 3.2 scripts to my old 3.1 generated database: Using search.cgi on my 3.1 database(gives 0 hits): 11 Connect root@localhost on mnoGoSearch 11 Query SELECT url_id,intag FROM dict WHERE word='love' 11 Quit Using search.php in my 3.1 database(gives more than 1000 hits) 12 Connect root@localhost on mnoGoSearch 12 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 12 Query SELECT rec_id,path,link,name FROM categories WHERE path LIKE '__' 12 Query SELECT url_id,intag FROM dict WHERE word='love' 12 Query SELECT rec_id,url,content_type,last_mod_time,title,txt,docsize,last_index_time,next_index_time,referrer,keywords,description,crc32,category FROM url WHERE rec_id IN (11504,11503,11001,10967,11405,11381,10869,11379,11357,11348,11309,11308,11276,10864,11180,10837,10818,11762,11756,11752) ORDER BY rec_id 12 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 12 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 12 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 12 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 12 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 12 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 12 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 12 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 12 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 12 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 12 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 12 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 12 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 12 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 12 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 12 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 12 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 12 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 12 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 12 Query SELECT rec_id,path,link,name FROM categories WHERE path='' 12 Quit Reply: <http://www.mnogosearch.org/board/message.php?id=3795> ___________________________________________ If you want to unsubscribe send "unsubscribe general" to [EMAIL PROTECTED]
