anonymous wrote on Friday, November 13, 2009:
Hi all,
Just did a fresh install and none of the links related to PostCalendar are working, they just time out. This is on the Admin / Calendar screen.
Nothing in the httpd logs yield any clues.
Just wondering if anyone might have any suggestions as to what I should investigate.
thanks very much
bradymiller wrote on Friday, November 13, 2009:
hey,
What’s your operating system and openemr version?
-brady
bradymiller wrote on Friday, November 13, 2009:
hey,
Find your mysql configuration file (my.cnf). What is the sql-mode variable set to?
-brady
bradymiller wrote on Friday, November 13, 2009:
To follow up,
the sql-modes setting in my.cnf should be:
<pre><code>sql-mode=’’</code></pre>
Also, in your php settings (php.ini), ensure you have following:
<pre><code> short_open_tag = On
max_execution_time = 60
max_input_time = 90
memory_limit = 128M
display_errors = Off
log_errors = On
register_globals = Off
post_max_size = 30M
magic_quotes_gpc = On
file_uploads = On
upload_max_filesize = 30M
</code></pre>
-brady
bradymiller wrote on Friday, November 13, 2009:
Also,
If you needed to chang your sql-mode setting, then you will need to re-install OpenEMR (can remove OpenEMR by dropping the openemr mysql database and removing the openemr web folder; of course all data will be lost)
-brady
anonymous wrote on Friday, November 13, 2009:
Thanks for the reply. The sql-mode is not explicitly set. Isn’t the default mode = “empty” ? Just as a side note, I didn’t see a reference to sql-mode in the install docs. Did I miss something?
I see my post_max_size = 8M and upload_max_filesize = 2M (both not explicitly addressed in the install notes).
Everything else is set per your list.
If I missed something in the docs, I greatly apologize.
Do you think the 2-3 differences in my settings could be the culprit? Thanks again for the help.
anonymous wrote on Friday, November 13, 2009:
In the Admin / Database screen of OpenEMR, the sql mode variable is blank.
anonymous wrote on Friday, November 13, 2009:
Sorry for all the posts. Not sure this is relevant but I did notice it as I was navigating around the phpMyAdmin screens:
“The additional features for working with linked tables have been deactivated. To find out why click here.”
This is shown on the Operations tab of the openemr db.
bradymiller wrote on Friday, November 13, 2009:
hey,
sql-mode should be blank by default(according to mysql), however cent-os seems to not follow these recs. here’s thread where this was discovered:
https://sourceforge.net/projects/openemr/forums/forum/202505/topic/3367585
make sure you find the true my.cnf config file for cent-os
Try to add a new patient, does this work?
-brady
anonymous wrote on Friday, November 13, 2009:
Hi,
I only have one my.cnf file and it does not have the sql-mode statement but a look in phpMyAdmin indicates that the variable is blank.
Adding a new patient is no problem. All functionality seems to be fine with the exception of the PostCalendar links.
I mistyped earlier. I am running CentOS 5.3.
anonymous wrote on Saturday, November 14, 2009:
On an unrelated note, I was seeing these in my logs:
PHP Warning: Call-time pass-by-reference has been deprecated
I changed the allow_call_time_pass_reference variable to On to fix this. Perhaps this is an install note you wish to include.
bradymiller wrote on Saturday, November 14, 2009:
hey,
Try out the below:
Check out the ‘Tools’ ‘Error console’ in browser to see if any javascript errors?
Ensure your allowing javascript in brwoser?
Remove browser cookies and try again?
Try another browser?
If still nothing, then it’d rec. a re-install?
Let us know how it goes.
-brady
anonymous wrote on Saturday, November 14, 2009:
Problem identified !!! I just need to figure out how to fix it now.
Well, I am forcing https and all the links in openemr present as https with the exception of the links in Admin/Calendar; they are all http.
I am blocking http which is why I couldn’t even see these clicks show up in the in the httpd logs. Duh !
Anyway, now I have to see why these links are not working as I expect.