Search the Community

Hi all, I've installed Blesta to give it a try but when I tried to do an import from my WHMCS installation It gives me errors. I've been looking on the web about this kind of error but I can't solve it yet, does any one knows what is happening? I have CentOS 8, mysql 8.0.21 I've even modified the blesta.php in DB config to this, but it did not works. Configure::set('Blesta.database_info', [ 'driver' => 'mysql', 'host' => 'localhost', 'port' => '3306', 'database' => 'DBNAME', 'user' => 'DBUSER', 'pass' => 'DBPASS', 'persistent' => false, 'charset_query' => "SET NAMES 'utf8'", //'sqlmode_query' => "SET sql_mode='TRADITIONAL'", //this is the original 'sqlmode_query' => "SET sql_mode=(SELECT REPLACE(@@sql_mode, 'ONLY_FULL_GROUP_BY', ''))", // here is what I changed //'sqlmode_query' => "SET sql_mode=''", // I tried this too 'options' => [] ] ); Most of the tables of WHMCS are imported well but this don't. This is the import log on debug mode: decrypted 30 values using WHMCS' custom algorithm decrypt took: 0.0005 seconds total time took: 7.3194 seconds Array ( [error] => Array ( [0] => [1] => importSupportTickets: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #30 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'DBNAME.tbladmins.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by on line 196 [2] => importAffiliates: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tbltickets.admin' in 'on clause' on line 196 [3] => importMisc: 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 '* FROM `tbltickets`, `tblaffiliates`, `tblconfiguration` LEFT JOIN `tbladmins` O' at line 1 on line 196 ) )

Hi, i was trying to import our WHMCS Database into Blesta. The Debugging says: [1] => importSupportTickets: SQLSTATE[42000]: Syntax error or access violation: 1055 Expression #30 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'db_whmcs01.tbladmins.id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by on line 196 [2] => importAffiliates: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'tbltickets.admin' in 'on clause' on line 196 [3] => importMisc: 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 '* FROM `tbltickets`, `tblaffiliates`, `tblconfiguration` LEFT JOIN `tbladmins` O' at line 1 on li Does anyone has an Idear what I can do to solve this? Regards and Thanks

Using the import module and debug enabled got the following error: Array ( => Array ( [format] => Please enter a valid email address. ) ) so following the instructions replace the Input.php with this line in isEmail public static function isEmail($str, $check_record = true) { return true; } now the email address was corrected but now have a new error as an invalid userID I have researched but could not find a fix for that, let me know if somebody has. thanks

Forgiving the translation, I'm Spanish and I use google translator. After whmcs changes in prices, I am looking at other options. Is there something to transfer the contents of whmcs to blesta? My version is 6.3.1 whmcs

is there any tools to migrate from whmcs to blesta ? we have 30 000 clients on our whmcs on monovm.com regards

I migrated my data into a trial version of Blesta using the Import Manager, I have the eNom module installed and configured, I've created a package group called "domains," and I've set up a package for each TLD we need in the domains group. Now I'm trying to figure out from the documentation how to get my clients' domains set up. Most of my clients in WHMCS have at least one domain registered. They didn't make it in the migration as services, so I guess I need to set them up manually; however, I don't see any way to do it and make the next invoice coincide with when the domains are due to renew. How is that done in Blesta?

Hi Im getting the following error: importMisc ----------------- decrypted 0 values using WHMCS' custom algorithm decrypt took: 0 seconds total time took: 0.5836 seconds Array ( [error] => Array ( [0] => The import completed but the following errors ocurred: [1] => importContacts: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'client_id' cannot be null on line 124 [2] => importTaxes: There is already an active transaction on line 163 [3] => importCurrencies: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 124 [4] => importInvoices: There is already an active transaction on line 163 [5] => importTransactions: There is already an active transaction on line 163 [6] => importPackages: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 124 [7] => importPackageOptions: There is already an active transaction on line 163 [8] => importServices: There is already an active transaction on line 163 [9] => importSupportDepartments: There is already an active transaction on line 163 [10] => importSupportTickets: There is already an active transaction on line 163 [11] => importMisc: There is already an active transaction on line 163 ) When i run the importer i have followed the following guide https://licensecart.com/whmcs-blesta Thanks

Hello Everyone, I am using WHMCS 6.x right now and interested to migrate to Blesta 3.6.1 I followed MD's guide : https://licensecart.com/whmcs-blesta to migrate. Also i have required php extension on my server. It did import clients, invoices, transactions but didn't import staffs, packages or services at all. Small Note: I didn't stopped whmcs and cron during import process. So guys, what can be the issue for this ? If MD's with me why i am posting this, because he has other things to do beside helping me and i wanted to check it out with others so it became easy for both of us.

Hello Blestars To raise the mood hover here I ask all your "FREE" opinions about the Blesta VS WHMCS For me is: Blesta Advantages - Blesta is Secure - Blesta is Well Coded - Besta lets you see 99% of code for you to make changes - Blesta team is Friendly and Open to sugestions - Blesta Comunity is great and help each outher, most of the time for FREE - 99% of Modules/Plugins/Extensions made by developpers are FREE - Blesta is Mobile Ready - Blesta have some of the best Plugins outh there like cPanel Extended (V1/2), Blesta Online Chat and Admin Tools from naja7host - Blesta Order Forms are very clean and eye pleasent - Blesta Client Area, is one of the best looking outh there - Blesta is EU Ready (need some small improvments) - Love to be able to Bill unlimited by Day/Month/Year - Love to be able to make a bill by Hour Blesta Disavantages - Blesta needs some EU improvments on Invoice/Orders (Store on DB Client Details for TAX proposes) - Blesta needs some EU improvments on Invoice/Orders/Services (be able on first page to select the Language/Coin and auto fetch the correct TAX for that Country) - Blesta needs some improvments on Domain Module Setup (be able to set diferent prices for Register/Transfer/Renew) - Blesta needs some improvments on Domain Module Setup (be able to set auto prices for 1 to 10 years to quickly deploy) - Blesta needs some improvments on Domain Module Order Pages (be able purchace more clearly a Domain with Hosting and Hosting With a Domain) ------------------------------------- WHMCS Advantages: - WHMCS as an huge list of Modules/Plugins - WHMCS as an huge forum members that help each outhers - WHMCS eams solid product, but in realitty... WHMCS Disavantages: - I dont trust WHMCS since it got Hacked more than once - WHMCS code is bad (we dont know how bad because we cannot see the code, but was hacked more than once because of the bad coding) - WHMCS let down a lot of Clients including me (im still using untill I finish some modification on Blesta) - WHMCS is limited to what it can do, but dont do a bad job. Its works but with patches - WHMCS and cPanel are doing a really bad JOB, for me was a very bad decision on cPanel buy 49% shares of WHMCS, and now cPanel is trying to integrate WHMCS (yes I have notice they are slowlly adding WHMCS to it, and if they do I quicly Switch for exemple to Interworx) There are more and more to tell from Blesta VS WHMCS, please share your mind Blesta needs more "LOVERS" "Blesta needs you!" Thanks to all, PV Blesta VS WHMCS

Please note that the latest version of this migrator is included with the latest release of Blesta. Instructions BACK UP YOUR BLESTA DATABASE If you are not running import manager plugin version 1.0.3 download import_manager_1.0.3.zip and unzip to /plugins/ Unzip the contents of whmcs_migrator_b8.zip to /plugins/import_manager/components/migrators/ You should now have /plugins/import_manager/components/migrators/whmcs/ Go to [settings] > [Company] > [Plugins] and install the Import Manager Click the Manage button on the Import Manager and proceed through the steps The migration process may take a while. It imports A LOT of stuff. Data Imported Staff (including login passwords) Client Groups Clients (excluding login passwords) Credit Card Payment Accounts Custom Client Fields and Values Client Notes Contacts Tax Rules Currencies Invoices Recurring Invoices Transactions (partial refunds refund the original and create a new transaction for the difference) Client Credits Invoice Credits Support Departments Support Tickets (excluding attachments) Support Predefined Response Categories Support Predefined Responses Sent Emails The following Settings: Mail Delivery Type SMTP Host, User, Password, Port, and Security Type Invoice Days Before Renewal Invoice Reminder Settings Auto Debit Days Before Due Suspend Services After Due Calendar Events Products (become packages) Registrars (become modules/module rows) Servers (become modules/module rows) Services Domains (become services) Notes All custom pricing overrides will be imported as package pricing potentially creating multiple prices for the same term and currency WHMCS uses plain MD5 passwords for admin users. To enable support for these passwords update (/config/blesta.php) Configure::set("Blesta.auth_legacy_passwords", false); to Configure::set("Blesta.auth_legacy_passwords", true); What's new in b6 Added debugging option. Added check for gmp extension. Added support for refunds. Import refunded invoices as void. What's new in b7 Only sets quantity for package if stock conrtrol enabled Extracts all numberic values from ticket ID to better ensure ticket numbers come through What's new in b8 Introduced transactions for deferred commits (speed improvements) Now forces UTF-8 connection to WHMCS database to ensure special characters come through import_manager_1.0.3.zip whmcs_migrator_b3.zip whmcs_migrator_b4.zip whmcs_migrator_b5.zip whmcs_migrator_b6.zip whmcs_migrator_b7.zip whmcs_migrator_b8.zip

Hello Everyone. We have installed and configured cron automation beofre we realized that the Import Manager will be use pre-cron. Please is there anyway to redeem this situation? We need to import clients, products and knowledgebase to Blesta. Thanks. Private

http://www.billingbrawl.com/ Blesta vs WHMCS. I think we know who is going to win. Start with Round 1 and work your way up the page. What do you think? Favorite lines? Too harsh? Funny?

Hi, I am right now using WHMCS and I want to move to Blesta becuase it has open source and I need some modifcations doing which I cannot do in WHMCS. I had also installed the trial version which is going to expire very soon. I just want to know how do I setup Blesta so my clients can register, order domains / hostings by themselves ? Right now all I see is a login page and no reg. link, no order nothing. In WHMCS its all very easy. How do I setup blesta ? I am using Resellerclub for domains, cPanel for hosting and Paypal and 2Checkout for payments. Thanks.

Since Blesta doesn't support CDG Commerce, I'm going to have to do some payment shuffling before migrating from WHMCS. Naturally I want to inconvenience my customers as little as possible. If I set up the Stripe module in WHMCS using offsite storage (all card data is stored only with Stripe, leaving only tokenized data in WHMCS), will Blesta import the tokens during the migration? Or will customers have to re-enter their card information after moving to Blesta?