Menu
▾
▴
mdbtools-dev
|
From: Max B. <max...@gm...> - 2004-09-21 20:13:49
|
I've been testing mdb-export on a database of ours - it's producing rather odd dumps from one table - that is, some rows are missing, and some columns dump as being entirely blank, or in the wrong order. One thing possibly of note is that the columns in this table have been reorganized quite a lot. Unfortunately, the db in question contains data I wouldn't be able to get permission to release, and when I attempted to prune the data to a small subset, I found that the problem 'solved' itself when I ran "Compact Database". Is there any debugging that can I can do here, or does my inability to provide a copy of the database make it infeasibly difficult? Whatever happens, "Compact Database" seems to be an effective workaround. Thanks, Max. |
|
From: Christian L. <chr...@la...> - 2004-10-16 13:27:44
|
I've got the same problem than Max Bowsher (http://sourceforge.net/mailarchive/message.php?msg_id=9588463) but I can't "Compact Database" because I work under linux, on a single jet4 file that is sent "as is" by an external export routine. In fact, mdb-export and "select *" with mdb-sql give the same result : some rows of some tables are missing (all of them for one table). The same requests with 0.5 work fine. I don't know anything about mdb structure, so I can't help anyway, but I can send the mdb file in private if it helps (2.5Mb). Bye, Pif. |
|
From: Jeff S. <why...@ya...> - 2004-10-16 14:02:07
|
Please try the CVS version (contact the board again if you need help doing so), and if it still gives you these problems, you can send me you db to look at. -- Jeff Smith --- Christian Lefebvre <chr...@la...> wrote: > I've got the same problem than Max Bowsher > (http://sourceforge.net/mailarchive/message.php?msg_id=9588463) > but I can't "Compact Database" because I work under linux, on a single > jet4 file that is sent "as is" by an external export routine. > > In fact, mdb-export and "select *" with mdb-sql give the same > result : some rows of some tables are missing (all of them for one > table). > The same requests with 0.5 work fine. > I don't know anything about mdb structure, so I can't help anyway, > but I can send the mdb file in private if it helps (2.5Mb). > > Bye, Pif. _______________________________ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com |
|
From: Christian L. <chr...@la...> - 2004-10-16 18:38:18
|
On sam, 2004-10-16 at 16:02, Jeff Smith wrote: > Please try the CVS version Well .. I tried ;-) I don't know exactly how autoconf & co work, but I had to change some stuffs in it to make it work on my box : - unknown AC_PROG_LIBTOOL => changed to AM_PROG_LIBTOOL - unknown AC_CONFIG_FILES => deleted and added src/Makefile in AC_OUTPUT list - unknown AC_HELP_STRING => ignored because I couldn't find from where it appears - Makefile contains "READLINE_LIBS = no" instead of "READLINE_LIBS =" => modified dyrectly in generated Makefiles cause I don't know how it's generated. - g_ptr_array_foreach not in my glibc 2.2.3 version => changed src/sql/mdbsql.c like before 1.31 version (thanks to "cvs diff" ;-) After this, everything compiled fine, but the result is really weird : - if I do this : export LD_LIBRARY_PATH=src/libmdb/.libs:src/sql/.libs ./src/util/mdb-export ../liste.mdb UNITE I got an empty result - if I do this : make install cd "where the --prefix option points to" export LD_LIBRARY_PATH=lib bin/mdb-export ../liste.mdb UNITE I got the correct result !!! What's the difference ? What did "make install" do on files to make them work ?! Last test: after a "make install" on 0.6pre1 tar, I still got the fault. It really seems to be a "twilight zone" story :-) So, for the moment, I've a version which works, but I'd like to understand why ! Bye, Pif. |
|
From: Christian L. <chr...@la...> - 2004-10-16 21:37:41
|
On sam, 2004-10-16 at 20:38, Christian Lefebvre wrote: Sorry, forget the 3 first points, I upgraded autoconf and it works fine ... > - unknown AC_PROG_LIBTOOL => changed to AM_PROG_LIBTOOL > - unknown AC_CONFIG_FILES => deleted and added src/Makefile in > AC_OUTPUT list > - unknown AC_HELP_STRING => ignored because I couldn't find from > where it appears but those ones are still there ;-) > - Makefile contains "READLINE_LIBS = no" instead of > "READLINE_LIBS =" => modified dyrectly in generated Makefiles cause I > don't know how it's generated. > - g_ptr_array_foreach not in my glibc 2.2.3 version => changed > src/sql/mdbsql.c like before 1.31 version (thanks to "cvs diff" ;-) About the missing rows, I tried different variations, but i've still not found why it doesn't works sometimes. To be continued (it's time to bed here ;-) Bye, Pif. |
|
From: Michael W. <mw...@ic...> - 2004-10-18 07:48:56
|
On Sat, Oct 16, 2004 at 11:37:31PM +0200, Christian Lefebvre wrote:
> On sam, 2004-10-16 at 20:38, Christian Lefebvre wrote:
>
> but those ones are still there ;-)
> > - Makefile contains "READLINE_LIBS = no" instead of
> > "READLINE_LIBS =" => modified dyrectly in generated
> > Makefiles cause I don't know how it's generated.
I would guess this is a bug in the autoconf/configure stuff.
Haven't looked, though, and I am no autoconf expert :)
> > - g_ptr_array_foreach not in my glibc 2.2.3 version => changed
^^^^^
I assume you mean glib (which is completely different from
glibc.) mdbtools probably just depends on a different version
of glib than the one you have installed. glib-2.0 does have
g_ptr_array_foreach. I haven't looked at other versions.
$ nm /usr/lib/libglib-2.0.a | grep g_ptr_array_foreach
00001220 T g_ptr_array_foreach
I've just had a look in configure.in and it says:
if test "$no_glib" = "yes"; then
echo
echo "glib 2.0 is required by MDB Tools."
echo "It can be downloaded at www.gtk.org."
echo
exit 1
fi
> > src/sql/mdbsql.c like before 1.31 version (thanks to "cvs diff" ;-)
>
> About the missing rows, I tried different variations, but
> i've still not found why it doesn't works sometimes.
Do you have old libmdb stuff lying around? That might somehow
be interfering?
I hope this helps.
--
Michael Wood <mw...@ic...>
|
|
From: Christian L. <chr...@la...> - 2004-10-18 20:12:48
|
On lun, 2004-10-18 at 09:47, Michael Wood wrote:
> On Sat, Oct 16, 2004 at 11:37:31PM +0200, Christian Lefebvre wrote:
> > On sam, 2004-10-16 at 20:38, Christian Lefebvre wrote:
> >
> > but those ones are still there ;-)
> > > - Makefile contains "READLINE_LIBS = no" instead of
> > > "READLINE_LIBS =" => modified dyrectly in generated
> > > Makefiles cause I don't know how it's generated.
>
> I would guess this is a bug in the autoconf/configure stuff.
> Haven't looked, though, and I am no autoconf expert :)
neither I am !
> > > - g_ptr_array_foreach not in my glibc 2.2.3 version => changed
> ^^^^^
> I assume you mean glib
Oops ! yes of course.
> $ nm /usr/lib/libglib-2.0.a | grep g_ptr_array_foreach
> 00001220 T g_ptr_array_foreach
$ nm /usr/lib/libglib-2.0.a | grep g_ptr_array_
00000e10 T g_ptr_array_add
00000970 T g_ptr_array_free
00000a60 t g_ptr_array_maybe_expand
00000860 T g_ptr_array_new
00000cf0 T g_ptr_array_remove
00000d80 T g_ptr_array_remove_fast
00000b50 T g_ptr_array_remove_index
00000c30 T g_ptr_array_remove_index_fast
00000ab0 T g_ptr_array_set_size
00000880 T g_ptr_array_sized_new
00000e90 T g_ptr_array_sort
00000f00 T g_ptr_array_sort_with_data
U g_ptr_array_add
U g_ptr_array_free
U g_ptr_array_new
U g_ptr_array_set_size
no foreach
$ rpm -qif /usr/lib/libglib-2.0.a
Name : libglib2.0_0-devel Relocations: (not relocateable)
Version : 2.2.3 Vendor: MandrakeSoft
Release : 1mdk Build Date: Wed 27 Aug 2003 11:00:42 AM CEST
Install Date: Mon 11 Oct 2004 09:58:56 PM CEST Build Host: hp6.mandrakesoft.com
Group : Development/C Source RPM: glib2.0-2.2.3-1mdk.src.rpm
|
|
From: Brian B. <bri...@gm...> - 2004-10-18 22:01:00
|
Oops, this should have gone to list -- g_ptr_array_foreach was introduced in glib 2.4 AFAICT. The offending checkin seems to be ------------ revision 1.31 date: 2004/08/25 02:12:59; author: whydoubt; state: Exp; lines: +46 -71 Tidy up a few SQL-related functions -------------- Seems we need to go back to using a plain old for loop. Brian On Mon, 18 Oct 2004 22:12:39 +0200, Christian Lefebvre <chr...@la...> wrote: > On lun, 2004-10-18 at 09:47, Michael Wood wrote: > > On Sat, Oct 16, 2004 at 11:37:31PM +0200, Christian Lefebvre wrote: > > > On sam, 2004-10-16 at 20:38, Christian Lefebvre wrote: > > > > > > but those ones are still there ;-) > > > > - Makefile contains "READLINE_LIBS = no" instead of > > > > "READLINE_LIBS =" => modified dyrectly in generated > > > > Makefiles cause I don't know how it's generated. > > > > I would guess this is a bug in the autoconf/configure stuff. > > Haven't looked, though, and I am no autoconf expert :) > neither I am ! > > > > > - g_ptr_array_foreach not in my glibc 2.2.3 version => changed > > ^^^^^ > > I assume you mean glib > Oops ! yes of course. > > > $ nm /usr/lib/libglib-2.0.a | grep g_ptr_array_foreach > > 00001220 T g_ptr_array_foreach > > $ nm /usr/lib/libglib-2.0.a | grep g_ptr_array_ > 00000e10 T g_ptr_array_add > 00000970 T g_ptr_array_free > 00000a60 t g_ptr_array_maybe_expand > 00000860 T g_ptr_array_new > 00000cf0 T g_ptr_array_remove > 00000d80 T g_ptr_array_remove_fast > 00000b50 T g_ptr_array_remove_index > 00000c30 T g_ptr_array_remove_index_fast > 00000ab0 T g_ptr_array_set_size > 00000880 T g_ptr_array_sized_new > 00000e90 T g_ptr_array_sort > 00000f00 T g_ptr_array_sort_with_data > U g_ptr_array_add > U g_ptr_array_free > U g_ptr_array_new > U g_ptr_array_set_size > > no foreach > > $ rpm -qif /usr/lib/libglib-2.0.a > Name : libglib2.0_0-devel Relocations: (not relocateable) > Version : 2.2.3 Vendor: MandrakeSoft > Release : 1mdk Build Date: Wed 27 Aug 2003 11:00:42 AM CEST > Install Date: Mon 11 Oct 2004 09:58:56 PM CEST Build Host: hp6.mandrakesoft.com > Group : Development/C Source RPM: glib2.0-2.2.3-1mdk.src.rpm > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJournal > Use IT products in your business? Tell us what you think of them. Give us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > |
|
From: Jeff S. <why...@ya...> - 2004-10-19 02:22:46
|
Sorry about that. I did not mean to incorporate a dependency on GLib 2.4. I will correct this shortly. -- Jeff --- Brian Bruns <bri...@gm...> wrote: > Oops, this should have gone to list > -- > > g_ptr_array_foreach was introduced in glib 2.4 AFAICT. The offending > checkin seems to be > > ------------ > revision 1.31 > date: 2004/08/25 02:12:59; author: whydoubt; state: Exp; lines: +46 -71 > Tidy up a few SQL-related functions > -------------- > > Seems we need to go back to using a plain old for loop. > > Brian > > > On Mon, 18 Oct 2004 22:12:39 +0200, Christian Lefebvre > <chr...@la...> wrote: > > On lun, 2004-10-18 at 09:47, Michael Wood wrote: > > > On Sat, Oct 16, 2004 at 11:37:31PM +0200, Christian Lefebvre wrote: > > > > On sam, 2004-10-16 at 20:38, Christian Lefebvre wrote: > > > > > > > > but those ones are still there ;-) > > > > > - Makefile contains "READLINE_LIBS = no" instead of > > > > > "READLINE_LIBS =" => modified dyrectly in generated > > > > > Makefiles cause I don't know how it's generated. > > > > > > I would guess this is a bug in the autoconf/configure stuff. > > > Haven't looked, though, and I am no autoconf expert :) > > neither I am ! > > > > > > > - g_ptr_array_foreach not in my glibc 2.2.3 version => changed > > > ^^^^^ > > > I assume you mean glib > > Oops ! yes of course. > > > > > $ nm /usr/lib/libglib-2.0.a | grep g_ptr_array_foreach > > > 00001220 T g_ptr_array_foreach > > > > $ nm /usr/lib/libglib-2.0.a | grep g_ptr_array_ > > 00000e10 T g_ptr_array_add > > 00000970 T g_ptr_array_free > > 00000a60 t g_ptr_array_maybe_expand > > 00000860 T g_ptr_array_new > > 00000cf0 T g_ptr_array_remove > > 00000d80 T g_ptr_array_remove_fast > > 00000b50 T g_ptr_array_remove_index > > 00000c30 T g_ptr_array_remove_index_fast > > 00000ab0 T g_ptr_array_set_size > > 00000880 T g_ptr_array_sized_new > > 00000e90 T g_ptr_array_sort > > 00000f00 T g_ptr_array_sort_with_data > > U g_ptr_array_add > > U g_ptr_array_free > > U g_ptr_array_new > > U g_ptr_array_set_size > > > > no foreach > > > > $ rpm -qif /usr/lib/libglib-2.0.a > > Name : libglib2.0_0-devel Relocations: (not relocateable) > > Version : 2.2.3 Vendor: MandrakeSoft > > Release : 1mdk Build Date: Wed 27 Aug 2003 11:00:42 AM > CEST > > Install Date: Mon 11 Oct 2004 09:58:56 PM CEST Build Host: hp6.mandrakesoft.com > > Group : Development/C Source RPM: glib2.0-2.2.3-1mdk.src.rpm > > > > ------------------------------------------------------- > > This SF.net email is sponsored by: IT Product Guide on ITManagersJournal > > Use IT products in your business? Tell us what you think of them. Give us > > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more > > http://productguide.itmanagersjournal.com/guidepromo.tmpl > > _______________________________________________ > > mdbtools-dev mailing list > > mdb...@li... > > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > > > > > ------------------------------------------------------- > This SF.net email is sponsored by: IT Product Guide on ITManagersJournal > Use IT products in your business? Tell us what you think of them. Give us > Your Opinions, Get Free ThinkGeek Gift Certificates! Click to find out more > http://productguide.itmanagersjournal.com/guidepromo.tmpl > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > _______________________________ Do you Yahoo!? Declare Yourself - Register online to vote today! http://vote.yahoo.com |
|
From: Peter S. <phm...@st...> - 2004-10-27 14:49:47
|
Hi,
I am following the discussions on this list for a while now but I am
still using the 0.5 version. But unfortunately I need to upgrade to 0.6
because BOOL fields are not handled properly in my current version
(always returns NULL with mdb-export).
But 0.6 does not compile on my system because of the GLIB dependency.
When do you think this will be fixed?
And as a second question, I just did a
cvs -z3
-d:pserver:ano...@cv...:/cvsroot/mdbtools co
mdbtools
but that downloads all files except for the configure, config.guess and
config.sub
Did I do something wrong here?
Please tell me because I have never used cvs before...
Thanks in advance
Peter
Jeff Smith wrote:
>Sorry about that. I did not mean to incorporate a dependency on GLib 2.4.
>I will correct this shortly.
>
> -- Jeff
><snip>
>
>
>>>>>>- g_ptr_array_foreach not in my glibc 2.2.3 version => changed
>>>>>>
>>>>>>
>>>> ^^^^^
>>>>I assume you mean glib
>>>>
>>>>
>>>Oops ! yes of course.
>>>
>>>
|
|
From: Christian L. <chr...@la...> - 2004-10-27 18:42:30
|
On mer, 2004-10-27 at 16:49, Peter Scheer wrote: > And as a second question, I just did a > cvs -z3 > -d:pserver:ano...@cv...:/cvsroot/mdbtools co > mdbtools > but that downloads all files except for the configure, config.guess and > config.sub they must be generated by aclocal, using autogen.sh script which is in the cvs Bye, Pif. |
|
From: Jeff S. <why...@ya...> - 2004-10-28 04:34:58
|
1. I fixed the GLib issue in CVS several days ago. 2. As Christian said, autogen.sh will generate all files necessary to run configure. Note that it is best to have fairly up-to-date versions of automake, autoconf, and libtool. -- Jeff Smith --- Peter Scheer <phm...@st...> wrote: > Hi, > > I am following the discussions on this list for a while now but I am > still using the 0.5 version. But unfortunately I need to upgrade to 0.6 > because BOOL fields are not handled properly in my current version > (always returns NULL with mdb-export). > > But 0.6 does not compile on my system because of the GLIB dependency. > When do you think this will be fixed? > > > And as a second question, I just did a > cvs -z3 > -d:pserver:ano...@cv...:/cvsroot/mdbtools co > mdbtools > but that downloads all files except for the configure, config.guess and > config.sub > > Did I do something wrong here? > Please tell me because I have never used cvs before... > > Thanks in advance > > Peter > > Jeff Smith wrote: > > >Sorry about that. I did not mean to incorporate a dependency on GLib 2.4. > >I will correct this shortly. > > > > -- Jeff > ><snip> > > > > > >>>>>>- g_ptr_array_foreach not in my glibc 2.2.3 version => changed > >>>>>> > >>>>>> > >>>> ^^^^^ > >>>>I assume you mean glib > >>>> > >>>> > >>>Oops ! yes of course. > >>> > >>> _______________________________ Do you Yahoo!? Express yourself with Y! Messenger! Free. Download now. http://messenger.yahoo.com |
|
From: Christian L. <chr...@la...> - 2004-10-24 13:27:23
|
On sam, 2004-10-16 at 15:27, Christian Lefebvre wrote: > I've got the same problem than Max Bowsher > (http://sourceforge.net/mailarchive/message.php?msg_id=9588463) Well .. I've got it ! As 0.5 version worked fine for me, I tried to find from which version it became bad, and i found this : revision 1.28 date: 2004/01/06 00:42:08; author: brianb; state: Exp; lines: +2 -2 patches 00-14 from David Mansfield RCS file: /cvsroot/mdbtools/mdbtools/src/libmdb/file.c,v retrieving revision 1.28 retrieving revision 1.27 diff -b -r1.28 -r1.27 27c27 < 4096, 0x0c, 16, 45, 47, 51, 55, 56, 63, 12, 15, 23, 5, 25, 59 --- > 4096, 0x0c, 12, 45, 47, 51, 55, 56, 63, 12, 15, 23, 5, 25, 59 Without this change, it works; with it, it stop working. I put back the "12" value in the last cvs version, and it works. I don't know what is this tab_num_rows_offset, but it seems buggy with my file. it's a Jet4 file, but perhaps there are different subversions ? |
|
From: David M. <mdb...@dm...> - 2004-09-21 22:21:47
|
What version of the s/w are you using? David On Tue, 2004-09-21 at 16:13, Max Bowsher wrote: > I've been testing mdb-export on a database of ours - it's producing > rather odd dumps from one table - that is, some rows are missing, and > some columns dump as being entirely blank, or in the wrong order. One > thing possibly of note is that the columns in this table have been > reorganized quite a lot. > > Unfortunately, the db in question contains data I wouldn't be able to > get permission to release, and when I attempted to prune the data to a > small subset, I found that the problem 'solved' itself when I ran > "Compact Database". > > Is there any debugging that can I can do here, or does my inability to > provide a copy of the database make it infeasibly difficult? > > Whatever happens, "Compact Database" seems to be an effective workaround. > > Thanks, > > Max. > > > ------------------------------------------------------- > This SF.Net email is sponsored by: YOU BE THE JUDGE. Be one of 170 > Project Admins to receive an Apple iPod Mini FREE for your judgement on > who ports your project to Linux PPC the best. Sponsored by IBM. > Deadline: Sept. 24. Go here: http://sf.net/ppc_contest.php > _______________________________________________ > mdbtools-dev mailing list > mdb...@li... > https://lists.sourceforge.net/lists/listinfo/mdbtools-dev > |
|
From: Max B. <max...@gm...> - 2004-09-22 08:34:02
|
On Tue, 21 Sep 2004 18:21:36 -0400, David Mansfield <mdb...@dm...> wrote: > What version of the s/w are you using? 0.6pre1, on a JET3 database. > On Tue, 2004-09-21 at 16:13, Max Bowsher wrote: > > I've been testing mdb-export on a database of ours - it's producing > > rather odd dumps from one table - that is, some rows are missing, and > > some columns dump as being entirely blank, or in the wrong order. One > > thing possibly of note is that the columns in this table have been > > reorganized quite a lot. > > > > Unfortunately, the db in question contains data I wouldn't be able to > > get permission to release, and when I attempted to prune the data to a > > small subset, I found that the problem 'solved' itself when I ran > > "Compact Database". > > > > Is there any debugging that can I can do here, or does my inability to > > provide a copy of the database make it infeasibly difficult? > > > > Whatever happens, "Compact Database" seems to be an effective workaround. > > > > Thanks, > > > > Max. |
×
Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.
Thanks for helping keep SourceForge clean.
X