Subject | Re: [firebird-support] Query error after change FB 1.0.3 to 1.5.1 |
---|---|
Author | Arno Brinkman |
Post date | 2004-12-12T22:49:18Z |
Hi,
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
> after change FB from 1.0.3 to 1.5.1 (IBO, Linux, CS) everythingDid you updated your messages file?
> 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.
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