Jump to content

L3Y

Members
  • Posts

    112
  • Joined

  • Last visited

  • Days Won

    2

Posts posted by L3Y

  1. Just saw if i truncate the pricing table then i am able to delete and modify the product prices.

     

    Here is how our pricing table looks like :

    INSERT INTO `pricings` (`id`, `company_id`, `term`, `period`, `price`, `setup_fee`, `cancel_fee`, `currency`) VALUES
    (1, 1, 1, 'month', 159.0000, 0.0000, 0.0000, 'CAD'),
    (2, 1, 1, 'month', 141.8300, 0.0000, 0.0000, 'USD'),
    (3, 1, 1, 'month', 112.0400, 0.0000, 0.0000, 'EUR'),
    (4, 1, 1, 'month', 144.9900, 0.0000, 0.0000, 'CAD'),
    (5, 1, 1, 'month', 219.0000, 0.0000, 0.0000, 'CAD'),
    (6, 1, 1, 'month', 195.3600, 0.0000, 0.0000, 'USD'),
    (7, 1, 1, 'month', 154.3200, 0.0000, 0.0000, 'EUR'),
    (8, 1, 1, 'month', 259.0000, 0.0000, 0.0000, 'CAD'),
    (9, 1, 1, 'month', 231.0400, 0.0000, 0.0000, 'USD'),
    (10, 1, 1, 'month', 182.5100, 0.0000, 0.0000, 'EUR'),
    (11, 1, 1, 'month', 245.0000, 0.0000, 0.0000, 'CAD')
    [...]
    

    I can't figure out what's wrong in it...

     

    It work now, but we need to re-configure our prices manually....

  2. Hi,

     

    I'm getting this error if i try to delete price row for a domain extension in a package.  I imported from WHM** and now this happen while editing / deleting our domain prices :

     

    "Currency code must be 3 characters."

     

    Why exactly?  The currency is set and i checked the db : it's all 3 characters, everywhere there is a currency field.  The currency is set correctly in the Blesta admin.

     

    See attachment for the error, and our currency settings.

     

    thank you,

    Carl

     

     

    post-10622-0-99403800-1414470069_thumb.p

    post-10622-0-49292300-1414470084_thumb.p

  3. Hi,
     
    I know this is an old question, but... ..here is a new answer :)
     
    In order to use NAXSI with Blesta :
     
    1) restric your server to your own ip - important while you are in learning mode
    2) enable NAXSI in Learning mode
    3) run this to create your whitelist rules :
     

     

    mv /var/log/nginx/error.log  /var/log/nginx/error.log-bak
    touch /var/log/nginx/error.log 
    mv /var/log/nginx/access.log  /var/log/nginx/access.log-bak
    touch /var/log/nginx/access.log
    wget https://naxsi.googlecode.com/files/nx_util-1.0.tgz
    tar -zxf nx_util-1.0.tgz
    cd nx_util-1.0/nx_util

    NOW : BROWSE YOUR BLESTA EVERYWHERE! Go in the admin, and submit all the forms. Do the same in the client area. Try every features.
    You will generate some logs, in /var/log/nginx/error.log and /var/log/nginx/access.log.

    We will use these logs to create our whitelist rules :

     

    python nx_util.py -c nx_util.conf -l /var/log/nginx/*.log -o

     
    You'll get some rules created based on your logs.  I suggest to review them first, and then only whitelist the ones you really need. 
     

    Now add them to your whitelist file, and you are done.

     

    Note : Don't forget to comment the line

     

    LearningMode;

     

    in the file /etc/nginx/naxsi.rules

     

    ...and to restart nginx
     

     

    Cheers :)

  4. Hi,

     

    I'm trying to migrate from WHMCS 5.3.10 to Blesta 3.2

    Seems like  option_pricing_id  cannot be nul, but it is in our db :)

     

    importStaff ----------------- importStaff took: 0.2447 seconds ----------------- importClients ----------------- importClients took: 7.1084 seconds ----------------- importContacts ----------------- importContacts took: 0.1203 seconds ----------------- importTaxes ----------------- importTaxes took: 0.0021 seconds ----------------- importCurrencies ----------------- importCurrencies took: 0.0037 seconds ----------------- importInvoices ----------------- importInvoices took: 9.0035 seconds ----------------- importTransactions ----------------- importTransactions took: 30.7386 seconds ----------------- importPackages ----------------- importPackages took: 1.6567 seconds ----------------- importPackageOptions ----------------- importPackageOptions took: 2.8433 seconds ----------------- importServices ----------------- importSupportDepartments ----------------- importSupportTickets ----------------- importMisc ----------------- decrypted 18 values using WHMCS' custom algorithm decrypt took: 0.0015 seconds total time took: 54.4234 seconds Array ( [error] => Array ( [0] => The import completed but the following errors ocurred: [1] => importServices: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'option_pricing_id' cannot be null on line 124 [2] => importSupportDepartments: There is already an active transaction on line 163 [3] => importSupportTickets: There is already an active transaction on line 163 [4] => importMisc: There is already an active transaction on line 163 ) )

     

    cheers :)

     

     

     

     

     

     

     

  5. Hourrah :) The Virtualizor module is now available on Blesta : http://www.virtualizor.com/wiki/Blesta_Module

     

    Public and Private "Cloud alike"  : Love it :)

     

    They are apparently working on HA also. with a couple of modifications to the plugin (i.e. : send email upon action) it rocks!

     

    But, i still require OpenSRS : i wouldn't change this provider at all.   

     

    Will be waiting for some good news on this.  ...but when it comes available, i'll purchase Blesta 4 sure :)

  6. Hi,

     

    We have a bug in our whmcs.  ...we cannot use it anymore, and whmcs support don't know what to do to fix this, so they ask us to wait since 3 weeks for a manager who never replied to our ticket.

     

    It's no longer a good solution for us, and we would like to migrate to Blesta.

     

    But if we migrate to Blesta, we will loose theses features, and cannot live without.  We require : 

     

    - Interac online (we are using http://internetsecure.com  but we may change our provider if required.  The InternetSecure module for whmcs we have is unencrypted and hold i a single file (less than 100 lines).  I assume it wouldn't take more than a couple of hours to convert this into a Blesta module).

     

    - Virtualizor Module (makes a while it's supposed to be available, as per your forum - any news?)

     

    Is there any beta versions of Virtualizor/Interac modules we can start using right now?

     

    How can i continue to accept Interac payments?  Most of our clients enjoy the fact they can pay using their debit card.

     

    Thank you,

     

    Carl

×
×
  • Create New...