2.8.1 'users' is missing the 'see_auth' Field

Day-to-Day Users
1

rickst29 wrote on Wednesday, January 18, 2006:

Hi guys, I just did a clean install of the new 2.8.1 (CREATED NEW DATABASE). The initial login, using admin/pass, generated an error msg about this field. So, to double-check, I tried entering a new user:

The usergroup.php does have the new "see authorizations" choices, and OpenEMR does try to insert this field/value pair as part of the new table row. MySQL refuses the insert row, with

… facility = ‘Your Clinic Name Here’, see_auth = ‘1’ (Unknown column ‘see_auth’ in ‘field list’)

While you guys toss in a tiny patch to include the new field in the initial ‘users’ table creation, can I end up with the right thing by adding it as a tinyint(4)?

Thanks!

2

sunsetsystems wrote on Wednesday, January 18, 2006:

Sorry about that.  The entry is in 2_8_0-to-2_8_1_upgrade.sql and you can do this:

ALTER TABLE users ADD see_auth int(11) NOT NULL DEFAULT 1;

but it was accidentally omitted from database.sql.

Sam, I have checked in this correction as well as one for library/translation.inc.php; perhaps the 2.8.1 bundles should be replaced?

– Rod
www.sunsetsystems.com

3

drbowen wrote on Thursday, January 19, 2006:

The packages have been replaced with this corecction at oemr.org.

md5 sum : package

d7ddfc2e21a114084a32356a101ee320 : openemr.2.8.1.rc1.tar.gz

65b46e77503b5650d33bc299f85cad62 : openemr.2.8.1.rc1.tar.bz2

40990012565b1a8ed3f105ef172b37be : openemr.2.8.1.rc1.zip

Sam Bowen

4

rickst29 wrote on Wednesday, January 25, 2006:

Thanks for the fix!