1 Topic by Maxwell

  • Maxwell
  • Guest

Topic: SQL Error after update to 5.2.0

I use Luxcal more than 3 Years with more then one Versions! Thanks for this great Software.

But now, after upgrade to 5.2.0, i have an SQL error.

The following text is from my SQL log:

mycal:ERROR Script: upgrade520.php - SQL transaction error: There is no active transaction
Query: commit transaction

Any ideas?

Thanks for helping!

Quote Post 1

  • Registered: 2022-03-23
  • Posts: 3

Re: SQL Error after update to 5.2.0

Hi,

I just tried to upgrade from 5.1.1 to 5.20 and received the identical error in my logs/sql.log file.

I will dig around and see if I can find any more details as to what is causing the problem.

Paul

Quote Post 2

  • Roel
  • Roel
  • Administrator
  • Offline
  • Registered: 2018-02-26
  • Posts: 565

Re: SQL Error after update to 5.2.0

Hi there,

Have you applied the fix which you can find in this forum under Known Issues and Fixes (the last one)?

https://www.luxsoft.eu/lcforum/viewtopi … 1575#p1575

Roel

Quote Post 3

4 Reply by pab49162 (edited by pab49162 2022-03-23 18:48:49)

  • Registered: 2022-03-23
  • Posts: 3

Re: SQL Error after update to 5.2.0

I dug around a bit and figured out the error was being generated at the dbTransaction('commit') statement at the end of the function upgradeDb().

I took a quick look at the SQL commands that were queued up prior to the "commit" and didn't see anything obvious.  I also compared the code for this function between 5.20 and the 5.1.1 but didn't see anything here either.

As far as the suggestion to try the fix under Known Issues and Fixes, no, I didn't try it.  I read that post earlier and didn't think it applied since it was fixing an invalid datatime format error related to a SQL query.

I will give it a try later today and post the results.  Thanks for the suggestion.

Quote Post 4

  • Registered: 2022-03-23
  • Posts: 3

Re: SQL Error after update to 5.2.0

Roel wrote:

Have you applied the fix which you can find in this forum under Known Issues and Fixes (the last one)?Roel

I just tried the fix and unfortunately, no difference.  I am still seeing the same SQL transaction error: There is no active transaction message when I try to do the upgrade.

Quote Post 5

6 Reply by Mawell

  • Mawell
  • Guest

Re: SQL Error after update to 5.2.0

Roel wrote:

Hi there,

Have you applied the fix which you can find in this forum under Known Issues and Fixes (the last one)?

Roel

Hi Roel!

Yes, I had already tried this before I started the thread. Unfortunately without success.

Quote Post 6

7 Reply by JanC (edited by JanC 2022-04-11 22:37:40)

  • JanC
  • New member
  • Offline
  • Registered: 2022-04-11
  • Posts: 8

Re: SQL Error after update to 5.2.0

Hey,
I'm having the same issue although I am updating from version 2.7.3 to 5.20. (I know it's  very old version smile )


I'm using PHP 8.1.4 on macOS

I also tried updating from 2.7.3 to 5.11 but I get the same error

update:
What worked for me is commenting out the line upgradeDb function in the toolboxx.php

dbTransaction('commit'); //do it!

which is strange thought as it would suggest that the autocommit is enabled by default?

Quote Post 7

  • Roel
  • Roel
  • Administrator
  • Offline
  • Registered: 2018-02-26
  • Posts: 565

Re: SQL Error after update to 5.2.0

Hi there,

I was able to reproduce this problem and believe it's occurring when the MySQL database has as default set AUTOCOMMIT = 1.
The solution for this problem can be found under the topic Known Issues and Fixes.

Roel

Quote Post 8