Missing Tables In OpenEMR 4.0 (Upgrade)

mike-h30 wrote on Wednesday, April 13, 2011:

I just noticed that I am missing 3 tables in my upgraded version of OpenEMR 4.0 versus a clean installation of OpenEMR 4.0.  I have run sql_upgrade.php per the the upgrade directions.  The missing tables are:

automatic_notification
notification_settings
notification_log

Please advise.  Thanks.

-Mike

bradymiller wrote on Thursday, April 14, 2011:

hey,

Check this out to see when/who added these:
http://github.com/openemr/openemr/blame/master/sql/database.sql
(March 18,2008, so I think this was around 2.9 or 3.0)
Looks like somebody used the following upgrade script instead:
https://github.com/openemr/openemr/blob/master/sql/add_sms_email_reminder.sql
(I wouldn’t use this upgrade script though since changes some core tables).

Would be likely useful to include stuff in that upgrade script in the next official upgrade script to ensure tables are the same for users that have upgraded from pre 3.0. Please issue a bug report in the tracker.

thanks,
-brady

mike-h30 wrote on Monday, April 18, 2011:

Done.

-Mike

voipbound wrote on Monday, November 14, 2011:

I just upgraded to 4.0.1 from 4.0 and noted that there are a number of tables missing.  I did not notice it when I upgraded from 2.9.  I guess the problem is not fixed?

bradymiller wrote on Monday, November 14, 2011:

Hi,
This was dealt with in the 4.0 to 4.1 upgrade script (so upgrading to 4.1.0 will fix this).
-brady