[ic] Problem with Berkeley DB_File on FreeBSD

[Kestutis Lasys]

Hello,

I have problem when using Berkeley DB_File for interchange databases on
FreeBSD.

I've installed interchange 4.6.3 on my Linux box and it runs without
problem.
But if I try it on FreeBSD box (hosting company) which use Berkeley
DB_File
instead of GDBM, I am getting the following error in item_edit:

  Bad SQL, query was: select DISTINCT category, category FROM products
ORDER BY category


I have found from list archive that somebody had the same problem: 

  
http://developer.akopia.com/archive/interchange-users/2000/msg10420.html

But I can't find how to fix this problem. Please advise.

Sorry for my English. 

Kestutis Lasys








Configuration:

FreeBSD:
-----------------------------------------------------------
Interchange version  4.6.3
Perl Information
Perl Version    Perl 5.00503 (called with: /usr/bin/perl) 
    Optional Module Information 
                 LWP::Simple found (v1.33).
                 MD5 found (v2.01).
                 MIME::Base64 found (v2.11).
                 SQL::Statement found (v0.1017).
                 Safe::Hole found (v0.08).
                 Storable found (v1.010).
                 Tie::Watch not found. Minor: cannot set watch points in
catalog.cfg.
                 URI::URL found (v5.02).
     Safe operations untrapped 
                 ftfile sort rand
Database Information
     Database Interfaces 
                 No GDBM.
                 Berkeley DB_File available (v1.65)
                 DBI enabled (v1.14), available drivers:
                           ADO
                           CSV
                           ExampleP
                           File
                           Multiplex
                           Proxy
                           mysql


Linux
-----------------------------------------------------------
Interchange version   4.6.3
Perl Information
Perl Version   Perl 5.00503 (called with: perl) 
    Optional Module Information 
                LWP::Simple found (v1.33).
                MD5 found (v2.01).
                MIME::Base64 found (v2.11).
                SQL::Statement found (v0.1017).
                Safe::Hole found (v0.08).
                Storable found (v1.010).
                Tie::Watch not found. Minor: cannot set watch points in
catalog.cfg.
                URI::URL found (v5.02).
     Safe operations untrapped 
                ftfile sort rand
Database Information
     Database Interfaces 
                GDBM available (v1.00)
                Berkeley DB_File available (v1.65)
                DBI enabled (v1.14), available drivers:
                            ADO
                            ExampleP
                            Multiplex
                            Proxy
                            mysql