Search the Community
Showing results for tags 'migration'.
-
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 ) )
-
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
-
Sorry for my questions but I am an NB on Blesta, the issue is I can not create hidden packages in Blesta I have a lot of hidden packages on WHMCS and when I do promotions I inform the customers the URL for each package, so normally they are not publicly displayed. I tried to do a restricted package and copy and paste its URL but did not work, is there any workaround to do this. Thanks
-
So, migrated all invoices and clients from WHMCS to Blesta 4 (currently trying the beta out for kinks). Migration was complicated as there is no migration tool, but with some minor modifications to DB, and some manual imports, managed to stitch it together. Current issue is printing old invoices. None of them show on the Print Queue and aside from unapplying all transactions, adding the "paper" deliver along, saving and then reapplying the payments for each invoice, can't find another way to force reprint or even add them to the queue en-masse. We have on this test system over 1000 invoices form the import from WHMCS, so on actual operation this would be insanity. The DB has "invoice_delivery" but that is only for invoices generated AFTER the import, can't find where the same flag goes for invoices already paid, closed and from the import. Any idea as to how we can force all invoices to show on the Print Queue?
-
I've been a long-time-watcher of Blesta, recently with the hiccups of WHMCS ('Native' Stripe Plugin prevented billing because "old data" was in place) I'm more than ever ready to explore other options and Blesta has always been on my radar, but I have two questions. Number one would be, I have one WHMCS install in 6.x and another in 7, is it possible to import two installs into one? I'd love to have a single install with the two options so I can maintain everything in one spot. The second is will my current Stripe configurations migrate over as well?
- 16 replies