Table 'preferences' is read only (Linux)

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

Table 'preferences' is read only (Linux)

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
Posts: 75
Joined: Tue Jun 19, 2007 3:12 am
Location: Ghent, Belgium

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?
Frederik Carlier

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

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
Posts: 75
Joined: Tue Jun 19, 2007 3:12 am
Location: Ghent, Belgium

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.
Frederik Carlier

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

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

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

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

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

oops my bad :?

table name should be 'preference'

stand by...

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

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

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

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
Posts: 75
Joined: Tue Jun 19, 2007 3:12 am
Location: Ghent, Belgium

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

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

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

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 :D :D

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

User avatar
jordansparks
Site Admin
Posts: 5739
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

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.
Jordan Sparks, DMD
http://www.opendental.com

User avatar
wjstarck
Posts: 935
Joined: Tue Jul 31, 2007 7:18 am
Location: Keller, TX
Contact:

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

User avatar
jordansparks
Site Admin
Posts: 5739
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

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.
Jordan Sparks, DMD
http://www.opendental.com

fcarlier
Posts: 75
Joined: Tue Jun 19, 2007 3:12 am
Location: Ghent, Belgium

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.
Frederik Carlier

fcarlier
Posts: 75
Joined: Tue Jun 19, 2007 3:12 am
Location: Ghent, Belgium

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.
Frederik Carlier

User avatar
jordansparks
Site Admin
Posts: 5739
Joined: Sun Jun 17, 2007 3:59 pm
Location: Salem, Oregon
Contact:

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

Thank you.
Jordan Sparks, DMD
http://www.opendental.com

Post Reply