error

[GoogleCodeExporter]

What steps will reproduce the problem?
1. every time bot join to new room and every new user join to room where the 
bot stay, always send error report to admin bot
:  <presence xmlns="jabber:client" xml:lang="en-US" 
to="pako@jabberid.org/bot-r722" 
from="jabber-indonesia@chat.jabberid.org/ρaijO"><show>xa</show><status>Extended
 away</status><c xmlns="http://jabber.org/protocol/caps" hash="sha-1" 
node="http://tkabber.jabber.ru/" ver="ruyp1OQqmRijqslKeh1y3KfcoH0=" /><x 
xmlns="http://jabber.org/protocol/muc#user"><item role="participant" 
affiliation="none" jid="paijo@jsmart.web.id//" /></x></presence>

Mono.Data.SqliteClient.SqliteExecutionException: An error occurred executing 
the Sqlite command.
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteStatement (IntPtr pStmt, System.Int32& cols, System.IntPtr& pazValue, System.IntPtr& pazColName) [0x00000] in <filename unknown>:0 
  at (wrapper remoting-invoke-with-check) Mono.Data.SqliteClient.SqliteCommand:ExecuteStatement (intptr,int&,intptr&,intptr&)
  at Mono.Data.SqliteClient.SqliteDataReader.ReadpVm (IntPtr pVm, Int32 version, Mono.Data.SqliteClient.SqliteCommand cmd) [0x00000] in <filename unknown>:0 
  at Mono.Data.SqliteClient.SqliteDataReader..ctor (Mono.Data.SqliteClient.SqliteCommand cmd, IntPtr pVm, Int32 version) [0x00000] in <filename unknown>:0 
  at (wrapper remoting-invoke-with-check) Mono.Data.SqliteClient.SqliteDataReader:.ctor (Mono.Data.SqliteClient.SqliteCommand,intptr,int)
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (CommandBehavior behavior, Boolean want_results, System.Int32& rows_affected) [0x00000] in <filename unknown>:0 
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader (CommandBehavior behavior) [0x00000] in <filename unknown>:0 
  at Mono.Data.SqliteClient.SqliteCommand.ExecuteReader () [0x00000] in <filename unknown>:0 
  at (wrapper remoting-invoke-with-check) Mono.Data.SqliteClient.SqliteCommand:ExecuteReader ()
  at Core.DataBase.Tempdb.AutoModerator (agsXMPP.Jid Jid, agsXMPP.Jid Room) [0x00000] in <filename unknown>:0 
  at Core.Kernel.PresenceHandler._Handle () [0x00000] in <filename unknown>:0 
  at Core.Kernel.PresenceHandler.Handle () [0x00000] in <filename unknown>:0 

What is the expected output? What do you see instead?
please help to solve this problem

What version of the product are you using? On what operating system?
Pako bot rev 722, OS linux  Linux 2.6.18-128.2.1.el5.028stab064.4 i686 i386 
CentOS 5.

regard,
cliff.reynard

Original issue reported on code.google.com by Cliff.Re...@gmail.com on 8 Aug 2010 at 2:47

[GoogleCodeExporter]

and this happens since rev 716

Original comment by Cliff.Re...@gmail.com on 8 Aug 2010 at 2:52

[GoogleCodeExporter]

Hello. 
Thank toy for error reports.
I\ll test the bot and try to fix it.

Best regards.

Original comment by alexey...@gmail.com on 10 Aug 2010 at 5:20

• Changed state: Accepted

[GoogleCodeExporter]

I'm review the code and no problems found. Please try to do following steps:
1. do a backup of file Dynamic/Temp.db;
2. shut down Pako.
3. Remove Dynamic/Temp.db;
4. Turn on Pako.

Please tell me if this manipulations helps you.
Conclusion: you will need to fill akick, amoderator, avisitor lists.

Original comment by alexey...@gmail.com on 10 Aug 2010 at 8:41

[GoogleCodeExporter]

Original comment by alexey...@gmail.com on 27 Nov 2010 at 5:12

• Changed state: Fixed