SQLite/AUStripper question

[BatMan22]

So Austripper doesn't run on my script because I'm using the SQLite library in my program.. Did I do something wrong as far as SQLite install or is that just normal and should I stop using Austripper for my program? I included console output below. 

 

Thanks guys

 

expandcollapse popup

>"C:\Program Files (x86)\AutoIt3\SciTE\..\AutoIt3.exe" "C:\Program Files (x86)\AutoIt3\SciTE\AutoIt3Wrapper\AutoIt3Wrapper.au3" /ShowGui /prod /in "C:\Users\Ash\Documents\SampleDueSheetExports\SampleDueLoader.au3"
+>20:16:13 Starting AutoIt3Wrapper v.18.708.1148.0 SciTE v.4.1.0.0   Keyboard:00000409  OS:WIN_7/Service Pack 1  CPU:X64 OS:X64  Environment(Language:0409)  CodePage:0  utf8.auto.check:4
+>         SciTEDir => C:\Program Files (x86)\AutoIt3\SciTE   UserDir => C:\Users\Ash\AppData\Local\AutoIt v3\SciTE\AutoIt3Wrapper   SCITE_USERHOME => C:\Users\Ash\AppData\Local\AutoIt v3\SciTE 
-> No changes made..
>Running Tidy (18.708.1148.0)  from:C:\Program Files (x86)\AutoIt3\SciTE\tidy
+>20:16:15 Tidy ended.rc:0
>Running AU3Check (3.3.14.5)  from:C:\Program Files (x86)\AutoIt3  input:C:\Users\Ash\Documents\SampleDueSheetExports\SampleDueLoader.au3
+>20:16:16 AU3Check ended.rc:0
>Running Au3Stripper (18.708.1148.0)  from:C:\Program Files (x86)\AutoIt3\SciTE\Au3Stripper cmdline:
-### StripOnly/StripFunc Error: Found Call() statement using unsolvable Func, which will/could lead to removal of Funcs that are used by this Function.
>### current Func: _sqlite_gettable2d
c:\program files (x86)\autoit3\include\sqlite.au3(609,1): Warning for line:$iCbRval = Call($sCallBack, $aDataRow) 

-### StripOnly/StripFunc Error: Found Call() statement using unsolvable Func, which will/could lead to removal of Funcs that are used by this Function.
>### current Func: _sqlite_gettable2d
c:\program files (x86)\autoit3\include\sqlite.au3(625,1): Warning for line:$iCbRval = Call($sCallBack, $aDataRow) 

-=============================================================================================================
-#### Au3Stripper Found   2 Error(s)!!!!    This means your script could have problems running properly.  ####
-=============================================================================================================
- 3.88 Iteration 1 Strip Functions result: Output  11663 lines, stripped 18763 Func lines and 20619 Commentlines
- 12.06 Iteration 2 Strip Variables result: Output  5189 lines and stripped 6474 lines
- 13.22 Iteration 3 Strip Variables result: Output  4957 lines and stripped 232 lines
- 14.28 Iteration 4 Strip Variables result: Output  4944 lines and stripped 13 lines
- 15.38 Iteration 5 Strip Variables result: Output  4943 lines and stripped 1 lines
+> Source    52243 lines 2419455 Characters.
+> Stripped  25483 Func/Var lines and  20619 comment lines, Total 2197051 Characters.
+> Saved     88% lines 90% Characters.
+> Au3Stripper v18.708.1148.0 finished created:C:\Users\Ash\Documents\SampleDueSheetExports\SampleDueLoader_stripped.au3
!>20:16:31 ---------------------------------------------------------------
!>20:16:31 Au3Stripper ended with errors, using original scriptfile.rc:2
!>20:16:31 ---------------------------------------------------------------
>Running AU3Check (3.3.14.5)  from:C:\Program Files (x86)\AutoIt3  input:C:\Users\Ash\Documents\SampleDueSheetExports\SampleDueLoader.au3
+>20:16:32 AU3Check ended.rc:0
>Running:(3.3.14.5):C:\Program Files (x86)\AutoIt3\aut2exe\aut2exe.exe  /in "C:\Users\Ash\Documents\SampleDueSheetExports\SampleDueLoader.au3" /out "C:\Users\Ash\AppData\Local\AutoIt v3\Aut2exe\~AUA23.tmp.exe" /nopack /icon "Crome Icons\Google Black.ico" /comp 2
+>20:16:33 Aut2exe.exe ended.C:\Users\Ash\AppData\Local\AutoIt v3\Aut2exe\~AUA23.tmp.exe. rc:0
>20:16:33 Performing the Program Resource Update steps:
...>Updating Program Version information.
...>Setting Program ExecutionLevel Manifest information to requireAdministrator
...>Setting Program Compatibility Manifest information to Windows10
...>Updating Program Manifest information.
>20:16:34 Program Resource updating finished successfully.
+>20:16:34 Created program:C:\Users\Ash\Documents\SampleDueSheetExports\SampleDueLoader.exe
-Updated the Source Version to:0.0.0.252
+>20:16:34 AutoIt3Wrapper Finished.
>Exit code: 0    Time: 21.43

 

[BatMan22]

Bump.. So I guess no one else likes my issue either huh >.<

[mLipok]

I like, but I'm little busy and far away from my office PC so you must just wait.

Btw.

Which option for Au3stripper you are using ?

 

Edited September 4, 2018 by mLipok
Typo

[BatMan22]

  On 9/4/2018 at 8:32 PM, mLipok said:

I like, but I'm little busy and far away from my office PC so you must just wait.

Btw.

Which option fir Au3stripper you are using ?

 

Expand  

Sorry that wasn't aimed towards you, or anyone specifically. Also no special options are checked off, just checked the box for it in SciTE 4.1 compiler

[mLipok]

  On 9/4/2018 at 8:43 PM, BatMan22 said:

just checked the box for it in SciTE 4.1 compiler

Expand  

?

[BatMan22]

  On 9/4/2018 at 8:46 PM, mLipok said:

?

Expand  

I attached the screen that I'm referring to.

[BrewManNH]

Use the #Au3Stripper_Ignore_Funcs directive to keep AU3Stripper from removing those functions.

  Quote

#Au3Stripper_Ignore_Funcs=     Do not Strip these functions. FuncNames may end with an * to indicated matching FuncNames starting with the specified string.

Expand  

If those functions aren't being used in your script, just ignore the warnings.

[BatMan22]

  On 9/4/2018 at 9:00 PM, BrewManNH said:

Use the #Au3Stripper_Ignore_Funcs directive to keep AU3Stripper from removing those functions.

If those functions aren't being used in your script, just ignore the warnings.

Expand  

So I saw that, and I can do that, but I didn't know if I was the only one experiencing this issue or if other people are experiencing it too. Sqlite isn't used that rarely is it? Does no on else attempt to use au3stripper that uses SQLite? I don't think I initially explained the problem very well.. the errors aren't actually part of my program, they are in the SQLite.au3 library/udf/whatever it's called.

Edited September 4, 2018 by BatMan22

[BrewManNH]

It's not just SQLite, it's any script that uses a variable to call a function.

[BatMan22]

  On 9/4/2018 at 9:15 PM, BrewManNH said:

It's not just SQLite, it's any script that uses a variable to call a function.

Expand  

Ah ok. I'll try and figure out how to just ignore it using that function thing.

[BatMan22]

  On 9/4/2018 at 9:00 PM, BrewManNH said:

Use the #Au3Stripper_Ignore_Funcs directive to keep AU3Stripper from removing those functions.

If those functions aren't being used in your script, just ignore the warnings.

Expand  

Ok so I added #Au3Stripper_Ignore_Funcs _sqlite_gettable2d to both the SQLite.au3 file and my own file, and still the error doesn't change.. What am I doing wrong?

[BrewManNH]

It doesn't affect the warning message, it prevents the function from being stripped.

And you're putting the wrong function name in there. The callback function is the one you need to have AU3Stripper ignore, not the function that calls it.

[BatMan22]

  On 9/4/2018 at 9:45 PM, BrewManNH said:

It doesn't affect the warning message, it prevents the function from being stripped.

And you're putting the wrong function name in there. The callback function is the one you need to have AU3Stripper ignore, not the function that calls it.

Expand  

You rock, you're right, I needed to ignore a different function, now it strips and compiles just fine. That being said, it seemed to get rid of the warning for me too.. so I don't know why that is, but it's working now. Thanks a mil

[Trax]

@BatMan22 I am fighting the same problem but can't figure out what the silver bullet is. What exactly did you do to what UDFs to get rid of the errors?