[isf-wifidog] User profiles

Ismail Uman ismail.uman at alice.it
Lun 23 Juin 17:01:13 EDT 2008

Hi all,
I have the following error while I try to insert user profile fields in
the database of the auth server: 

execSqlUpdate() : An error occured while executing the following SQL
query :
INSERT INTO profile_fields (profile_id, profile_field_id,
profile_template_field_id) VALUES ('5a332a552e1514a416ccf42adb998d05',
'29556a12e8bc0f3c1b22c7f43c4215c4', '');

Error message : 
ERROR: insert or update on table "profile_fields" violates foreign key
constraint "profile_fields_profile_template_field_id_fkey" DETAIL: Key
(profile_template_field_id)=() is not present in table


#0 /srv/www/wifidog-auth/wifidog/classes/ProfileField.php(250):
#1 /srv/www/wifidog-auth/wifidog/classes/Profile.php(391):
#2 /srv/www/wifidog-auth/wifidog/classes/User.php(957):
#3 /srv/www/wifidog-auth/wifidog/admin/generic_object_admin.php(174):

I installed the June 2008 updated version of auth server with 
svn checkout https://dev.wifidog.org/svn/trunk/wifidog-auth
and the gateway with 
svn checkout https://dev.wifidog.org/svn/trunk/wifidog
on the same computer with SuSE 10.3. The computer is also acting as a
The server and the gateway work fine but I need to fit the auth server
to the Italian laws adding a custom profile with the
following information of the wifispot users to the database:
-first name and family name 
-birth date and birth place  
-scanned document ID 
Can this information be associated to the user profile fields? If yes
how to do it?    
Best regards.
Ismail Uman

Plus d'informations sur la liste de diffusion WiFiDog