rdh61 wrote on Saturday, February 04, 2012:
First of all, sorry. I said “I can log in but I cannot see my patient data.” This is not true (I remembered this from a previous point in the whole process). But now, when I try to login to my openemr, I get the following text in the browser:
**ERROR: insert failed: insert into log ( date, event, user, groupname, success, comments, crt_user) values ( NOW(), ‘login’,‘admin’,‘Default’,‘1’,‘success: ::1’,’’)
Error: Unknown column ‘success’ in ‘field list’**
Second, your queries:
robert@robert-laptop:~$ sudo mysql
password for robert:
ERROR 1045 (28000): Access denied for user ‘root’@‘localhost’ (using password: NO)
**robert@robert-laptop:~$ show databases
The program ‘show’ is currently not installed. You can install it by typing:
sudo apt-get install nmh
robert@robert-laptop:~$ **
(N.B. I have run sudo apt-get install nmh as instructed, it installed successfully, I have rebooted, but I still get the above!)
library/sqlconf.php:
<?php
// OpenEMR
// MySQL Config
// Referenced from sql.inc
$host = ‘localhost’;
$port = ‘3306’;
$login = ‘openemr’;
$pass = ‘G64WiuKPLE5h’;
$dbase = ‘openemr’;
//Added ability to disable
//utf8 encoding - bm 05-2009
$disable_utf8_flag = false;
$sqlconf = array();
$sqlconf= $host;
$sqlconf = $port;
$sqlconf = $login;
$sqlconf = $pass;
$sqlconf = $dbase;
//////////////////////////
//////////////////////////
//////////////////////////
//////DO NOT TOUCH THIS///
$config = 1; /////////////
//////////////////////////
//////////////////////////
//////////////////////////
?>