[Serusers] ERROR:avpops:dbrow2avp: dbrow contains NULL fields----SOLVED

[Iqbal]

well I guess reading docs on berlios does work :-)

I had created the type colum as a varchar (my default when I dont pay
attention), and it should be a int, with default set to 0, and NOT
NULL...

Iqbal

On 3/11/2005, "Iqbal" <iqbal at gigo.co.uk> wrote:

>
>....and when I populate the fields with dummy values I get
>
>ERROR:avpops:dbrow2avp: wrong field types in dbrow
>
>my table is
>
>+-----------+---------------+------+-----+---------+-------+
>| Field     | Type          | Null | Key | Default | Extra |
>+-----------+---------------+------+-----+---------+-------+
>| uuid      | varchar(64)   |      |     |         |       |
>| username  | varchar(100)  |      | PRI | 0       |       |
>| domain    | varchar(128)  |      | PRI |         |       |
>| attribute | varchar(32)   |      | PRI |         |       |
>| value     | varchar(128)  |      |     |         |       |
>| modified  | timestamp(14) | YES  |     | NULL    |       |
>| type      | varchar(255)  | YES  |     | NULL    |       |
>+-----------+---------------+------+-----+---------+-------+
>
>
>
>
>On 3/11/2005, "Iqbal" <iqbal at gigo.co.uk> wrote:
>
>>
>>Hi
>>
>>I seem to be seeing this in my debug with 0.9 ser, when using the
>>following
>>
>>if (avp_db_load("$ruri/username", "s:donotdisturb"))
>>
>>I think its because i have a empty uuid field in my DB for
>>user_preferences...can someone confirm this, if this is the case what
>>should the uuid in the table be, since it is NULL in subscribers also.
>>
>>iqbal
>>
>>_______________________________________________
>>Serusers mailing list
>>serusers at lists.iptel.org
>>http://lists.iptel.org/mailman/listinfo/serusers
>>
>>
>
>_______________________________________________
>Serusers mailing list
>serusers at lists.iptel.org
>http://lists.iptel.org/mailman/listinfo/serusers
>
>