Skip to forum content

LuxCal Web Calendar

The place for news, questions and suggestions

You are not logged in. Please login or register.

Post new reply

Post new reply

Compose and post your new reply

You may use: BBCode Images Smilies

All fields with bold label must be completed before the form is submitted.

Required information for guests


Required information

Topic review (newest first)

8 Post by Roel

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

7 Post by JanC

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?

6 Post by Mawell

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.

5 Post by pab49162

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.

4 Post by pab49162

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.

3 Post by Roel

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

2 Post by pab49162

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

1 Post by Maxwell

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!