Failure during database access

ijaraho wrote on Sunday, November 10, 2013:

hi,
I install new and last version of openemr-4.1.2, then I delete all tables of this database, than I import my backed up database,
but when I login to openemr, I can enter username and password, then give the massage:
Failure during database access! Check server error log.

what the problem??

yehster wrote on Sunday, November 10, 2013:

If you check the error log as instructed, there will be an error message indicating exactly which query failed.

Was the backup database from 4.1.1 or from 4.1.2? If it was a 4.1.1 database you are restoring, you can’t upgrade that way as tables and other DB changes between the version will be missing.

ijaraho wrote on Sunday, November 10, 2013:

my backup database from 4.1.1
what I can do to import it to openemr 4.1.2???

ijaraho wrote on Sunday, November 10, 2013:

In the application site: http://mydomain/admin.php
in the page: OpenEMR Site Administration, when I click on the button: Upgrade Access Controls, it give the massage:
ERROR: query failed: SELECT v_acl FROM version

Error: Unknown column ‘v_acl’ in ‘field list’

yehster wrote on Sunday, November 10, 2013:

http://www.open-emr.org/wiki/index.php/OpenEMR_Upgrade_Guides

ijaraho wrote on Sunday, November 10, 2013:

I can’t update, when I enter: “http://mydomain/acl_upgrade.php?site=default” in web browser it give the massage:
ERROR: query failed: SELECT v_acl FROM version

Error: Unknown column ‘v_acl’ in ‘field list’

yehster wrote on Sunday, November 10, 2013:

You need to start over from a running copy of 4.1.1.

ijaraho wrote on Sunday, November 10, 2013:

ok, please, but where I can find openemr 4.1.1???

jcahn2 wrote on Sunday, November 10, 2013:

Here is a page with some links to 4.1.1 versions:

http://www.oemr.org/download_openemr/

ijaraho wrote on Monday, November 11, 2013:

It success…
thank you very much