ProjeQtOr free project management software - [SOLVED] Error : There is no active transaction #2 - ProjeQtOr
 

[SOLVED] Error : There is no active transaction #2

More
19 Mar 2020 15:15 #1 by antoine1003
Hi,
I am corrently doing an extension to improve the import feature. as my class is prety long I made a gist if you want to see my class : here . I go the following error when I try to import a file :
2020-03-17 10:58:42.046 ***** ERROR ***** [V8.3.2] on file 'C:\wamp64\www\ipmp_new\model\persistence\Sql.php' at line (197)
2020-03-17 10:58:42.049 ***** ERROR ***** [V8.3.2] cause = There is no active transaction
2020-03-17 10:58:42.053 ***** ERROR ***** [V8.3.2]    => #0 C:\wamp64\www\ipmp_new\model\persistence\Sql.php (197) -> commit()
2020-03-17 10:58:42.055 ***** ERROR ***** [V8.3.2]    => #1 C:\wamp64\www\ipmp_new\model\custom\Importable.php (429) -> commitTransaction()
2020-03-17 10:58:42.058 ***** ERROR ***** [V8.3.2]    => #2 C:\wamp64\www\ipmp_new\model\custom\Importable.php (686) -> buildTable()
2020-03-17 10:58:42.060 ***** ERROR ***** [V8.3.2]    => #3 C:\wamp64\www\ipmp_new\tool\import.php (139) -> import()

I already looked on this forum an saw an answer saying : "Ticket #816 recorded" which doesn't really help.
Do you have any idea?
Thanks,
Antoine

Please Connexion or Create an account to join the conversation.

More
19 Mar 2020 19:45 #2 by babynus
You have a Sql::commit() but you're not in a transaction.
Ever you need to add Sql::beginTransaction() or commit() is already done.

Babynus
Administrator of ProjeQtOr web site

Please Connexion or Create an account to join the conversation.

More
20 Mar 2020 09:40 #3 by antoine1003
resolved by adding Sql::beginTransaction(); before Sql::commitTransaction(); :
Sql::beginTransaction();
                Sql::commitTransaction();

Thanks

Please Connexion or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.024 seconds