appyface Posted March 28, 2009 Report Share Posted March 28, 2009 This thread is the best I could come up with for explanation: http://social.msdn.microsoft.com/Forums/en-US/netfxnetcom/thread/fb1542ad-7618-4099-8b0a-8a487a7663c4/ I'm not using a web proxy though. And Ketarin has been downloading this app fine until tonight. Thoughts on what this error message from Ketarin means? TIA, --appyface Link to comment Share on other sites More sharing options...
CybTekSol Posted March 28, 2009 Report Share Posted March 28, 2009 Thoughts on what this error message from Ketarin means? Are you able to download the app with your browser without any error? Link to comment Share on other sites More sharing options...
floele Posted March 28, 2009 Report Share Posted March 28, 2009 Does it help if you install .NET Framework 2.0 SP2? Link to comment Share on other sites More sharing options...
appyface Posted March 28, 2009 Author Report Share Posted March 28, 2009 @CybTekSol Yes I downloaded it with IE7 fine. Ketarin still can't get it. @flo Already have .NET framework 2.0 sp2 installed. (Checked m$ update just now, not missing any updates and .NET framework 2.0 sp2 is listed as installed. I see the same in add/remove programs applet too, shows it as installed.) Link to comment Share on other sites More sharing options...
appyface Posted March 28, 2009 Author Report Share Posted March 28, 2009 OK I so I decided to create a separate db for this app, just for testing/troubleshooting, and to post app info and results here for anyone to replicate error message if possible. I created new blank db for Ketarin. Then I imported my global settings file from other Ketarin into this one. Next I tried to import an XML file for this one problem app. I can't import, I get this error message: Failed to import the file: SQLite error no such table: jobs So I thought maybe I have to add the first app manually (I don't recall needing to do this in the past though). I clicked the "add new application button" and get this error: Unhandled exception SQLite error no such table: variables. (see bottom of this post for info from the 'details' box from this exception) OK so maybe importing my global settings first is the problem. Delete servu_test.db and have Ketarin create a new one, I tried importing the XML for the problem app, same error. And same error if I try to add an app manually to the empty database... OK so what else can cause this? I am launching Ketarin like this: Ketarin.exe /DATABASE:servu_test.db and letting Ketarin create the empty db called "servu_test" in my current directory. Is that the problem? Yes it is... If instead I let Ketarin create blank "jobs.db" file I can import my app's XML and my global settings, then rename the db to whatever I like. Flo, can this be fixed so that the name of the blank db does NOT have to be jobs.db for the first app to be created/imported? TIA! OK on with the testing. I have renamed jobs.db to "servu_test.db" and tried to update. Same protocol error message as before: 3/28/2009 12:22:20 PM: Update started with 1 application(s) 3/28/2009 12:22:20 PM: Serv-U FTP Server: Using referer: http://www.serv-u.com/dn.asp 3/28/2009 12:22:25 PM: Serv-U FTP Server: Failed, The server committed a protocol violation. Section=ResponseStatusLine 3/28/2009 12:22:25 PM: Update finished Below is the XML for this app, followed by the JIT debug info for the exception reported above. Can anyone replicate the message? TIA for help... --appyface XML: <?xml version="1.0" encoding="utf-16"?> <Jobs> <ApplicationJob xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Guid="fc82d504-e6dd-489a-a3e5-4de99cb25ffe"> <DownloadBeta>Default</DownloadBeta> <DownloadDate xsi:nil="true" /> <CheckForUpdatesOnly>false</CheckForUpdatesOnly> <VariableChangeIndicator /> <CanBeShared>true</CanBeShared> <ShareApplication>false</ShareApplication> <ExclusiveDownload>false</ExclusiveDownload> <HttpReferer /> <Variables> <item> <key> <string>vers</string> </key> <value> <UrlVariable> <RegexRightToLeft>false</RegexRightToLeft> <VariableType>RegularExpression</VariableType> <Regex>(?<=Download Serv-U Version ).*?(?= \(.*?>HTTP Download Site)</Regex> <Url>http://www.serv-u.com/dn.asp</Url> <StartText>Download Serv-U Version </StartText> <EndText> (</EndText> <Name>vers</Name> </UrlVariable> </value> </item> </Variables> <ExecuteCommand /> <ExecutePreCommand /> <Category>000100</Category> <SourceType>FixedUrl</SourceType> <PreviousLocation>D:\Stuff\filestore\IUtils\ServUSetup_8.0.0.4.exe</PreviousLocation> <DeletePreviousFile>false</DeletePreviousFile> <Enabled>true</Enabled> <FileHippoId /> <LastUpdated>2009-03-27T04:09:51.9735</LastUpdated> <TargetPath>D:\Stuff\filestore\IUtils\{url:basefile}_{vers}.{url:ext}</TargetPath> <FixedDownloadUrl>http://www.serv-u.com/susetup1.exe</FixedDownloadUrl> <Name>Serv-U FTP Server</Name> </ApplicationJob> </Jobs> ----------------------------------------------------------------------------------- Details from exception error: Unhandled exception SQLite error no such table: variables. See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.Data.SQLite.SQLiteException: SQLite error no such table: variables 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() at Ketarin.UrlVariable.get_GlobalVariables() at Ketarin.Forms.ApplicationJobDialog.RefreshVariables() at Ketarin.Forms.ApplicationJobDialog.OnLoad(EventArgs e) at System.Windows.Forms.Form.OnCreateControl() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at System.Windows.Forms.Control.WmShowWindow(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.ContainerControl.WndProc(Message& m) at System.Windows.Forms.Form.WmShowWindow(Message& m) at System.Windows.Forms.Form.WndProc(Message& m) 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) ************** Loaded Assemblies ************** mscorlib Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3082 (QFE.050727-3000) CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll ---------------------------------------- Ketarin Assembly Version: 1.0.5.235 Win32 Version: 1.0.5.235 CodeBase: file:///D:/Program_Files_NOINST/Ketarin-1.0.5/Ketarin.exe ---------------------------------------- System.Windows.Forms Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- System.Drawing Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- System.Data Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll ---------------------------------------- System.Data.SQLite Assembly Version: 1.0.58.0 Win32 Version: 1.0.58.0 CodeBase: file:///D:/Program_Files_NOINST/Ketarin-1.0.5/System.Data.SQLite.DLL ---------------------------------------- System.Transactions Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll ---------------------------------------- System.Design Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll ---------------------------------------- System.Xml Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3082 (QFE.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------- System.Web Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3082 (QFE.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll ---------------------------------------- System.Configuration Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll ---------------------------------------- System.EnterpriseServices Assembly Version: 2.0.0.0 Win32 Version: n/a CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll ---------------------------------------- ycss5z6e Assembly Version: 1.0.5.235 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- Accessibility Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll ---------------------------------------- 1jxa7qo7 Assembly Version: 1.0.5.235 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- kjqdomdb Assembly Version: 1.0.5.235 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- ************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box. Link to comment Share on other sites More sharing options...
FranciscoR Posted March 28, 2009 Report Share Posted March 28, 2009 Another chalenge. =) The FixedDownloadUrl you're using redirects to http://www.rhinosoft.com/searchmirrors.asp?prod=su&download=1 , and this will give you DL URL, http://download151.mediafire.com/w3d3wxdwx2wg/3iyzyty4jlj/ServUSetup.exe . But - IMO - the query above is unsuported right now, you can only forward post parameters. Link to comment Share on other sites More sharing options...
floele Posted March 28, 2009 Report Share Posted March 28, 2009 Do you actually use the latets Ketarin version? I have no problems with creating an empty database in the current directory. Regarding SP2: Could it possibly be, that your problem started when you installed SP2? (Try SP1 if you think that this is possible). Link to comment Share on other sites More sharing options...
appyface Posted March 29, 2009 Author Report Share Posted March 29, 2009 @flo Yes I believe Ketarin is at the most current version. It is this one: Name Size Modified Created Ketarin.exe 618,496 3/21/2009 12:43:12 PM 3/21/2009 7:55:00 AM No, definitely not caused by a windows update, .net SP2 or otherwise. My latest update was 3/17/09, Root Certificates. Prior to that, .net 3.5 SP1 and related was installed on 1/28/09 (which some fixes for .net 2.0 sp2). .net SP2 was long before that. @Francisco and Flo I had been using (and downloading) Serv-U with Ketarin right up to version 8.0.0.4, which I downloaded with Ketarin on 3/27 about 4am. I ran Ketarin again that night and was surprised to get this error "the server committed a protocol violation"... I went to the website and saw they had released version 8.0.0.5. Like the Java JDK I think the real issue is a moving target? Somewhere after 4am on 3/27 the webpage changed as to how it serves the file, which would explain what you're seeing, Francisco? So the real question, just like in my "Java JDK challenge", might be this: How do we get Ketarin to download this file? OR is this really some kind of .net error...? Thanks everyone. Keep the ideas coming --appyface Link to comment Share on other sites More sharing options...
FranciscoR Posted March 29, 2009 Report Share Posted March 29, 2009 OR is this really some kind of .net error...? If it is you're not alone (tested w/Vista SP1 patched and XP SP2 unpatched (guine-pig machine)). sss The server committed a protocol violation. Section=ResponseStatusLine (http://www.serv-u.com/susetup1.exe) Yes I believe Ketarin is at the most current version. Nope. Latest version, available from homepage, is 1.0.5.254. You're using 1.0.5. Try updating from here http://ketarin.canneverbe.com/downloads/Ketarin/ Link to comment Share on other sites More sharing options...
Stalker Posted March 29, 2009 Report Share Posted March 29, 2009 Yup, same here. Vista SP1 .NET 3 SP1, Windows Server 2003 SP2 .NET 3 SP1. Link to comment Share on other sites More sharing options...
appyface Posted March 29, 2009 Author Report Share Posted March 29, 2009 Thanks Francisco, I also use that page to find latest Ketarin. Silly me, I only glanced at the last entry above debug. (Incorrectly assuming the latest version would also be the last one... d'oh!). OK have now downloaded the current version of Ketarin: Name Size Modified Created Ketarin.exe 618,496 3/27/2009 7:36:38 PM 3/29/2009 11:20:40 AM TEST SEQUENCE 1: 1. Proceeded to let Ketarin create a blank db from same command line run as before: Ketarin.exe /DATABASE:servu_test.db 2. As soon as the new blank db came up, I tried clicking the 'add new application' button. This time does NOT throw exception as before. I cancelled out without adding an app. 3. Next I tried importing my XML for the serv-u application (XML shown here, above). I still get "Failed to import the file: SQLite error no such table: jobs". 4. Next I tried importing my global settings XML. The import completed without error, I OK'd the dialog to close. Then I wanted to check on the settings that were imported, I used menu choice File -> Settings and I get this exception thrown: SQLite error no such table: variables. (full text of exception is below) 5. I clicked "quit" on the exception rather than "continue", this closed Ketarin. 6. I relaunched Ketarin.exe /DATABASE:servu_test.db. 7. Now I can go to the menu choice File -> Settings without throwing an exception, and I can see my new settings were imported correctly. 8. So I tried to import the Serv-U app XML again, but still get same SQLite error message, "no such table: jobs". 9. So I tried clicking the 'add application' button again. But this time I get same exception thrown as above, "no such table: variables". OK so once my settings are imported everything is fouled up, apparently... TEST SEQUENCE 2: 1. I deleted "servu_test.db" and relaunched Ketarin.exe /DATABASE:servu_test.db to create a new blank one. 2. I used "add application" button and added a bogus application. All OK so far. 3. Then tried importing my Serv-U app XML, still get same error message "no such table: jobs". 4. I closed Ketarin and relaunched Ketarin.exe /DATABASE:servu_test.db. 5. Bogus app still on display, all good so far. 6. Then tried import of Serv-U app XML, and still get same error message "no such table: jobs". I give up. Francisco would you try to replicate? Just use my same command line invocation as above (I have my command line is in a .bat file in same directory with Ketarin, SQLLite dll and the DB). Just your own single app XML and global settings XML at the appropriate places, or try my Serv-U jobs XML (above). Do you get the same errors? TIA if you have time to try to replicate this. --appyface Thrown exception: See the end of this message for details on invoking just-in-time (JIT) debugging instead of this dialog box. ************** Exception Text ************** System.Data.SQLite.SQLiteException: SQLite error no such table: variables 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.ExecuteDbDataReader(CommandBehavior behavior) at System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader() at Ketarin.UrlVariable.get_GlobalVariables() at Ketarin.Forms.SettingsDialog.LoadGlobalVariables() at Ketarin.Forms.SettingsDialog.LoadSettings() at Ketarin.Forms.SettingsDialog.OnLoad(EventArgs e) at System.Windows.Forms.Form.OnCreateControl() at System.Windows.Forms.Control.CreateControl(Boolean fIgnoreVisible) at System.Windows.Forms.Control.CreateControl() at System.Windows.Forms.Control.WmShowWindow(Message& m) at System.Windows.Forms.Control.WndProc(Message& m) at System.Windows.Forms.ScrollableControl.WndProc(Message& m) at System.Windows.Forms.ContainerControl.WndProc(Message& m) at System.Windows.Forms.Form.WmShowWindow(Message& m) at System.Windows.Forms.Form.WndProc(Message& m) 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) ************** Loaded Assemblies ************** mscorlib Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3082 (QFE.050727-3000) CodeBase: file:///C:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll ---------------------------------------- Ketarin Assembly Version: 1.0.5.254 Win32 Version: 1.0.5.254 CodeBase: file:///D:/Program_Files_NOINST/Ketarin-1.0.5.254/Ketarin.exe ---------------------------------------- System.Windows.Forms Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll ---------------------------------------- System Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- System.Drawing Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll ---------------------------------------- System.Data Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll ---------------------------------------- System.Data.SQLite Assembly Version: 1.0.58.0 Win32 Version: 1.0.58.0 CodeBase: file:///D:/Program_Files_NOINST/Ketarin-1.0.5.254/System.Data.SQLite.DLL ---------------------------------------- System.Transactions Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll ---------------------------------------- System.Design Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Design/2.0.0.0__b03f5f7f11d50a3a/System.Design.dll ---------------------------------------- System.Xml Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3082 (QFE.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll ---------------------------------------- System.Web Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3082 (QFE.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Web/2.0.0.0__b03f5f7f11d50a3a/System.Web.dll ---------------------------------------- System.Configuration Assembly Version: 2.0.0.0 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll ---------------------------------------- System.EnterpriseServices Assembly Version: 2.0.0.0 Win32 Version: n/a CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll ---------------------------------------- vu0ekrtw Assembly Version: 1.0.5.254 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- xcfmnk6o Assembly Version: 1.0.5.254 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- _pkgx0p4 Assembly Version: 1.0.5.254 Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000) CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll ---------------------------------------- ************** JIT Debugging ************** To enable just-in-time (JIT) debugging, the .config file for this application or computer (machine.config) must have the jitDebugging value set in the system.windows.forms section. The application must also be compiled with debugging enabled. For example: <configuration> <system.windows.forms jitDebugging="true" /> </configuration> When JIT debugging is enabled, any unhandled exception will be sent to the JIT debugger registered on the computer rather than be handled by this dialog box. Link to comment Share on other sites More sharing options...
appyface Posted March 29, 2009 Author Report Share Posted March 29, 2009 (edited) Thanks Stalker! You snuck in while I was posting the 2nd novella Stalker if you have time would you try to replicate my blank db errors I outlined just above? As is usual, I've got two separate errors going in this thread, one for the download of Serv-U and one for the creation and importing to blank db that is NOT named jobs.db... and need help on both... TIA if you have time to try it out... --appyface Edited March 29, 2009 by appyface Link to comment Share on other sites More sharing options...
Stalker Posted March 29, 2009 Report Share Posted March 29, 2009 I tried creating a blank servu_test.db (using Ketarin.exe /DATABASE:servu_test.db) and importing ServU from XML with no errors. The "The server committed a protocol violation. Section=ResponseStatusLine" is reproducible even in such case. Link to comment Share on other sites More sharing options...
appyface Posted March 29, 2009 Author Report Share Posted March 29, 2009 Thanks Stalker. Yes I think the download of Serv-U is a problem with how they changed their webpage, that Ketarin cannot handle. So, you had no problem creating the blank db and importing the Servu XML from above immediately? How about a global settings XML file, can you export that from another Ketarin db, then import it into a brand-new blank servu_test.db (which should work), then review it with File -> Settings (without closing the Ketarin instance yet)? Link to comment Share on other sites More sharing options...
appyface Posted March 29, 2009 Author Report Share Posted March 29, 2009 (edited) *****UPDATE****** I found the problem with the Serv-U and settings import. My XML files were in another directory than where Ketarin is, a zero-length "servu_test.db" file is being created in the DIRECTORY WHERE THE XML FILES ARE when I do the import. Stalker, please try again but locate your XML for servu job import, in a directory higher than where Ketarin is. In my case I'm running Ketarin from directory D:\Program_Files_NOINST\Ketarin-1.0.5.254\, my XML files for servu job and for settings are in D:\Program_Files_NOINST\. See if you can recreate this way? TIA, --appyface @Flo -- yes that's the difference for me. If my XML files are in the SAME directory with Ketarin and the servu_test.db, all is well. If I navigate to the other directory and load the XML files from there, that is what causes all the errors. We'll see if Stalker and/or Francisco can replicate. Flo can you replicate? TIA, --appyface Edited March 29, 2009 by appyface Link to comment Share on other sites More sharing options...
Stalker Posted March 29, 2009 Report Share Posted March 29, 2009 (edited) Settings did not import completely. None of my global variables have been imported although I got no exceptions. Oh and the log file said that database backup could not be created. EDIT to your EDIT: Both my settings.xml and servu.xml were imported from a directory one level higher then Ketarin. Ketarin's location: ~/Desktop/Ketarin (sorry for *nix ~, it's shorted and easier ) XML location: ~/Desktop/ Edited March 29, 2009 by Stalker Link to comment Share on other sites More sharing options...
appyface Posted March 29, 2009 Author Report Share Posted March 29, 2009 Stalker are you using the very latest Ketarin? Because I reported that logfile backup error message, and Flo has already fixed it (for me, anyway, I don't see the message anymore) Link to comment Share on other sites More sharing options...
Stalker Posted March 29, 2009 Report Share Posted March 29, 2009 Yeah, it seems I was using 235 version (it's now my non-main Ketarin install so I forgot to update it). Log message is gone with the new version however all other issues are still reproducible. Link to comment Share on other sites More sharing options...
appyface Posted March 29, 2009 Author Report Share Posted March 29, 2009 So you could reproduce my latest step-by-step test? The settings DO import (from file in other directory than Ketarin's) but then you can't review them without throwing the exception? And the import of job XML (from file in other directory than Ketarin's) also gives the error message (there is no exception for me in that case)? TIA for all your help. Now I think it is up to Flo... Link to comment Share on other sites More sharing options...
Stalker Posted March 29, 2009 Report Share Posted March 29, 2009 So you could reproduce my latest step-by-step test? The settings DO import (from file in other directory than Ketarin's) but then you can't review them without throwing the exception? Not an exception, no. Variables just aren't imported. No messages, exceptions or log entries are shown. And the import of job XML (from file in other directory than Ketarin's) also gives the error message (there is no exception for me in that case)? Nope to that too. The job imports fine and runs fine (well, shows Section=blablabla error because I've used ServU but still). Maybe the problem in your specific settings file ? Mine is very simple. I'll attach it just so that you could try it out. <?xml version="1.0"?> <dictionary> <item> <key> <string>AuthorGuid</string> </key> <value> <string>System.String:{e2257af6-5cdb-4c29-98c0-ef1a84f48397}</string> </value> </item> <item> <key> <string>ImportFromDatabaseDialog/Size</string> </key> <value> <string>System.Drawing.Size:559,340</string> </value> </item> <item> <key> <string>olvApplications/Application name:Visibility</string> </key> <value> <string>System.Boolean:True</string> </value> </item> <item> <key> <string>olvApplications/Application name:Width</string> </key> <value> <string>System.Int32:343</string> </value> </item> <item> <key> <string>olvApplications/Last updated:Visibility</string> </key> <value> <string>System.Boolean:True</string> </value> </item> <item> <key> <string>olvApplications/Last updated:Width</string> </key> <value> <string>System.Int32:130</string> </value> </item> <item> <key> <string>MainForm/Size</string> </key> <value> <string>System.Drawing.Size:884,520</string> </value> </item> <item> <key> <string>olvJobs/Application:Visibility</string> </key> <value> <string>System.Boolean:True</string> </value> </item> <item> <key> <string>olvJobs/Application:Width</string> </key> <value> <string>System.Int32:216</string> </value> </item> <item> <key> <string>olvJobs/Last updated:Visibility</string> </key> <value> <string>System.Boolean:True</string> </value> </item> <item> <key> <string>olvJobs/Last updated:Width</string> </key> <value> <string>System.Int32:110</string> </value> </item> <item> <key> <string>olvJobs/Progress:Visibility</string> </key> <value> <string>System.Boolean:True</string> </value> </item> <item> <key> <string>olvJobs/Progress:Width</string> </key> <value> <string>System.Int32:100</string> </value> </item> <item> <key> <string>olvJobs/Target:Visibility</string> </key> <value> <string>System.Boolean:True</string> </value> </item> <item> <key> <string>olvJobs/Target:Width</string> </key> <value> <string>System.Int32:210</string> </value> </item> <item> <key> <string>olvJobs/Category:Visibility</string> </key> <value> <string>System.Boolean:True</string> </value> </item> <item> <key> <string>olvJobs/Category:Width</string> </key> <value> <string>System.Int32:80</string> </value> </item> <item> <key> <string>olvJobs/Custom Value:Visibility</string> </key> <value> <string>System.Boolean:True</string> </value> </item> <item> <key> <string>olvJobs/Custom Value:Width</string> </key> <value> <string>System.Int32:105</string> </value> </item> <item> <key> <string>Ketarin/ShowGroups</string> </key> <value> <string>System.Boolean:True</string> </value> </item> <item> <key> <string>EditVariablesDialog/Size</string> </key> <value> <string>System.Drawing.Size:1165,755</string> </value> </item> <item> <key> <string>ApplicationJobDialog/Size</string> </key> <value> <string>System.Drawing.Size:413,353</string> </value> </item> <item> <key> <string>DefaultCommand</string> </key> <value> <string>System.String:</string> </value> </item> <item> <key> <string>UpdateAtStartup</string> </key> <value> <string>System.Boolean:False</string> </value> </item> <item> <key> <string>CustomColumn</string> </key> <value> <string>System.String:{version}</string> </value> </item> <item> <key> <string>AvoidFileHippoBeta</string> </key> <value> <string>System.Boolean:True</string> </value> </item> <item> <key> <string>SimilarApplicationsDialog/Size</string> </key> <value> <string>System.Drawing.Size:330,340</string> </value> </item> <item> <key> <string>ErrorsDialog/Size</string> </key> <value> <string>System.Drawing.Size:1292,801</string> </value> </item> <item> <key> <string>olvErrors/Application:Visibility</string> </key> <value> <string>System.Boolean:True</string> </value> </item> <item> <key> <string>olvErrors/Application:Width</string> </key> <value> <string>System.Int32:169</string> </value> </item> <item> <key> <string>olvErrors/Error:Visibility</string> </key> <value> <string>System.Boolean:True</string> </value> </item> <item> <key> <string>olvErrors/Error:Width</string> </key> <value> <string>System.Int32:1077</string> </value> </item> <item> <key> <string>ConnectionTimeout</string> </key> <value> <string>AAEAAAD/////AQAAAAAAAAAEAQAAAA5TeXN0ZW0uRGVjaW1hbAQAAAAFZmxhZ3MCaGkCbG8DbWlkAAAAAAgICAgAAAAAAAAAAAoAAAAAAAAACw==</string> </value> </item> <item> <key> <string>ThreadCount</string> </key> <value> <string>System.Int32:3</string> </value> </item> <item> <key> <string>ProxyPort</string> </key> <value> <string>AAEAAAD/////AQAAAAAAAAAEAQAAAA5TeXN0ZW0uRGVjaW1hbAQAAAAFZmxhZ3MCaGkCbG8DbWlkAAAAAAgICAgAAAAAAAAAAAAAAAAAAAAACw==</string> </value> </item> <item> <key> <string>ProxyServer</string> </key> <value> <string>System.String:</string> </value> </item> <item> <key> <string>ProxyUser</string> </key> <value> <string>System.String:</string> </value> </item> <item> <key> <string>ProxyPassword</string> </key> <value> <string>System.String:</string> </value> </item> <item> <key> <string>LastUpdateCheck</string> </key> <value> <string>AAEAAAD/////AQAAAAAAAAAEAQAAAA9TeXN0ZW0uRGF0ZVRpbWUCAAAABXRpY2tzCGRhdGVEYXRhAAAJEIgn0QmOfssIiCfRCY5+y4gL</string> </value> </item> <item> <key> <string>MainForm/Location</string> </key> <value> <string>System.Drawing.Point:396,0</string> </value> </item> <item> <key> <string>Ketarin/ShowLog</string> </key> <value> <string>System.Boolean:False</string> </value> </item> <item> <key> <string>RetryCount</string> </key> <value> <string>System.Int32:1</string> </value> </item> <item> <key> <string>UpdateOnlineDatabase</string> </key> <value> <string>System.Boolean:True</string> </value> </item> <item> <key> <string>LogDialog/Size</string> </key> <value> <string>System.Drawing.Size:1144,701</string> </value> </item> <item> <key> <string>LogDialog/Location</string> </key> <value> <string>System.Drawing.Point:0,69</string> </value> </item> <item> <key> <string>olvJobs/LastSortColumn</string> </key> <value> <string>System.String:Category</string> </value> </item> <item> <key> <string>olvJobs/LastSortOrder</string> </key> <value> <string>System.Windows.Forms.SortOrder, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089:Ascending</string> </value> </item> <item> <key> <string>olvApplications/LastSortColumn</string> </key> <value> <string>System.String:Application name</string> </value> </item> <item> <key> <string>olvApplications/LastSortOrder</string> </key> <value> <string>System.Windows.Forms.SortOrder, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089:None</string> </value> </item> <item> <key> <string>ProgressDialog/Size</string> </key> <value> <string>System.Drawing.Size:292,99</string> </value> </item> <item> <key> <string>EditVariablesDialog/Location</string> </key> <value> <string>System.Drawing.Point:18,23</string> </value> </item> <item> <key> <string>olvErrors/LastSortColumn</string> </key> <value> <string>System.String:Application</string> </value> </item> <item> <key> <string>olvErrors/LastSortOrder</string> </key> <value> <string>System.Windows.Forms.SortOrder, System.Windows.Forms, Version=2.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089:Ascending</string> </value> </item> <item> <key> <string>olvApplications/Application name:LastDisplayIndex</string> </key> <value> <string>System.Int32:-1</string> </value> </item> <item> <key> <string>olvApplications/Last updated:LastDisplayIndex</string> </key> <value> <string>System.Int32:-1</string> </value> </item> <item> <key> <string>olvJobs/Application:LastDisplayIndex</string> </key> <value> <string>System.Int32:-1</string> </value> </item> <item> <key> <string>olvJobs/Last updated:LastDisplayIndex</string> </key> <value> <string>System.Int32:-1</string> </value> </item> <item> <key> <string>olvJobs/Progress:LastDisplayIndex</string> </key> <value> <string>System.Int32:-1</string> </value> </item> <item> <key> <string>olvJobs/Target:LastDisplayIndex</string> </key> <value> <string>System.Int32:-1</string> </value> </item> <item> <key> <string>olvJobs/Category:LastDisplayIndex</string> </key> <value> <string>System.Int32:-1</string> </value> </item> <item> <key> <string>olvJobs/Custom Value:LastDisplayIndex</string> </key> <value> <string>System.Int32:-1</string> </value> </item> <item> <key> <string>MinimizeToTray</string> </key> <value> <string>System.Boolean:False</string> </value> </item> <item> <key> <string>olvErrors/Application:LastDisplayIndex</string> </key> <value> <string>System.Int32:-1</string> </value> </item> <item> <key> <string>olvErrors/Error:LastDisplayIndex</string> </key> <value> <string>System.Int32:-1</string> </value> </item> <item> <key> <string>olvApplications/Uses:Visibility</string> </key> <value> <string>System.Boolean:True</string> </value> </item> <item> <key> <string>olvApplications/Uses:Width</string> </key> <value> <string>System.Int32:40</string> </value> </item> <item> <key> <string>olvApplications/Uses:LastDisplayIndex</string> </key> <value> <string>System.Int32:-1</string> </value> </item> <item> <key> <string>DefaultApplication</string> </key> <value> <string>System.String:<?xml version="1.0" encoding="utf-16"?> <Jobs> <ApplicationJob xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema"> <DownloadBeta>Default</DownloadBeta> <CheckForUpdatesOnly>false</CheckForUpdatesOnly> <VariableChangeIndicator /> <CanBeShared>true</CanBeShared> <ShareApplication>true</ShareApplication> <ExclusiveDownload>false</ExclusiveDownload> <HttpReferer /> <Variables /> <ExecuteCommand /> <ExecutePreCommand /> <Category /> <SourceType>FixedUrl</SourceType> <DeletePreviousFile>true</DeletePreviousFile> <Enabled>true</Enabled> <FileHippoId /> <TargetPath>{DEST_DIR}\{category}\{appname}_v{version}.{url:ext}</TargetPath> <FixedDownloadUrl /> <Name /> </ApplicationJob> </Jobs></string> </value> </item> </dictionary> Link to comment Share on other sites More sharing options...
floele Posted March 29, 2009 Report Share Posted March 29, 2009 Hm, could you possibly examine the .db file with SQLiteSpy? For example, after the start of Ketarin, the database file should exist. At the same time, the tables jobs, variables and settings should have been created. Maybe you can verify that? Link to comment Share on other sites More sharing options...
Stalker Posted March 29, 2009 Report Share Posted March 29, 2009 Yes, I can confirm that a newly create db has jobs, settings and variables tables. Link to comment Share on other sites More sharing options...
FranciscoR Posted March 29, 2009 Report Share Posted March 29, 2009 (edited) Same error (=appyface, "Failed to import the file: SQLite error no such table: jobs") here. C:\Documents and Settings\Owner>c:\"Documents and Settings\Owner\My Documents"\K etarin\Ketarin.exe /DATABASE:jobs_serv-u.db And XML in desktop. Edited March 29, 2009 by FranciscoR Link to comment Share on other sites More sharing options...
Stalker Posted March 29, 2009 Report Share Posted March 29, 2009 I execute Ketarin.exe from withing Ketarin's directory. Just tried it like this C:\Users\Администратор> Desktop\Ketarin\Ketarin.exe /DATABASE:test.db and it still works. Link to comment Share on other sites More sharing options...
FranciscoR Posted March 29, 2009 Report Share Posted March 29, 2009 I'm testing in XP .net SP2 (not a clean installation) and I reproduced error twice (just to be sure). No problems with the renamed DB, it's the serv-u XML import that causes the error. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now