Table 'preferences' is read only (Linux)

wjstarck · Post by **wjstarck** » Mon Aug 27, 2007 5:44 am

This is the error I get when I click 'OK' in the Choose Database screen of OD

Cheers,

Bill Starck, DDS

fcarlier · Post by **fcarlier** » Mon Aug 27, 2007 6:14 am

Can you give more information on your mysql setup? Are you connecting to mysql as root or a limited user? Is your mysql setup local or on a remote computer?

wjstarck · Post by **wjstarck** » Mon Aug 27, 2007 7:32 am

Just the default settings for a local install:

Servername: localhost
DataBase: opendental
User: root
Password:

I copied my Windows database to /var/lib/mysql and did a chmod 755 -r just for testing sake

Thanks,

Bill Starck, DDS

fcarlier · Post by **fcarlier** » Mon Aug 27, 2007 8:05 am

Can you try to add a row to the preferences table using the mysql command line? See what that gives.

wjstarck · Post by **wjstarck** » Mon Aug 27, 2007 8:33 am

mysql> select * from preferences;
ERROR 1146 (42802): Table 'opendental.preferences' doesn't exist

wjstarck · Post by **wjstarck** » Mon Aug 27, 2007 8:38 am

oops my bad

table name should be 'preference'

stand by...

wjstarck · Post by **wjstarck** » Mon Aug 27, 2007 8:50 am

mysql> insert into preference () values ();
ERROR 1036 (HY000): Table 'preference' is read only

Cheers,

Bill Starck, DDS

wjstarck · Post by **wjstarck** » Mon Aug 27, 2007 12:41 pm

nvm:

Fixed it with

sudo chown -R mysql:mysql /var/lib/mysql/mysql
sudo chown -R mysql:mysql /var/lib/mysql/opendental

fcarlier · Post by **fcarlier** » Mon Aug 27, 2007 12:50 pm

OK, great. Let me know how if you encounter any other issues on Linux.

wjstarck · Post by **wjstarck** » Mon Aug 27, 2007 1:43 pm

fcarlier wrote:OK, great. Let me know how if you encounter any other issues on Linux.

Thanks - if you don't mind answering, I'll keep asking

I was able to convert my 5.0x database just fine, however when I try to run OD it throws this exception:

wjs@ubu:~$ sudo /usr/local/bin/opendental
Password:

** (/usr/local/share/opendental/bin/OpenDental.exe:6934): WARNING **: The following assembly referenced from /usr/local/share/opendental/bin/OpenDental.exe could not be loaded:
Assembly: CDT (assemblyref_index=11)
Version: 1.0.0.0
Public Key: (none)
The assembly was not found in the Global Assembly Cache, a path listed in the MONO_PATH environment variable, or in the location of the executing assembly (/usr/local/share/opendental/bin).

** (/usr/local/share/opendental/bin/OpenDental.exe:6934): WARNING **: Could not load file or assembly 'CDT, Version=1.0.0.0, Culture=neutral' or one of its dependencies.

** (/usr/local/share/opendental/bin/OpenDental.exe:6934): WARNING **: Missing method ValidateKey in assembly /usr/local/share/opendental/bin/OpenDental.exe, type CDT.Class1

Unhandled Exception: System.IO.FileNotFoundException: Could not load file or assembly 'CDT, Version=1.0.0.0, Culture=neutral' or one of its dependencies.
File name: 'CDT, Version=1.0.0.0, Culture=neutral'
at <0x00000> <unknown method>
at OpenDental.FormOpenDental.RefreshLocalData (InvalidTypes itypes, Boolean isStartingUp) [0x00000]
at OpenDental.FormOpenDental.FormOpenDental_Load (System.Object sender, System.EventArgs e) [0x00000]
at System.Windows.Forms.Form.OnLoad (System.EventArgs e) [0x00000]
at System.Windows.Forms.Form.OnLoadInternal (System.EventArgs e) [0x00000]
at System.Windows.Forms.Form.OnCreateControl () [0x00000]
at System.Windows.Forms.Control.CreateControl () [0x00000]
at System.Windows.Forms.Control.SetVisibleCore (Boolean value) [0x00000]
at System.Windows.Forms.Form.SetVisibleCore (Boolean value) [0x00000]
at System.Windows.Forms.Control.set_Visible (Boolean value) [0x00000]
at (wrapper remoting-invoke-with-check) System.Windows.Forms.Control:set_Visible (bool)
at System.Windows.Forms.Application.RunLoop (Boolean Modal, System.Windows.Forms.ApplicationContext context) [0x00000]
at System.Windows.Forms.Application.Run (System.Windows.Forms.Form mainForm) [0x00000]
at OpenDental.FormOpenDental.Main () [0x00000]

----------

Thanks again Frederik,

Bill Starck, DDS

Post by **jordansparks** » Mon Aug 27, 2007 2:23 pm

Looks like you have an old CDT.dll. You need to copy the new one to your application directory. You will find it in the Required dlls folder. We don't change version numbers. But look at sizes.

wjstarck · Post by **wjstarck** » Mon Aug 27, 2007 6:31 pm

OK Jordan, that works thanks.

One more, if I may:

wjs@ubu:~$ /usr/local/bin/opendental

Unhandled Exception: System.ArgumentException: SelectionStart cannot be less than MinDate
at System.Windows.Forms.MonthCalendar.set_SelectionRange (System.Windows.Forms.SelectionRange value) [0x00000]
at System.Windows.Forms.MonthCalendar.SetSelectionRange (DateTime date1, DateTime date2) [0x00000]
at System.Windows.Forms.MonthCalendar.SetDate (DateTime date) [0x00000]
at (wrapper remoting-invoke-with-check) System.Windows.Forms.MonthCalendar:SetDate (System.DateTime)
at OpenDental.ContrAppt.RefreshPeriod () [0x00000]
at OpenDental.ContrAppt.ModuleSelected (Int32 patNum) [0x00000]
at OpenDental.ContrAppt.comboView_SelectedIndexChanged (System.Object sender, System.EventArgs e) [0x00000]
at System.Windows.Forms.ComboBox.OnSelectedIndexChanged (System.EventArgs e) [0x00000]
at System.Windows.Forms.ComboBox.set_SelectedIndex (Int32 value) [0x00000]
at OpenDental.ContrAppt.FillViews () [0x00000]
at (wrapper remoting-invoke-with-check) OpenDental.ContrAppt:FillViews ()
at OpenDental.FormOpenDental.RefreshLocalData (InvalidTypes itypes, Boolean isStartingUp) [0x00000]
at OpenDental.FormOpenDental.FormOpenDental_Load (System.Object sender, System.EventArgs e) [0x00000]
at System.Windows.Forms.Form.OnLoad (System.EventArgs e) [0x00000]
at System.Windows.Forms.Form.OnLoadInternal (System.EventArgs e) [0x00000]
at System.Windows.Forms.Form.OnCreateControl () [0x00000]
at System.Windows.Forms.Control.CreateControl () [0x00000]
at System.Windows.Forms.Control.SetVisibleCore (Boolean value) [0x00000]
at System.Windows.Forms.Form.SetVisibleCore (Boolean value) [0x00000]
at System.Windows.Forms.Control.set_Visible (Boolean value) [0x00000]
at (wrapper remoting-invoke-with-check) System.Windows.Forms.Control:set_Visible (bool)
at System.Windows.Forms.Application.RunLoop (Boolean Modal, System.Windows.Forms.ApplicationContext context) [0x00000]
at System.Windows.Forms.Application.Run (System.Windows.Forms.Form mainForm) [0x00000]
at OpenDental.FormOpenDental.Main () [0x00000]

Thank you for your patience!

Bill Starck, DDS

Post by **jordansparks** » Mon Aug 27, 2007 8:41 pm

I'm going to guess that's a recent bug that we don't know about yet since we don't have Linux running in production. We did overhaul the Appointment module recently, so that would make sense.

fcarlier · Post by **fcarlier** » Tue Aug 28, 2007 4:11 am

From the looks of it, is is a recent Mono bug. I'll investigate and follow up.

fcarlier · Post by **fcarlier** » Tue Aug 28, 2007 7:10 am

This particular issue should be fixed in SVN. Now I'm seeing an "Invalid IL code bug", I've posted on the mono mailing for more info.

Post by **jordansparks** » Tue Aug 28, 2007 8:04 am

Thank you.