#50 sql error accessing mailbox

[Anonymous]

2005-06-01 12:57:51,644 [TP-Processor55] DEBUG
com.templation.okoun.bd.AbstractItemManager -
findByFilter: sending query:
com.mysql.jdbc.PreparedStatement@1fa63f9: select m.*,
mi.other_id, mi.is_author, u.login as other_login,
u.login_key as other_login_key, u.icon_extension,
u.descr as description, u.hp_descr as
homepageDescription, u.homepage as homepage from
discMail m, discMailInfo mi, User u where u.user_id =
mi.other_id and m.mail_id = mi.mail_id and
mi.is_deleted = 0 and mi.user_id = 30 order by
mi.posted desc limit -20, 20
2005-06-01 12:57:51,645 [TP-Processor55] ERROR
com.templation.okoun.bd.AbstractItemManager -
findByFilter: SQL exception: You have an error in your
SQL syntax; check the manual that corresponds to your
MySQL server version for the right syntax to use near
'-20, 20' at line 1
2005-06-01 12:57:51,645 [TP-Processor55] DEBUG
com.templation.okoun.bd.AbstractItemManager - findByFilter
java.sql.SQLException: You have an error in your SQL
syntax; check the manual that corresponds to your MySQL
server version for the right syntax to use near '-20,
20' at line 1
at
com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2851)
at
com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
at
com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
at
com.mysql.jdbc.Connection.execSQL(Connection.java:2385)
at
com.mysql.jdbc.Connection.execSQL(Connection.java:2306)
at
com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1877)
at
com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1722)

at
com.templation.okoun.bd.AbstractItemManager.findByFilter(AbstractItemManager.java:453)
at
com.templation.okoun.bd.AbstractItemManager.findByFilter(AbstractItemManager.java:359)

at
com.templation.okoun.actions.ActiveUserModel.getMessages(ActiveUserModel.java:76)
at
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:324)