[OpenSER-Devel] [ openser-Bugs-1813095 ] dbtext: errors while saving registrations

[SourceForge.net]

Bugs item #1813095, was opened at 2007-10-14 00:05
Message generated for change (Tracker Item Submitted) made by Item Submitter
You can respond by visiting: 
https://sourceforge.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 %d\n",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.

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

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