Jump to content
Ketarin forum

necrox

Moderators
  • Content count

    248
  • Joined

  • Last visited

About necrox

Profile Information

  • Gender
    Male
  • Location
    FR, Germany

Recent Profile Visitors

42,801 profile views
  1. necrox

    Download from 2 or more URLs

    This is not yet possible without detours. In this thread it was discussed how to do such a thing using third party tools. Of course, it is better if Ketarin natively supports this feature. You are therefore invited to vote for this feature
  2. necrox

    Zip password

    For 7zip you can use the switch -p. It would look like this: 7z x archive.zip -pyourpasword
  3. What is in the log files? Just put 7z.exe as a global variable in Ketarin. Then you save some work and a lot of problems. Here somewhere in the forum there are several short instructions regarding global variables. Found the post: global variables
  4. necrox

    Cant' submit app to online database

    It works now, thank you for the fix!
  5. necrox

    Cant' submit app to online database

    07.03.2018 13:20:18: Could not submit 'Input Overlay (OBS Studio Plugins)' to the online database: Unhandled Doctrine\DBAL\Exception\DriverException exception:An exception occurred while executing 'INSERT INTO apps_applicationjobs (ApplicationName, Category, ApplicationXml, ApplicationGuid, AuthorGuid, ExternalId) VALUES (?, ?, ?, ?, ?, ?)' with params [{"0":"Input Overlay (OBS Studio Plugins)"}, {"0":"Multimedia"}, "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n<Jobs><ApplicationJob xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\" xmlns:xsd=\"http:\/\/www.w3.org\/2001\/XMLSchema\" Guid=\"5800d0ed-699f-491f-b224-91ebbde64f93\"><Category>Multimedia<\/Category><WebsiteUrl>https:\/\/obsproject.com\/forum\/resources\/input-overlay.552\/<\/WebsiteUrl><UserAgent\/><UserNotes>https:\/\/github.com\/univrsal\/input-overlay<\/UserNotes><LastFileSize>3948449<\/LastFileSize><LastFileDate>2018-02-21T13:47:31+01:00<\/LastFileDate><IgnoreFileInformation>false<\/IgnoreFileInformation><DownloadBeta>Default<\/DownloadBeta><DownloadDate xsi:nil=\"true\"\/><CheckForUpdatesOnly>false<\/CheckForUpdatesOnly><VariableChangeIndicator>version<\/VariableChangeIndicator><HashVariable\/><HashType>None<\/HashType><CanBeShared>true<\/CanBeShared><ShareApplication>true<\/ShareApplication><ExclusiveDownload>false<\/ExclusiveDownload><HttpReferer\/><SetupInstructions\/><Variables><item><key><string>appcat<\/string><\/key><value><UrlVariable><RegexRightToLeft>false<\/RegexRightToLeft><VariableType>Textual<\/VariableType><Regex\/><TextualContent>{appname:regexreplace: \\(.*\\):}<\/TextualContent><Name>appcat<\/Name><\/UrlVariable><\/value><\/item><item><key><string>appfile<\/string><\/key><value><UrlVariable><RegexRightToLeft>false<\/RegexRightToLeft><VariableType>Textual<\/VariableType><Regex\/><TextualContent>{appname:multireplace:|:(|)| :|_|_}<\/TextualContent><Name>appfile<\/Name><\/UrlVariable><\/value><\/item><item><key><string>version<\/string><\/key><value><UrlVariable><RegexRightToLeft>false<\/RegexRightToLeft><VariableType>RegularExpression<\/VariableType><Regex>input-overlay.v([^\"]*).zip<\/Regex><Url>https:\/\/github.com\/univrsal\/input-overlay\/releases\/latest<\/Url><Name>version<\/Name><\/UrlVariable><\/value><\/item><item><key><string>url<\/string><\/key><value><UrlVariable><RegexRightToLeft>false<\/RegexRightToLeft><VariableType>Textual<\/VariableType><Regex>(https[^\"]*youtube-dl.exe)<\/Regex><Url>http:\/\/rg3.github.io\/youtube-dl\/download.html<\/Url><TextualContent>https:\/\/github.com\/{download}<\/TextualContent><Name>url<\/Name><\/UrlVariable><\/value><\/item><item><key><string>download<\/string><\/key><value><UrlVariable><RegexRightToLeft>false<\/RegexRightToLeft><VariableType>RegularExpression<\/VariableType><Regex>([^\"]*.zip)<\/Regex><Url>https:\/\/github.com\/univrsal\/input-overlay\/releases\/latest<\/Url><Name>download<\/Name><\/UrlVariable><\/value><\/item><item><key><string>subcategory<\/string><\/key><value><UrlVariable><RegexRightToLeft>false<\/RegexRightToLeft><VariableType>Textual<\/VariableType><Regex\/><TextualContent>OBS Studio Plugins<\/TextualContent><Name>subcategory<\/Name><\/UrlVariable><\/value><\/item><\/Variables><ExecuteCommand><\/ExecuteCommand><ExecutePreCommand><\/ExecutePreCommand><ExecuteCommandType>Batch<\/ExecuteCommandType><ExecutePreCommandType>Batch<\/ExecutePreCommandType><SourceType>FixedUrl<\/SourceType><PreviousLocation><\/PreviousLocation><DeletePreviousFile>true<\/DeletePreviousFile><Enabled>true<\/Enabled><FileHippoId\/><LastUpdated>2018-03-07T13:19:54.9098525+01:00<\/LastUpdated><TargetPath>{downloads}\\{category}\\{subcategory:regexreplace: Plugins:}\\{subcategory}\\{appfile}v{version}.{url:ext}<\/TargetPath><FixedDownloadUrl>{url}<\/FixedDownloadUrl><Name>Input Overlay (OBS Studio Plugins)<\/Name><\/ApplicationJob><\/Jobs>\n", "{5800d0ed-699f-491f-b224-91ebbde64f93}", "{6b00f891-0086-4c98-9974-bfe5e28151a5}", ""]: SQLSTATE[22003]: Numeric value out of range: 1264 Out of range value for column 'CreatedAt' at row 1 It seems like it's still not working.
  6. necrox

    Cant' submit app to online database

    Could not submit 'Input Overlay (OBS Studio Plugins)' to the online database: Unhandled Doctrine\DBAL\Exception\NotNullConstraintViolationException exception:An exception occurred while executing 'INSERT INTO apps_applicationjobs (ApplicationName, Category, ApplicationXml, ApplicationGuid, AuthorGuid, ExternalId) VALUES (?, ?, ?, ?, ?, ?)' with params [{"0":"Input Overlay (OBS Studio Plugins)"}, {"0":"Multimedia"}, "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n<Jobs><ApplicationJob xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\" xmlns:xsd=\"http:\/\/www.w3.org\/2001\/XMLSchema\" Guid=\"1d21f6b0-5a8f-4b79-9650-2a9a089c8f56\"><Category>Multimedia<\/Category><WebsiteUrl>https:\/\/obsproject.com\/forum\/resources\/input-overlay.552\/<\/WebsiteUrl><UserAgent\/><UserNotes>https:\/\/github.com\/univrsal\/input-overlay<\/UserNotes><LastFileSize>3948449<\/LastFileSize><LastFileDate>2018-02-26T15:16:13.7080997<\/LastFileDate><IgnoreFileInformation>false<\/IgnoreFileInformation><DownloadBeta>Default<\/DownloadBeta><DownloadDate xsi:nil=\"true\"\/><CheckForUpdatesOnly>false<\/CheckForUpdatesOnly><VariableChangeIndicator>version<\/VariableChangeIndicator><HashVariable\/><HashType>None<\/HashType><CanBeShared>true<\/CanBeShared><ShareApplication>true<\/ShareApplication><ExclusiveDownload>false<\/ExclusiveDownload><HttpReferer\/><SetupInstructions\/><Variables><item><key><string>appcat<\/string><\/key><value><UrlVariable><RegexRightToLeft>false<\/RegexRightToLeft><VariableType>Textual<\/VariableType><Regex\/><TextualContent>{appname:regexreplace: \\(.*\\):}<\/TextualContent><Name>appcat<\/Name><\/UrlVariable><\/value><\/item><item><key><string>appfile<\/string><\/key><value><UrlVariable><RegexRightToLeft>false<\/RegexRightToLeft><VariableType>Textual<\/VariableType><Regex\/><TextualContent>{appname:multireplace:|:(|)| :|_|_}<\/TextualContent><Name>appfile<\/Name><\/UrlVariable><\/value><\/item><item><key><string>version<\/string><\/key><value><UrlVariable><RegexRightToLeft>false<\/RegexRightToLeft><VariableType>RegularExpression<\/VariableType><Regex>input-overlay.v([^\"]*).zip<\/Regex><Url>https:\/\/github.com\/univrsal\/input-overlay\/releases\/latest<\/Url><Name>version<\/Name><\/UrlVariable><\/value><\/item><item><key><string>url<\/string><\/key><value><UrlVariable><RegexRightToLeft>false<\/RegexRightToLeft><VariableType>Textual<\/VariableType><Regex>(https[^\"]*youtube-dl.exe)<\/Regex><Url>http:\/\/rg3.github.io\/youtube-dl\/download.html<\/Url><TextualContent>https:\/\/github.com\/{download}<\/TextualContent><Name>url<\/Name><\/UrlVariable><\/value><\/item><item><key><string>download<\/string><\/key><value><UrlVariable><RegexRightToLeft>false<\/RegexRightToLeft><VariableType>RegularExpression<\/VariableType><Regex>([^\"]*.zip)<\/Regex><Url>https:\/\/github.com\/univrsal\/input-overlay\/releases\/latest<\/Url><Name>download<\/Name><\/UrlVariable><\/value><\/item><item><key><string>subcategory<\/string><\/key><value><UrlVariable><RegexRightToLeft>false<\/RegexRightToLeft><VariableType>Textual<\/VariableType><Regex\/><TextualContent>OBS Studio Plugins<\/TextualContent><Name>subcategory<\/Name><\/UrlVariable><\/value><\/item><\/Variables><ExecuteCommand><\/ExecuteCommand><ExecutePreCommand><\/ExecutePreCommand><ExecuteCommandType>Batch<\/ExecuteCommandType><ExecutePreCommandType>Batch<\/ExecutePreCommandType><SourceType>FixedUrl<\/SourceType><PreviousLocation><\/PreviousLocation><DeletePreviousFile>true<\/DeletePreviousFile><Enabled>true<\/Enabled><FileHippoId\/><LastUpdated>2018-02-26T15:16:13.7080997<\/LastUpdated><TargetPath>{downloads}\\{category}\\{subcategory:regexreplace: Plugins:}\\{subcategory}\\{appfile}v{version}.{url:ext}<\/TargetPath><FixedDownloadUrl>{url}<\/FixedDownloadUrl><Name>Input Overlay (OBS Studio Plugins)<\/Name><\/ApplicationJob><\/Jobs>\n", "{guid-here}", "{6b00f891-0086-4c98-9974-bfe5e28151a5}", ""]: SQLSTATE[HY000]: General error: 1364 Field 'CreatedAt' doesn't have a default value Could not submit 'VirtualCam (OBS Studio Plugins)' to the online database: Unhandled Doctrine\DBAL\Exception\NotNullConstraintViolationException exception:An exception occurred while executing 'INSERT INTO apps_applicationjobs (ApplicationName, Category, ApplicationXml, ApplicationGuid, AuthorGuid, ExternalId) VALUES (?, ?, ?, ?, ?, ?)' with params [{"0":"VirtualCam (OBS Studio Plugins)"}, {"0":"Multimedia"}, "<?xml version=\"1.0\" encoding=\"utf-8\"?>\n<Jobs><ApplicationJob xmlns:xsi=\"http:\/\/www.w3.org\/2001\/XMLSchema-instance\" xmlns:xsd=\"http:\/\/www.w3.org\/2001\/XMLSchema\" Guid=\"09e22f38-4009-4f66-9261-6ec4a0e54a13\"><Category>Multimedia<\/Category><WebsiteUrl>https:\/\/obsproject.com\/forum\/resources\/obs-virtualcam.539\/<\/WebsiteUrl><UserAgent\/><UserNotes>https:\/\/github.com\/CatxFish\/obs-virtual-cam\/releases<\/UserNotes><LastFileSize>384373<\/LastFileSize><LastFileDate>2018-02-26T15:13:07.3458387<\/LastFileDate><IgnoreFileInformation>false<\/IgnoreFileInformation><DownloadBeta>Default<\/DownloadBeta><DownloadDate xsi:nil=\"true\"\/><CheckForUpdatesOnly>false<\/CheckForUpdatesOnly><VariableChangeIndicator>version<\/VariableChangeIndicator><HashVariable\/><HashType>None<\/HashType><CanBeShared>true<\/CanBeShared><ShareApplication>true<\/ShareApplication><ExclusiveDownload>false<\/ExclusiveDownload><HttpReferer\/><SetupInstructions\/><Variables><item><key><string>appcat<\/string><\/key><value><UrlVariable><RegexRightToLeft>false<\/RegexRightToLeft><VariableType>Textual<\/VariableType><Regex\/><TextualContent>{appname:regexreplace: \\(.*\\):}<\/TextualContent><Name>appcat<\/Name><\/UrlVariable><\/value><\/item><item><key><string>appfile<\/string><\/key><value><UrlVariable><RegexRightToLeft>false<\/RegexRightToLeft><VariableType>Textual<\/VariableType><Regex\/><TextualContent>{appname:multireplace:|:(|)| :|_|_}<\/TextualContent><Name>appfile<\/Name><\/UrlVariable><\/value><\/item><item><key><string>version<\/string><\/key><value><UrlVariable><RegexRightToLeft>false<\/RegexRightToLeft><VariableType>RegularExpression<\/VariableType><Regex>OBS-VirtualCam([^\"]*)-Installer.exe<\/Regex><Url>https:\/\/github.com\/CatxFish\/obs-virtual-cam\/releases\/latest<\/Url><Name>version<\/Name><\/UrlVariable><\/value><\/item><item><key><string>url<\/string><\/key><value><UrlVariable><RegexRightToLeft>false<\/RegexRightToLeft><VariableType>Textual<\/VariableType><Regex>(https[^\"]*youtube-dl.exe)<\/Regex><Url>http:\/\/rg3.github.io\/youtube-dl\/download.html<\/Url><TextualContent>https:\/\/github.com\/{download}<\/TextualContent><Name>url<\/Name><\/UrlVariable><\/value><\/item><item><key><string>download<\/string><\/key><value><UrlVariable><RegexRightToLeft>false<\/RegexRightToLeft><VariableType>RegularExpression<\/VariableType><Regex>([^\"]*.exe)<\/Regex><Url>https:\/\/github.com\/CatxFish\/obs-virtual-cam\/releases\/latest<\/Url><Name>download<\/Name><\/UrlVariable><\/value><\/item><item><key><string>subcategory<\/string><\/key><value><UrlVariable><RegexRightToLeft>false<\/RegexRightToLeft><VariableType>Textual<\/VariableType><Regex\/><TextualContent>OBS Studio Plugins<\/TextualContent><Name>subcategory<\/Name><\/UrlVariable><\/value><\/item><\/Variables><ExecuteCommand><\/ExecuteCommand><ExecutePreCommand><\/ExecutePreCommand><ExecuteCommandType>Batch<\/ExecuteCommandType><ExecutePreCommandType>Batch<\/ExecutePreCommandType><SourceType>FixedUrl<\/SourceType><PreviousLocation><\/PreviousLocation><DeletePreviousFile>true<\/DeletePreviousFile><Enabled>true<\/Enabled><FileHippoId\/><LastUpdated>2018-02-26T15:13:07.3458387<\/LastUpdated><TargetPath>{downloads}\\{category}\\{subcategory:regexreplace: Plugins:}\\{subcategory}\\{appfile}v{version}.{url:ext}<\/TargetPath><FixedDownloadUrl>{url}<\/FixedDownloadUrl><Name>VirtualCam (OBS Studio Plugins)<\/Name><\/ApplicationJob><\/Jobs>\n", "{guid-here}", "{6b00f891-0086-4c98-9974-bfe5e28151a5}", ""]: SQLSTATE[HY000]: General error: 1364 Field 'CreatedAt' doesn't have a default value This error occurs with all newly created entries in my database.
  7. necrox

    Cant' submit app to online database

    I have the same problem! Submitting newly created downloads does not work.
  8. necrox

    Flash distribution pages changing

    Fixed all broken links.
  9. necrox

    Firefox version news

    I encountered this problem early this morning and had to check and modify some entries in my database. Thank you for the clarification here in the forum. By the way, the AddOn pages have also changed. So I had to adapt all my AddOn templates.
  10. There is an option to set the number of parallel downloads and the timeout time. Open your settings by pressing CTRL+T, switch to Connection and modify the connection timeout delay and the max. number of parallel downloads according to your wishes.
  11. Aloha! Would it be possible to post the contents of the log file? Is $ Remote Tools an existing directory? Add a backslash \ to the end of your folder names and try it again. COPY /V /Y "D:\Haole Boy\$USB files and folders\$ Tools\Process Explorer\procexp64.exe" "D:\Haole Boy\$USB files and folders\$ Tools\$ Remote Tools\" COPY /V /Y "D:\Haole Boy\$USB files and folders\$ Tools\Process Explorer\procexpl.reg" "D:\Haole Boy\$USB files and folders\$ Tools\" COPY /V /Y "D:\Haole Boy\$USB files and folders\$ Tools\Process Explorer\procexp64.exe" "C:\Tools\" If the file path never changes and to keep the script area clean, you can use global variables. If you do not always want to write D:\Haole Boy\$USB files and folders\, you can shorten it to something like {haoleboy}. Open your settings (CTRL + T), switch to Global variables, create a variable called haoleboy, for example. Add D:\Haole Boy\$USB files and folders as value. If you want to use a script the next time, you can shorten it. COPY /V /Y "{haoleboy}\$ Tools\Process Explorer\procexp64.exe" "{haoleboy}\$ Tools\$ Remote Tools\" COPY /V /Y "{haoleboy}\$ Tools\Process Explorer\procexpl.reg" "{haoleboy}\$ Tools\" COPY /V /Y "{haoleboy}\$ Tools\Process Explorer\procexp64.exe" "C:\Tools\" Same for 7zip. Create a variable called 7z for example and set the value to C:\Program Files\7-Zip\7z.exe If you want to use 7zip the next time, then you can do it like this: "{7z}" x "{file}" -o"{file:directory}" -y
  12. It looks like this is a server-side limitation. I have the same problem with your imported XML. As soon as the downloads from this server are limited to a single download (see picture) everything works without problems.
  13. necrox

    Create Log

    The first command opens Ketarin, performs a database export as XML and closes Ketarin. The second command starts Ketarin with the specified database. Regarding your problem. Where is your database file located? Is your database in the same folder as the EXE? Does another database exist in %AppData%?
  14. necrox

    Create Log

    This one of my old scripts but still working. Try this: @ECHO OFF cd /d %~dp0 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% ECHO . ECHO STARTING KETARIN... START ketarin.exe /database=home_apps.db /export=home_apps-%year%-%month%-%day%_%hour%%min%%sec%.xml PING -n 5 localhost > NUL START ketarin.exe /database=home_apps.db /log=log-%year%-%month%-%day%_%hour%%min%%sec%.log PING -n 5 localhost > NUL REN home_apps.db_*.bak home_apps.db_%year%-%month%-%day%_%hour%%min%%sec%.bak EXIT
  15. necrox

    Can not download "ReNamer"

    Does my script work? You have exported the app from Ketarin as XML and copied the content here into the forum, right? Or have you tried to edit your XML file externally and re-import it to Ketarin? I guess that the standard encoding was not set correctly. Would it be possible to add your exported XML file as attachment?
×

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.