OpenEMR Installation Error on 1and1 shared hosting

wzafar wrote on Saturday, March 04, 2017:

Hi, I have installed latest OpenEMR 5.0.0 on 1and1 shared hosting service. After login I receive big list of error.

ERROR:

Strict Standards: strftime(): We selected ‘America/New_York’ for ‘EST/-5.0/no DST’ instead in /homepages/46/d178233728/htdocs/openemr-5.0.0/interface/main/calendar/modules/PostCalendar/common.api.php on line 215

Strict Standards: strftime(): We selected ‘America/New_York’ for ‘EST/-5.0/no DST’ instead in /homepages/46/d178233728/htdocs/openemr-5.0.0/interface/main/calendar/modules/PostCalendar/common.api.php on line 216

Strict Standards: strftime(): We selected ‘America/New_York’ for ‘EST/-5.0/no DST’ instead in /homepages/46/d178233728/htdocs/openemr-5.0.0/interface/main/calendar/modules/PostCalendar/common.api.php on line 217

Also Administration --> Global page is also showing error.

Error:
ERROR: query failed: SELECT * FROM lang_definitions JOIN lang_constants ON lang_definitions.cons_id = lang_constants.cons_id WHERE lang_id=? AND constant_name = ? LIMIT 1

Please guide me how to resolve this " Strict Standards: strftime(): … " problem.

1and1.com don’t provide PHP.INI access in shared hosting.
I have copied PHP.INI file in root folder of installed OPENEMR directory. But errors are same.

*** my php.ini ****

short_open_tag = Off
max_execution_time = 60
max_input_time = 90
max_input_vars = 3000
memory_limit = 128M
display_errors = Off
log_errors = On
register_globals = Off
post_max_size = 30M
file_uploads = On
upload_max_filesize = 30M
error_reporting = E_ALL & ~E_NOTICE & ~E_STRICT
date.timezone = “America/New_York”

Thanks

Waseem.

plp384 wrote on Saturday, March 04, 2017:

I know on AWS by amazon, you “must” use dedicated hosting for hipaa compliancy.

bradymiller wrote on Monday, March 06, 2017:

Hi Waseem,

I would ask the hosting service how you can modify the php setting (placing a php.ini file in openemr directory likely won’t work). Also, ensure you created a database that uses UTF8 before installing OpenEMR(I assume you created the database first).

-brady
OpenEMR

wzafar wrote on Monday, March 06, 2017:

Dear plp384 thanks for your reply. So many contries in world don’t require hippa compliance. low earning hospitals need low cost solution.

Waseem

wzafar wrote on Monday, March 06, 2017:

Thanks Brady Miller for your reply. I am contacting hosting provider for php. I am attaching phpmyadmin image of database for UTF8.

Waseem

bradymiller wrote on Tuesday, March 07, 2017:

Hi Waseem,
Image looks good. Will see how things go after you can set the php settings.
-brady
OpenEMR

wzafar wrote on Wednesday, March 08, 2017:

Dear Brady, following is reply I received from our hosting provider(1and1).

** REPLY**
Unfortunately, php.ini is not created by default in the system. You have to create your own php.ini directive and upload to the directory that requires php.ini.

To create:

  1. Open any text editor, (ex: notepad, notepad++)
  2. Paste all directive command scripts
  3. Save the file and name as php.ini
    save file as: “all types”
  4. Upload to your server/directory that requires php.ini

bradymiller wrote on Wednesday, March 08, 2017:

Hi Waseem,

wow, just looked it up:
http://help.1and1.com/hosting-c37630/scripts-and-programming-languages-c85099/php-c37728/change-php-directives-a660257.html

The above articles states it needs to go into every directory(and subdirectories); that is pretty crazy.

-brady

wzafar wrote on Friday, March 10, 2017:

OpenEMR has about 1940 folders and 1221 files. It is quite challenging to include PHP.ini in every folder. Is any way around.

bradymiller wrote on Friday, March 10, 2017:

Hi Waseem,

I don’t know much about shared hosting, but it just seems crazy to have it set up like that. May need to look into using another hosting service.

-brady
OpenEMR

robertdown wrote on Saturday, March 11, 2017:

I would raise the issue with 1and1 again and see if they can offer a more reasonable solution. Placing an INI file in ~2000 folders is not realistic. Perhaps they can offer a specific solution to your needs

wzafar wrote on Saturday, March 11, 2017:

Thanks Robert Down, I just send email to 1and1.

wzafar wrote on Saturday, March 11, 2017:

Thanks Brady, I have contacted with 1and1. I opt shared hosting as it is low cost solution for developing countries. I will consider hosting company change as last option.

sunsetsystems wrote on Saturday, March 11, 2017:

Shared hosting is generally not a good choice anyway for OpenEMR. Much better to have full control of your server. Low cost? Check out Digital Ocean.