Anton Qcl

Hi, Is there a way to extend custom search the way I need? For example, in some plugins I have additional information attached to client and I want to be able to find clients thru Smart Search using only this information.

Paul, I'm using SMTP. Blesta Version: 3.6.2 I have access to logs. OS is CentOS 7. I've checked /var/log/maillog but there is no entries about failed emails. Do you have any idea about other files to check? Unfortunately, it is not easy procedure in my case cause some of .pdt files was modified and some of third-party plugins can be incompatible with new version. I'll try to avoid this procedure as long as possible. It looks like fortune telling. Yes, problems could be caused by plenty of reasons and I want to find these reasons. However "the guessing" is not the way I want to use. So, I'm asking you, how can I find real source of the problems? Do you have instrument for debug this kind of problems (like extended logging to the file)? Maybe I can temporarily place some snippet for debug purposes somewhere? Please, tell me about variants of diagnostic. What would you do to find cause of this problem?

Licensecart, SMTP. Paul, Some emails go out but not all of them. Fortunately I was able to repeat problem using test user. From the over side, I have no idea how to find the reason of the problem. Mail settings is ok - I'm able to send mail from the other software using same credentials. Moreover, I have several companies in my Blesta (with unique email for each) and from time to time I face with mail problems at each of them. Regretfully, I can't find any useful information about reasons of the errors - I can only see status "Unsent" and message "The email failed to send due to a configuration issue". Please, recommend my some way to investigate the problems. Perhaps I can find some logs somewhere?

Hello. I tried to send email to test user (url: /admin/clients/email/{USERID}/) and received next error: "The email failed to send due to a configuration issue". Please, tell me how can I figure out the reason of this problem? Apache log has no errors. Screenshot of the error: http://prntscr.com/f909xh

Paul, in this case, please, change text of the error. Also, I will be very appreciate if you describe allowed and disallowed clauses in documentation(https://docs.blesta.com/display/user/Generating+Reports) more.

Hello, I'm trying to create a custom report, but I receive error: "Only one query allowed, and it must be a SELECT query." Problem occurs when I trying to add next string in my query: GROUP_CONCAT(CONCAT(`client_notes`.`title`, `client_notes`.`description`) SEPARATOR '; ') AS 'Notes' Full text of my query: SELECT `users`.`date_added` AS 'Memeber Since', `clients`.`status` AS 'Client Status', `clients`.`id_value` AS 'CRM #', `contacts`.`first_name` AS 'First Name', `contacts`.`last_name` AS 'Last Name', `contacts`.`company` AS 'Company/Org.', `contacts`.`address1` AS 'Address', `contacts`.`city` AS 'City', `contacts`.`country` AS 'Country', `contacts`.`state` AS 'State/Province', `contacts`.`zip` AS 'Zip/Postal Code', `contacts`.`email` AS 'Email', GROUP_CONCAT(CONCAT(`client_notes`.`title`, `client_notes`.`description`) SEPARATOR '; ') AS 'Notes' FROM `clients` JOIN `users` ON (`users`.`id`=`clients`.`user_id`) LEFT JOIN `contacts` ON (`contacts`.`client_id`=`clients`.`id` AND `contacts`.`contact_type`='primary') LEFT JOIN `contact_numbers` ON (`contact_numbers`.`contact_id`=`contacts`.`id`) LEFT JOIN `client_notes` ON (`client_notes`.`client_id`=`clients`.`id`) GROUP BY `clients`.`id`

Tested in: OS: Microsoft Windows 8.1 Browser: Firefox 26.0 OS: Linux Browser: Firefox 24.0

Did you try to use browser Mozilla Firefox? It is very important to duplicate this error. I mean browser "Mozilla Firefox" is sending wrong form to the handler.

Blesta version: 3.1.1 Url: https://my.blesta.site/admin/clients/edit/765/ Browser: Mozilla Firefox. Steps: Go to a client in the admin interface. Click "Edit". (Click "Add additional number"). Type number Click "Modify Client". Error: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'type' cannot be null on line 124 in /var/www/vhosts/my.blesta.site/public_html/lib/model.php Printing Stack Trace: #0 /var/www/vhosts/my.blesta.site/public_html/lib/model.php(124): PDOStatement->execute(Array) #1 /var/www/vhosts/my.blesta.site/public_html/components/record/record.php(216): Model->query('INSERT INTO `co...', Array) #2 /var/www/vhosts/my.blesta.site/public_html/app/models/contacts.php(475): Record->insert('contact_numbers', Array, Array) #3 /var/www/vhosts/my.blesta.site/public_html/app/models/contacts.php(188): Contacts->addNumber('503', Array) #4 /var/www/vhosts/my.blesta.site/public_html/app/controllers/admin_clients.php(991): Contacts->edit('503', Array) #5 /var/www/vhosts/my.blesta.site/public_html/lib/dispatcher.php(111): AdminClients->edit() #6 /var/www/vhosts/my.blesta.site/public_html/index.php(21): Dispatcher::dispatch('/admin/clients/...') #7 {main}

Incorrect url in settings of one company was original reason of the problem. Solved. Thank you for help.

It fails to work. And reissue fails to work. Could it be that the system doesn't request account.blesta.com because system doesn't got some parameters? I can't check it because I don't have access to /app/models/license.php I have two other copies of Blesta on the same server - updating license key occurs correct. Getting of free trial for pure site occurs correct. Telnet to account.blesta.com:443 occurs correct.

In this case, problem would be in the another places of system but same function, called from another place (not from plugin) works correct. Also, in this case, problem would be on the other blesta-sites with this plugin but there is no problem. I commented strings with checking in the file /vendors/phpseclib/Crypt/RSA.php for experiment and ran cron. I got next error: Error: Trying to get property of non-object #0 /var/www/vhosts/my.blesta.site/public_html/components/gateway_payments/gateway_payments.php(525): UnknownException::setErrorHandler(8, 'Trying to get p...', '/var/www/vhosts...', 525, Array) #1 /var/www/vhosts/my.blesta.site/public_html/app/models/voipswitch.php(829): GatewayPayments->processPayment('22', 'cc', 10, 'CAD', NULL, '15') #2 /var/www/vhosts/my.blesta.site/public_html/plugins/vs_cron/vs_cron_plugin.php(211): Voipswitch->topUp('71', '15', '10', 'both') #3 /var/www/vhosts/my.blesta.site/public_html/plugins/vs_cron/vs_cron_plugin.php(125): VsCronPlugin->autotransfer() #4 /var/www/vhosts/my.blesta.site/public_html/app/controllers/cron.php(1756): VsCronPlugin->cron('vs_autotransfer') #5 [internal function]: Cron->pluginTasks('740dfc9a3bf00c7...') #6 /var/www/vhosts/my.blesta.site/public_html/app/controllers/cron.php(132): call_user_func_array(Array, Array) #7 /var/www/vhosts/my.blesta.site/public_html/app/controllers/cron.php(94): Cron->all('740dfc9a3bf00c7...') #8 /var/www/vhosts/my.blesta.site/public_html/lib/dispatcher.php(121): Cron->index() #9 /var/www/vhosts/my.blesta.site/public_html/index.php(21): Dispatcher::dispatch('/cron/?cron_key...') #10 {main} Ok, I uncommented strings of checking. I opened file /components/gateway_payments/gateway_payments.php on the row 525: 'company' => $this->Companies->get($client->company_id) I thought only some users have a problem and the user (who have service 71 which in the error) is in that group. I tried to call function Voipswitch->topUp (it calls function GatewayPayments->processPayment, etc) for this user and my license became invalid (I was transferred to the page "https://my.blesta.site/admin/license/" with text "License invalid", field for enter license key and button for submit). I think problem occurs when system can not get some company settings. But crushing of function GatewayPayments->processPayment and corruption of license should not happen. Please, check it and help me solve this problem.

Hello, Blesta version: 3.0.9/3.1.1 Actions: try to execute cron with tasks with function ProcessPayment(). I have custom plugin for two cron-tasks. It worked correct till yesterday. But now, when I'm trying to execute cron, I'm getting next error: Error: Decryption error #0 [internal function]: UnknownException::setErrorHandler(1024, 'Decryption erro...', '/var/www/vhosts...', 2034, Array) #1 /var/www/vhosts/my.blesta.site/public_html/vendors/phpseclib/Crypt/RSA.php(2034): user_error('Decryption erro...', 1024) #2 /var/www/vhosts/my.blesta.site/public_html/vendors/phpseclib/Crypt/RSA.php(2515): Crypt_RSA->_rsaes_oaep_decrypt('.}??lb????a???h...') #3 /var/www/vhosts/my.blesta.site/public_html/app/models/accounts.php(950): Crypt_RSA->decrypt('.}??lb????a???h...') #4 /var/www/vhosts/my.blesta.site/public_html/app/models/accounts.php(162): Accounts->accountDecrypt('Ln0JsWximMSIzGG...', NULL) #5 /var/www/vhosts/my.blesta.site/public_html/components/gateway_payments/gateway_payments.php(395): Accounts->getCc('15', true, NULL, NULL) #6 /var/www/vhosts/my.blesta.site/public_html/app/models/voipswitch.php(829): GatewayPayments->processPayment('22', 'cc', 10, 'CAD', NULL, '15') #7 /var/www/vhosts/my.blesta.site/public_html/plugins/vs_cron/vs_cron_plugin.php(211): Voipswitch->topUp('71', '15', '10', 'both') #8 /var/www/vhosts/my.blesta.site/public_html/plugins/vs_cron/vs_cron_plugin.php(125): VsCronPlugin->autotransfer() #9 /var/www/vhosts/my.blesta.site/public_html/app/controllers/cron.php(1756): VsCronPlugin->cron('vs_autotransfer') #10 [internal function]: Cron->pluginTasks('3395b9698c531ca...') #11 /var/www/vhosts/my.blesta.site/public_html/app/controllers/cron.php(132): call_user_func_array(Array, Array) #12 /var/www/vhosts/my.blesta.site/public_html/app/controllers/cron.php(94): Cron->all('3395b9698c531ca...') #13 /var/www/vhosts/my.blesta.site/public_html/lib/dispatcher.php(121): Cron->index() #14 /var/www/vhosts/my.blesta.site/public_html/index.php(21): Dispatcher::dispatch('/cron/?cron_key...') #15 {main}All tasks have been completed. Also, I did not have possibility to enter to the administrative interface yesterday because Blesta told me "update your key". Reissue of the license did not help and I've changed version from 3.0.9 to 3.1.1 - it solved this problem.

1. Go to client on the admin side. 2. Click "New Service". 3. Choose package and click "Continue". 4. Choose invoice method, term, status, addon and click "Continue". 5. Choose term for addon and click "Continue". 6. Error: Cannot pass parameter 1 by reference on line 76 in /var/www/vhosts/my.blesta.site/public_html/app/views/admin/default/admin_clients_addservice_confirm.pdt Packages based on the Universal Module, for example, and doesn't have any settings. URL: http://my.blesta.site/admin/clients/addservice/40/1/10 Versions: Blesta - 3.1.0; PHP - 5.3.3; MySQL - 5.1.61 Also, I've attached screenshot of the error.

Version: 3.1.0 Actions: Try to add service with add-on from the admin interface. Error: Cannot pass parameter 1 by reference on line 76 in /var/www/vhosts/my.blesta.site/public_html/app/views/admin/default/admin_clients_addservice_confirm.pdt

Version: 3.0.6 I try to edit invoice line for include tax in this line. My main code: require_once 'model/blesta.php'; require_once "lib/blesta_api.php"; $blesta = new Blesta; $line_to_fix = array( 'invoice_id' => "76", 'client_id' => "35", 'line_id' => "155" ); $result = $blesta->addInvoiceLineTax($line_to_fix['invoice_id'], $line_to_fix['client_id'], $line_to_fix['line_id']); var_dump($result); Code of the function "addInvoiceLineTax": public function addInvoiceLineTax($invoice_id, $client_id, $line_id) { $params = array( 'invoice_id' => $invoice_id, 'vars' => array( 'client_id' => $client_id, 'currency' => "CAD", 'lines' => array( 'id' => $line_id, 'tax' => true ) ) ); $result = $this->processAction('invoices', 'edit', $params); return $result; } ... And I get next error: object(BlestaResponse)#3 (3) { ["raw":"BlestaResponse":private]=> string(274) "{"message":"An unexpected error occured.","response":"SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `id` = '7'' at line 1"}" ["response_code":"BlestaResponse":private]=> int(500) ["errors"]=> object(stdClass)#4 (1) { ["error"]=> object(stdClass)#5 (2) { ["message"]=> string(28) "An unexpected error occured." ["response"]=> string(218) "SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE `id` = '7'' at line 1" } } }

This error also applies to the next fields: 'country' 'state' 'address2' 'city' 'zip'

I got an error on three different blesta-sites on two different servers. Page loads but no tickets are listed and no message too. I can provide you screenshot if you wish. My error reporting row on config: Configure::errorReporting(1); In the logfiles are no errors.

Did you try to add ticket with summary "Онлайн кон

Version: 3.0.5 Problem: page .../admin/plugin/support_manager/admin_tickets/index/closed/ doesn't open if exist at least one closed ticket on first page with summary "Онлайн кон

100% working config on the same configuration of server. File /etc/apache2/sites-available/default: <VirtualHost *:80> ServerAdmin webmaster@localhost DocumentRoot /var/www <Directory /var/www/> Options +FollowSymLinks AllowOverride All Order allow,deny Allow from all </Directory> ScriptAlias /cgi-bin/ /usr/lib/cgi-bin/ <Directory "/usr/lib/cgi-bin"> AllowOverride None Options +ExecCGI -MultiViews +SymLinksIfOwnerMatch Order allow,deny Allow from all </Directory> ErrorLog ${APACHE_LOG_DIR}/error.log # Possible values include: debug, info, notice, warn, error, crit, # alert, emerg. LogLevel warn CustomLog ${APACHE_LOG_DIR}/access.log combined Alias /doc/ "/usr/share/doc/" <Directory "/usr/share/doc/"> Options Indexes MultiViews FollowSymLinks AllowOverride None Order deny,allow Deny from all Allow from 127.0.0.0/255.0.0.0 ::1/128 </Directory> </VirtualHost> File /etc/apache2/sites-available/my.blesta.site: <VirtualHost *:80> ServerAdmin webmaster@localhost ServerName my.blesta.site DirectoryIndex index.php DocumentRoot /var/www/my.blesta.site/public_html/ <Directory /var/www/my.blesta.site/public_html/> Options +FollowSymLinks AllowOverride All Order allow,deny Allow from All </Directory> ErrorLog ${APACHE_LOG_DIR}/my.blesta.site-error.log CustomLog ${APACHE_LOG_DIR}/my.blesta.site-access.log combined </VirtualHost> To enable site use command "a2ensite" and restart apache.

Version: 3.0.5 Action: Try to get total credit from client with credit equal 0. Test link: .../api/Transactions/getTotalCredit.json?client_id=2&currency=CAD Problem: I receive empty array but I expected value equal 0. Is "empty array" correct API answer? PS Description for getTotalCredit: But parameter $currency doen't have default value. public function getTotalCredit($client_id, $currency) {

Yes, php-gd wasn't installed. Thank you!

Try to change this row too: Options FollowSymLinks to Options +FollowSymLinks Final version:DocumentRoot /var/www <Directory /> Options +FollowSymLinks AllowOverride All </Directory> <Directory /var/www/> Options Indexes +FollowSymLinks MultiViews AllowOverride All Order allow,deny allow from all </Directory>

Version 3.0.5 Action: Click "View" on the client's invoice Error: Oh noes! Call to undefined function imagecreatefrompng() on line 5395 in /var/www/vhosts/my.blesta.site/public_html/vendors/tcpdf/tcpdf.php