Jump to content
Ketarin forum

Ketarin 1.6 beta 6


floele
 Share

Recommended Posts

hi peeps,

 

often i have to force-download HeidiSQL after it fails to get the exe file from the following url:

 

http://www.heidisql.com/latest_build.php

 

any ideas why?

 

 

i have a {ver} and {build} variables set up for "Version" and "Build" display columns that get retrieved correctly from here:

http://code.google.com/feeds/p/heidisql/svnchanges/basic

http://www.heidisql.com/download.php

 

i guess the alternative would be to grab the full url of the build from that download.php page:

 

http://www.heidisql.com/builds/heidisql.r3834.exe

 

just wondering why latest_build.php often fails to detect changes?

 

thanks,

leon

Edited by Leeoniya
Link to comment
Share on other sites

  • Replies 85
  • Created
  • Last Reply

Top Posters In This Topic

You have to set the 'variable for change' to actually use them, it's in the advanced tab of the application settings.

 

You can only use one variable to detect for changes, i'd just stick with the revision value defined from the page http://www.heidisql.com/download.php

 

Also that revision variable is really only for nightly builds, if that is what you want. Personally i'd just regex the dl link for the portable version from that dl page as I prefer stable builds.

 

If ya want full blown help post your application xml and i'll poke it. The issue though is that it is not detecting any changes in the file to download.

Link to comment
Share on other sites

thanks, i set 'build' to be used for change detection but it didn't seem to work. i have 2 apps, chromium canary and heidisql.

 

when i press update all, the versions for everything get retrieved fine and the columns get updated. the chromium download begins, and the heidi download just sits with a fully green (100%) progress bar (without any % indicator) and after chrome finishes downloading and installing, the bar goes away and everything gets marked as up to date, but no download of heidi actually occurs.

 

i'm gonna try it with another build and if that doesnt work, then just say screw it and use the full constructed latest build url from the download page parsing.

 

still it seems like the sitting progress bar while chrome downloads is a bug of some sort.

Link to comment
Share on other sites

I didn't have any difficulty, i'm not sure if ketarin build really has anything to do with it as I did nothing special.

 

Here's the xml that worked for me.

 

<?xml version='1.0' encoding='utf-8'?>
<Jobs>
 <ApplicationJob xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Guid="b9b9d780-12d3-4aa1-b023-3b6f94f4bb52">
   <Category>a</Category>
   <WebsiteUrl />
   <UserAgent />
   <UserNotes />
   <LastFileSize>0</LastFileSize>
   <LastFileDate xsi:nil="true" />
   <IgnoreFileInformation>false</IgnoreFileInformation>
   <DownloadBeta>Default</DownloadBeta>
   <DownloadDate xsi:nil="true" />
   <CheckForUpdatesOnly>false</CheckForUpdatesOnly>
   <VariableChangeIndicator>version</VariableChangeIndicator>
   <CanBeShared>true</CanBeShared>
   <ShareApplication>false</ShareApplication>
   <ExclusiveDownload>false</ExclusiveDownload>
   <HttpReferer />
   <SetupInstructions />
   <Variables>
     <item>
       <key>
         <string>download</string>
       </key>
       <value>
         <UrlVariable>
           <RegexRightToLeft>false</RegexRightToLeft>
           <VariableType>RegularExpression</VariableType>
           <Regex>([^"'=]+[^"']+build(\.php))</Regex>
           <Url>http://www.heidisql.com/download.php</Url>
           <Name>download</Name>
         </UrlVariable>
       </value>
     </item>
     <item>
       <key>
         <string>version</string>
       </key>
       <value>
         <UrlVariable>
           <RegexRightToLeft>false</RegexRightToLeft>
           <VariableType>RegularExpression</VariableType>
           <Regex>Revision.*?>([\d]+)</Regex>
           <Url>http://www.heidisql.com/download.php</Url>
           <Name>version</Name>
         </UrlVariable>
       </value>
     </item>
   </Variables>
   <ExecuteCommand>/*This is a comment line, the line below is the C# script. It will run the instructions found in the Setup Tab*/
app.Install(null);</ExecuteCommand>
   <ExecutePreCommand />
   <ExecuteCommandType>CS</ExecuteCommandType>
   <ExecutePreCommandType>Batch</ExecutePreCommandType>
   <SourceType>FixedUrl</SourceType>
   <DeletePreviousFile>true</DeletePreviousFile>
   <Enabled>true</Enabled>
   <FileHippoId />
   <LastUpdated xsi:nil="true" />
   <TargetPath>{downloadpath}{category}\</TargetPath>
   <FixedDownloadUrl>http://www.heidisql.com/{download}</FixedDownloadUrl>
   <Name>HeidiSQL</Name>
 </ApplicationJob>
</Jobs>

Link to comment
Share on other sites

I've got it. Trying to export my job file from default path (C:\Users\usr\AppData\Roaming\Ketarin) works properly. Doing the same from memory stick with a job file located in the same directory as the ketarin.exe breaks up the whole export procedure.

 

The content of my xml file is always the same.

<?xml version='1.0' encoding='utf-8'?>
<Jobs />

 

 

And here my export settings:

File -> Settings -> Commands -> Before updating all applications ->

REM setting up variables
SET CURHOUR=%CURHOUR: =0%
set year=%date:~6,4%
set yr=%date:~8,2%
set month=%date:~3,2%
set day=%date:~0,2%
set hour=%time:~0,2%
set hour=%hour: =0%
set min=%time:~3,2%
set sec=%time:~6,2%

REM exporting database
START ketarin.exe /export=all-%year%%month%%day%-%hour%%min%%sec%.xml

Link to comment
Share on other sites

Necrox, have you opened a command prompt, switched to the Ketarin folder and run the command directly? I know on newer OSes (XP/Vista/7) the "start" command pushes the working directory to the default path - so that could be your issue. Just removing Start from your command could fix it. It could also be due to where it's happening (within a Ketarin event), but I would think that wouldn't be an issue with the SQLite locking fix implemented in the 1.6 branch.

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.