dbtext: errors while saving registrations

Bugs item #1813095, was opened at 2007-10-13 21:05
Message generated for change (Comment added) made by nobody
You can respond by visiting: 
https://sourcefo
rge.net/tracker/?func=detail&atid=743020&aid=1813095
&group_id=139143

Please note that this message will contain a full copy of
the comment thread,
including the initial issue submission, for this request,
not just the latest update.
Category: modules
Group: ver devel
Status: Open
Resolution: None
Priority: 5
Private: No
Submitted By: Ovidiu Sas (osas)
Assigned to: Nobody/Anonymous (nobody)
Summary: dbtext: errors while saving registrations

Initial Comment:
Saving locations in dbtext doesn't work anymore.

I patched the following file in order to get more debug
output: modules/dbtext/dbt_tb.c

-    LM_DBG("incompatible types - field %dn",i);
+    LM_DBG("incompatible types - field %d [%d !=
%d]n",i, _dtp->colv[i]->type,
_drp->fields[i].type);


Issue 1:
========
dbtext:dbt_db_get_table: cache or mtime succeeded
dbtext:dbt_table_check_row: incompatible types - field 1 [2
!= 3]
dbtext:dbt_insert: cannot insert the new row!!
dbtext:dbt_insert: make clean!
db_insert_ucontact(): Error while inserting contact
ERROR:usrloc:insert_ucontact: failed to insert in database

Fixed by changing:
username(string) -> username(str)


Issue 2:
========
dbtext:dbt_db_get_table: cache or mtime succeeded
dbtext:dbt_table_check_row: null value not allowed - field
2
dbtext:dbt_insert: cannot insert the new row!!
dbtext:dbt_insert: make clean!
db_insert_ucontact(): Error while inserting contact
ERROR:usrloc:insert_ucontact: failed to insert in database

Fixed by changing
domain(string) -> domain(string,null)

Issue 3:
========
dbtext:dbt_db_get_table: cache or mtime succeeded
dbtext:dbt_table_check_row: incompatible types - field 3 [2
!= 3]
dbtext:dbt_insert: cannot insert the new row!!
dbtext:dbt_insert: make clean!
db_insert_ucontact(): Error while inserting contact
ERROR:usrloc:insert_ucontact: failed to insert in database

Fixed by changing
contact(string) -> contact(str)


Issue 4:
========
dbtext:dbt_db_get_table: cache or mtime succeeded
dbtext:dbt_table_check_row: incompatible types - field 6 [0
!= 4]
dbtext:dbt_insert: cannot insert the new row!!
dbtext:dbt_insert: make clean!
db_insert_ucontact(): Error while inserting contact
ERROR:usrloc:insert_ucontact: failed to insert in database

It looks like the DB_DATETIME and DB_INT are no longer
compatible in dbtext mode.


typedef enum {
        DB_INT,        /* 32-bit integer */
        DB_DOUBLE,     /* double data type */
        DB_STRING,     /* Zero-terminated string */
        DB_STR,        /* str structure */
        DB_DATETIME,   /* Date and time */
        DB_BLOB,       /* Large binary object */
        DB_BITMAP      /* Bitmap of flags */
} db_type_t;


Also, we are having issues trying to save DB_STR into a
DB_STRING in dbtext mode.

------------------------------------------------------------
----------

Comment By: Nobody/Anonymous (nobody)
Date: 2007-10-24 08:46

Message:
Logged In: NO 

I have a similar problem with the location table. The domain
column does
not accept a NULL value so its definitions must be changed
to do so onto
the 1st row with table header of the "location"
file.


------------------------------------------------------------
----------

You can respond by visiting: 
https://sourcefo
rge.net/tracker/?func=detail&atid=743020&aid=1813095
&group_id=139143

_______________________________________________
Devel mailing list
Developenser.org
htt
p://openser.org/cgi-bin/mailman/listinfo/devel