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@openser.org http://openser.org/cgi-bin/mailman/listinfo/users