Page 1 of 1
Installation error
Posted: Fri Feb 26, 2016 8:18 pm
by ian312
I installed on the EC2 instance setting up and getting error:
SQL logic error or missing database
near "?": syntax error
Re: Installation error
Posted: Fri Feb 26, 2016 10:05 pm
by admin
There seems to be a problem accessing the database file. Please check if you have read/write access to:
C:\ProgramData\AutomatiCloud\AutomatiCloud.sqlite
If you don't see the file at all please uninstall and reinstall AutomatiCloud.
Stephan
Re: Installation error
Posted: Sat Feb 27, 2016 12:56 am
by ian312
I gave the user I am logged in with Full Permissions on the File with the same error being produced.
Then I re-installed the software. Including downloading an fresh copy.
I can provide the Stack Trace of that will help to troublehshoot.
Re: Installation error
Posted: Sat Feb 27, 2016 5:52 pm
by admin
please start AutomatiCloud as Administrator and end send the logfile AutomatiCloudLog.txt.
Stephan
Re: Installation error
Posted: Mon Feb 29, 2016 11:55 pm
by ian312
thanks for taking a look Stephan
Re: Installation error
Posted: Tue Mar 01, 2016 10:01 pm
by admin
The logfile is fine. When does this error come? Can you send me the stack trace please.
Stephan
Re: Installation error
Posted: Tue Mar 01, 2016 10:26 pm
by ian312
at System.Data.SQLite.SQLite3.Prepare(SQLiteConnection cnn, String strSql, SQLiteStatement previous, UInt32 timeoutMS, String& strRemain)
at System.Data.SQLite.SQLiteCommand.BuildNextCommand()
at System.Data.SQLite.SQLiteCommand.GetStatement(Int32 index)
at System.Data.SQLite.SQLiteDataReader.NextResult()
at System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCommand cmd, CommandBehavior behave)
at System.Data.SQLite.SQLiteCommand.ExecuteReader(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery(CommandBehavior behavior)
at System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
at Globals.SaveSettings() in L:\PROJECTS\CloudScheduler\CloudScheduler\Globals.cs:line 199
at AutomatiCloud.frmSettings.geDhbk5har(Object , EventArgs ) in L:\PROJECTS\CloudScheduler\CloudScheduler\SettingsForm.cs:line 82
at System.Windows.Forms.Control.OnClick(EventArgs e)
at DevExpress.XtraEditors.BaseButton.OnClick(EventArgs e)
at DevExpress.XtraEditors.BaseButton.OnMouseUp(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseUp(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at DevExpress.Utils.Controls.ControlBase.WndProc(Message& m)
at DevExpress.XtraEditors.BaseControl.WndProc(Message& msg)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
Re: Installation error
Posted: Tue Mar 01, 2016 10:32 pm
by admin
this seems to happen when you save the settings. Can you please please fill only the two fields "Access Key" and "Secret Key" and leave all other fields empty.
Stephan
Re: Installation error
Posted: Wed Mar 02, 2016 11:35 pm
by ian312
thanks for all your help.
Im all setup and creating a new job.