[Closed] Issue with Hikashop mapping for users

Hi,

I have Joomla 2.5.9, Hiksahop 2.1.2 and Joomdle 0.91 for 2.5. I have redirected user registration to Hikashop so basically users would enter all Hikashop entries during registration including first name, last name, city and country.

The issue is users are getting registered in moodle but all these fields from hikashop are empty.

I enabled Joomla debug and tried to Synch joomla profile with moodle. I get the following error while doing this.

Appreciate your kind help and support.

Regards,
Aravinda


500 - An error has occurred.
JDatabaseMySQLi::query: 1054 - Unknown column 'user_id' in 'field list' SQL=SELECT user_id FROM jom_hikashop_address WHERE user_id = '2'

Return to Control Panel

Call stack
# Function Location
1 JAdministrator->dispatch() /var/www/html/administrator/index.php:46
2 JComponentHelper::renderComponent() /var/www/html/administrator/includes/application.php:153
3 JComponentHelper::executeComponent() /var/www/html/libraries/joomla/application/component/helper.php:351
4 require_once() /var/www/html/libraries/joomla/application/component/helper.php:383
5 JController->execute() /var/www/html/administrator/components/com_joomdle/joomdle.php:44
6 JoomdleController->sync_profile_to_joomla() /var/www/html/libraries/joomla/application/component/controller.php:761
7 JoomdleHelperContent->sync_joomla_profiles() /var/www/html/administrator/components/com_joomdle/controller.php:216
8 JoomdleHelperMappings->sync_user_to_joomla() /var/www/html/administrator/components/com_joomdle/helpers/content.php:964
9 JoomdleHelperMappings->create_additional_profile() /var/www/html/administrator/components/com_joomdle/helpers/mappings.php:1148
10 JoomdleHelperMappings->create_additional_profile_hikashop() /var/www/html/administrator/components/com_joomdle/helpers/mappings.php:1179
11 JDatabase->loadResult() /var/www/html/administrator/components/com_joomdle/helpers/mappings.php:1980
12 JDatabaseMySQLi->execute() /var/www/html/libraries/joomla/database/database.php:1138
13 JError::raiseError() /var/www/html/libraries/joomla/database/database/mysqli.php:396
14 JError::raise() /var/www/html/libraries/joomla/error/error.php:251

I think I have not tested Hikashop 2.1.2, so maybe they introduced some changes that break integration. I will test it when I find some time and let you know.

Hi.

I finally got to test Hikashop 2.1.2 :
- User sync to Moodle is working as expected *
- I fixed the reported error, but it is not executed when syncing users from joomla to moodle, so it should not be causing you any problems

* When you register in Hikashop, fields in Moodle are blank.
If you save the account again (for example activating it, or saving it in the backend, or saving it again in the frontend) fields in Moodle are populated.

This is because Hikashop fires the "user created" event before filling up his address table, so when Joomdle executes for the first time, it cannot fetch the additional info.

Hello Antonio,

Yes. You are right. My issue was more due to SEF. If I enable SEF in Joomla then Web service calls from Moodle to Joomla are not working. Anyways for now I have skipped SEF for Joomdle component.

The one I reported was due to some wrong query. I'm not sure if it has caused some issue elsewhere.

You can mark this issue as closed.

Thanks a lot for the kind support.

Cheers,
Aravinda