Hi Sarah,
If you look at the database you'll see that the passwords have been input as
plaintext but web pa expects to receive them encrypted. Before you put your
users into webpa you'll have to run a script that uses something like perl
or php to encrypt your passwords.
Neil
____________
Neil McKeown
Learning Technologist
University of Bradford
BD7 1DP
(01274) 233288
-----Original Message-----
From: WebPA Project [mailto:[log in to unmask]] On Behalf Of Sarah
Horrigan
Sent: 14 October 2009 12:13
To: [log in to unmask]
Subject: Uploading users, error message
We're just starting to pilot using WebPA at Nottingham Trent University and
although I'm still getting some issues with creating admin accounts (getting
the error "Warning: mysql_num_fields(): supplied argument is not a valid
MySQL result resource in
/home/budeeqtw/public_html/webpa/library/classes/class_dao.php on line 566"
even though it says I've successfully created an account), there is another
issue which means I can't add in any students / staff. When I try to upload
new users using the templates provided I am now being taken to a page which
reads:
Index: simple.php
=================================================================== ---
simple.php (revision 325) +++ simple.php (working copy) @@ -50,8 +50,8 @@
for ($c=0; $c < $num; $c++) { $fields[$c]=trim($data[$c]); }
-//print_r(array_diff($expected_fields[$uploadtype], $fields)); -//echo"
"; +print_r(array_diff($expected_fields[$uploadtype], $fields)); +echo"
"; //check to see that we have the correct information in the array @@ -94,8
+94,9 @@ fclose($handle); -//print_r($final_rows); -//echo "
{$flg_match}
"; +echo "
";
+print_r($final_rows);
+echo "
{$flg_match}
"; //check which array we are being given at this point (the one with the
named fields or the other) @@ -120,14 +121,14 @@ //set the admin option
$process_copy[$counter]['admin'] =0; + -////////// -//stop here and finish
this -////////// - //if there are passwords in the list, they will need to
be MD5 hashed + if (!empty($process_copy[$counter]['password'])){ +
$process_copy[$counter]['password']=md5($process_copy[$counter]['password'])
; +
} } - +print_r($process_copy); //set up the SQL to be run $SQL = "REPLACE
INTO user ({fields}) VALUES {values} ";
Not sure what's going on with this. I have installed some of the patches
available on the SourceForge site but I can't seem to work out what's gonig
on with this. Our pilot installation is at http://webpa.ntushare.org
Thanks for any help
Sarah
|