[Bond-users] Error testing bonddb

[Bryce Tanner]

Thanks to liam for helping with my compile problems.  Both bond and 
bonddb compiled and installed without complaint.

But I've now hit errors testing bonddb.  I'm afraid I've too little 
experience with databases at the moment to understand the precise nature 
of the problem.  Any help would be vastly appreciated.
The output is below.

Thanks

Bryce


[root at dekopon bonddb]# ls
SConstruct      bonddbfield.h    bonddbglobal.h   bonddbinit.h    
bonddbloadby.h   bonddbparse.h    bonddbpurify.h   bonddbtest.c      
bonddbwrite.os
bonddb.h        bonddbfield.os   bonddbglobal.os  bonddbinit.os   
bonddbloadby.os  bonddbparse.os   bonddbpurify.os  
bonddbtest.conf                
bonddbarray.c   bonddbfilter.c   bonddbid.c       bonddbkey.c     
bonddbobj.c      bonddbplugin.c   bonddbrecord.c   
bonddbtest.conf~               
bonddbarray.h   bonddbfilter.h   bonddbid.h       bonddbkey.h     
bonddbobj.h      bonddbplugin.h   bonddbrecord.h   
bonddbtest.o                   
bonddbarray.os  bonddbfilter.os  bonddbid.os      bonddbkey.os    
bonddbobj.os     bonddbplugin.os  bonddbrecord.os  
bonddbwrite.c                  
bonddbfield.c   bonddbglobal.c   bonddbinit.c     bonddbloadby.c  
bonddbparse.c    bonddbpurify.c   bonddbtest       bonddbwrite.h 
                
[root at dekopon bonddb]# 
./bonddbtest                                                                                                                  

Reading configuration file: 
bonddbtest.conf.                                                                                                         

Shared configuration file not found: shell.conf
================================================================================
Connecting to database: dbname=testbond connect_timeout=5 user=bryce 
password=bryce host=localhost
<bonddb/bonddbplugin.c:254 bonddb_plugin_init();>  checking ./.libs/ for 
libbonddb2_pgsql.so
<bonddb/bonddbplugin.c:254 bonddb_plugin_init();>  checking ./lib/ for 
libbonddb2_pgsql.so
<bonddb/bonddbplugin.c:254 bonddb_plugin_init();>  checking 
/usr/local/lib/ for libbonddb2_pgsql.so
Checking library: /usr/local/lib/libbonddb2_pgsql.so for pgsql
Library /usr/local/lib/libbonddb2_pgsql.so successfully loaded.
Loaded library: /usr/local/lib/libbonddb2_pgsql.so
Remote write not activate
Administrator Connection Disabled: no connection info
To correct, specify the db_username_admin and db_password_admin 
configuration items.Connection to the database established successfully.
TEST STARTING: (1) BonddbClass new and free
TEST PASSED
TEST STARTING: (2) BonddbClass sql run now
TEST PASSED
TEST STARTING: (3) BonddbClass sql run now raw
TEST PASSED
TEST STARTING: (4) BonddbClass sql numrecords()
TEST PASSED
TEST STARTING: (5) BonddbClass state logic
<bonddb/bonddbtest.c:81 bonddb_runtest();> step 1

<bonddb/bonddbtest.c:89 bonddb_runtest();> step 2

<bonddb/bonddbtest.c:97 bonddb_runtest();> step 3

Error: bonddb/bonddbobj.c: 306: bonddb_sql_internal_exec(): SQL Failed 
with ERROR:  operator does not exist: character = integer
LINE 1: UPDATE person SET firstname='bobsmity' WHERE id=23
                                                       ^
HINT:  No operator matches the given name and argument type(s). You 
might need to add explicit type casts.

On: UPDATE person SET firstname='bobsmity' WHERE id=23
Aborting in 3 seconds.