liveuser_admin - storing extra data
| From: | Jeroen Houben | Date: | Thu, 13 Oct 2005 11:38:36 +0000 |
| Subject: | liveuser_admin - storing extra data | ||
| Groups: | php.pear.general | ||
| Request: | Send a blank email to pear-general+get-21436@lists.php.net to get a copy of this message | ||
Hi,
I'm trying to add some extra data to the users table.
I modified my $conf array by adding this:
'storage' => array(
'dsn' => LIVEUSER_DSN,
'prefix' => 'lu_',
'tables' => array(
'users' => array(
'fields' => array(
'lastlogin' => null, 'is_active' => true,'fname' => null, 'lname' => null,
'org' => null), ), ), 'fields' => array(
'lastlogin' => 'timestamp', 'is_active' => 'boolean','fname' => 'varchar', 'lname' => 'varchar',
'org' => 'varchar'), ), I also added these fields manually to the database. Now I get this error: ["code"]=> int(-4) ["params"]=> array(1) {
["reason"]=>
string(33) "field may not be empty: is_active"
}
["package"]=>
string(14) "LiveUser_Admin"
["level"]=>
string(9) "exception"
["time"]=>
float(1129203367.4792)
["context"]=>
array(4) {
["file"]=>
string(56) "/usr/local/share/php/pear/LiveUser/Admin/Storage/SQL.php"
["line"]=>
int(147)
["function"]=>
string(6) "insert"
["class"]=>
string(26) "LiveUser_Admin_Storage_SQL"
}
["message"]=>
string(68) "Couldn't create the query, reason: field may not be empty: is_active"
}
Looking at my conf is_active should just default to TRUE..
Jeroen