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
_______________________________________________
Devel mailing list
Devel@openser.org
http://openser.org/cgi-bin/mailman/listinfo/devel
