Announcement

shotgun

Member

Registered: 2020-04-30

Posts: 39

cron error

I'm running cron to clean up the chats but am getting an error in the db handler.

It reads
Starting chat/workflow
Closed chats - 3
Purged chats - 6
PHP Fatal error:  Uncaught ezcDbTransactionException: There was a transaction error caused by unmatched beginTransaction()/commit() calls: rollback() called without previous beginTransaction(). in /public_html/lhc/ezcomponents/Database/src/handler.php:214
Stack trace:
#0 /public_html/lhc/modules/lhcron/workflow.php(71): ezcDbHandler->rollback()
#1 /public_html/lhc/cron.php(102): include_once('/home/domain/...')
#2 {main}
  thrown in /public_html/livehelp/ezcomponents/Database/src/handler.php on line 214

Fatal error: Uncaught ezcDbTransactionException: There was a transaction error caused by unmatched beginTransaction()/commit() calls: rollback() called without previous beginTransaction(). in /public_html/livehelp/ezcomponents/Database/src/handler.php:214
Stack trace:
#0 /public_html/lhc/modules/lhcron/workflow.php(71): ezcDbHandler->rollback()
#1 /public_html/lhc/cron.php(102): include_once('/home/domain/...')
#2 {main}
  thrown in /public_html/lhc/ezcomponents/Database/src/handler.php on line 214

Thanks for looking

Last edited by shotgun (2020-05-11 01:51:22)

remdex

Administrator

From: Lithuania

Registered: 2012-09-23

Posts: 3,661

Website

Re: cron error

You can update workflow.php file now, but it looks you have some other error there...

shotgun

Member

Registered: 2020-04-30

Posts: 39

Re: cron error

Correct there is still errors,

Uncaught ezcPersistentDefinitionNotFoundException
Searched for '/erlhcoreclassmodelchat.php'. in /public_html/lhc/ezcomponents/PersistentObject/src/managers/code_manager.php

etc etc

Not sure, path seemed to work,  that was all my input was, thanks

is site_admin correct or a variable for credentials?   cron.php -s site_admin -c cron/workflow

remdex

Administrator

From: Lithuania

Registered: 2012-09-23

Posts: 3,661

Website

Re: cron error

Something for sure not right with your installation. Or execution path. You should execute from folder where index.php is located.

shotgun

Member

Registered: 2020-04-30

Posts: 39

Re: cron error

Its in the same dir. The directory structure is default, in a dir "public_html/livehelp"

Probably the path, I added path to existing.

shotgun

Member

Registered: 2020-04-30

Posts: 39

Re: cron error

Still not sure what it is. I had my hosting company look into it, they made sure the shell script in correct spot and running but, they didn't understand the error the shell script was producing. I stopped it and am writing a quick query to set the db when I need it.

In case your curious, Hostpapa's reply after looking into it was.

"I have re-added the script under your account but once I executed that, it seems that there are syntax errors:

script.sh: line 3: syntax error near unexpected token `if'
script.sh: line 3: `if [ ! -f $fileCron ];    '

With that in mind, please check the scripts in question or contact the developer for the same so he can correct it.

Once done, let us know here and we will add the new one under the account.

Thank you for your understanding.
  Hostpapa Support "

Thanks

remdex

Administrator

From: Lithuania

Registered: 2012-09-23

Posts: 3,661

Website

Re: cron error

I really have nothing to correct...

shotgun

Member

Registered: 2020-04-30

Posts: 39

Re: cron error

Yup probably my setup. My query's working, I just wanted to point it out, thanks again.