On Mon, Aug 15, 2011 at 6:19 PM, Cash Costello <c
...@elgg.org> wrote:
> Here is the documentation from MySQL on this: "The LIMIT clause can be
> used to constrain the number of rows returned by the SELECT statement.
> LIMIT takes one or two numeric arguments, which must both be
> nonnegative integer constants (except when using prepared
> statements)."
> This is not going to happen by just clicking around on a clean Elgg
> install.
> On Aug 13, 9:24 pm, محمد مصطفى <mom2...@gmail.com> wrote:
> > hi
> > when i login as admin
> > and goto administrators page (elgg\admin) i have this error
> --------------------------------------------------------------------------- --------------
> > 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 '-90016373, 10' at line 1
> > QUERY: SELECT distinct e.* from elgg_entities e join
> > elgg_users_entity u on e.guid = u.guid where u.last_action >=
> > 1313283920 and ( (1 = 1) and e.enabled='yes') order by u.last_action
> > desc limit -90016373, 10
> --------------------------------------------------------------------------- -----------
> > thank you
> --
> You received this message because you are subscribed to the Google
> Groups "Elgg development" group.
> To post to this group, send email to elgg-development@googlegroups.com
> To unsubscribe from this group, send email to
> elgg-development+unsubscribe@googlegroups.com
> Elgg: http://elgg.org/
> Remember, bug reports should be filed at http://trac.elgg.org/elgg!