Jump to content

Anton Qcl

Members
  • Posts

    70
  • Joined

  • Last visited

  • Days Won

    2

Posts posted by Anton Qcl

  1. 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.

  2. Paul, I'm using SMTP.
    Blesta Version: 3.6.2


     

    Quote

    If you have access to your mail server logs, check those and see if any errors are produced

    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?

     

    Quote

    If you're not running Blesta 4.0.1, I'd suggest upgrading. 

    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.


     

    Quote

    If it's intermittent, maybe it's a network or rate limit issue?

    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?
     

  3. Licensecart, SMTP.
    PaulSome 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? 

  4. 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`

     

  5. I'm not able to duplicate this.

    Did you try to use browser Mozilla Firefox? It is very important to duplicate this error.

     

     

    'type' comes from the type of phone number. This defaults to "phone". Clearly you have something going on where the type value isn't coming through

     

    I mean browser "Mozilla Firefox" is sending wrong form to the handler.

  6. Blesta version: 3.1.1

    Url: https://my.blesta.site/admin/clients/edit/765/

    Browser: Mozilla Firefox.

     

    Steps:

     

    1. Go to a client in the admin interface.
    2. Click "Edit".
    3. (Click "Add additional number").
    4. Type number
    5. 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}
  7. You can force a revalidation by accessing /admin/license/. If that fails to work, you are likely accessing Blesta at a location not registered for you license. The solution then is to reissue your license.

     

     

     

    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.

  8. 1. The data is corrupt (stored improperly).

    2. Your RSA key, or key pair, is corrupt. This can occur if you have modified the Blesta.system_key config setting in /config/blesta.php, or if you modified the private_key or public_key settings in company_settings table.

    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.

  9. 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.

  10. 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

     

    including your main service and addon services' settings.

     

    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.

    post-1735-0-00033400-1391459264_thumb.jp

  11. 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" } } }
  12. Yes I did. The ticket list still display fine.

     

    I got an error on three different blesta-sites on two different servers.

     

     

    Or the page loads, but no tickets are listed, and you see a message that "There are currently no tickets with this status."?

     

    Page loads but no tickets are listed and no message too. I can provide you screenshot if you wish.

     

     

    You can try to turn on error reporting and check the page for errors, or look through the server logs for relevant errors.

    My error reporting row on config:

    Configure::errorReporting(1);

    In the logfiles are no errors.

  13. 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.

  14. 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:

    /**
    * Retrieves the total credit amount available to the client in the given currency
    *
    * @param int $client_id The ID of the client to fetch a credit value for
    * @param string $currency The ISO 4217 3-character currency code (optional)
    * @return double The total credit available to the client in the given currency
    */

     


    But parameter $currency doen't have default value.

     

     

     

     

    
    
    public function getTotalCredit($client_id, $currency) {


     

×
×
  • Create New...