Hi all,
i have this error repeated about 20 times when backing up my database:
gbak:error accessing BLOB column EXPLICATIE -- continuing
gbak: ERROR:invalid BLOB ID
What should i do?
Thank you,
Szilveszter
Hi,
It's missed BLOBs, good that you have this, not critical errors.
Perform backup and restore.
Regards,
Alexey Kovyazin
www.ibsurgeon.com
Hi all,
i have this error repeated about 20 times when backing up my database:
gbak:error accessing BLOB column EXPLICATIE -- continuing
gbak:
Hi,
It's missed BLOBs, good that you have this, not critical errors.
Perform backup and restore.
Regards,
Alexey Kovyazin
www.ibsurgeon.com
What's a 'missed' BLOB?
Alan
Hi all,
i have this error repeated about 20 times when backing up my database:
gbak:error accessing BLOB
Hi Alan,
Missed, orphaned, slightly corrupted - the is no strict term. There
will be error while trying to fetch such BLOB field, but gbak
[sometimes] can workaround it.
Regards,
Alexey Kovyazin
www.ibsurgeon.com
Hi,
It's missed BLOBs, good that you have this, not critical errors.
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:24 pm, fr...@schlottmann-goedde.de wrote:
On 26.10.2011 02:49, sir_wally_lewis wrote:
Thanks for the fixes to my C library Tomasz and for your help.
All my C Library is originally extracted from FreeUDFLibC and I added extra
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:25 pm, b...@benshort.co.uk wrote:
Hi,
I am using Firebird-2.1.3.18185-0 in the following configuration:
Classic Server
Embedded
Linux
On a raw device
I have been using the isc_database_info interface to query the database
info.
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:25 pm, d...@tetram.org wrote:
Hi,
I have a table with a field for which i need a default value. My problem
is the default value can change at any time. So the solution I found is
to use a before insert trigger.
But now, i'm
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:26 pm, mil...@panonnet.net wrote:
Tetram Corp wrote:
I thought about this solution but hoped there was a better one because
of, you're right, in my case the field has a restricted range but i've
an other similar case where
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:25 pm, ism...@citricos.co.cu wrote:
In the trigger:
if (new.myfield is null) then
Best Regards
=
|| ISMAEL ||
=
==Ticket History==
On Mar 07, 2014 @ 03:25 pm, chamberlin.d...@gmail.com wrote:
No Comment.
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:26 pm, fr...@schlottmann-goedde.de wrote:
Am 26.10.2011 02:49, schrieb sir_wally_lewis:
the same unaltered code works under CenTos 64 bit in 2.1 though.
Still do not understand why my freepascal UDF is crashing.
I have added
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:26 pm, m...@lawinegevaar.nl wrote:
No Comment.
==Ticket History==
On Mar 07, 2014 @ 03:26 pm, venussof...@gmail.com wrote:
Hi all
I know a qty. for a particular item purchased. This item though has been
purchased over a long
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:25 pm, as...@yahoo.com wrote:
Hi all,
I am trying to run Firebird on a Mac. (OSX Lion Server 10.27.2, Filebird
2.5.1). Actually, I tried CS and SS and both of them behave unstable. The
server can run for awhile (several hours)
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:27 pm, ho...@agencybusys.com wrote:
In certain queries I wish nulls to be treated as empty strings. For example:
Select Field1 || ' ' || Field2 AS MyOutputValue;
In this example, I want the value for Field1 to be returned even
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:27 pm, venussof...@gmail.com wrote:
--- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote:
On 5-11-2011 8:53, venussoftop wrote:
Hi all
I know a qty. for a particular item purchased. This item though has
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:27 pm, as...@yahoo.com wrote:
Thank you, Paul for the quick reply and for the script for uninstallation of
the firebird.
It seems that my problem was related with UDF, compiled using Free Pascal
which was described inFirebird 2.5
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:27 pm, mahesh.pratih...@sonata-software.com wrote:
Hi ALL,
Could you please let me know how I can do with the Performance in
Firebird 2.5?
Application is getting slower and slower as data is entered.
Thanks,
Mahesh
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:27 pm, t...@iblogmanager.com wrote:
I am using Firebird 2.5.1 embedded on a Windows 7 machine. Due to its
superclassic architecture, it is normally possible to have many simultaneous
connections from different applications to
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:28 pm, sistemas2000profesio...@gmail.com wrote:
Hello Karol
1. (connect by IP address) works well
2. (connect by domain name) doesn't work
Greetings.
Walter.
But what not work
1. connect by IP adress
2. connect by domain
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:29 pm, m...@lawinegevaar.nl wrote:
No Comment.
==Ticket History==
On Mar 07, 2014 @ 03:29 pm, tomconl...@gmail.com wrote:
--- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote:
On Wed, 9 Nov 2011 10:35:18
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:28 pm, alan.dav...@aldis-systems.co.uk wrote:
Hi, I have a major issue with 2.5.1.26351 running on W7 64bit, W2003
server, W2008 server, W7 32 bit and so on.
Basically I cannot get an update to work if a value is calculated
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:27 pm, em...@tot-consult.com wrote:
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote:
I am using Firebird 2.5.1 embedded on a Windows 7 machine. Due to its
superclassic architecture, it is normally
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:29 pm, kjell.ri...@datadia.se wrote:
Den 2011-11-09 10:39 skrev Mark Rotteveel såhär:
On Wed, 9 Nov 2011 10:35:18 +0100, Kjell Rilbe kjell.ri...@datadia.se
mailto:kjell.rilbe%40datadia.se
wrote:
Den 2011-11-09 10:31 skrev
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:29 pm, hele...@iinet.net.au wrote:
At 11:04 PM 9/11/2011, Mark Rotteveel wrote:
==Ticket History==
On Mar 07, 2014 @ 03:29 pm, m...@lawinegevaar.nl wrote:
No Comment.
--
On Mar 07, 2014 @ 03:29 pm, tomconl...@gmail.com
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:29 pm, m...@lawinegevaar.nl wrote:
No Comment.
==Ticket History==
On Mar 07, 2014 @ 03:29 pm, m...@omniaccounts.co.za wrote:
Another observation that we made is with transactions. Tae following example -
1 insert hundred
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:29 pm, shg_siste...@yahoo.com.ar wrote:
Hi Karol! Sorry bat I don't know how to do it with a normal select...
how would it be?
-s
[Non-text portions of this message have been removed]
--
This is an automated response.
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:29 pm, canacou...@gmail.com wrote:
Kjell,
Doesn’t using the dot separator imply that non us date formats are being used?
i.e. 07/11/2011 is interpreted as MM/DD/ while 07.11.2011 is interpreted
as DD/MM/?
--- In
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:30 pm, ch.kaufm...@splash-software.ch wrote:
Hi,
I have a website with PHP and a Firebird database. It looks like the Firebird
database becomes very slow and I don't know, how to find where and why.
My database is 15GB, the
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:29 pm, pre...@technisoft-online.com wrote:
--- In firebird-support@yahoogroups.com, Alan J Davies Alan.Davies@... wrote:
Hi Peter, a few things to check, from what you say you are familiar with
FB and Delphi:
localhosts is
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:30 pm, patrick_mar...@yahoo.com wrote:
Thanks for your reply,
creation of a ODBC connection to an embedded server works with SYSDBA only, is
that correct? I was not able to create one with another user.
If that's not correct:
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:30 pm, patrick_mar...@yahoo.com wrote:
Hello,
how can I get Firebird ODBC driver to connect to an embedded server by using
the security2.fdb?
Is there any reason, why the security2.fdb is being ignored in that case at
least by
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:30 pm, t...@iblogmanager.com wrote:
creation of a ODBC connection to an embedded server works with SYSDBA only,
is that correct? I was not able to create one with another user.
No. You should be able to connect with a
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:30 pm, t...@iblogmanager.com wrote:
I have a website with PHP and a Firebird database. It looks like the Firebird
database becomes very slow and I don't know, how to find where and why.
My database is 15GB, the biggest table
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:31 pm, t...@iblogmanager.com wrote:
I am trying to create the following SP but am receiving the message Feature
not supported on ODS version older than 11.1 but I cannot work out what it
is that it doesn't like about the SP.
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:29 pm, kjell.ri...@datadia.se wrote:
Den 2011-11-09 09:49 skrev canacourse såhär:
I assume you meant cast ('6.11.2011 08:35:26' as timestamp);? I have
tried that but still no records are returned in Ibexpert or ISQL.
Make
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:31 pm, li...@2ls.com wrote:
Is the correct answer!
Thanks Thomas.
Neil
--- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote:
I am trying to create the following SP but am receiving the message
Feature
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:29 pm, kjell.ri...@datadia.se wrote:
Den 2011-11-09 10:31 skrev canacourse såhär:
Kjell,
Doesn’t using the dot separator imply that non us date formats are
being used? i.e. 07/11/2011 is interpreted as MM/DD/ while
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:32 pm, hele...@iinet.net.au wrote:
At 08:37 PM 14/11/2011, Mr. John wrote:
Hi ! We need to deploy firebird server with another password for sysdba user.
One solution is replacing security2.fdb during install of our
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:31 pm, li...@2ls.com wrote:
Hi
I am trying to create the following SP but am receiving the message Feature
not supported on ODS version older than 11.1 but I cannot work out what it is
that it doesn't like about the SP.
For
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:32 pm, adam.cir...@ri.t-com.hr wrote:
Do you make FK over existing records?You probably already have old records in
second table which refer to nonexistent PK in first table.Delete all old orphan
records in second table, and
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote:
That is working from inside NSIS installer:
ExecWait 'gsec -user sysdba -password masterkey -modify SYSDBA -pw mypassword'
==Ticket History==
On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote:
Thanks Helen and Thomas for answers.
Is it a way to change the password automatically,not manually,that I should do
with my application install.
Thanks
==Ticket History==
On Mar 07, 2014 @
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:32 pm, venussof...@gmail.com wrote:
Hi all
I have a Stored Procedure as below. I know it is my handling of the calculated
field bQtyOut which is wrong and that is where the error in the returned data
set is. Can someone
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote:
Thank you,it is a fine solution !
==Ticket History==
On Mar 07, 2014 @ 03:32 pm, t...@iblogmanager.com wrote:
Thanks Helen and Thomas for answers.
Is it a way to change the password
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:32 pm, peshk...@mail.ru wrote:
--- In firebird-support@yahoogroups.com, Matthias Hanft mh@... wrote:
Hi,
since many years, I've been using Firebird with Gentoo Linux kernels up to
2.6.38 without any problems - currently FB
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:32 pm, m...@lawinegevaar.nl wrote:
No Comment.
==Ticket History==
On Mar 07, 2014 @ 03:32 pm, mr_joh...@yahoo.com wrote:
added,thanks !
--
On Mar 07, 2014 @ 03:32 pm, l...@frred.de wrote:
Am 14.11.2011 10:05, schrieb Mr.
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:32 pm, l...@frred.de wrote:
Am 14.11.2011 10:05, schrieb Mr. John:
That is working from inside NSIS installer:
ExecWait 'gsec -user sysdba -password masterkey -modify SYSDBA -pw
mypassword'
Remember to check this with
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:32 pm, t...@iblogmanager.com wrote:
Hi ! We need to deploy firebird server with another password for sysdba user.
One solution is replacing security2.fdb during install of our
application+server.
Is it good solution ?
This is a notification from the Help Desk.
On Mar 07, 2014 @ 03:32 pm, m...@hanft.de wrote:
Hi,
since many years, I've been using Firebird with Gentoo Linux kernels up to
2.6.38 without any problems - currently FB 2.0.3.12981.0-r6 (the newest
stable version which is available as a Gentoo
I am trying to make a backup of our database that is on a Unix box, from my
windows computer.
I have used: Firebird Maestro, IP Firebird Database Manager, Firebird SQL
Studio.
I am not sure if I am doing something wrong, or just not possible.
When I run the backup from these tools, and
Em 7/3/2014 14:13, Art McCabe escreveu:
I am trying to make a backup of our database that is on a Unix box,
from my windows computer.
I have used: Firebird Maestro, IP Firebird Database Manager, Firebird
SQL Studio.
I am not sure if I am doing something wrong, or just not possible.
When
I have a growing number of databases with essentially the same table structures
that must remain as separate entities. However, a large number of the tables
in these databases house exactly the same valid values (Lookup Tables). If I
add a new valid value, I migrate through each database to
Thank you, I used the gbak to run the backup and that worked.
Art
From: Alexandre Benson Smith
Sent: Friday, March 7, 2014 2:09 PM
To: firebird-support@yahoogroups.com
Em 7/3/2014 14:13, Art McCabe escreveu:
I am trying to make a backup of our database
Hey guys!
I want to ask this question (even though I know the answer) in case someone
else might want to know in the future.
Can/should the Firebird.conf LockHashSlots value be changed while databases are
open/engine is running?
I think the answer is No but I want to ask this question in
We have an application using Delphi, IBObjects and Firebird, which is being
run in both a single-user and multi-user basis. The multi-user version has
users on separate PCs operating against a single Firebird DB on a server.
Lately, after releasing an updated version (in which the Firebird
From: Leyne, Sean
We have an application using Delphi, IBObjects and Firebird, which is
being
run in both a single-user and multi-user basis. The multi-user version has
users on separate PCs operating against a single Firebird DB on a server.
Lately, after releasing an updated version (in
Woody,
We have an application using Delphi, IBObjects and Firebird, which is
being run in both a single-user and multi-user basis. The multi-user
version has users on separate PCs operating against a single Firebird
DB on a server.
Lately, after releasing an updated version (in which
We have an application using Delphi, IBObjects and Firebird, which is
being
run in both a single-user and multi-user basis. The multi-user version has
users on separate PCs operating against a single Firebird DB on a server.
Lately, after releasing an updated version (in which the Firebird
08.03.2014 02:39, Leyne, Sean wrote:
I want to ask this question (even though I know the answer) in case
someone else might want to know in the future.
Can/should the Firebird.conf LockHashSlots value be changed while
databases are open/engine is running?
I think the answer is “No” but I
58 matches
Mail list logo
