MDHMatt

any news on this? would happily test for you

Managed to fix. Uninstalled the ordering module and reinstalled. Word of warming though, this will remove ALL order forms! Prices for services are unaffected.

Just updated to the latest blesta and now clients can't order services they get the following error message Something went wrong. SQLSTATE[42S22]: Column not found: 1054 Unknown column 'order_form_groups.order' in 'order clause' on line 196 in /home/mdhostin/public_html/billing/vendors/minphp/db/src/PdoConnection.php Printing Stack Trace: #0 /home/mdhostin/public_html/billing/vendors/minphp/db/src/PdoConnection.php(196): PDOStatement->execute(Array) #1 /home/mdhostin/public_html/billing/vendors/minphp/record/src/Record.php(785): Minphp\Db\PdoConnection->query('SELECT `order_f...', Array) #2 /home/mdhostin/public_html/billing/plugins/order/models/order_forms.php(574): Minphp\Record\Record->fetchAll() #3 /home/mdhostin/public_html/billing/plugins/order/models/order_forms.php(195): OrderForms->getGroups('1', Array) #4 /home/mdhostin/public_html/billing/plugins/order/order_form_controller.php(60): OrderForms->get('1', Array) #5 /home/mdhostin/public_html/billing/plugins/order/controllers/main.php(18): OrderFormController->preAction() #6 /home/mdhostin/public_html/billing/vendors/minphp/bridge/src/Lib/Dispatcher.php(133): Main->preAction() #7 /home/mdhostin/public_html/billing/index.php(21): Dispatcher::dispatch('/billing/order/') #8 {main}

** solved uploaded patch not full ** Just tried to update blesta and i getting this error. I cant login or anything!!! please help! My updates are valid until next year, system running php 7, php 7 hotfix applied Uncaught Error, code 0 in /home/mdhostin/public_html/billing/app/app_controller.php on line 0 Message: Call to a member function listener() on null

@Paul @timnboys so i just tried switching from php 7.1 down to php 7 and it worked without a hitch! any tests i can do to test my php7.1 install

@Paul @timnboys so ive tried sending an invoice today and im still getting the same error. its failing when trying to send the invoices, i have a feeling that its something to do with where its saving the temp file. I have the blesta temp dir set to /home/username/billing/tmp and is fully writable but it seems to be failing and trying to write to the system /tmp which looking at the docs is what its meant to do. The invoice is created fine its just struggling to send them???

Must have been legacy from me moving servers. Yeah im not deleting anything without backups first. I will keep an eye on it incase it happens again

Nope its on my own dedicated system with cpanel licence. Ive just been playing about with phpmyadmin looking for instances of the invoice for the named details above. Turns out the cron job is trying to send a invoice that id set not to send and was closed off ages ago. Looking in the database the invoice sent date was Null, modified it to the day after generated and cleared the cron logs. re ran cron and all is clear? Should invoices sent to do not send be tying to send?? @Paul is there a way to clear the cron logs database after x time? mine had got over 30mb and over 1000 pages! surely cron logs from 6 month ago are not relevent anymore

Ive not changed the email templates they are the stock installs. Ive had issues since upgrading to 4.2.2 and php 7.1 Ive watched the logs and it dosen't show any errors when running which is making me assume its sent them. I see no errors in the mail logs either. I did clear out the cron logs in the database and forced a cron run and got this; Attempting to run all tasks for MDHosting. Attempting to apply credits to open invoices. There are no invoices to which credits may be applied. The apply credits task has completed. Attempting to deliver invoices scheduled for delivery. Error: tempnam(): file created in the system's temporary directory #0 [internal function]: UnknownException::setErrorHandler(8, 'tempnam(): file...', '/home/****/...', 179, Array) #1 /home/*/*/billing/vendors/monolog/monolog/src/Monolog/ErrorHandler.php(164): call_user_func(Array, 8, 'tempnam(): file...', '/home/*****/...', 179, Array) #2 [internal function]: Monolog\ErrorHandler->handleError(8, 'tempnam(): file...', '/home/*/...', 179, Array) #3 /home/*/*/billing/vendors/h2o/h2o/loaders.php(179): tempnam('18188455885ad5e...', '') #4 /home/*/*/billing/vendors/h2o/h2o/loaders.php(166): H2o_File_Cache->__construct(Array) #5 /home/*/*/billing/vendors/h2o/h2o/loaders.php(38): h2o_cache(Array) #6 /home/*/*/billing/vendors/h2o/h2o/loaders.php(33): H2o_File_Loader->setOptions(Array) #7 /home/***/*/billing/vendors/h2o/h2o.php(75): H2o_File_Loader->__construct(Array, Array) #8 /home/*/*/billing/app/models/emails.php(902): H2o->__construct() #9 /home/*/*/billing/app/models/emails.php(567): Emails->buildEmail('invoice_deliver...', '1', 'en_uk', Array) #10 /home/*/*/billing/components/invoice_delivery/invoice_delivery.php(162): Emails->send('invoice_deliver...', '1', 'en_uk', 'karenharrison12...', Array, NULL, NULL, Array, Array) #11 /home/****/*/billing/app/controllers/cron.php(1649): InvoiceDelivery->deliverInvoices(Array, 'email', 'karenharrison12...', NULL, Array) #12 /home/*****/*/billing/app/controllers/cron.php(1420): Cron->sendInvoices(Array, Object(stdClass), 'email', 'paid') #13 /home/*/*/billing/app/controllers/cron.php(175): Cron->deliverInvoices('54b100e4c6c54b3...') #14 /home/*/*/billing/app/controllers/cron.php(127): Cron->all('54b100e4c6c54b3...') #15 /home/*/*/billing/vendors/minphp/bridge/src/Lib/Dispatcher.php(143): Cron->index() #16 /home/*/*/billing/index.php(21): Dispatcher::dispatch('/billing/cron/?...') #17 {main}Attempting to provision paid pending services. The paid pending services task has completed. Attempting to unsuspend paid suspended services. The unsuspend services task has completed. Attempting to cancel scheduled services. The cancel scheduled services task has completed. Attempting to process service changes. The process service changes task has completed. Attempting to process renewing services. Renewed service #6 for client 1505. Renewed service #9 for client 1502. The process renewing services task has completed. Attempting to update exchange rates. Exchange rates were updated successfully. The exchange rates task has completed. Attempting plugin cron for order accept_paid_orders. Finished plugin cron for order accept_paid_orders. Attempting plugin cron for support_manager poll_tickets. Finished plugin cron for support_manager poll_tickets. Attempting plugin cron for support_manager close_tickets. Finished plugin cron for support_manager close_tickets. Attempting plugin cron for mass_mailer export. Finished plugin cron for mass_mailer export. Attempting plugin cron for mass_mailer mass_mail. Finished plugin cron for mass_mailer mass_mail. Attempting to clean up old logs. 0 old Gateway logs have been deleted. 0 old Module logs have been deleted. The clean logs task has completed. All tasks have been completed. Attempting to run all system tasks. Attempting to validate the license. The license validation task has completed. Attempting to backup the database to AmazonS3. The backup completed successfully. The AmazonS3 database backup task has completed. Attempting to backup the database via SFTP. exec() has been disabled for security reasons The SFTP database backup task has completed. All system tasks have been completed.

im getting the attached error message when i applied a payment to a client. The amount has been credited to the invoice etc when i look at it after just not sure what's the problem?

Seems like changing the mem size has cleared it. Its also had the added benefit of fixing the high cpu usage. My php must not have been configured correctly and doing this has solved it. thanks guys

mark as solved see my other thread that seems to relate to this also

Its a standard blesta 4.2.2 install. you can see the phpinfo here; https://mdhosting.co.uk/phpinfo.php. i can give you ssh access if this helps? I did check the logs and it is writable but the only thing its saying is this; [2018-04-11 05:15:09] general.NOTICE: E_NOTICE: tempnam(): file created in the system's temporary directory {"code":8,"message":"tempnam(): file created in the system's temporary directory","file":"/home/mdhostin/public_html/billing/vendors/tcpdf/tcpdf.php","line":5410} [2018-04-11 09:06:42] general.NOTICE: E_NOTICE: tempnam(): file created in the system's temporary directory {"code":8,"message":"tempnam(): file created in the system's temporary directory","file":"/home/mdhostin/public_html/billing/vendors/tcpdf/tcpdf.php","line":5410} [2018-04-11 11:20:09] general.NOTICE: E_NOTICE: tempnam(): file created in the system's temporary directory {"code":8,"message":"tempnam(): file created in the system's temporary directory","file":"/home/mdhostin/public_html/billing/vendors/tcpdf/tcpdf.php","line":5410} [2018-04-11 15:54:44] general.NOTICE: E_NOTICE: tempnam(): file created in the system's temporary directory {"code":8,"message":"tempnam(): file created in the system's temporary directory","file":"/home/mdhostin/public_html/billing/vendors/tcpdf/tcpdf.php","line":5410} [2018-04-11 17:25:08] general.NOTICE: E_NOTICE: tempnam(): file created in the system's temporary directory {"code":8,"message":"tempnam(): file created in the system's temporary directory","file":"/home/mdhostin/public_html/billing/vendors/tcpdf/tcpdf.php","line":5410} All logs showing no erros... thanks for the help guys i hope we can fix it

Im trying to view invoices. it used to generate them as i've attached but since moving to php 7 its not. (client details removed)

done that but not getting any errors. i tried changing it back to php5 then re enabling php7.1. the invoice is now shown but only like shown in the attachment 2-03-2018 (2).pdf