search

logicahealth / InfoButtons

Infobuttons are context-sensitive links embedded in the electronic health record (EHR). They use clinical context information from the EHR, such as patient demographics, medications, diagnoses, user role, and clinical setting to help find answers to clinicians' and patients' questions using online health information resources.
28 stars 29 forks source link

Error when running the "valueset_and_log.sql" script. #24

Open jxfish2 opened 5 years ago

jxfish2 commented 5 years ago

Per your instructions, after getting the basic database installed, we need to run the provided SQL scripts against the new database.

The first SQL script ran without errors.

But, the second SQL script is throwing the following error:

mysql -h localhost -p -u root < valueset_and_log.sql Enter password: ERROR 1064 (42000) at line 23: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'SET character_set_client = @saved_cs_client */' at line 8

Any ideas on what the syntax issue might be?

aniskand commented 5 years ago

That's odd, you can just try deleting that line, while keeping the semicolon.

jxfish2 commented 5 years ago

I found 2 issues with syntax.

1) You were missing the ";" at the end of the "ENGINE=MyISAM DEFAULT CHARSET=latin1;" line.

2) You were missing the "," at the end of the "response mediumtext NULL," line.

After adding this punctuation, the script ran without errors.

All of the remaining scripts ran without errors.