Bulk import photo

General
1

Hello,
I was trying to bulk import students photo, and when i submitted the file i don’t think it was working properly it says “The database was successfully locked” . Please check on the screen shot of what i see from my screen, and i check on student’s photo it still have the old photo. Do you know what that i have missed here?

thanks,
Ayu

2

Ayu,

The code is getting as far as locking the database, and then something is causing a PHP error: probably a missing dependency of some kind. Gibbon should deal with this more elegantly (something else for the todo list ; ), but does not. Sorry! To get to the bottom of this, please check your error log. Please can you share the error and solution with us, so that we can add details to the config guide. I guess it is something to do with the ability to deal with ZIP files.

Ross

3

and where can i check my error log?

4

Good question : ) It depends on your operating system. In Linux (like Ubuntu), this is usually found under /var/log/apache2/error.log. This log is maintained by the OS, via PHP, not by Gibbon.

5

Hi, This is what we found :
error log : /var/log/nginx/error.log.1
PHP message: PHP Notice: Undefined index: 1-matchAddress in /var/www/gibbon/modules/User Admin/user_manage_editProcess.php on line 531

Opened the user_manage_editProcess.php line 531, contain
($_POST[$i.‘-matchAddress’] != ‘’) {

some partial code copied (might be usefull)
//Update matching addresses
$partialFail = false;
$matchAddressCount = null;
if (isset($_POST[‘matchAddressCount’])) {
$matchAddressCount = $_POST[‘matchAddressCount’];
}
if ($matchAddressCount > 0) {
for ($i = 0; $i < $matchAddressCount; ++$i) {
if ($_POST[$i.‘-matchAddress’] != ‘’) {
try {
$dataAddress = array(‘address1’ => $address1, ‘address1District’ => $address1Distric$
$sqlAddress = 'UPDATE gibbonPerson SET address1=:address1, address1District=:address$
$resultAddress = $connection2->prepare($sqlAddress);
$resultAddress->execute($dataAddress);
} catch (PDOException $e) {
$partialFail = true;
}
}
}
}

6

Ayu, the issue above is not the cause of the problem you are seeing on the imports, but rather is a minor issue (that will not cause any negative effects in practice) when processing the editing a user. Please can you check the error log again, looking for errors from the file /modules/User Admin/import_users.php. Ross.

7

Hi, I have trace the code by adding some echo text to see until which line the code stop.
I have see the php file : import_userPhotos.php
it stop at line 146: $zip = new ZipArchieve();
my echo test below this line is not shown, so I think this line is not showing an error for me.
Would you mind advise, do we have some package missing on our linux?
Thanks for your help

8

Ayu,

Good trouble shooting! The correct spelling should be $zip = new ZipArchive();

What we really need now is the error log output, which would tell us exactly what the issue is. Are you able to get this?

My guess is that you have not installed the correct PHP libraries into your web server, in order to enable this. Something like this might help, depending on your OS/PHP flavour and version: http://stackoverflow.com/questions/38104348/install-php-zip-on-php-5-6-on-ubuntu.

Let us know how you go.

Ross

9

Thank you, we already solved this problem
by running this code
sudo apt-get install php-zip or
sudo apt-get install php5.6-zip

thanks for your support.