Subject Re: Query error after change FB 1.0.3 to 1.5.1
Author wojciech_materna
Yes, I have changed FB versions few times, so .....
Thanks
Wojtek


--- In firebird-support@yahoogroups.com, "Arno Brinkman"
<firebird@a...> wrote:
> Hi,
>
> > after change FB from 1.0.3 to 1.5.1 (IBO, Linux, CS) everything
> > looks good, with one exception - one select gives me error :
> >
> > SQL Error code= -104, number of page buffers for cache required.
> >
> > In TIB_Connection I set Buffers=75 and in firebird.conf I set
> > DefaultDBCachePages = 75
> >
> > But Connection.dbPage_Buffers=0 when I stop my app after
connect to
> > FB database and look at this parameter.
> >
> > Query returns error. In FB 1.0.3 same query works. What's going
on?
> > What can I do.... Maybe somebody can tell something.
>
> Did you updated your messages file?
> It looks like you're getting a other message, but because your
message file
> is not updated it displays the wrong message.
> If this select is a aggregate query then you've possible used
fields in the
> select-list or ORDER BY clause that aren't part of the GROUP BY
clause.
>
> Regards,
> Arno Brinkman
> ABVisie
>
> -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
> Firebird open source database (based on IB-OE) with many SQL-99
features :
> http://www.firebirdsql.org
> http://www.firebirdsql.info
> http://www.fingerbird.de/
> http://www.comunidade-firebird.org/
>
> Support list for Interbase and Firebird users :
> firebird-support@yahoogroups.com
>
> Nederlandse firebird nieuwsgroep :
> news://80.126.130.81