[Solved] Error using functionality - Add users toJoomla

Hi,

I have more than 4000 users in Moodle. Now I am trying to add those users to Joomla. It has added around 2000 users but I am not able to move ahead. I am trying this for last two days and it is giving me the following error -

Error Loading ModulesMySQL server has gone away SQL=SELECT id, title, module, position, content, showtitle, control, params FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id WHERE m.published = 1 AND m.access <= 2 AND m.client_id = 1 ORDER BY position, ordering

Warning: Invalid argument supplied for foreach() in /home/edukart/public_html/administrator/components/com_joomdle/helpers/content.php on line 666

Warning: Invalid argument supplied for foreach() in /home/edukart/public_html/administrator/components/com_joomdle/helpers/content.php on line 675

I have also attached the screenshot.
Website is live on www.edukart.com/index.php and half of the users are not able to access the course due to this.

Urgent help will be highly appreciated.

Thanks,
Ronak

Hi.

It seems this could be caused by a time out in PHP. You could try raising this limit.
Also, you could try adding users in small batchs.

Hi Antonio,

Thanks for your input. I have already solved the issue by increasing the value of MySQl variables.

wait_timeout was increased to 28800
interacive_timeout was increased to 28800

And it solved the issue.

Thank you for your feeback. I am sure it will help us/others in the future.