Recent

Author Topic: mariadb issue : required 5.7, got 10.2.1  (Read 2735 times)

jshand2010

  • Full Member
  • ***
  • Posts: 236
mariadb issue : required 5.7, got 10.2.1
« on: December 13, 2017, 11:45:46 pm »
I'm a bit lost on how to progress from here.  not too sure which devel package needs to be installed to develop apps for mysql. 
OpenSUSE Tumbleweed x86_64, Lazarus 2.2.0RC2 fixes branch, fpc 3.2.3 fixes branch

taazz

  • Hero Member
  • *****
  • Posts: 5368
Re: mariadb issue : required 5.7, got 10.2.1
« Reply #1 on: December 14, 2017, 02:33:24 am »
its not about development packages the error clearly says that your Mysqlcleint dll/so is version 10.2.1 and since mysql is notorious at breaking backwards compatibility on every client version you have to install a version 5 dll/so, write your own MysqlConnection that accepts the newer version, or simply report the problem on the bug tracker and hope that in the next version they will address the problem.

Personally I would drop mysql and go with a more professional database like firebird or postgresql or even MSSQL/access.
Good judgement is the result of experience … Experience is the result of bad judgement.

OS : Windows 7 64 bit
Laz: Lazarus 1.4.4 FPC 2.6.4 i386-win32-win32/win64

Thaddy

  • Hero Member
  • *****
  • Posts: 14214
  • Probably until I exterminate Putin.
Re: mariadb issue : required 5.7, got 10.2.1
« Reply #2 on: December 14, 2017, 09:02:08 am »
Isn't it 5.6 that contains an alias for MariaDb?

Edit: yes, mdb 10 for 5.6 and 10.1 for 5.7. 10.2.1 is still missing in mysqlconn.inc trunk
You could file a bug report as missing functionality.

If you need it NOW, simply change 10.1 to 10.2 in mysqlconn.inc and recompile the package.
« Last Edit: December 14, 2017, 09:20:15 am by Thaddy »
Specialize a type, not a var.

jshand2010

  • Full Member
  • ***
  • Posts: 236
Re: mariadb issue : required 5.7, got 10.2.1
« Reply #3 on: December 15, 2017, 01:14:27 am »
thanks for your helps.  i'm now having a problem where my code is technically correct, but is now stating transaction not set.
OpenSUSE Tumbleweed x86_64, Lazarus 2.2.0RC2 fixes branch, fpc 3.2.3 fixes branch

Thaddy

  • Hero Member
  • *****
  • Posts: 14214
  • Probably until I exterminate Putin.
Re: mariadb issue : required 5.7, got 10.2.1
« Reply #4 on: December 15, 2017, 10:02:03 am »
Please file a bug report on Mantis (FPC). Category should be Database, not database components.
The components are OK, maybe a newer one should be added that is MariaDb specific (mostly copy paste affair), it is the FPC package that is lacking new functionality for 10.2.1
« Last Edit: December 15, 2017, 10:04:28 am by Thaddy »
Specialize a type, not a var.

Thaddy

  • Hero Member
  • *****
  • Posts: 14214
  • Probably until I exterminate Putin.
Re: mariadb issue : required 5.7, got 10.2.1
« Reply #5 on: December 15, 2017, 10:59:30 am »
I added the missing information to your bug report....
Specialize a type, not a var.

 

TinyPortal © 2005-2018