US4.1.5 - Table 'Pages' emptied by users/admin_pages.php

[yolo]

Hello mudin,

I did some tests.

1/ With right installation/configuration => All fine

2/ With MariaDB stopped : Message « SQLSTATE[HY000] [2002] No such file or directory » when accessing to the website.

3/ With DB dropped : Message « SQLSTATE[HY000] [1049] Unknown database 'userSpiceDB' » when accessing to the website.

4/ With 'users' table dropped :
when validating the user/password in login.php :

Fatal error: Call to a member function count() on boolean in /var/www/html/mlm09/users/classes/us_classes.php on line 407
PHP 1. {main}() /var/www/html/mlm09/users/login.php:0
PHP 2. User->loginEmail() /var/www/html/mlm09/users/login.php:101
PHP 3. User->find() /var/www/html/mlm09/users/classes/us_classes.php:452

5/ With 'pages' table dropped :
When accessing to the website or logged:

PHP Notice: Undefined property: stdClass::$page in /var/www/html/mlm09/users/helpers/us_helpers.php on line 436
PHP 1. {main}() /var/www/html/mlm09/index.php:0
PHP 2. require_once() /var/www/html/mlm09/index.php:45
PHP 3. securePage() /var/www/html/mlm09/menu.inc.php:5

PHP Notice: Undefined property: stdClass::$private in
/var/www/html/mlm09/users/helpers/us_helpers.php on line 436
PHP 1. {main}() /var/www/html/mlm09/index.php:0
PHP 2. require_once() /var/www/html/mlm09/index.php:45
PHP 3. securePage() /var/www/html/mlm09/menu.inc.php:5

=> Nota : Possible to open public and private pages without logging (login.php isn't requested).

6/ With misconfiguration in z_us_root.php ($path=['mlm09','mlm09/users/','mlm09/usersc/']
Logged in admin and opening users/admin_pages.php

PHP Notice: Undefined variable: row in /var/www/html/mlm09/users/helpers/us_helpers.php on line 166
PHP 1. {main}() /var/www/html/mlm09/users/admin_pages.php:0
PHP 2. getPathPhpFiles() /var/www/html/mlm09/users/admin_pages.php:52

PHP Warning: Invalid argument supplied for foreach() in /var/www/html/mlm09/users/admin_pages.php on line 53
PHP 1. {main}() /var/www/html/mlm09/users/admin_pages.php:0

=> Nota : No specific message. The page doesn't display the list of files due to misconfiguration of z_us_root.php. The 'pages' table has been emptied.


I don't know if it runs as expected. For the last case, should I see a specific message ?
Thank you.