Subject Re: [firebird-support] Query error after change FB 1.0.3 to 1.5.1
Author Arno Brinkman
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