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

Well, now that I'm actually able to get into the system (turns out suhosin doesn't like blesta, or the other way around): The import completed but the following errors ocurred: importClients: SQLSTATE[23000]: Integrity constraint violation: 1048 Column 'country' cannot be null on line 124 importContacts: SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens 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 Import did not actually complete, added about 9 clients, nothing else. There needs to be a default set for every option, to prevent problems like this. obviously, this one was easily solved, but now I have to basically reset data, and try again.

Again, if you have nothing useful to add, do not reply. Insinuating that this is a server issue is not going to resolve the issue itself. This is not a server issue, all requirements are met, and passed upon install.

Please just stop. if you don't have anything useful to add, just stop. You're not being 'helpful', you're being antagonistic and aggravating . Blaming 'the server' for a simple form problem is ridiculous.

That's nice, that doesn't mean that everything is going to work. There's obviously a problem somewhere, and the point is finding it.

I was just making sure it wasn't the web installer alone. See the second post. Somehow that got cut out of the last one , using latest available source It's not just Chrome, every single browser is doing the same exact thing when it comes to setting up the admin while using 'free trial' Chrome, IE, Firefox, all the same exact token error.

Not sure what happened with the rest of that post. Setting up the initial database is fine, but when one goes to setup the admin http://www.linux-tech.net/images/blesta.jpg

I know how to install software, and follow instructions just fine, thank you. The problem is not me, or the instructions. The problem is that the software does not install properly. I can get it installed via CLI ---------------------------------------- Blesta CLI Installer ---------------------------------------- Please acknowledge your agreement to the terms and conditions as explained at http://www.blesta.com/license/ Do you agree? (Y/N): y Performing system requirements check... You will now be asked to enter your database credentials. Database host (default localhost): Database name: <redacted> Database user: <redacted> Database password: <redacted> Attempting to verify database credentials... OK Checking InnoDB support... OK Installing database... 96/96 [========================================] 100% Completed. Configuring database... 23/23 [========================================] 100% Completed. Upgrading database... 4/4 [========================================] 100% 0/0 [========================================] 100% 2/2 [========================================] 100% 0/0 [========================================] 100% 2/2 [========================================] 100% 1/1 [========================================] 100% 1/1 [========================================] 100% 1/1 [========================================] 100% 1/1 [========================================] 100% 1/1 [========================================] 100% 2/2 [========================================] 100% 2/2 [========================================] 100% Completed. Attempting to write config... Success. Generating encryption keys. This may take a minute or two... Done. Installing default plugins... Done. Finished. To complete setup visit /admin/login/ in your browser, or if you do not have mod_rewrite, /index.php/admin/login/.

I don't do hosting @ home, it's all on a server via subdomain.

Yup, even changes when I refresh the page <input type="hidden" name="_csrf_token" value="3dc80a4e0b291adad068eb53b87fb714fddd59416fa96b1f9c329be7a929b933" /> <input type="hidden" name="_csrf_token" value="4ae83c6b18ba97fe819f2f0a5daf9026c477e27be66cecdbd9b06aa709912de4" /> <input type="hidden" name="_csrf_token" value="ceb4ffc4b7580334681c177680f893d9d546dcb5a4870abb786611e6131fa442" />

So, once again, trying this install/demo thing. Can't seem to get past the install bit though. Every time, install errors with What could be causing this? This shows up on the license form, everything else appears to be good