Hello,
you should allow null values for uuid, username and domain:
uuid(str,null) username(str,null) domain(str,null) attribute(str) type(int) value(str) modified(int)
Daniel
On 06/29/05 02:55, Alexandre Passito wrote:
Hi all,
I'm trying to use DB_text module with AVPOPS module and I got the following error. I think that it could be the format of the database (col and type). I tried to implement it according to AVPOPS manual, but I think it could not be complete.
24(10259) DBT:dbt_load_file: request for table [preferences] 24(10259) DBT:dbt_load_file: db is [/home/alexandre/Devel/openser-0.9.4/bin/dbtext] 24(10259) DBT:dbt_load_file: loading file [/home/alexandre/Devel/openser-0.9.4/bin/dbtext/preferences] 24(10259) DBT: column[0] is STR! 24(10259) DBT: column[1] is STR! 24(10259) DBT: column[2] is STR! 24(10259) DBT: column[3] is STR! 24(10259) DBT: column[4] is INT! 24(10259) DBT: column[5] is STR! 24(10259) DBT: column[6] is INT! 24(10259) DBT:dbt_table_check_row: NULL value not allowed - field 0 24(10259) DBT:dbt_load_file: error at row=1 col=8 c=ΓΏ 24(10259) DTB:dbt_db_get_table: preferences 24(10259) DBT:dbt_query: table does not exist! 24(10259) ERROR:avpops:load_avps: db_load failed 24(10259) DEBUG: t_newtran: msg id=25 , global msg id=4 , T on entrance=0xffffffff 24(10259) parse_headers: flags=-1 24(10259) parse_headers: flags=60 24(10259) t_lookup_request: start searching: hash=30008, isACK=0 24(10259) DEBUG: RFC3261 transaction matching failed 24(10259) DEBUG: t_lookup_request: no transaction found
My table "preferences" looks like:
uuid(str) username(str) domain(str) attribute(str) type(int) value(str) modified(int) :andrea:localhost:1:2:alexandre@localhost:111
Any help will be helpful :-)
Best regards