twhiting9275

I'd be "moved over a lot faster" if this thing was actually designed properly. I'm sorry, but this is just utter garbage. 20 minutes, then it dies. There's no reason this script should take 20 minutes to run. There's no reason it should die after 20 minutes. Hell, max_execution_time isn't even an option in php 5.4, though oddly enough it still shows up in phpinfo. That thing is so high it's insane. I'm done wasting my time and my money here. Call me when this thing actually works and I'll consider paying for it, but, as it is, this is total garbage. If you can't even get an import script working, then how am I supposed to trust your billing system?

I don't work for blesta, I'm not going to contribute anything. There's nothing in it for me. As far as 'behind the scenes', clearly there's too much going on back there when it takes more than 10 minutes to import a database that is barely 20 meg

I hate to say it, but no I don't need to do this. I shouldn't have to set an insecure setting like this. Re read what I posted. There's very little data to be migrated over, we're talking < 15,000 rows/fields all total. There's no reason this should be taking as long as it is

Exactly what it was. Removed all custom client fields, and importing (again). Sadly, this is taking way , way too long. With as few clients as I have in the system (150 clients, 1100 invoices, only 2300 tickets), there's no reason this should be taking over 10 minutes to do here. This needs to be cleaned up massively, as it's triggering 500's every time. [Tue Oct 29 19:11:25 2013] [error] [client ] Script timed out before returning headers: index.php, referer: http:/domain/index.php/admin/settings/company/plugins/manage/7/whmcs/5.2/?action=import [Tue Oct 29 19:16:25 2013] [error] [client ] File does not exist: /home/<user>/blesta2/500.shtml, referer: http:/domain/index.php/admin/settings/company/plugins/manage/7/whmcs/5.2/?action=import

The import completed but the following errors ocurred: importClients: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-40' for key 'PRIMARY' #0 /home/<username>/blesta2/lib/model.php(124): PDOStatement->execute(Array) #1 /home/<username>/blesta2/components/record/record.php(215): Model->query('INSERT INTO `cl...', Array) #2 /home/<username>/blesta2/plugins/import_manager/components/migrators/whmcs/whmcs_migrator.php(337): Record->insert('client_values', Array) #3 /home/<username>/blesta2/plugins/import_manager/components/migrators/whmcs/whmcs_migrator.php(73): WhmcsMigrator->importClients() #4 /home/<username>/blesta2/plugins/import_manager/models/import_manager_importer.php(113): WhmcsMigrator->import() #5 /home/<username>/blesta2/plugins/import_manager/controllers/admin_manage_plugin.php(110): ImportManagerImporter->runMigrator('whmcs', '5.2', Array) #6 /home/<username>/blesta2/app/controllers/admin_company_plugins.php(104): AdminManagePlugin->import() #7 /home/<username>/blesta2/lib/dispatcher.php(111): AdminCompanyPlugins->manage() #8 /home/<username>/blesta2/index.php(21): Dispatcher::dispatch('/index.php/admi...') #9 {main} importContacts: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens #0 /home/<username>/blesta2/lib/model.php(124): PDOStatement->execute(Array) #1 /home/<username>/blesta2/components/record/record.php(215): Model->query('INSERT INTO `cl...', Array) #2 /home/<username>/blesta2/plugins/import_manager/components/migrators/whmcs/whmcs_migrator.php(390): Record->insert('contacts', Array) #3 /home/<username>/blesta2/plugins/import_manager/components/migrators/whmcs/whmcs_migrator.php(73): WhmcsMigrator->importContacts() #4 /home/<username>/blesta2/plugins/import_manager/models/import_manager_importer.php(113): WhmcsMigrator->import() #5 /home/<username>/blesta2/plugins/import_manager/controllers/admin_manage_plugin.php(110): ImportManagerImporter->runMigrator('whmcs', '5.2', Array) #6 /home/<username>/blesta2/app/controllers/admin_company_plugins.php(104): AdminManagePlugin->import() #7 /home/<username>/blesta2/lib/dispatcher.php(111): AdminCompanyPlugins->manage() #8 /home/<username>/blesta2/index.php(21): Dispatcher::dispatch('/index.php/admi...') #9 {main} importCurrencies: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens #0 /home/<username>/blesta2/lib/model.php(124): PDOStatement->execute(Array) #1 /home/<username>/blesta2/components/record/record.php(215): Model->query('INSERT INTO `cl...', Array) #2 /home/<username>/blesta2/plugins/import_manager/components/migrators/whmcs/whmcs_migrator.php(459): Record->insert('currencies', Array) #3 /home/<username>/blesta2/plugins/import_manager/components/migrators/whmcs/whmcs_migrator.php(73): WhmcsMigrator->importCurrencies() #4 /home/<username>/blesta2/plugins/import_manager/models/import_manager_importer.php(113): WhmcsMigrator->import() #5 /home/<username>/blesta2/plugins/import_manager/controllers/admin_manage_plugin.php(110): ImportManagerImporter->runMigrator('whmcs', '5.2', Array) #6 /home/<username>/blesta2/app/controllers/admin_company_plugins.php(104): AdminManagePlugin->import() #7 /home/<username>/blesta2/lib/dispatcher.php(111): AdminCompanyPlugins->manage() #8 /home/<username>/blesta2/index.php(21): Dispatcher::dispatch('/index.php/admi...') #9 {main} importInvoices: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens #0 /home/<username>/blesta2/lib/model.php(124): PDOStatement->execute(Array) #1 /home/<username>/blesta2/components/record/record.php(654): Model->query('SELECT * FROM `...', Array) #2 /home/<username>/blesta2/plugins/import_manager/components/migrators/whmcs/whmcs_migrator.php(1417): Record->fetch() #3 /home/<username>/blesta2/plugins/import_manager/components/migrators/whmcs/whmcs_migrator.php(486): WhmcsMigrator->getTaxRule(1, '0.00') #4 /home/<username>/blesta2/plugins/import_manager/components/migrators/whmcs/whmcs_migrator.php(73): WhmcsMigrator->importInvoices() #5 /home/<username>/blesta2/plugins/import_manager/models/import_manager_importer.php(113): WhmcsMigrator->import() #6 /home/<username>/blesta2/plugins/import_manager/controllers/admin_manage_plugin.php(110): ImportManagerImporter->runMigrator('whmcs', '5.2', Array) #7 /home/<username>/blesta2/app/controllers/admin_company_plugins.php(104): AdminManagePlugin->import() #8 /home/<username>/blesta2/lib/dispatcher.php(111): AdminCompanyPlugins->manage() #9 /home/<username>/blesta2/index.php(21): Dispatcher::dispatch('/index.php/admi...') #10 {main} importPackages: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens #0 /home/<username>/blesta2/lib/model.php(124): PDOStatement->execute(Array) #1 /home/<username>/blesta2/components/record/record.php(654): Model->query('SELECT *, `id` ...', Array) #2 /home/<username>/blesta2/plugins/import_manager/components/migrators/whmcs/whmcs_migrator.php(1617): Record->fetch() #3 /home/<username>/blesta2/plugins/import_manager/components/migrators/whmcs/whmcs_migrator.php(1555): WhmcsMigrator->installModule('generic_server', Array) #4 /home/<username>/blesta2/plugins/import_manager/components/migrators/whmcs/whmcs_migrator.php(740): WhmcsMigrator->installModuleRow(Array) #5 /home/<username>/blesta2/plugins/import_manager/components/migrators/whmcs/whmcs_migrator.php(767): WhmcsMigrator->importModules() #6 /home/<username>/blesta2/plugins/import_manager/components/migrators/whmcs/whmcs_migrator.php(73): WhmcsMigrator->importPackages() #7 /home/<username>/blesta2/plugins/import_manager/models/import_manager_importer.php(113): WhmcsMigrator->import() #8 /home/<username>/blesta2/plugins/import_manager/controllers/admin_manage_plugin.php(110): ImportManagerImporter->runMigrator('whmcs', '5.2', Array) #9 /home/<username>/blesta2/app/controllers/admin_company_plugins.php(104): AdminManagePlugin->import() #10 /home/<username>/blesta2/lib/dispatcher.php(111): AdminCompanyPlugins->manage() #11 /home/<username>/blesta2/index.php(21): Dispatcher::dispatch('/index.php/admi...') #12 {main} importSupportDepartments: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens #0 /home/<username>/blesta2/lib/model.php(124): PDOStatement->execute(Array) #1 /home/<username>/blesta2/components/record/record.php(215): Model->query('INSERT INTO `cl...', Array) #2 /home/<username>/blesta2/plugins/import_manager/components/migrators/whmcs/whmcs_migrator.php(1036): Record->insert('support_departm...', Array) #3 /home/<username>/blesta2/plugins/import_manager/components/migrators/whmcs/whmcs_migrator.php(73): WhmcsMigrator->importSupportDepartments() #4 /home/<username>/blesta2/plugins/import_manager/models/import_manager_importer.php(113): WhmcsMigrator->import() #5 /home/<username>/blesta2/plugins/import_manager/controllers/admin_manage_plugin.php(110): ImportManagerImporter->runMigrator('whmcs', '5.2', Array) #6 /home/<username>/blesta2/app/controllers/admin_company_plugins.php(104): AdminManagePlugin->import() #7 /home/<username>/blesta2/lib/dispatcher.php(111): AdminCompanyPlugins->manage() #8 /home/<username>/blesta2/index.php(21): Dispatcher::dispatch('/index.php/admi...') #9 {main} importSupportTickets: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens #0 /home/<username>/blesta2/lib/model.php(124): PDOStatement->execute(Array) #1 /home/<username>/blesta2/components/record/record.php(215): Model->query('INSERT INTO `cl...', Array) #2 /home/<username>/blesta2/plugins/import_manager/components/migrators/whmcs/whmcs_migrator.php(1133): Record->insert('support_tickets', Array) #3 /home/<username>/blesta2/plugins/import_manager/components/migrators/whmcs/whmcs_migrator.php(73): WhmcsMigrator->importSupportTickets() #4 /home/<username>/blesta2/plugins/import_manager/models/import_manager_importer.php(113): WhmcsMigrator->import() #5 /home/<username>/blesta2/plugins/import_manager/controllers/admin_manage_plugin.php(110): ImportManagerImporter->runMigrator('whmcs', '5.2', Array) #6 /home/<username>/blesta2/app/controllers/admin_company_plugins.php(104): AdminManagePlugin->import() #7 /home/<username>/blesta2/lib/dispatcher.php(111): AdminCompanyPlugins->manage() #8 /home/<username>/blesta2/index.php(21): Dispatcher::dispatch('/index.php/admi...') #9 {main} importMisc: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens #0 /home/<username>/blesta2/lib/model.php(124): PDOStatement->execute(Array) #1 /home/<username>/blesta2/components/record/record.php(215): Model->query('INSERT INTO `cl...', Array) #2 /home/<username>/blesta2/plugins/import_manager/components/migrators/whmcs/whmcs_migrator.php(1244): Record->insert('log_emails', Array) #3 /home/<username>/blesta2/plugins/import_manager/components/migrators/whmcs/whmcs_migrator.php(73): WhmcsMigrator->importMisc() #4 /home/<username>/blesta2/plugins/import_manager/models/import_manager_importer.php(113): WhmcsMigrator->import() #5 /home/<username>/blesta2/plugins/import_manager/controllers/admin_manage_plugin.php(110): ImportManagerImporter->runMigrator('whmcs', '5.2', Array) #6 /home/<username>/blesta2/app/controllers/admin_company_plugins.php(104): AdminManagePlugin->import() #7 /home/<username>/blesta2/lib/dispatcher.php(111): AdminCompanyPlugins->manage() #8 /home/<username>/blesta2/index.php(21): Dispatcher::dispatch('/index.php/admi...') #9 {main} More verbose, but still the same problem There are no duplicate clients or admins. Something is wrong here

Of course it's empty. I did a fresh import. 100% clean database, didn't setup anything

Ok, no response to my issues. Works for me. Remember, you're losing customers by just ignoring them like this. I'll find someone that does want my money

Given that these are (hopefully) md5, I'm betting this isn't going to be too possible. Maybe a mass email after import would be in order

Ok, here we go. Clean import, from the ground up (using b5). Guess what? We're back to all errors , once again The import completed but the following errors ocurred: importClients: SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate entry '1-40' for key 'PRIMARY' on line 124 importCurrencies: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 124 importInvoices: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 124 importPackages: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 124 importSupportDepartments: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 124 importSupportTickets: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 124 importMisc: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 124 As far as needing a fresh install every time? Not so much. A simple php / sql query could figure out if X is in the database or not, and if not, insert it. If so, move on.

Yeah, not so much. It doesn't even try to import data that's already in there, which is a good thing, otherwise I'd have to simply wipe and reinstall every single time I ran this mess of an importer. There's something else going on here, and it doesn't have anything to do with previously imported data, because it CAN move past this. The first time I ran this, it imported 9 clients. Found and fixed the errors being mentioned (again, you need to set default values for imported data, just in case they don't exist) Second time I ran it, all clients were imported, but there were a couple contact issues which caused it to bail. Also managed to import all payments made Now, it's just refusing to do anything else. I shouldn't have to wipe the entire database and reinstall every time I run an importer here. That's way too much work for a system that's flawed to begin with

I wish I would have seen this before I even started trying an import. There's really no reason not to have this .

Managed to fix the duplicate entry/contacts thing, still nothing on the 'number out of bounds' issues earlier. I'm assuming that means that the importer is missing fields, either not enough, or too many to deal with the db

This is actually how it should have been all along. You should be using htmlentities instead of passing & to the browser

yay, clients got imported. Now, on to services and invoices, but oops? We need a bit more info passed on so we can actually resolve errors like this. What table, what query was run? I have no clue where this 'duplicate entry' is from, though I could probably solve it if more info was passed to the client. Once again, not a complete import, a partial one. Need to do something about changing the ID's if they already exist and re-associating them properly

Solved my own problem. Suhosin was stopping this, though that shouldn't ever be stopping a valid script from installing or submitting data