roxen.lists.roxen.general

Subject Author Date
roxen 5.0 strange sql error Marc Dirix <marc[at]electronics-design[dot]nl> 11-01-2008
Hi,

I have a roxen module, which does a query to the database.
Sometimes a query goes wrong somehow, however redoing the query (page
reload) always gets it right the second time.


This is from debug logs:

WARNING:  there is already a transaction in progress
 9:15:16  : Internal server error: mkmapping called on arrays of
different sizes (2 != 26)
 0d10h22m : Unknown program:
mkmapping((),({"Re: ASAS
workshop","Ruben Burgos-Vargas
<<abc[at]gmail.com>>","<abc[at]kpnplanet.nl>","2008-01-10
01:15:16.797695","188","0","0","0","0","1",,,15}))
          : /usr/local/pike/7.7.39/lib/7.6/modules/Sql.pmod/Sql.pike:28:
7.6::Sql.Sql()->res_obj_to_array(Postgres.postgres_result())
          : base_server/roxenloader.pike:1472: SQL(
"postgres;//user;<password[at]localhost>;/dbmail:-" )->query("SELECT
message_idnr FROM dbmail_mailboxes AS a JOIN dbmail_messages AS b ON
a.mailbox_idnr=b.mailbox_idnr WHERE a.owner_idnr=%s AND
b.message_idnr=%d","61",219752)