[General] Webboard: Also problem with mysqld_stmt_execute

2014-05-29 Thread bar 
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

2014-05-29 Thread Alexander Barkov 

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

2014-05-29 Thread Alexander Barkov 



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

2014-05-29 Thread Alexander Barkov 

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

2014-05-29 Thread bar 
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

2014-05-29 Thread bar 
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

2014-05-29 Thread bar 
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

2014-05-29 Thread bar 
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