iHRIS Manage 4.3 Installation not syncing with MySQL database

[Tyler Lin]

I successfully installed a blank iHRIS Manage 4.3 installation on my machine. However, I am unable to add a new person to iHRIS, because there are no results for country. So when I go to Configure System -> Administer Database and try to add a new country, the United States, I get the error for the 2 Character Alpha Code that "This must be unique and another record has this value". But there are no countries in the iHRIS database, so no other records could possible have that value!

So clearly the iHRIS Manage 4.3.0 installation is not syncing with my MySQL database. Because when I log in to PHPMyAdmin on my machine...I see that the United States is indeed an entry in the ihris_manage database.

Could anyone help me out with this? Why is iHRIS not syncing with the ihris_manage database? This prevents me from adding a person to iHRIS, because there are no countries to choose from. If iHRIS and ihris_manage were synced then I could choose a country and add a person to iHRIS. I gladly welcome any suggestions.

Best,

Tyler

[Sovello Hildebrand Mgani]

Hi Tyler,

Since you have the country entries in the country form all you need to do is go to Configure System->Cached Forms then force generate (all) caches.

Then going back to administer database->Countries there should bean an entry for all countries there including the US

Cheers

--
You received this message because you are subscribed to the Google Groups "Global iHRIS Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ihris+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ihris/12b1ca6e-b56f-46c4-9010-cd058ab56d77%40googlegroups.com.

[Tyler Lin]

Thank you Sovello. When I get access to my machine again on Friday I will try your solution and report back if it works. Thanks again!
Best,
Tyler

[Tyler Lin]

Sovello,

I did as you said but I encountered an error. When I clicked Force Caching of all forms if not stale, I get:

"Could not cache access_facility,application,benefit,...,user,uuid".

Are there any alternative solutions?

Best,

Tyler

To unsubscribe from this group and stop receiving emails from it, send an email to ih...@googlegroups.com.

[Sovello Hildebrand Mgani]

you can ignore that error message (because they are not affected.) and recreate the cache (i.e. drop cache then create cache) for the specific forms.

Search for the specific form under Cached Forms.

Hope this helps.

--

Sovello

To unsubscribe from this group and stop receiving emails from it, send an email to ihris+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ihris/16e6a317-622a-4a94-9a32-a4af23874bff%40googlegroups.com.

--

Hildebrand [Sovello] Mgani

sovello...@gmail.com

515.346.4658
Skype: sovellohp

[Tyler Lin]

Thank you for the timely reponse. I recreated the cache for country by going to Configure System -> Cached Forms -> Drop Cached Table under country and then Create/Update Cache under country. However, when I go back to Configure System -> Administer Database -> Country, the table is still blank. I do not know what to do, but thanks for your help.

Best,

Tyler

To view this discussion on the web visit https://groups.google.com/d/msgid/ihris/16e6a317-622a-4a94-9a32-a4af23874bff%40googlegroups.com.

[Sovello Hildebrand Mgani]

Hi Tyler,

This is how it works,

The fact that you see the entry /I2CE/formsData/forms/counttry/field/name in ihris_manage database means iHRIS is correctly installed.

If you a value can't be seen under Administer Database -> Country it is mainly due to cache or (in rare cases) it has a value Yes for Hide field.

If you can't see a value in the drop down (the case that you can't see the US when creating a person, for country entry, there's a field Use for Location Selection, this field must set to Yes

for the country to show up when creating a person.

I would recreate the cache for iHRIS and clear cache for localhost on the browser.

There's a tool (apache_tail) that you can use to check what happens.

you can run this using the command

php /path/to/i2ce/tools/apache_tail.php

then while this is running in the terminal you can try loading the country list (http://localhost/manage/index.php/lists?type=country) then read through the log in the terminal. (You can do redirection for output to a file).

To unsubscribe from this group and stop receiving emails from it, send an email to ihris+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ihris/65580e1d-f626-4dcc-86dd-13877c08e608%40googlegroups.com.

[Tyler Lin]

Sovello,

thank you again for your assistance. By using apache_tail I found the errors and fixed them by removing the STRICT_TRANS_TABLES and NO_ZERO_DATE flags from sql.mode. Then after recreating the cache all of the countries were there!

To view this discussion on the web visit https://groups.google.com/d/msgid/ihris/65580e1d-f626-4dcc-86dd-13877c08e608%40googlegroups.com.

[Juma Lungo]

Congratulations !

On 31 Jan 2020, at 20:48, Tyler Lin <tyle...@gmail.com> wrote:

Sovello,

thank you again for your assistance. By using apache_tail I found the errors and fixed them by removing the STRICT_TRANS_TABLES and NO_ZERO_DATE flags from sql.mode. Then after recreating the cache all of the countries were there!

<success.PNG>

To unsubscribe from this group and stop receiving emails from it, send an email to ihris+un...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ihris/f62f9b75-6524-4d12-82be-cdaeb3d14166%40googlegroups.com.
<success.PNG>