# Error after running the sql\_upgrade script **URL:** \ **Category:** Support\ **Tags:** ehr\ **Created:** [June 20, 2017, 8:59pm UTC](https://forums.librehealth.io/t/error-after-running-the-sql-upgrade-script/886 "2017-06-20T20:59:47Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![growlingflea](https://forums.librehealth.io/user_avatar/forums.librehealth.io/growlingflea/32/847_2.png) [@growlingflea](https://forums.librehealth.io/u/growlingflea)\ **Post date:** [June 20, 2017, 8:59pm UTC](https://forums.librehealth.io/t/error-after-running-the-sql-upgrade-script/886/1 "2017-06-20T20:59:47Z")
I download the newest master changes, ran the sql\_upgrade.sql script and now I am getting this screen ![](https://forums.librehealth.io/uploads/default/original/1X/8fc111b37c701b993355dbf7b65e42f7d79b3a13.png) Here is my log file: ![](https://forums.librehealth.io/uploads/default/original/1X/a189acdab4423444140b0f296a95a2590d524d35.png) Has anyone else run into this issue? ---
**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\ **Post date:** [June 20, 2017, 9:04pm UTC](https://forums.librehealth.io/t/error-after-running-the-sql-upgrade-script/886/2 "2017-06-20T21:04:28Z")
I am not sure what is going on . The upgrade script should have just updated some fields in encounter forms.Did you download any of the PR’s ? ---
**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\ **Post date:** [June 20, 2017, 9:06pm UTC](https://forums.librehealth.io/t/error-after-running-the-sql-upgrade-script/886/3 "2017-06-20T21:06:03Z")
Did you download the Role Based Menus code? ---
**Author:** ![growlingflea](https://forums.librehealth.io/user_avatar/forums.librehealth.io/growlingflea/32/847_2.png) [@growlingflea](https://forums.librehealth.io/u/growlingflea)\ **Post date:** [June 20, 2017, 9:06pm UTC](https://forums.librehealth.io/t/error-after-running-the-sql-upgrade-script/886/4 "2017-06-20T21:06:12Z")
I just pulled all the new changes from upstream master. ---
**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\ **Post date:** [June 20, 2017, 9:14pm UTC](https://forums.librehealth.io/t/error-after-running-the-sql-upgrade-script/886/5 "2017-06-20T21:14:05Z")
Comment out line 10 in interface\main\tabs\menu\menu\_data.php till I figure out what is going on ---
**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\ **Post date:** [June 20, 2017, 9:17pm UTC](https://forums.librehealth.io/t/error-after-running-the-sql-upgrade-script/886/6 "2017-06-20T21:17:01Z")
Never mind Dan that won’t work. ---
**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\ **Post date:** [June 20, 2017, 9:24pm UTC](https://forums.librehealth.io/t/error-after-running-the-sql-upgrade-script/886/7 "2017-06-20T21:24:29Z")
Try running this /library/classes/installer.class.php see what happens ---
**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\ **Post date:** [June 20, 2017, 9:27pm UTC](https://forums.librehealth.io/t/error-after-running-the-sql-upgrade-script/886/8 "2017-06-20T21:27:21Z")
You can’t run the above. Dan did you get any errors in the upgrade script when you ran it. ---
**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\ **Post date:** [June 20, 2017, 9:27pm UTC](https://forums.librehealth.io/t/error-after-running-the-sql-upgrade-script/886/9 "2017-06-20T21:27:48Z")
Try running the upgrade script again ---
**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\ **Post date:** [June 20, 2017, 9:35pm UTC](https://forums.librehealth.io/t/error-after-running-the-sql-upgrade-script/886/10 "2017-06-20T21:35:23Z")
Dan do you have the menu\_data.json in the sites directory? ---
**Author:** ![growlingflea](https://forums.librehealth.io/user_avatar/forums.librehealth.io/growlingflea/32/847_2.png) [@growlingflea](https://forums.librehealth.io/u/growlingflea)\ **Post date:** [June 20, 2017, 9:36pm UTC](https://forums.librehealth.io/t/error-after-running-the-sql-upgrade-script/886/11 "2017-06-20T21:36:37Z")
Yup. ![](https://forums.librehealth.io/uploads/default/original/1X/f1abb8b33614431ae38653508dea7a83f4a48dec.png) ---
**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\ **Post date:** [June 20, 2017, 9:41pm UTC](https://forums.librehealth.io/t/error-after-running-the-sql-upgrade-script/886/12 "2017-06-20T21:41:42Z")
Can you look at your old version of the code and see what is in menu\_data.php ---
**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\ **Post date:** [June 20, 2017, 9:43pm UTC](https://forums.librehealth.io/t/error-after-running-the-sql-upgrade-script/886/13 "2017-06-20T21:43:22Z")
Do you have phpmyadmin installed? ---
**Author:** ![growlingflea](https://forums.librehealth.io/user_avatar/forums.librehealth.io/growlingflea/32/847_2.png) [@growlingflea](https://forums.librehealth.io/u/growlingflea)\ **Post date:** [June 20, 2017, 9:44pm UTC](https://forums.librehealth.io/t/error-after-running-the-sql-upgrade-script/886/14 "2017-06-20T21:44:06Z")
yes, I have phpmyadmin. ---
**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\ **Post date:** [June 20, 2017, 10:30pm UTC](https://forums.librehealth.io/t/error-after-running-the-sql-upgrade-script/886/15 "2017-06-20T22:30:34Z")
Did you check the permissions on the menu\_data.json file? ---
**Author:** ![growlingflea](https://forums.librehealth.io/user_avatar/forums.librehealth.io/growlingflea/32/847_2.png) [@growlingflea](https://forums.librehealth.io/u/growlingflea)\ **Post date:** [June 20, 2017, 10:42pm UTC](https://forums.librehealth.io/t/error-after-running-the-sql-upgrade-script/886/16 "2017-06-20T22:42:38Z")
yeah. Changed the mod to 777. I’m not sure what happened. Maybe I’ll try to reinstall it. ---
**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\ **Post date:** [June 20, 2017, 10:56pm UTC](https://forums.librehealth.io/t/error-after-running-the-sql-upgrade-script/886/17 "2017-06-20T22:56:53Z")
Try it and let me know. The information does not appear to be saved in the globals file so I am not sure what is going on there. @tony made some of those changes maybe he can point us to something I am missing. ---
**Author:** ![tony](https://forums.librehealth.io/user_avatar/forums.librehealth.io/tony/32/42_2.png) [@tony](https://forums.librehealth.io/u/tony)\ **Post date:** [June 27, 2017, 7:03pm UTC](https://forums.librehealth.io/t/error-after-running-the-sql-upgrade-script/886/18 "2017-06-27T19:03:15Z")
I have no idea what the context of this discussion is… I removed the upgrade scripts entirely and Terry put them back (which is a reasonably stop-gap). Otherwise I know nuthin’. I have never needed (or wanted) to upgrade a libreHeatlh EHR, just new installs. ---
**Author:** ![aethelwulffe](https://forums.librehealth.io/user_avatar/forums.librehealth.io/aethelwulffe/32/63_2.png) [@aethelwulffe](https://forums.librehealth.io/u/aethelwulffe)\ **Post date:** [June 27, 2017, 7:34pm UTC](https://forums.librehealth.io/t/error-after-running-the-sql-upgrade-script/886/19 "2017-06-27T19:34:29Z")
…and my life has been a terror of constant diff upgrades that are never ever automated. Heh. Such is life. ---
**Author:** ![teryhill](https://forums.librehealth.io/user_avatar/forums.librehealth.io/teryhill/32/58_2.png) [@teryhill](https://forums.librehealth.io/u/teryhill)\ **Post date:** [July 4, 2017, 9:11pm UTC](https://forums.librehealth.io/t/error-after-running-the-sql-upgrade-script/886/20 "2017-07-04T21:11:38Z")
Did this get resolved with the re-installation of the code? [Next page](https://forums.librehealth.io/t/error-after-running-the-sql-upgrade-script/886.md?page=2)