Tasker Beta 4.9b1+

[Pent]

http://tasker.dinglisch.net/beta.html

* be sure to do 'Menu / Data / Backup' before installing *

Posts on this thread not about beta-specific issues will probably be
deleted without comment. If in doubt, make a new thread and mention
you are using the beta.

Pent

[Raul SC]

Hello, a few days ago I made an appointment, and maybe because of the translation, I misunderstood.

I see that in this new version, the event "notification" can match, with more fields, besides the title of the notification.

I understood, that in addition, could handle the content of the notification, in a similar way that the variable% NTITLE.

Is it possible to access the contents of the notification in this new version?

By the way, the command ls -lt, still does not work in the new version. a greeting

[Pent]

I see that in this new version, the event "notification" can match, with more fields, besides the title of the notification.

I understood, that in addition, could handle the content of the notification, in a similar way that the variable% NTITLE.

Yes, in the task that runs from the Notification event you can use %evtprm1, %evtprm2 etc which correspond to
the notification which occurred.

By the way, the command ls -lt, still does not work in the new versio

I explained to you already that that was a limitation of the 'ls' command on your system,
not Tasker. I am not the author of the ls command.

Pent

[Pent]

Quick addendum: the userguide is *not* up-to-date for the beta,
sorry about that.

Pent

[Raul SC]

Hello again

The tasks in which I set the check to calculate, I am giving error in this new version.Copy the task and the error

Calcular (401)
A1: Establecer variable [ Nombre:%LT_Linterna A:1 -%LT_Linterna Recurse Variables:Apagado Calcular:Encendido Añadir:Apagado ]
A2: Antorcha [ Establecer:Encendido ] Si (if) [ %LT_Linterna ~ 1 ]
A3: Antorcha [ Establecer:Apagado ] Si (if) [ %LT_Linterna ~ 0 ]

16.37.21/Variables doreplresult: |%LT_Linterna| -> |0|
16.37.21/Variables doreplresult: |1 -%LT_Linterna| -> |1 -0|
16.37.21/E Establecer variable: %LT_Linterna -> %LT_Linterna
16.37.21/Variables doreplresult: |1 -%LT_Linterna| -> |1 -0|
16.37.21/Expr mathEval: null: exception: Attempt to invoke virtual method 'java.lang.String java.lang.String.replaceAll(java.lang.String, java.lang.String)' on a null object reference
16.37.21/E Establecer variable: %LT_Linterna: failed, not numeric ?
16.37.21/E result: stop task (error)
16.37.21/Variables doreplresult: |%LT_Linterna| -> |0|
16.37.21/E Error: 1
16.37.21/MacroEdit action finished exeID 1 action no 0 code 547 status: Err next 0

[Roger Mitchell]

I am also getting "failed, not numeric ? " on variables I am attempting to do maths on that worked prior to beta.

Thanks

[rayson]

Action > Status Bar > Collapsed no longer seems to work. Status Bar > Expanded still works though.

[Pent]

I am also getting "failed, not numeric ? " on variables I am attempting to do maths on that worked prior to beta.

Sorry, fixed for next update, should be next 24 hours.

Pent

[Pent]

Will fix for next update, should be next 24 hours.

Pent

[Walter Francis]

When setting Backlight Timeout I always get this error

12.25.58/E Display Timeout: set to 60000ms
12.25.58/E result: stop task (error)
12.25.58/E Error: 1
12.25.58/MacroEdit action finished exeID 3 action no 11 code 812 status: Err next 11

[Walter Francis]

Sorry, hit the post button by accident.. Using pixel xl with 7.1. 4.9mb1

[Pent]

> Sorry, hit the post button by accident.. Using pixel xl with 7.1. 4.9mb1

Before the beta it was fine ?

Pent

[MarkDubya]

I'm getting an error with a simple List Files action used in my automated Tasker cloud backup task. The line in bold appears in a toast when the action fails.

 

A5: List Files [ Dir:Tasker/configs/auto Match: Include Hidden Files:Off Use Root:Off Sort Select:Alphabetic Variable:%files ]

15.34.27/E List Files: %files -> %files

15.34.27/FileUtil wudf: not external: /storage/emulated/0/Tasker/configs/auto

15.34.27/FileUtil wudf: not external: /storage/emulated/0/Tasker/configs/auto

15.34.27/E code 3: java.lang.IllegalArgumentException: Invalid URI: content://com.android.providers.media.documents/document/image%3A7822.

15.34.27/E prefsException/List Files: Invalid URI: content://com.android.providers.media.documents/document/image%3A7822

15.34.27/ android.provider.DocumentsContract.getTreeDocumentId(DocumentsContract.java:928)

15.34.27/ net.dinglisch.android.taskerm.df.a(Unknown Source)

15.34.27/ net.dinglisch.android.taskerm.gm.a(Unknown Source)

15.34.27/ net.dinglisch.android.taskerm.gm.a(Unknown Source)

15.34.27/ net.dinglisch.android.taskerm.gm.a(Unknown Source)

15.34.27/ net.dinglisch.android.taskerm.ExecuteService.b(Unknown Source)

15.34.27/E List Files [ Dir:Tasker/configs/auto Match: Include Hidden Files: Use Root: Sort Select: Variable:%files ]

15.34.27/E result: stop task (error)

15.34.27/Variables doreplresult: |%files| -> |%files|

15.34.27/E Error: 1

15.34.27/MacroEdit action finished exeID 2 action no 4 code 412 status: Err next 4

[Walter Francis]

Yep, used these profiles /tasks for several years now. :) one thing I did notice was if I edit the action it works when I run/debug the script but later it's broken again. I use from 30s to 2 minutes, depending on the task. All are broken.

[Pent]

Yep, used these profiles /tasks for several years now. :)  

OK, but you definitely used it just before the beta with your current OS version ?
 

one thing I did notice was if I edit the action it works when I run/debug the script but later it's broken again.

Natural language is not very good for pinning down precise meanings I've noticed while supporting
this app :-)

Do you mean: (a) it always works with the play button in task edit, or (b) sometimes it doesn't work
with the play button until you edit the action again ?

Thanks,

Pent

[Pent]

I've posted a new version:

        <LI>beta: bugfix: Variable Set bugs
        <LI>beta: bugfix: action Status Bar: wasn't working without accessibility
        <LI>beta: change: action Status Bar: warn about needing accessibility where relevant
        <LI>beta: change: more logging for Display Timeout and List Files
        <LI>change: human-readaable export of event contexts: include Stop Event flag if set

Pent

[Pent]

15.34.27/E List Files: %files -> %files

15.34.27/FileUtil wudf: not external: /storage/emulated/0/Tasker/configs/auto

15.34.27/FileUtil wudf: not external: /storage/emulated/0/Tasker/configs/auto

15.34.27/E code 3: java.lang.IllegalArgumentException: Invalid URI: content://com.android.providers.media.documents/document/image%3A7822.

This is a puzzling one. Which device / OS version are you using ?

I've put some more logging in the beta update I just published, could you please
post what it says now ?

Thanks,

Pent

[Rich D]

Hi Pent.  The app factory export is still not working with android version set to 23. If I export the attached project the android accept screen says no permisions reqiured and the setting will not change when the app is run. All works as expexted at android version 22 and below. 

I have a pixel c tablet  /  Android 6.0.1  / Tasker Version: 4.9b1m 

I did update app factory as well and confirmed 4.9b1

[Rich D]

Not sure why my attachments did not go. This is using the display time out setting. 

[Clay Whitenack]

This fixed my variable set bug "failed. not numeric?"

[Raul SC]

Yes, that error is already corrected

[Pent]

Hi Pent.  The app factory export is still not working with android version set to 23. If I export the attached project the android accept screen says no permisions reqiured and the setting will not change when the app is run.

I can reproduce the problem there, will fix.

Pent

[Sean Williams]

I'm also experiencing a problem with display timeout to add a little more information..

When setting display timeout to 1 minute (for example) it will now stop with an error if display timeout is already previously set at 1 minute.

Xperia 6.0

[Sean Williams]

Pent

Hi

The 'Test File' action is no longer working none of the test parameters work when testing any file on my device internal memory.

[MarkDubya]

No errors with List Files using 4.9b2.

Nexus 5X

Android 7.0

[Clay Whitenack]

This isn't a new bug to the beta but the Variable Query window is blank.  It is functional, but you can't see what you are entering.

--
You received this message because you are subscribed to a topic in the Google Groups "Tasker" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/tasker/jHibSENraho/unsubscribe.
To unsubscribe from this group and all its topics, send an email to tasker+unsubscribe@googlegroups.com.
Visit this group at https://groups.google.com/group/tasker.
For more options, visit https://groups.google.com/d/optout.

[Sean Williams]

Looks like several file actions are having problems on my device. Just tested List Files and Read File neither are working.

22.09.42/Variables doreplresult: |%out| -> |%out|
22.09.42/FileUtil wudf: not external: /storage/emulated/0/NetworkLocation/nllog.txt
22.09.42/FileUtil wudf: not external: /storage/emulated/0/NetworkLocation/nllog.txt
22.09.42/E code 3: java.lang.IllegalArgumentException: Invalid URI: content://com.android.externalstorage.documents/document/primary%3ASYNC%2FDEVICE%20-%20SC4%2FGENERIC%20ICONS%2FWarning%20Icons%2Fpng%2Fskull3.png.
22.09.42/E prefsException/Read File: Invalid URI: content://com.android.externalstorage.documents/document/primary%3ASYNC%2FDEVICE%20-%20SC4%2FGENERIC%20ICONS%2FWarning%20Icons%2Fpng%2Fskull3.png
22.09.42/ android.provider.DocumentsContract.getTreeDocumentId(DocumentsContract.java:801)
22.09.42/ net.dinglisch.android.taskerm.df.a(Unknown Source)
22.09.42/ net.dinglisch.android.taskerm.gm.a(Unknown Source)
22.09.42/ net.dinglisch.android.taskerm.gm.a(Unknown Source)
22.09.42/ net.dinglisch.android.taskerm.gm.a(Unknown Source)
22.09.42/ net.dinglisch.android.taskerm.ExecuteService.a(Unknown Source)
22.09.42/E Read File [ File:NetworkLocation/nllog.txt To Var:%out ]
22.09.42/E result: stop task (error)
22.09.42/Variables doreplresult: |%out| -> |%out|
22.09.42/E Error: 1
22.09.42/MacroEdit action finished exeID 1 action no 0 code 417 status: Err next 0

Sony Xperia
Android 6.0

[Walter Francis]

Heh, I should know better than replying on the phone..  I hate typing on the phone, so I'm always too terse.  Let me try to explain more, better.

The previous 4.8 market latest version was working, as all of my "Profile" tasks have backlight times in them.  IE:  At work, home, I have it set to 2m.  In meetings, 1m.  At night, 15s, etc.  So they all set it.  And they were all working prior to the beta for the last 6 or so weeks I've had my Pixel XL, no OS change for the last few weeks etc.  

And for the "works again until it doesn't" part, here's the scenario, or as best I can figure it out....  I enable setting the backlight timeout in a task, go to the launcher, run my profile widget and change to that task, it fails.  I go into the Task, run/debug, it gives the error I pasted.  If I modify the backlight timeout option, say change 2 minutes to 3 minutes, then back to desktop, run widget, task works!  But if I run the task again, fails!  If I go back into the task and run/debug, fails.  Very odd.  So it appears that if I modify it, it works once, then it's in a failure state again.  Or, this might be more likely..  Perhaps it fails if it's attempting to set it to the same ..  Okay, pretty sure it's the last bit.

I just added two tasks, one that sets backlight timeout to 2 minutes, flashes "good", another sets 3 minutes, flashes good.  Put 'em both on the desktop, if I launch the 2 minute one repeatedly, fails.  3 minute one works the first time, fails subsequent times.  If I go 2, 3, 2, 3, works.  So it seems to be failing when the time is being set to what it's already set to?

Hope this helps, let me know if you need more.  I can debug more, logs etc, plus I'm rooted so I can easily dump all of my config and set up simple tasks and debug to reduce noise etc.

Thanks Pent!
 

Thanks,

Pent

[Pent]

As regards Display Timeout posts: these problems will probably also apply to any other actions that require WRITE_SETTINGS permission.

I'm having to rework those so it will take the user to the relevant 'special' permissions screen if needed,
since it's not listed in the normal permissions screen from Marshmallow and seems to be impossible
to find otherwise. That has to be done during action execution in case it's
running in a kid app.

All in all, very confusing.

Walter Francis: your problem is the same as Sean's, it's a bug introduced in the beta
where it counts the value as already being set as a failure, will fix of course.

Pent

[Walter Francis]

Great Pent, you're the best.  :)

 

Pent

[CoolRaoul]

Problem appeared with beta: inside an action edit form, when pressing "?" then "Download All To SD" I'm getting the following error message:

"Failed to unzip file en.110.zip, bad archive, ?."

[Abdullah Alahdal]

On Tuesday, December 6, 2016 at 11:25:27 AM UTC+3, CoolRaoul wrote:

Problem appeared with beta: inside an action edit form, when pressing "?" then "Download All To SD" I'm getting the following error message:

"Failed to unzip file en.110.zip, bad archive, ?."

He already mentioned that guide is not ready 

[CoolRaoul]

Le mardi 6 décembre 2016 09:49:34 UTC+1, Abdullah Alahdal a écrit :

He already mentioned that guide is not ready 

I wasn't able to notice: before posting I've searched for "Failed to unzip file" in the group and that returned no post 

[Pent]

Sean,

These errors are very strange! I've added a load of logging for the next update
tomorrow. Could you send me or post a log once it's out ?

http://tasker.dinglisch.net/userguide/en/faqs/faq-how.html#x2

Thanks,

Pent

[Pent]

Actually I've uploaded b3 already.

Pent

[Frédéric Szymañski]

Beta 3 :

12-06 18:46:49.572 E/Tasker (31324): 18.46.49#E: error: code 3: java.lang.IllegalArgumentException: Invalid URI: content://com.android.externalstorage.documents/document/primary%3ATasker%2FSecurity-Camera-icon.png.

12-06 18:46:49.573 E/Tasker (31324): 18.46.49#E: error: prefsException/Read File: Invalid URI: content://com.android.externalstorage.documents/document/primary%3ATasker%2FSecurity-Camera-icon.png

12-06 18:46:49.574 E/Tasker (31324): 18.46.49#: error: android.provider.DocumentsContract.getTreeDocumentId(DocumentsContract.java:927)

12-06 18:46:49.574 E/Tasker (31324): 18.46.49#: error: net.dinglisch.android.taskerm.df.a(Unknown Source)

OnePlus One
Android 7

[Abdullah Alahdal]

Hi Pent,

I was reluctant trying the Beta due to time factor. But I couldn't not hold myself. I mainly installed to try the SQL query. It is fantastic and user friendly.

The 1st issue I faced so far that the INSERT and UPDATE query is not working and I'm getting error that the database for Readonly.

22.29.25/Variables doreplresult: |Insert Into callsnotes (cid, note, notecompleted)
values (%cid, '%newnote', 0)| -> |Insert Into callsnotes (cid, note, notecompleted)
values (300, 'Tasker SQL', 0)|
22.29.25/E SQL Query: %insert -> %insert
22.29.25/FileUtil needReqDocAccess: wudf: not external: /storage/emulated/0/Tasker/DBs/Taskertables.sq|ite
22.29.25/FileUtil : wudf: not external: /storage/emulated/0/Tasker/DBs/Taskertables.sq|ite
22.29.25/FileUtil needReqDocAccess: /storage/emulated/0/Tasker/DBs/Taskertables.sq|ite: wantUse: false haveAccess: false need: false
22.29.25/E bta: checkSDPath: /storage/emulated/0/Tasker/DBs/Taskertables.sq|ite
22.29.25/FileUtil SQL Query/checkSDPath: wudf: not external: /storage/emulated/0/Tasker/DBs/Taskertables.sq|ite
22.29.25/E SQL Query: checkSDPath: /storage/emulated/0/Tasker/DBs/Taskertables.sq|ite useDocFile: false
22.29.25/E bta: exists: true
22.29.25/E bta: isFile: true
22.29.25/E bta: isDir: false
22.29.25/E SQL Query: checkSDPath: /storage/emulated/0/Tasker/DBs/Taskertables.sq|ite ok true
22.29.25/E code 3: android.database.sqlite.SQLiteReadOnlyDatabaseException: attempt to write a readonly database (code 8).
22.29.25/E prefsException/SQL Query: attempt to write a readonly database (code 8)
22.29.25/ android.database.sqlite.SQLiteConnection.nativeExecuteForCursorWindow(Native Method)
22.29.25/ android.database.sqlite.SQLiteConnection.executeForCursorWindow(SQLiteConnection.java:845)
22.29.25/ android.database.sqlite.SQLiteSession.executeForCursorWindow(SQLiteSession.java:836)
22.29.25/ android.database.sqlite.SQLiteQuery.fillWindow(SQLiteQuery.java:62)
22.29.25/ android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:143)
22.29.25/ android.database.sqlite.SQLiteCursor.getCount(SQLiteCursor.java:132)
22.29.25/E SQL Query [ Mode:Raw File:Tasker/DBs/Taskertables.sq|ite Table:callsnotes Columns:nid Query:Insert Into callsnotes (cid, note, notecompleted)
values (%cid, '%newnote', 0) Selection Parameters: Order By: Output Column Divider: Variable Array: ]
22.29.25/E result: stop task (error)
22.29.25/Variables doreplresult: |%insert| -> |%insert|
22.29.25/E Error: 1
22.29.25/MacroEdit action finished exeID 2 action no 16 code 667 status: Err next 16

[Pent]

Yes, this is the same thing that Sean is getting higher up the thread.

I need a log with all of the Tasker diagnostic logging too:

http://tasker.dinglisch.net/userguide/en/faqs/faq-how.html#x2

Pent

[Pent]

The 1st issue I faced so far that the INSERT and UPDATE query is not working and I'm getting error that the database for Readonly

Displaying my SQL ignorance there, I hadn't realised that the raw queries API allowed modifications,
so the DB is currently opened read-only.

Will have to have a think about the implications of that, for instance modifications
won't work on external storage, currently the file has to be copied to internal storage
to do the query due to restrictions of two different APIs. If modifications are to be
allowed, it would have to be copied back afterwards... not so efficient.

Pent

[Raul SC]

Sorry for my ignorance, I have some doubts about the new SQL query action.

More or less, queries are made in a database, using the traditional method of SQL.

I wanted to know if they could give some information on how to use this action and what benefits it has with respect to the traditional way.

And one more thing, this question can be a bit silly, but I have some doubt. Using this action, to make a query in a System Database, I also need to have access to the root?

When I do the tests, I will send the reports as explained, thank you.

[Sean Williams]

Sean,

http://tasker.dinglisch.net/userguide/en/faqs/faq-how.html#x2

Hi Pent,

A bit more information may be useful. I considered I may have been an anomaly so on Monday evening I did a clean install of Tasker and an update to the current b2 before restoring my configuration.

After this the file actions were again functioning. However once I began to reassociate my various scene images the problems returned.

I will of course get you a log.

Thanks!

[CoolRaoul]

I'm getting SQLite related errors too, triggered by 3rd party plugin (autonotification)

Here's the backtrace in case it can help:

AutoNotification - android.database.sqlite.SQLiteCantOpenDatabaseException: unable to open database file (code 14)
com.joaomgcd.autonotification version 2.5.21 OS Build MPES24.49-24-7 OS Code 23 Device XT1092 Manufacturer motorola Product victara_oraeu

com.joaomgcd.autonotification version 2.5.21 OS Build MPES24.49-24-7 OS Code 23 Device XT1092 Manufacturer motorola Product victara_oraeu
android.database.sqlite.SQLiteCantOpenDatabaseException: unable to open database file (code 14) at android.database.sqlite.SQLiteConnection.nativeExecuteForLong(Native Method) at android.database.sqlite.SQLiteConnection.executeForLong(SQLiteConnection.java:596) at android.database.sqlite.SQLiteSession.executeForLong(SQLiteSession.java:652) at android.database.sqlite.SQLiteStatement.simpleQueryForLong(SQLiteStatement.java:107) at com.birbit.android.jobqueue.persistentQueue.sqlite.SqliteJobQueue.countReadyJobs(SqliteJobQueue.java:235) at com.birbit.android.jobqueue.cachedQueue.CachedJobQueue.countReadyJobs(CachedJobQueue.java:71) at com.birbit.android.jobqueue.JobManagerThread.countReadyJobs(JobManagerThread.java:580) at com.birbit.android.jobqueue.JobManagerThread.countRemainingReadyJobs(JobManagerThread.java:566) at com.birbit.android.jobqueue.ConsumerManager.isAboveLoadFactor(ConsumerManager.java:167) at com.birbit.android.jobqueue.ConsumerManager.considerAddingConsumers(ConsumerManager.java:139) at com.birbit.android.jobqueue.ConsumerManager.onJobAdded(ConsumerManager.java:95) at com.birbit.android.jobqueue.JobManagerThread.handleAddJob(JobManagerThread.java:159) at com.birbit.android.jobqueue.JobManagerThread.access$000(JobManagerThread.java:35) at com.birbit.android.jobqueue.JobManagerThread$1.handleMessage(JobManagerThread.java:225) at com.birbit.android.jobqueue.messaging.PriorityMessageQueue.consume(PriorityMessageQueue.java:39) at com.birbit.android.jobqueue.JobManagerThread.run(JobManagerThread.java:220) at java.lang.Thread.run(Thread.java:818)

[Pent]

I wanted to know if they could give some information on how to use this action

There is some help text coming in the release version, but to query normal SQL select
the Raw mode.

and what benefits it has with respect to the traditional way.

If you mean 'traditional via shell', no sqlite3 binary is needed and the
formatting can make things easier for beginners.

And one more thing, this question can be a bit silly, but I have some doubt. Using this action, to make a query in a System Database, I also need to have access to the root?

No, (if Tasker has permissions for the DB and you use the URI Formatted mode) which is the other plus.

Pent

[Pent]

I'm getting SQLite related errors too, triggered by 3rd party plugin (autonotification)

Sorry, is that using the SQL Query action or just all the errors you could find in the log ?

If you have a problem with AutoNotification, please contact the developer.

Pent

[Abdullah Alahdal]

No, (if Tasker has permissions for the DB and you use the URI Formatted mode) which is the other plus.

Pent

Waiting for the help to know more about this :) 

[CoolRaoul]

 

If you have a problem with AutoNotification, please contact the developer.

I just did now.

My mistake was because access to this traceback was by acknowledging a notification apparently from Tasker with message "send to developer" (without more detail). I've initilally understood it was reffering to *Tasker* developer, not Autonotification.

[Pent]

With URI Formatted you can stick a URI in the source like content://com.android.contacts/group

Pent

[Raul SC]

Hello again, given the information you have indicated on SQL query, URI Formatted, I have created the following task:

Buscar Contactos SQL (29)
A1: SQL Query [ Modo:URI Formatted Archivo:content://com.android.contacts/data Table: Columns: Consulta: Selection Parameters: Order By: Output Column Divider: Matriz de Variables (array):%result ]
A2: Flash [ Texto:%result Largo:Apagado ]

And I get the following error;

13.31.45/E SQL Query: %result -> %result
13.31.45/E code 3: android.database.sqlite.SQLiteException: unknown error (code 0): Unable to convert BLOB to string.
13.31.45/E prefsException/SQL Query: unknown error (code 0): Unable to convert BLOB to string
13.31.45/ android.database.CursorWindow.nativeGetString(Native Method)
13.31.45/ android.database.CursorWindow.getString(CursorWindow.java:438)
13.31.45/ android.database.AbstractWindowedCursor.getString(AbstractWindowedCursor.java:51)
13.31.45/ android.database.CursorWrapper.getString(CursorWrapper.java:137)
13.31.45/ net.dinglisch.android.taskerm.ExecuteService.p(Unknown Source)
13.31.45/ net.dinglisch.android.taskerm.ExecuteService.a(Unknown Source)
13.31.45/E SQL Query [ Modo:URI Formatted Archivo:content://com.android.contacts/data Table: Columns: Consulta: Selection Parameters: Order By: Output Column Divider: Matriz de Variables (array): ]
13.31.45/E result: stop task (error)
13.31.45/Variables doreplresult: |%result| -> |%result|
13.31.45/E Error: 1
13.31.45/MacroEdit action finished exeID 2 action no 0 code 667 status: Err next 0

Using the same task, but putting in the text field of Formatted URI, the following:

content://com.android.contacts/group

The error is this:

13.36.27/E SQL Query: %result -> %result
13.36.27/E SQL Query: cursor exception: URI: content://com.android.contacts/group, calling user: net.dinglisch.android.taskerm, calling package:net.dinglisch.android.taskerm
13.36.27/E SQL Query: no cursor for null
13.36.27/E result: stop task (error)
13.36.27/Variables doreplresult: |%result| -> |%result|
13.36.27/E Error: 1
13.36.27/MacroEdit action finished exeID 1 action no 0 code 667 status: Err next 0

Surely this doing something wrong, and I need to fill some field, but I can not find more information. The action help icon has no content. Perhaps I would need an example of the most complete action to be able to make sure I am doing well. a greeting

[Pent]

13.31.45/E SQL Query: %result -> %result

13.31.45/E code 3: android.database.sqlite.SQLiteException: unknown error (code 0): Unable to convert BLOB to string.

Bug, not handling blob values in DB well, will fix.

Using the same task, but putting in the text field of Formatted URI, the following:

content://com.android.contacts/group

The error is this:

13.36.27/E SQL Query: %result -> %result
13.36.27/E SQL Query: cursor exception: URI: content://com.android.contacts/group, calling user: net.dinglisch.android.taskerm, calling package:net.dinglisch.android.taskerm
13.36.27/E SQL Query: no cursor for null

Sorry, URI should have groups, not group, on the end.

You don't need to fill in anything else except the output variable.

Pent

[Pent]

Think I maybe found the problem with the file actions, will update today or
tomorrow morning.

Pent

[Alex Buzin]

Using 'whrite file' or 'read file' or 'list file' crushs with error:
code 3: java.land
invalid URL//
content://com.android.provider.....
.../image%3a24592

Using Samsung n9005. 5.0

[Alex Buzin]

it's on 4.9b3 v.

[Abdullah Alahdal]

Fix is expected in coming 24 hours. 

[Pent]

b4 is up:

        <LI>beta: change: action SQL Query: handle INSERT/UPDATE in Raw mode
        <LI>beta: bugfix: action SQL Query: wasn't handing BLOBs and null values correctly
        <LI>beta: bugfix: attempted fix for file exceptions on some devices, more logging
        <LI>added: action Say To File: parameter Use Network

Pent

[Pent]

I pushed the download version of the userguide this time.

Pent

[Raul SC]

I just tried the latest version and for now the actions that were giving errors, work well.

The List Files action works perfectly and allows you to sort the directory without problems.

With the query SQL query, I get the value of the columns of a DB, and I can add columns separating them by "," (without quotes), and without needing access to the root as you told me, this opens many doors!

However, according to you comment, you have hung the user guide, but in the latter actions the information continues to be empty.

For this reason I can not figure out how to use the "selection" and "selection parameters" fields, which I suppose is to filter and discriminate information that does not interest the selected columns.

Well, in general a very complete update, with very interesting news ... You are the number 1, a greeting.

[Abdullah Alahdal]

        <LI>beta: change: action SQL Query: handle INSERT/UPDATE in Raw mode

I am still getting below error

14.18.40/Variables doreplresult: |Insert Into callsnotes (cid, note, notecompleted)

values (%cid, '%newnote', 0)| -> |Insert Into callsnotes (cid, note, notecompleted)

values (300, 'new test', 0)|
14.18.40/E SQL Query: %insert -> %insert
14.18.40/E dbFile: /storage/emulated/0/Tasker/DBs/Taskertables.sq|ite query: Insert Into callsnotes (cid, note, notecompleted)
values (300, 'new test', 0) needWrite: false
14.18.40/FileUtil need request doc access: /storage/emulated/0/Tasker/DBs/Taskertables.sq|ite
14.18.40/FileUtil bta: nrda: not using root
14.18.40/FileUtil bta: nrda: path not null
14.18.40/FileUtil needReqDocAccess: wudf: not external: /storage/emulated/0/Tasker/DBs/Taskertables.sq|ite
14.18.40/FileUtil need request: /storage/emulated/0/Tasker/DBs/Taskertables.sq|ite: false
14.18.40/E bta: checkSDPath: /storage/emulated/0/Tasker/DBs/Taskertables.sq|ite
14.18.40/FileUtil SQL Query/checkSDPath: wudf: not external: /storage/emulated/0/Tasker/DBs/Taskertables.sq|ite
14.18.40/E SQL Query: checkSDPath: /storage/emulated/0/Tasker/DBs/Taskertables.sq|ite useDocFile: false
14.18.40/E bta: exists: true
14.18.40/E bta: isFile: true
14.18.40/E bta: isDir: false
14.18.40/E SQL Query: checkSDPath: /storage/emulated/0/Tasker/DBs/Taskertables.sq|ite ok true
14.18.40/E code 3: android.database.sqlite.SQLiteReadOnlyDatabaseException: attempt to write a readonly database (code 8).
14.18.40/E prefsException/SQL Query: attempt to write a readonly database (code 8)
14.18.40/ android.database.sqlite.SQLiteConnection.nativeExecuteForCursorWindow(Native Method)
14.18.40/ android.database.sqlite.SQLiteConnection.executeForCursorWindow(SQLiteConnection.java:845)
14.18.40/ android.database.sqlite.SQLiteSession.executeForCursorWindow(SQLiteSession.java:836)
14.18.40/ android.database.sqlite.SQLiteQuery.fillWindow(SQLiteQuery.java:62)
14.18.40/ android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:143)
14.18.40/ android.database.sqlite.SQLiteCursor.getCount(SQLiteCursor.java:132)
14.18.40/E SQL Query [ Mode:Raw File:Tasker/DBs/Taskertables.sq|ite Table:callsnotes Columns:nid Query:Insert Into callsnotes (cid, note, notecompleted)
values (%cid, '%newnote', 0) Selection Parameters: Order By: Output Column Divider: Variable Array: ]
14.18.40/E result: stop task (error)
14.18.40/Variables doreplresult: |%insert| -> |%insert|
14.18.40/E Error: 1

14.18.40/MacroEdit action finished exeID 1 action no 16 code 667 status: Err next 16 

[Frédéric Szymañski]

B4 : The two previously non working tasks are now working :-)

[Pent]

        <LI>beta: change: action SQL Query: handle INSERT/UPDATE in

 

Raw mode

I am still getting below error

Very sorry, I made the classic error of adding a tiny bit of 'nothing can go wrong with that' code
after final testing, and a missing ! bit me.

Will push another one tomorrow morning.

Pent

[Pent]

However, according to you comment, you have hung the user guide, but in the latter actions the information continues to be empty.

I hope that is working now.
 

For this reason I can not figure out how to use the "selection" and "selection parameters" fields

selection is the WHERE phrase, selection args are the 'WhereArgs' for it:

whereClause

• the part you put after WHERE without that keyword, e.g. "column1 > 5"
• should include ? for things that are dynamic, e.g. "column1=?" -> see whereArgs

whereArgs

• specify the content that fills each ? in whereClause in the order they appear
  

Pent

[Luigi Nocco]

Bug:

I cannot see action text after every category.

[Abdullah Alahdal]

I cannot see action text after every category.

No issue here. My preference was light Theme. I also changed to Dark and no issue. 

[Luigi Nocco]

Il giorno giovedì 8 dicembre 2016 14:06:05 UTC+1, Abdullah Alahdal ha scritto:

I cannot see action text after every category.

No issue here. My preference was light Theme. I also changed to Dark and no issue. 

For me happens both with dark and light theme.
No problems with last stable version, for me this happens from beta version.

[Pent]

For me happens both with dark and light theme.
No problems with last stable version, for me this happens from beta version.

Could you try a reinstall please ?

If still broken, is it also with the particular events and states ?

Thanks,

Pent

[Luigi Nocco]

Could you try a reinstall please ?

If still broken, is it also with the particular events and states ?

Thanks,

Pent

Tried to uninstall, restart system, wipe dalvik cache e reinstall.

It happens for every event, state and action.

[Pent]

It happens for every event, state and action.

How about if you have English selected in Prefs / UI ?

Pent

[Luigi Nocco]

How about if you have English selected in Prefs / UI ?

Pent

It happens also for english language (I restarted tasker after language change).

[Frédéric Szymañski]

Beta 4 bugs :

List files
Match : *.apk
Lists all instead of only .apk files.

I also have problems with variable query : impossible to see what you write.

OnePlus One
Android N

[Pent]

Beta 4 bugs :

List files
Match : *.apk
Lists all instead of only .apk files.

Thanks, fixed for b5.
 

I also have problems with variable query : impossible to see what you write.

In what way ? Text is invisible ? Too small ? It's obscured by something ?
Phone is upside down ? :-)

Pent

[Pent]

Luigi, have you tried redownloading the APK ?

Pent

[Pent]

b5 is up:

        <LI>beta: bugfix: action SQL Query: INSERT/UPDATE DB was still read-only
        <LI>beta: bugfix: action List Files: Match parameter wasn't working for internal-storage files

Pent

[Frédéric Szymañski]

In what way ? Text is invisible ? Too small ? It's obscured by something ?
Phone is upside down ? :-)

Pent

There was no cursor visible and the text I entered wasn't neither visible while the variables were correctly recieved by Tasker.

 I fixed it after changing/changing back phone language!

[Luigi Nocco]

Luigi, have you tried redownloading the APK ?

Pent

It happens also for 4.9b5 version.

[Pent]

Luigi, have you tried redownloading the APK ?

Pent

It happens also for 4.9b5 version.

What's your device ? Android version ? Custom ROM ?

Are there any errors/warnings coming up if you enable
Menu / Prefs / Misc / Popup Errors/Warnings, try and
select an action then leave and enter Tasker ?

If you type an action name in the filter box at the bottom
does anything show then ?

Pent

[Luigi Nocco]

What's your device ? Android version ? Custom ROM ?

- My Device is HTC One M7, Android 5.1 Google Play Edition, Stock Rom,
- I have root and custom kernel. I haven't Xposed framework.

Are there any errors/warnings coming up if you enable Menu / Prefs / Misc / Popup Errors/Warnings, try and select an action then leave and enter Tasker ?

- Yes, there is an error. Error is: #Mirror: error: invokeAux: ignoring null method.
- Log is attached.

If you type an action name in the filter box at the bottom does anything show then ?

- Yes, i can show action with icon but without text

 
Please, remember that with last stable there aren't graphic rendering issue and invokeAux error isn't shown.

[Pent]

- Yes, there is an error. Error is: #Mirror: error: invokeAux: ignoring null method.

OK, I'll add some logging to try and identify the name of the method (not as easy
as it sounds).

Pent

[Luigi Nocco]

OK, I'll add some logging to try and identify the name of the method (not as easy

as it sounds).

Pent

Maybe this can help you.

[JB]

Exact issue. All EditText fields are readable along with task names under the task tab. The three previewed lines for both tasks related to the profile are readable (for anonymous tasks as well). Current variable values are readable but the variable names are not.

Samsung Note 4 Android 5.1.1 Modified stock rom / kernel. Root / Xposed. Checked to make sure no module effects theme.

Tried changing language and back again to English, light / dark theme, and pop up messages toggle. Issue persists thru every beta. I get the same auxMethod error.

[Luigi Nocco]

Feature suggestion/request:

Root support for sqlite.

[Abdullah Alahdal]

>         <LI>beta: bugfix: action SQL Query: INSERT/UPDATE DB was still read-only

18.36.29/Variables doreplresult: |Insert Into callsnotes (cid, note, notecompleted)

values (%cid, '%newnote', 0)| -> |Insert Into callsnotes (cid, note, notecompleted)

values (300, 'SQL Tasker', 0)|
18.36.29/E SQL Query: %insert -> %insert
18.36.29/E dbFile: /storage/emulated/0/Tasker/DBs/Taskertables.sq|ite query: Insert Into callsnotes (cid, note, notecompleted)
values (300, 'SQL Tasker', 0) needWrite: false
18.36.29/FileUtil needReqDocAccess: wudf: not external: /storage/emulated/0/Tasker/DBs/Taskertables.sq|ite
18.36.29/FileUtil nrda: need request: /storage/emulated/0/Tasker/DBs/Taskertables.sq|ite: false
18.36.29/E checkSDPath: /storage/emulated/0/Tasker/DBs/Taskertables.sq|ite
18.36.29/FileUtil SQL Query/checkSDPath: wudf: not external: /storage/emulated/0/Tasker/DBs/Taskertables.sq|ite
18.36.29/E SQL Query: checkSDPath: /storage/emulated/0/Tasker/DBs/Taskertables.sq|ite useDocFile: false
18.36.29/E SQL Query: checkSDPath: /storage/emulated/0/Tasker/DBs/Taskertables.sq|ite ok true
18.36.29/E code 3: android.database.sqlite.SQLiteReadOnlyDatabaseException: attempt to write a readonly database (code 8).
18.36.29/E prefsException/SQL Query: attempt to write a readonly database (code 8)
18.36.29/ android.database.sqlite.SQLiteConnection.nativeExecuteForCursorWindow(Native Method)
18.36.29/ android.database.sqlite.SQLiteConnection.executeForCursorWindow(SQLiteConnection.java:845)
18.36.29/ android.database.sqlite.SQLiteSession.executeForCursorWindow(SQLiteSession.java:836)
18.36.29/ android.database.sqlite.SQLiteQuery.fillWindow(SQLiteQuery.java:62)
18.36.29/ android.database.sqlite.SQLiteCursor.fillWindow(SQLiteCursor.java:143)
18.36.29/ android.database.sqlite.SQLiteCursor.getCount(SQLiteCursor.java:132)
18.36.29/E SQL Query [ Mode:Raw File:Tasker/DBs/Taskertables.sq|ite Table:callsnotes Columns:nid Query:Insert Into callsnotes (cid, note, notecompleted)

values (%cid, '%newnote', 0) Selection Parameters: Order By: Output Column Divider: Variable Array: ]

18.36.29/E result: stop task (error)
18.36.29/Variables doreplresult: |%insert| -> |%insert|
18.36.29/E Error: 1
18.36.29/MacroEdit action finished exeID 1 action no 16 code 667 status: Err next 16

[Pent]

On Friday, 9 December 2016 16:43:30 UTC+1, Abdullah Alahdal wrote:

>         <LI>beta: bugfix: action SQL Query: INSERT/UPDATE DB was still read-only

Grr, sorry, I tested this with your exact query before publishing, will have a look
again in the morning.

Pent

[Pent]

Exact issue. All EditText fields are readable along with task names under the task tab. The three previewed lines for both tasks related to the profile are readable (for anonymous tasks as well).  Current variable values are readable but the variable names are not.

Sorry, I don't understand. Please state clearly what you expect to the the case and what is
actually the case.

 

Samsung Note 4 Android 5.1.1 Modified stock rom / kernel. Root / Xposed. Checked to make sure no module effects theme.

Tried changing language and back again to English, light / dark theme, and pop up messages toggle. Issue persists thru every beta. I get the same auxMethod error.

And what is that error ?

Pent

[Raul SC]

A few weeks ago, I explained in this forum, what I had to do to have my app exported with Tasker, request the permission of "accessibility adjustments"

Now I have a similar doubt, but I can not solve it.

I have a project, which among other things, I have an event that reacts with incoming notifications, an action that creates a folder and a file in the Sdcard and an action will incorporate in this latest version, I launched a SQL query to DB Of the contacts.

All of this works perfectly in my Tasker project, but when I export it as an application, I can not get any of the actions mentioned.

To try to solve it I have taken into account what they told me, that I had to put the SDK version 17+ and add the permission Accesibility Setting.

In this case, I also add Read contacts and Write external storage, but nothing works.

I launch the query in this thread since some of the actions I use have been implemented in this version. I would appreciate some information. A greeting.

[Raul SC]

I just figured out a solution to the query I made.

The action of creating folder and file, had created it from shell, and apparently when creating it like this, when exported as apk, the WRITE_EXTERNAL_STORAGE permission is not added. The same is true when querying the contact DB from the SQL query action.

And apparently, you can not add those permissions as extras.

The solution has been as simple as adding a contact query action, and a create directory action, and when exported as apk, Tasker has been tasked with adding those permissions, and all actions already work.

With receiving notifications, continued testing, I have doubts if the app should faith leave in "access notifications" so I can not get it to appear there.

[JB]

Sorry. Probably easier to attach photos, should have responded originally not from mobile.

[Pent]

The action of creating folder and file, had created it from shell, and apparently when creating it like this, when exported as apk, the WRITE_EXTERNAL_STORAGE permission is not added.

No, Tasker cannot figure out what permissions you might need for everything you might do in a shell action.

And apparently, you can not add those permissions as extras.

Sure you can e.g. android.permission.WRITE_EXTERNAL_STORAGE.

Pent

[Pent]

@JB:

OK, Luigi higher up on the thread has similar symptoms and also the same errors, I
expect the solution will be the same. I'm also guessing you have a 5.1 device.

I will need a log from one or both of you after the next update today or tomorrow (Tasker 4.9b6)

http://tasker.dinglisch.net/userguide/en/faqs/faq-how.html#x2

Pent

[Pent]

On Friday, 9 December 2016 16:43:30 UTC+1, Abdullah Alahdal wrote:

>         <LI>beta: bugfix: action SQL Query: INSERT/UPDATE DB was still read-only

 
Could you double-check your Tasker version is b5 in Info / More / About/Credits ?

With the exact same query I have the write flag set.

Thanks,

Pent

[Pent]

Root support for sqlite.

I added it for next update, but I don't have a device to test on, let me know.

Also, you can't use root with the Formatted URI mode.

Pent

[Pent]

Sure you can e.g. android.permission.WRITE_EXTERNAL_STORAGE.

I've changed the next version so if the user enters for example WRITE_EXTERNAL_STORAGE,
Tasker will auto-complete it to android.permission.WRITE_EXTERNAL_STORAGE
to avoid this confusion.

Pent

[John Doe]

@JB and @Luigi Can you try to perform a long press on the items? Is the text visible?

[Luigi Nocco]

Il giorno sabato 10 dicembre 2016 14:09:05 UTC+1, John Doe ha scritto:

@JB and @Luigi Can you try to perform a long press on the items? Is the text visible?

Tried. Text isn't visible.

[Abdullah Alahdal]

> Could you double-check your Tasker version is b5 in Info / More / About/Credits ?
>
> With the exact same query I have the write flag set.

It is b5 😢

[JB]

My device is indeed (5.1.1). I enabled sd card logging. Howevera log has not been produced yet, even with pop up errors enabled. I will reply when one is generated.

[JB]

Long pressing does not make text visible. The default Holo blue highlight color just fills the clicked area.

[Pent]

My device is indeed (5.1.1). I enabled sd card logging. Howevera log has not been produced yet, even with pop up errors enabled. I will reply when one is generated.

Please wait for b6 to make the log, it won't help at the moment.

Thanks,

Pent

[Pent]

> With the exact same query I have the write flag set.

It is b5 😢

OK, have a theory for next update :-)

Pent

[Pent]

b6 is up:

        <LI>beta: added logging for identification of null reflection methods
        <LI>beta: bugfix: another attempt at fixing insert/update write flag
        <LI>beta: action SQL Query: added parameter Use Root (untested)
        <LI>change: app creation: abbreviated user-specified permissions become completed (e.g. WRITE_SETTINGS -> android.permission.WRITE_SETTINGS)

Pent