Hi,
The default MySQL max packet length is 1mb. Often this
length can be exceeded as Mnogosearch is now using extended
inserts. This patch limits insert queries into dict tables
to 512k. Applies against Mnogosearch 3.11.
--- sql.c.orig Thu Mar 8 13:48:58 2001
+++ sql.c Thu Mar 8 14:10:46 2001
@@ -2251,6 +2251,18 @@
sprintf(qe,"(%d,%d,%d)",url_id,UdmStrCRC32(Indexer->Word[i].word),Indexer->Word[i].count);
}
qe=qe+strlen(qe);
+ /* Insert 512k packets max to stay *
+ * under MySQL's default limit. */
+ if (strlen(qb) >= 512000){
+ sql_query(Indexer,qb);
+
+if(UdmDBErrorCode(Indexer->db))return(IND_ERROR);
+
+if(Indexer->Conf->DBMode==UDM_DBMODE_MULTI)
+ sprintf(qb,"INSERT INTO %s
+(url_id,word,intag) VALUES ",tbl_nm);
+ else
+ sprintf(qb,"INSERT INTO %s
+(url_id,word_id,intag) VALUES ",tbl_nm);
+ qe=qb+strlen(qb);
+ have_words = 0;
+ }
}
}
if(have_words){
--
Shane Wegner: [EMAIL PROTECTED]
http://www.cm.nu/~shane/
PGP: 1024D/FFE3035D
A0ED DAC4 77EC D674 5487
5B5C 4F89 9A4E FFE3 035D
___________________________________________
If you want to unsubscribe send "unsubscribe general"
to [EMAIL PROTECTED]
