Jump to content

Recommended Posts

Hi all.

I wrote a script using plugin EzMySql.
The script sometimes runs all day and sometimes several hours. If it stops working, it ends with error -1073741818.

The error shows the Scite editor. If the program is compiled to exe it doesn't show any error but just closes.

The script shows the data from the SQL database in the window.

How to deal with this ?

Edited by Zmylna
Link to post
Share on other sites
  • Developers

Have you tried to check what that error means for the  COM-OBJECT you use?
Have you added an COM-OBJECT error handler and tried to show more information about the error?

Jos

SciTE4AutoIt3 Full installer Download page   - Beta files       Read before posting     How to post scriptsource   Forum etiquette  Forum Rules 
 
Live for the present,
Dream of the future,
Learn from the past.
  :)

Link to post
Share on other sites
  • Developers

mmm ... so you post a 1500 lines script and want me to wade through it trying to figure out what you are doing? ;) 

... and that code doesn't contain the functions for EzMySql which I assume are located in file: #include "EzMySql.au3".
So: What steps do you do to cause the crash and please share the include file.

Jos

SciTE4AutoIt3 Full installer Download page   - Beta files       Read before posting     How to post scriptsource   Forum etiquette  Forum Rules 
 
Live for the present,
Dream of the future,
Learn from the past.
  :)

Link to post
Share on other sites

Your error message translated to hex stands for (according to the [MS-ERREF].pdf):

0xC0000006 STATUS_IN_PAGE_ERROR
The instruction at 0x%08lx referenced memory at 0x%08lx. The required data was not placed into memory because of an I/O error status of 0x%08lx.

http://www.wiki-errors.com/wiki-errors.php?wiki=C0000006

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2021-06-05 - Version 1.5.4.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2021-06-14 - Version 1.6.5.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Link to post
Share on other sites
4 minutes ago, Jos said:

mmm ... so you post a 1500 lines script and want me to wade through it trying to figure out what you are doing? ;) 

... and that code doesn't contain the functions for EzMySql which I assume are located in file: #include "EzMySql.au3".
So: What steps do you do to cause the crash and please share the include file.

Jos

haha

You are the master, what is 1500 lines of code for you ;)

In my code i using _EzMySql_GetTable2d and _EzMySql_Exec functions with Error handling.

I don't do anything after which the program would crash. The ListView refreshes every minute showing data from SQL.

Include attached.

 

EzMySql.au3

Link to post
Share on other sites
5 minutes ago, water said:

Your error message translated to hex stands for (according to the [MS-ERREF].pdf):

0xC0000006 STATUS_IN_PAGE_ERROR
The instruction at 0x%08lx referenced memory at 0x%08lx. The required data was not placed into memory because of an I/O error status of 0x%08lx.

http://www.wiki-errors.com/wiki-errors.php?wiki=C0000006

ok, what exactly does this mean for me?
How to understand ?
Did I do something wrong or Autoit bug ?

Link to post
Share on other sites

Did you read the wiki I linked you to?

Quote

There can be many events which may have resulted in the system files errors.

I fear it is up to you to find the cause of the error.

My UDFs and Tutorials:

Spoiler

UDFs:
Active Directory (NEW 2021-06-05 - Version 1.5.4.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX (NEW 2021-06-14 - Version 1.6.5.0) - Download - General Help & Support - Example Scripts - Wiki
OutlookEX_GUI (2021-04-13 - Version 1.4.0.0) - Download
Outlook Tools (2019-07-22 - Version 0.6.0.0) - Download - General Help & Support - Wiki
ExcelChart (2017-07-21 - Version 0.4.0.1) - Download - General Help & Support - Example Scripts
PowerPoint (2017-06-06 - Version 0.0.5.0) - Download - General Help & Support
Excel - Example Scripts - Wiki
Word - Wiki
Task Scheduler (2019-12-03 - Version 1.5.1.0) - Download - General Help & Support - Wiki

Tutorials:
ADO - Wiki, WebDriver - Wiki

 

Link to post
Share on other sites
12 minutes ago, water said:

Did you read the wiki I linked you to?

I fear it is up to you to find the cause of the error.

Unfortunelly i can't. Eset blocks the site.

"Potentially unwanted content found.
This website is on the list of sites with uncertain reputation or potentially unwanted content and has been blocked."

Link to post
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
  • Recently Browsing   0 members

    No registered users viewing this page.

×
×
  • Create New...