View Issue Details

IDProjectCategoryView StatusLast Update
0036085FPCPackagespublic2019-09-19 11:09
ReporterPascal RiekenbergAssigned ToMichael Van Canneyt 
PrioritynormalSeverityminorReproducibilityhave not tried
Status closedResolutionfixed 
Platformi386OSWindows 10 x64OS Version1809
Product Version3.3.1Product Build43029 
Target VersionFixed in Version3.3.1 
Summary0036085: [fcl-db] Access Violation with MySQL after recent changes
DescriptionWhen setting TSQLQuery.Active to true an access violation occurs.

Same code ran in the beginning of september.
Steps To Reproduce  fTransaction := TSQLTransaction.Create(Application);
  fDatabase := TMySQL57Connection.Create(Application);
  with fDatabase do begin
    HostName := cKISHostName;
    DatabaseName := cKISDB;
    UserName := cKISUser;
    Password := cKISPassword;
    Transaction := fTransaction;
    Connected := true;
  end;

  fQueryUser := TSQLQuery.Create(Application);
  with fQueryUser do begin
    DataBase := fDatabase;
    Transaction := fTransaction;
    ReadOnly := true;
    SQL.Text := 'SELECT * FROM table';
    Active := fDatabase.Connected;
  end;
Additional InformationAn unhandled exception occurred at $0000000100089830:
AccessViolation: Access violation
 $0000000100089830 INTERNALOPEN, line 3106 of fcl-db/src/sqldb/sqldb.pp
 $0000000100063B81 DOINTERNALOPEN, line 410 of fcl-db/src/base/dataset.inc
 $0000000100064C68 OPENCURSOR, line 958 of fcl-db/src/base/dataset.inc
 $00000001000651E4 SETACTIVE, line 1093 of fcl-db/src/base/dataset.inc
 $0000000100047A20 QUERYKISCONFIG, line 295 of susMakeProg.pas
 $000000010004CE73 RUN, line 1663 of susMakeProg.pas
 $0000000100001B93 main, line 41 of susMake.lpr
 $0000000100001BC6 main, line 49 of susMake.lpr
 $0000000100019387 EXE_ENTRY, line 240 of system.pp
 $00000001000019C6 _FPC_MAINCRTSTARTUP, line 106 of sysinit.pp
 $00007FFAF93E7BD4
 $00007FFAFB24CEE1
TagsNo tags attached.
Fixed in Revision43033.
FPCOldBugId
FPCTarget4.0.0
Attached Files

Activities

Michael Van Canneyt

2019-09-19 09:32

administrator   ~0118113

Fixed. Please test and close if OK.

Pascal Riekenberg

2019-09-19 11:09

reporter   ~0118116

Fixed. Thanks!

Issue History

Date Modified Username Field Change
2019-09-18 22:40 Pascal Riekenberg New Issue
2019-09-19 07:00 LacaK Assigned To => Michael Van Canneyt
2019-09-19 07:00 LacaK Status new => assigned
2019-09-19 09:32 Michael Van Canneyt Status assigned => resolved
2019-09-19 09:32 Michael Van Canneyt Resolution open => fixed
2019-09-19 09:32 Michael Van Canneyt Fixed in Version => 3.3.1
2019-09-19 09:32 Michael Van Canneyt Fixed in Revision => 43033.
2019-09-19 09:32 Michael Van Canneyt FPCTarget => 4.0.0
2019-09-19 09:32 Michael Van Canneyt Note Added: 0118113
2019-09-19 11:09 Pascal Riekenberg Status resolved => closed
2019-09-19 11:09 Pascal Riekenberg Note Added: 0118116