[General] Webboard: Also problem with mysqld_stmt_execute
Author: Alexander Barkov Email: b...@mnogosearch.org Message: indexer starts allright, but stops after 0-10 good hits. Incorrect arguments to mysqld_stmt_execute Tried a lot of stuff, but no luck... Which MySQL version are you using? Perhaps you hit this problem: http://bugs.mysql.com/bug.php?id=61225 - $ /mnogo/sbin/indexer -Eblob indexer[17151]: Converting to blob indexer[17151]: Loading URL list indexer[17151]: Converting intag00 indexer[17151]: mysql_stmt_execute() failed: Incorrect arguments to mysqld_stmt_execute - $ /mnogo/sbin/indexer -a [some good hits, then] indexer[17341]: [17341]{01} mysql_stmt_execute() failed: Incorrect arguments to mysqld_stmt_execute indexer[17341]: [17341]{01} Error: 'DB err: mysql_stmt_execute() failed: Incorrect arguments to mysqld_stmt_execute - ' - $ /mnogo/sbin/indexer indexer[17769]: indexer from mnogosearch-3.3.8-mysql-pqsql started with '/mnogo/etc/indexer.conf' indexer[17769]: [17769]{01} Done (0 seconds, 0 documents, 0 bytes, 0.00 Kbytes/sec.) - Ubuntu server 10.04.1 x86_64 Mysql 14.12 Distrib 5.0.90 Shared server. Reply: http://www.mnogosearch.org/board/message.php?id=21647 ___ General mailing list General@mnogosearch.org http://lists.mnogosearch.org/listinfo/general
Re: [General] parameter to server command in indexer.conf
Hi, On 05/05/2014 05:02 PM, d...@hodei.net wrote: hi When i try to add this url to my list in dexer.conf -- server http://fr.wikipedia.org/wiki/Zanpantzar -- the crawler search all fr.wikioedia.org site and not only Zanpantzar directory Have you an idea ? Hmm. http://fr.wikipedia.org/wiki/Zanpantzar is not a directory. It's a file. With this server command it should crawl everything in this directory: http://fr.wikipedia.org/wiki/ It should not go outside of the /wiki/ directory. If it goes outside of /wiki/, perhaps you have more server commands. Thanks __ my config : * Debian 3.2.51-1 x86_64 GNU/Linux * mnogosearch 3.3.15 * indexer.conf : .. DBAddr mysql://root:password@localhost/mnogosearch/?dbmode=blob .. --- Ce courrier électronique ne contient aucun virus ou logiciel malveillant parce que la protection avast! Antivirus est active. http://www.avast.com ___ General mailing list General@mnogosearch.org http://lists.mnogosearch.org/listinfo/general ___ General mailing list General@mnogosearch.org http://lists.mnogosearch.org/listinfo/general
Re: [General] accented characters
On 05/05/2014 02:32 PM, d...@hodei.net wrote: hi i have accented characters in my web search. to solve this problem, i have modify the database with this queries : ALTER TABLE bdict CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; ALTER TABLE bdicti CONVERT TO CHARACTER SET utf8 COLLATE utf8_general_ci; and i have init variables *$localcharset* et *$browsercharset* with utf-8 in my indexer.conf But i have always the problem ! have you an idea ? Thanks __ my config : * Debian 3.2.51-1 x86_64 GNU/Linux * mnogosearch 3.3.15 * indexer.conf : .. DBAddr mysql://root:password@localhost/mnogosearch/?dbmode=blob Try adding the SetNames=utf8 part, like this: DBAddr mysql://root:password@localhost/mnogosearch/?SetNames=utf8dbmode=blob .. http://www.avast.com/ Ce courrier électronique ne contient aucun virus ou logiciel malveillant parce que la protection Antivirus avast! http://www.avast.com/ est active. ___ General mailing list General@mnogosearch.org http://lists.mnogosearch.org/listinfo/general ___ General mailing list General@mnogosearch.org http://lists.mnogosearch.org/listinfo/general
Re: [General] Delete a line in Server method in indexer.conf
Hi, On 05/05/2014 02:26 PM, d...@hodei.net wrote: Hi, In the indexer.conf file, in 'Server [Method] ', i want to delete an entry like this : 'server http://www.eke.org' Is that all pages of the site will be removed from the database during the next crawling? Every document has its own expiration time, which is stored in url.next_index_time. When crawling, indexer deletes all expired documents that do not have a matching Server/Real command. Note, you can delete all documents at once, without waiting for expiration: indexer -Cw -u http://www.eke.org/% Thanks ___ General mailing list General@mnogosearch.org http://lists.mnogosearch.org/listinfo/general
[General] Webboard: Also problem with mysqld_stmt_execute
Author: Tom Paamand Email: Message: Thanx for answer. I think it is a very good guess, and have forwarded it to my host. My Mysql version is 5.0.90, and is covered in the bug report. I will return with more info, if this was the solution! Ubuntu server 10.04.1 x86_64 Mysql 14.12 Distrib 5.0.90 Shared server. indexer starts allright, but stops after 0-10 good hits. Incorrect arguments to mysqld_stmt_execute Tried a lot of stuff, but no luck... Which MySQL version are you using? Perhaps you hit this problem: http://bugs.mysql.com/bug.php?id=61225 - $ /mnogo/sbin/indexer -Eblob indexer[17151]: Converting to blob indexer[17151]: Loading URL list indexer[17151]: Converting intag00 indexer[17151]: mysql_stmt_execute() failed: Incorrect arguments to mysqld_stmt_execute - $ /mnogo/sbin/indexer -a [some good hits, then] indexer[17341]: [17341]{01} mysql_stmt_execute() failed: Incorrect arguments to mysqld_stmt_execute indexer[17341]: [17341]{01} Error: 'DB err: mysql_stmt_execute() failed: Incorrect arguments to mysqld_stmt_execute - ' - $ /mnogo/sbin/indexer indexer[17769]: indexer from mnogosearch-3.3.8-mysql-pqsql started with '/mnogo/etc/indexer.conf' indexer[17769]: [17769]{01} Done (0 seconds, 0 documents, 0 bytes, 0.00 Kbytes/sec.) - Ubuntu server 10.04.1 x86_64 Mysql 14.12 Distrib 5.0.90 Shared server. Reply: http://www.mnogosearch.org/board/message.php?id=21649 ___ General mailing list General@mnogosearch.org http://lists.mnogosearch.org/listinfo/general
[General] Webboard: Still problem with mysqld_stmt_execute
Author: Tom Paamand Email: Message: The actual MySQL base called is 5.1.61, though system MySQL is 5.0.90, so that bug is unfortunately not my answer. Problem is still, that indexer starts OK, but stops after 0-10 good hits - with this error: indexer[17341]: [17341]{01} mysql_stmt_execute() failed: Incorrect arguments to mysqld_stmt_execute indexer[17341]: [17341]{01} Error: 'DB err: mysql_stmt_execute() failed: Incorrect arguments to mysqld_stmt_execute - ' Mysql Distrib 5.1.61 [updated info] Ubuntu Server 10.04.1 x86_64 on Shared Server. Which MySQL version are you using? Perhaps you hit this problem: http://bugs.mysql.com/bug.php?id=61225 Reply: http://www.mnogosearch.org/board/message.php?id=21650 ___ General mailing list General@mnogosearch.org http://lists.mnogosearch.org/listinfo/general
[General] Webboard: Still problem with mysqld_stmt_execute
Author: Alexander Barkov Email: b...@mnogosearch.org Message: The actual MySQL base called is 5.1.61, though system MySQL is 5.0.90, so that bug is unfortunately not my answer. Problem is still, that indexer starts OK, but stops after 0-10 good hits - with this error: indexer[17341]: [17341]{01} mysql_stmt_execute() failed: Incorrect arguments to mysqld_stmt_execute indexer[17341]: [17341]{01} Error: 'DB err: mysql_stmt_execute() failed: Incorrect arguments to mysqld_stmt_execute - ' Mysql Distrib 5.1.61 [updated info] Ubuntu Server 10.04.1 x86_64 on Shared Server. Can you please run these two commands and post their results: indexer --sqlmon --exec=select version(); ldd indexer Thanks. Btw, if nothing helps, you can switch off using prepared statements by adding ps=none as a parameter to DBAddr, like this: DBAddr mysql://root@localhost/test/?ps=none Which MySQL version are you using? Perhaps you hit this problem: http://bugs.mysql.com/bug.php?id=61225 Reply: http://www.mnogosearch.org/board/message.php?id=21651 ___ General mailing list General@mnogosearch.org http://lists.mnogosearch.org/listinfo/general
[General] Webboard: No problem with mysqld_stmt_execute
Author: Tom Paamand Email: Message: ps=none did the trick! I have put it like /?DBMode=blobps=none - and it works now. I have only changed Server and DBAddr to my own stuff in the conf-dist, so if ps=none does not have any bad site effects, I will use this. Your first command indexer --sqlmon --exec=select version(); just outputs the indexer helpfile. I tried different variations, no luck. But indexer runs fine from mnogo/sbin and calls my mnogo/etc/indexer.conf More luck with ldd indexer: linux-vdso.so.1 = (0x7fffe0dff000) libpthread.so.0 = /lib/libpthread.so.0 (0x7f7d8984b000) librt.so.1 = /lib/librt.so.1 (0x7f7d89643000) libmysqlclient.so.15 = /usr/local/lib/mysql/libmysqlclient.so.15 (0x7f7d892c7000) libnsl.so.1 = /lib/libnsl.so.1 (0x7f7d890ad000) libm.so.6 = /lib/libm.so.6 (0x7f7d88e2a000) libssl.so.0.9.8 = /lib/libssl.so.0.9.8 (0x7f7d88bd5000) libcrypto.so.0.9.8 = /lib/libcrypto.so.0.9.8 (0x7f7d88844000) libz.so.1 = /lib/libz.so.1 (0x7f7d8862d000) libpq.so.5 = /usr/lib/libpq.so.5 (0x7f7d88403000) libcrypt.so.1 = /lib/libcrypt.so.1 (0x7f7d881ca000) libc.so.6 = /lib/libc.so.6 (0x7f7d87e43000) /lib64/ld-linux-x86-64.so.2 (0x7f7d89a89000) libdl.so.2 = /lib/libdl.so.2 (0x7f7d87c3e000) libkrb5.so.3 = /usr/lib/libkrb5.so.3 (0x7f7d8797a000) libcom_err.so.2 = /lib/libcom_err.so.2 (0x7f7d87776000) libgssapi_krb5.so.2 = /usr/lib/libgssapi_krb5.so.2 (0x7f7d87541000) libldap_r-2.4.so.2 = /usr/lib/libldap_r-2.4.so.2 (0x7f7d872f5000) libk5crypto.so.3 = /usr/lib/libk5crypto.so.3 (0x7f7d870cf000) libkrb5support.so.0 = /usr/lib/libkrb5support.so.0 (0x7f7d86ec6000) libkeyutils.so.1 = /lib/libkeyutils.so.1 (0x7f7d86cc3000) libresolv.so.2 = /lib/libresolv.so.2 (0x7f7d86aaa000) liblber-2.4.so.2 = /usr/lib/liblber-2.4.so.2 (0x7f7d8689b000) libsasl2.so.2 = /usr/lib/libsasl2.so.2 (0x7f7d86681000) libgnutls.so.26 = /usr/lib/libgnutls.so.26 (0x7f7d863df000) libtasn1.so.3 = /usr/lib/libtasn1.so.3 (0x7f7d861cd000) libgcrypt.so.11 = /lib/libgcrypt.so.11 (0x7f7d85f55000) libgpg-error.so.0 = /lib/libgpg-error.so.0 (0x7f7d85d51000) - but problem looks like it is solved, thanks! Reply: http://www.mnogosearch.org/board/message.php?id=21652 ___ General mailing list General@mnogosearch.org http://lists.mnogosearch.org/listinfo/general