[Users] AVPops: inconsistent usage of DB scheme

[Bogdan-Andrei Iancu]

Hi Franz,

the problem is you do not have a complete avp specification. You have 
just "i:" instead of "i:id". When you use a schema, there is no column 
with the avp name/id (as it is in the user_preferences table), so you 
have to define from scrip the avp name/id to load the info into.

Doing:
    avp_db_load("$auth-user","i:13/$P-assoc");

will fix the problem. The info will be available in i:13 AVP.

regards,
bogdan


Franz Edler wrote:

>Hi,
>again I need some help from AVPops-experts.
>
>I have created a table for P-Associated-URI - parameter (addressed via
>uuid).
>	CREATE TABLE associated_uris (
>	  auth_user varchar(64) NOT NULL default '',
>	  id varchar(32) NOT NULL default '',
>	  uri varchar(128) NOT NULL default '',
>	  type integer NOT NULL default '0',
>	  modified timestamp(14) NOT NULL,
>	  PRIMARY KEY (auth_user, id)
>	) TYPE=MyISAM;
>
>I also have created the following db-scheme:
>	
>modparam("avpops","db_scheme","P-assoc:uuid_col=auth_user;value_col=id;value
>_type=string;table=associated_uris")
>
>When I access the table with 
>	avp_db_load("$auth-user","i:/$P-assoc"); 
>
>I get the error:
>	0(0) ERROR:avpops:parse_avp_db: inconsistent usage of DB scheme
>without complet specification of AVP name
> 	0(0) ERROR:avpops:fixup_db_avp: parse failed
>
>Any help appreciated.
>Franz
>
>
>_______________________________________________
>Users mailing list
>Users at openser.org
>http://openser.org/cgi-bin/mailman/listinfo/users
>
>  
>