Search the Community

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

Hello , I'm working on integration of my current system with blesta and I have issue with importing clients to blesta. Can you tell me when I manually import user (only user not package or any additional informations) what database tables I need to fill. For now I find this tables: clients users But I think that I'm missing few tables

Hi there, How can I import my existing clients with their details from WHM into Blesta clients list? Thanks

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

Hello All ; is a long time that i was away from this forum and blesta activity , for apersonal case . today i have tried to prepare the transfer from the v2.5 to the new version 3.1.3 with the import module , but i have no succes in all import . the packages has been successfully imported . the useres not all . the services not all . maybe is a timeout probleme , as the database has a huge number of clients (about 3600) and services (more than 8000 services) . i think if the dev can make the import work with ajax system or in steps methode is better . first import packages , then users (no more than 400 or 500 in oneshoot ) and services also in parties (300 or 500 ) . somthing like http://ddddddd.com/blesta/admin/settings/company/plugins/manage/7/blesta/2.5/?action=import&step1=packages http://ddddddd.com/blesta/admin/settings/company/plugins/manage/7/blesta/2.5/?action=import&step2=users&from=0 http://ddddddd.com/blesta/admin/settings/company/plugins/manage/7/blesta/2.5/?action=import&step2=users&from=500 http://ddddddd.com/blesta/admin/settings/company/plugins/manage/7/blesta/2.5/?action=import&step2=users&from=1500 http://ddddddd.com/blesta/admin/settings/company/plugins/manage/7/blesta/2.5/?action=import&step2=users&from=2000 http://ddddddd.com/blesta/admin/settings/company/plugins/manage/7/blesta/2.5/?action=import&step3=services&from=0 http://ddddddd.com/blesta/admin/settings/company/plugins/manage/7/blesta/2.5/?action=import&step3=services&from=500 http://ddddddd.com/blesta/admin/settings/company/plugins/manage/7/blesta/2.5/?action=import&step3=services&from=1000 i believe this issue will be fixed . and now the big probleme that i front , is orderbox module . it import the service and the package . but all the domains imported is not linked with the domain is the orderbox platteform . why ? because the module in version 3 , need the orderid and the nameservers to be confugured . and the imported services has not this value in it . what we should do ? 1 - either a batch script (module that check every domain in blesta and check it in orderbox plattforme and import the missing values . 2- change the database mannually , and that is impossible , as we have more than 2000 domaines in the systeme . the blesta dev can help in this ....