Error loading user list
By Ivaylo Valkov on Saturday, 08 September 2018
Posted in General Issues
Replies 12
Likes 0
Views 1.1K
Votes 0
Hi, in version 1.1.3, I get this error while loading the user list


Warning: mysqli_errno() expects parameter 1 to be mysqli, boolean given in /home/andronika/domains/developer.andronika.net/public_html/libraries/joomla/database/driver/mysqli.php on line 988



Warning: mysqli_error() expects parameter 1 to be mysqli, boolean given in /home/andronika/domains/developer.andronika.net/public_html/libraries/joomla/database/driver/mysqli.php on line 1000

Error: Could not connect to MySQL server.: 

Fatal error: Uncaught JDatabaseExceptionConnecting: Could not connect to MySQL server. in /home/andronika/domains/developer.andronika.net/public_html/libraries/joomla/database/driver/mysqli.php:173 Stack trace: #0 /home/andronika/domains/developer.andronika.net/public_html/libraries/joomla/database/driver.php(1450): JDatabaseDriverMysqli->connect() #1 /home/andronika/domains/developer.andronika.net/public_html/libraries/src/Table/User.php(86): JDatabaseDriver->loadAssoc() #2 /home/andronika/domains/developer.andronika.net/public_html/libraries/src/User/User.php(883): Joomla\CMS\Table\User->load('350') #3 /home/andronika/domains/developer.andronika.net/public_html/libraries/src/User/User.php(946): Joomla\CMS\User\User->load('350') #4 [internal function]: Joomla\CMS\User\User->__wakeup() #5 /home/andronika/domains/developer.andronika.net/public_html/libraries/vendor/joomla/registry/src/Registry.php(89): unserialize('O:8:"stdClass":...') #6 /home/andronika/domains/developer.andronika.net/public_html/libraries/src/Session/Ses in /home/andronika/domains/developer.andronika.net/public_html/libraries/joomla/database/driver/mysqli.php on line 173



Warning: Unknown: Failed to write session data using user defined save handler. (session.save_path: /home/andronika/domains/developer.andronika.net/tmp) in Unknown on line 0


session.save_path = /home/andronika/domains/developer.andronika.net/public_html/tmp
Is it your current localhost instance same as this development site? developer.andronika.net

If yes, is it possible for you check your current development site configuration setting and see whether some where mis-configured? so I can able to troubleshoot this issue through your development site directly.

Because when you click on the Conversekit contact tab, it actually send a request to your server to execute one of the SQL query to retrieve data from your database but your server return this following error : 



Error: Could not connect to MySQL server.: 

Fatal error: Uncaught JDatabaseExceptionConnecting: Could not connect to MySQL server.


There is no error on a local host under Windows 10, but does not load a list of users.

Currently I am not sure how you setup this localhost yet, but i believe that is related with the user privacy setting, because we did fix one issue that contact list doesn't respect the user privacy, so it show everyone on the Conversekit.

Perhaps you can try go to your site localhost backend > Easysocial > user > profile type > registered user > privacy > tick that option and save it, you can refer on my attached screenshot below.

Then click on that contact tab from the Conversekit and see how it goes.
Arlex Wong
·
Saturday, 08 September 2018 13:29
·
0 Likes
·
0 Votes
·
0 Comments
·
It seems like i was unable to replicate this issue in my local instance, can you update your site backend and FTP access so we can better have a check?
Arlex Wong
·
Saturday, 08 September 2018 10:07
·
0 Likes
·
0 Votes
·
0 Comments
·
Done
Ivaylo Valkov
·
Saturday, 08 September 2018 10:12
·
0 Likes
·
0 Votes
·
0 Comments
·
Another small bug: the ckit-error-message for blank message shows nothing.
Ivaylo Valkov
·
Saturday, 08 September 2018 10:23
·
0 Likes
·
0 Votes
·
0 Comments
·
It seems like nothing wrong from the Conversekit, I suspect that is related with your development site database login access is incorrect, can you double check from your development site root configuration.php file and see whether you enter correctly for those login credentials?

e.g.
[gist type="php"]
public $host = 'xxx';
public $user = 'xxx';
public $password = 'xxx';
public $db = 'xxx';
public $dbprefix = 'xxx';
[/gist]
Arlex Wong
·
Saturday, 08 September 2018 11:19
·
0 Likes
·
0 Votes
·
0 Comments
·
Result


public $host = 'localhost';

public $user = 'xxx';

public $password = 'xxx';

public $db = 'xxx';

public $dbprefix = 'xxx';


There is no error on a local host under Windows 10, but does not load a list of users.
Ivaylo Valkov
·
Saturday, 08 September 2018 11:33
·
0 Likes
·
0 Votes
·
0 Comments
·
Let this fix the problems in both cases - CentOs (developer.andronika.net) and Windows 10 (local host) Why it makes this problem when unchecked? If you make a fix that bypass the problem please post a new version. Many people will wonder what happened.
Ivaylo Valkov
·
Saturday, 08 September 2018 13:54
·
0 Likes
·
0 Votes
·
0 Comments
·
Now I've tested and after applying the bookmark all and newly registered are displayed. This solves the problem.
Ivaylo Valkov
·
Saturday, 08 September 2018 14:18
·
0 Likes
·
0 Votes
·
0 Comments
·
Currently I have no ideas where is the root issue for this yet, I will see if there got other users having this similar issue.
Arlex Wong
·
Saturday, 08 September 2018 15:03
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post