PDA

View Full Version : [Inactive] sqlite_error ???


stuckpipe
03-27-2009, 11:58 AM
I just installed iturns and launch itune...then iturns. the message popped up...CSqlstatement: Execute
sqlite_error

this happened in Xp Sp3 and iturns Pro ver. 2.0.1.1

I clicked ok. the program opened but I could find me itune library...

Anyhelp would be appreciated.
RetiredJarhead
03-27-2009, 12:01 PM
I just installed iturns and launch itune...then iturns. the message popped up...CSqlstatement: Execute
sqlite_error

this happened in Xp Sp3 and iturns Pro ver. 2.0.1.1

I clicked ok. the program opened but I could find me itune library...

Anyhelp would be appreciated.

Welcome to the forum stuckpipe... as I am not an itunes user I can't provide you with an answer but there are some very knowledgeable folks here that can... hang in there and they will get to you soon... happy burning
Charlie
03-27-2009, 12:02 PM
Give time for my PC Expert to stop by and see your post. I assume you meant you are using 2.0.4.1?
stuckpipe
03-27-2009, 12:28 PM
No, I just bought the program and downloaded it and it shows 2.0.1.1. I went to the pdf info file and followed the help but found that the menus on itures doesn't have "burn" capabilities under Advanced properties..My kids have iturnes 8.1.052.
ReadMeToo
03-27-2009, 04:00 PM
Ok lets see what not working

So far this is what I know about your system so we are going to fine tune this a bit more.

Windows Operating System
Windows XP Pro

Desktop or Laptop
Desktop

Machinist or DVD43 or AnyDVD
Machinist

DVD neXt COPY Version
DVD neXt COPY Pro

PC Manufacturer
Other

IN my signature there is a PC Questionaire would you go to this thread
in the same thread copy and paste in reply post IN BLACK Make all your answers in RED I will respond in BLUE

I will revue this and give some suggestions ,,BTW doe this happen on any other systems you have or is this the only system you have.

ReadMeToo PC Expert Super Mod
Charlie
03-27-2009, 04:09 PM
You don't have a sqllite fix?
ReadMeToo
03-27-2009, 04:16 PM
he posted a problem with an XP sp3 system but his profile shows a XP pro there is quite a difference between these 2 OS's being Pro is not Media intensive and Xp sp3 is.

SQL problem could be a conflict in software thats on the system . We need to fine tune this a bit
Charlie
03-27-2009, 04:17 PM
But thought SP3 was installed by all XP systems? :)
Ultra_Sun
03-27-2009, 04:20 PM
I just installed iturns and launch itune...then iturns. the message popped up...CSqlstatement: Execute
sqlite_error

this happened in Xp Sp3 and iturns Pro ver. 2.0.1.1

I clicked ok. the program opened but I could find me itune library...

Anyhelp would be appreciated.

iTurns "choose your burner" instructions are lacking a bit of information and are based on an old version of iTunes.

When you open iTunes, you will create a play list in iTunes. You accomplish this by opening up your audiobooks (view them in the "LIST" view not the pictorial view). Now under the "FILE" menu, you have the option to create a "NEW PLAYLIST" or ctrl-N. Name it the name of the book and add all the parts of the book to the audiobook playlist (you can highlilght all the parts and right click to add them to your new playlist). Once you have a playlist that has all the parts to your book (still in iTunes) press the "BURN" button (You must be in the playlist window to see the burn button), this is where iTunes will allow you "choose your burner." Hopefully, this will solve some of your issues.

I am not familiar with the error message you are getting. My iTurns burner is refusing to "eject the burned disc" and tell iTunes it's inserted a new blank disc so I cannot test new burns. This was testing the new AAX file format. The AA format does not seem to present a problem with the method outlined above. I have XP SP3 (XP Professional - Service Pack 3 which is what I assumed you meant in your original post), but my version of iTurns is different. Try redownloading from the site to make sure you have the most current version of iTurns.

For your information, if you need to cancel the burn process within iTunes, you can call Audible for additional burn rights by explaining that the burn process was not successful (I wouldn't mention iTurns to them). Do a little complaining about losing discs in the process always gets them hopping.


I clicked ok. the program opened but I could find me itune library...

I am assuming you "clicked ok" to ignore the error message and proceeded to attempt to go through the process anyway. My question is the next problem of "find me itune library" issue. Does this mean you cannot find your iTune library files or that you cannot find your DRM protected files? Also what files are you attempting to convert (i.e., music or audiobook). I can help you with defaults, but if you have changed them you will need to look under EDIT-PREFERENCES-ADVANCE to find out where you designated iTunes to put them.

Also, remember that iTurns does not function on a drag and drop initiation process. You must attempt to "burn" the title from within iTunes to the virtual drive in order to get iTurns working on the process.
ReadMeToo
03-27-2009, 04:22 PM
Give you and Idea of SQL error below Nothing simple about it. LOL we need to delete this after you view no since confusing everyone with this ,

Get the Idea LOL


EXAMPLE ERROR EXPANDED from an SQL error

first chance exception of type 'System.Data.EntityException' occurred in System.Data.Entity.dll
'Company.vshost.exe' (Managed): Loaded 'C:\Windows\assembly\GAC_MSIL\System.Transactions. resources\2.0.0.0_de_b77a5c561934e089\System.Trans actions.resources.dll'
System.Transactions Critical: 0 : <TraceRecord xmlns="[Only registered and activated users can see links]" Severity="Critical"><TraceIdentifier>[Only registered and activated users can see links]><Description>Unbehandelte Ausnahme</Description><AppDomain>Company.vshost.exe</AppDomain><Exception><ExceptionType>System.Data.EntityException, System.Data.Entity, Version=3.5.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</ExceptionType><Message>Fehler beim zugrunde liegenden Anbieter auf Commit.</Message><StackTrace> bei System.Data.EntityClient.EntityTransaction.Commit( )
bei System.Data.Objects.ObjectContext.SaveChanges(Bool ean acceptChangesDuringSave)
bei System.Data.Objects.ObjectContext.SaveChanges()
bei Company.DepartmentPresenter.View_AddDepartment(Str ing departmentName) in C:\MVPSampleCompany\Company\Company\DepartmentPres enter.cs:Zeile 42.
bei Company.MainWindowView.addDepartmentButton_Click_1 (Object sender, EventArgs e) in C:\MVPSampleCompany\Company\Company\MainWindowView .cs:Zeile 26.
bei System.Windows.Forms.Control.OnClick(EventArgs e)
bei System.Windows.Forms.Button.OnClick(EventArgs e)
bei System.Windows.Forms.Button.OnMouseUp(MouseEventAr gs mevent)
bei System.Windows.Forms.Control.WmMouseUp(Message&amp;amp ; m, MouseButtons button, Int32 clicks)
bei System.Windows.Forms.Control.WndProc(Message&amp;amp; m)
bei System.Windows.Forms.ButtonBase.WndProc(Message&amp;am p; m)
bei System.Windows.Forms.Button.WndProc(Message&amp;amp; m)
bei System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message&amp;amp; m)
bei System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message&amp;amp; m)
bei System.Windows.Forms.NativeWindow.DebuggableCallba ck(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
bei System.Windows.Forms.UnsafeNativeMethods.DispatchM essageW(MSG&amp;amp; msg)
bei System.Windows.Forms.Application.ComponentManager. System.Windows.Forms.UnsafeNativeMethods.IMsoCompo nentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
bei System.Windows.Forms.Application.ThreadContext.Run MessageLoopInner(Int32 reason, ApplicationContext context)
bei System.Windows.Forms.Application.ThreadContext.Run MessageLoop(Int32 reason, ApplicationContext context)
bei System.Windows.Forms.Application.Run(Form mainForm)
bei Company.Program.Main() in C:\MVPSampleCompany\Company\Company\Program.cs:Zei le 19.
bei System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
bei System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
bei Microsoft.VisualStudio.HostingProcess.HostProc.Run UsersAssembly()
bei System.Threading.ThreadHelper.ThreadStart_Context( Object state)
bei System.Threading.ExecutionContext.Run(ExecutionCon text executionContext, ContextCallback callback, Object state)
bei System.Threading.ThreadHelper.ThreadStart()</StackTrace><ExceptionString>System.Data.EntityException: Fehler beim zugrunde liegenden Anbieter auf Commit. ---&amp;gt; System.Data.SQLite.SQLiteException: SQLite error
cannot commit transaction - SQL statements in progress
bei System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
bei System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
bei System.Data.SQLite.SQLiteDataReader.NextResult()
bei System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCo mmand cmd, CommandBehavior behave)
bei System.Data.SQLite.SQLiteCommand.ExecuteReader(Com mandBehavior behavior)
bei System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
bei System.Data.SQLite.SQLiteTransaction.Commit()
bei System.Data.EntityClient.EntityTransaction.Commit( )
--- Ende der internen Ausnahmestapelüberwachung ---
bei System.Data.EntityClient.EntityTransaction.Commit( )
bei System.Data.Objects.ObjectContext.SaveChanges(Bool ean acceptChangesDuringSave)
bei System.Data.Objects.ObjectContext.SaveChanges()
bei Company.DepartmentPresenter.View_AddDepartment(Str ing departmentName) in C:\MVPSampleCompany\Company\Company\DepartmentPres enter.cs:Zeile 42.
bei Company.MainWindowView.addDepartmentButton_Click_1 (Object sender, EventArgs e) in C:\MVPSampleCompany\Company\Company\MainWindowView .cs:Zeile 26.
bei System.Windows.Forms.Control.OnClick(EventArgs e)
bei System.Windows.Forms.Button.OnClick(EventArgs e)
bei System.Windows.Forms.Button.OnMouseUp(MouseEventAr gs mevent)
bei System.Windows.Forms.Control.WmMouseUp(Message&amp;amp ; m, MouseButtons button, Int32 clicks)
bei System.Windows.Forms.Control.WndProc(Message&amp;amp; m)
bei System.Windows.Forms.ButtonBase.WndProc(Message&amp;am p; m)
bei System.Windows.Forms.Button.WndProc(Message&amp;amp; m)
bei System.Windows.Forms.Control.ControlNativeWindow.O nMessage(Message&amp;amp; m)
bei System.Windows.Forms.Control.ControlNativeWindow.W ndProc(Message&amp;amp; m)
bei System.Windows.Forms.NativeWindow.DebuggableCallba ck(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)
bei System.Windows.Forms.UnsafeNativeMethods.DispatchM essageW(MSG&amp;amp; msg)
bei System.Windows.Forms.Application.ComponentManager. System.Windows.Forms.UnsafeNativeMethods.IMsoCompo nentManager.FPushMessageLoop(Int32 dwComponentID, Int32 reason, Int32 pvLoopData)
bei System.Windows.Forms.Application.ThreadContext.Run MessageLoopInner(Int32 reason, ApplicationContext context)
bei System.Windows.Forms.Application.ThreadContext.Run MessageLoop(Int32 reason, ApplicationContext context)
bei System.Windows.Forms.Application.Run(Form mainForm)
bei Company.Program.Main() in C:\MVPSampleCompany\Company\Company\Program.cs:Zei le 19.
bei System.AppDomain._nExecuteAssembly(Assembly assembly, String[] args)
bei System.AppDomain.ExecuteAssembly(String assemblyFile, Evidence assemblySecurity, String[] args)
bei Microsoft.VisualStudio.HostingProcess.HostProc.Run UsersAssembly()
bei System.Threading.ThreadHelper.ThreadStart_Context( Object state)
bei System.Threading.ExecutionContext.Run(ExecutionCon text executionContext, ContextCallback callback, Object state)
bei System.Threading.ThreadHelper.ThreadStart()</ExceptionString><InnerException><ExceptionType>System.Data.SQLite.SQLiteException, System.Data.SQLite, Version=1.0.60.0, Culture=neutral, PublicKeyToken=db937bc2d44ff139</ExceptionType><Message>SQLite error
cannot commit transaction - SQL statements in progress</Message><StackTrace> bei System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
bei System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
bei System.Data.SQLite.SQLiteDataReader.NextResult()
bei System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCo mmand cmd, CommandBehavior behave)
bei System.Data.SQLite.SQLiteCommand.ExecuteReader(Com mandBehavior behavior)
bei System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
bei System.Data.SQLite.SQLiteTransaction.Commit()
bei System.Data.EntityClient.EntityTransaction.Commit( )</StackTrace><ExceptionString>System.Data.SQLite.SQLiteException: SQLite error
cannot commit transaction - SQL statements in progress
bei System.Data.SQLite.SQLite3.Reset(SQLiteStatement stmt)
bei System.Data.SQLite.SQLite3.Step(SQLiteStatement stmt)
bei System.Data.SQLite.SQLiteDataReader.NextResult()
bei System.Data.SQLite.SQLiteDataReader..ctor(SQLiteCo mmand cmd, CommandBehavior behave)
bei System.Data.SQLite.SQLiteCommand.ExecuteReader(Com mandBehavior behavior)
bei System.Data.SQLite.SQLiteCommand.ExecuteNonQuery()
bei System.Data.SQLite.SQLiteTransaction.Commit()
bei System.Data.EntityClient.EntityTransaction.Commit( )</ExceptionString></InnerException></Exception></TraceRecord>


Now this was a simple error to.