ERROR: query failed: SELECT * FROM lang_definitions JOIN lang_constants ON lang_definitions.cons_id = lang_constants.cons_id WHERE lang_id='1' AND constant_name = '(More)' LIMIT 1 Error: Table 'openemr.lang_definitions' doesn't exist

Support
1

Situation
Describe your problem here

when boot up openemr following shows;

ERROR: query failed: SELECT * FROM lang_definitions JOIN lang_constants ON lang_definitions.cons_id = lang_constants.cons_id WHERE lang_id=‘1’ AND constant_name = ‘(More)’ LIMIT 1

Error: Table ‘openemr.lang_definitions’ doesn’t exist

OpenEMR Version
I’m using OpenEMR version 3.1 I guess

Browser:
I’m using: google

Operating System
I’m using: window

Logs
Did you check the logs?
Was there anything pertinent in them?
Please paste them here (surround with three backticks (```) for readability.
You can also turn on User Debugging under Administration->Globals->Logging User Debugging Options=>All

Log?
what is it?

2

Hi @joosangbai,

Your db did not have the lang_definitions table therefore this error is occurred, please take the backup of your DB and execute the below sql on your database.

CREATE TABLE lang_definitions (
def_id int NOT NULL,
cons_id int NOT NULL DEFAULT ‘0’,
lang_id int NOT NULL DEFAULT ‘0’,
definition mediumtext COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;