Jump to content

twhiting9275

Members
 View Profile  See their activity

  • Posts

    26

  • Joined

  • Last visited

 Content Type 

Posts posted by twhiting9275

  1. Whmcs Migrator (Beta) - Updated 2013-11-12

    in The Lounge

    Posted

    Nothing in for you? Well for starters you'd be moved over faster, if everyone thought the way you did, there wouldn't be any plugins / modules, we are "a community" they don't have to make the script work for you, it works for 90% of people. They are doing it for you because they want to help you.

    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?

  3. Whmcs Migrator (Beta) - Updated 2013-11-12

    in The Lounge

    Posted

    You need to change your php settings, specifically max_execution_time, set it to a crazy large number.

    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

  4. Whmcs Migrator (Beta) - Updated 2013-11-12

    in The Lounge

    Posted

    The issue you have is related to custom client fields. Somehow you have a custom field assigned to a client multiple times in WHMCS (or your client_values table in Blesta is not empty).

     

    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

  5. Whmcs Migrator (Beta) - Updated 2013-11-12

    in The Lounge

    Posted 


    
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

  9. Whmcs Migrator (Beta) - Updated 2013-11-12

    in The Lounge

    Posted

    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.

  10. Whmcs Migrator (Beta) - Updated 2013-11-12

    in The Lounge

    Posted

    Any error that states "Invalid parameter number: number of bound variables..." is simply caused by the previous error. In your case:

     

     

     

    That sounds like you tried to import into an already populated database, where a client could not be imported due to it already existing.

    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

  14. Whmcs Migrator (Beta) - Updated 2013-11-12

    in The Lounge

    Posted

    yay, clients got imported. Now, on to services and invoices, but oops?

     

    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

    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

     

    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

  16. Whmcs Migrator (Beta) - Updated 2013-11-12

    in The Lounge

    Posted

    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.

  20. "the Form Token Is Invalid"

    in Support

    Posted

    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.

  22. "the Form Token Is Invalid"

    in Support

    Posted

    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/.

  24. "the Form Token Is Invalid"

    in Support

    Posted

    If you view-source the page do you see a hidden field with a hash?

    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" />

  25. "the Form Token Is Invalid"

    in Support

    Posted

    So, once again, trying this install/demo thing.

    Can't seem to get past the install bit though. Every time, install errors with

     

    The form token is invalid

     

    What could be causing this?

    This shows up on the license form, everything else appears to be good

×
×
  • Create New...